Odoo Help


This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


v9 Community: The Balance Sheet is Wrong for every year but first one

Ken Woychesko
on 9/2/16, 11:41 PM 204 views

The Balance Sheet is wrong for every year except your first year, because Odoo doesn't carry-forward the balances in your Assets, Liabilities, and Equity accounts -- it 0's them out just like with income and expense accounts. Note: with Odoo's new financial-report-on-the-fly methodology, it doesn't 0-out the accounts with a JE, it 0's-out computationally.

The effect of 0'ing out these accounts is that suddenly the balances in your Bank, Accounts Receivable, Accounts Payable, and Equity type accounts have no effect on your Balance Sheet.

For example, on Dec. 31 your Balance Sheet might show:

$10,000 in AR

$20,000 in your bank

$40,000 in AP, and

$10,000 in Retained Earnings

On Jan 1, your Balance Sheet would show $0 in all of those accounts.

Can somebody please confirm they are seeing they same thing as I am? I would love to be wrong about this. Maybe it is the way I'm testing it or I'm misunderstanding how it should work.

Version 9c

You're exactly correct Ray -- I was choosing both a Start Date and an End Date. Thank you very much for pointing that out!

Ken Woychesko
on 9/3/16, 1:32 PM

Ray Carnes

--Ray Carnes--
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 9/4/16, 4:58 PM

I am not seeing the same thing. Are you using your own Chart of Accounts or one of the Charts provided? Post the types of each of the accounts you have listed. Are you running the report properly? A Balance Sheet always has the same start date, it is only the END DATE that changes.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 9/2/16, 11:41 PM
Seen: 204 times
Last updated: 9/4/16, 4:58 PM