This question has been flagged

Not being an accountant...

We are starting with a fresh set of accounts, leaving Openerp 7 behind and starting again with Odoo 10, new account!

Have inputed all the oustanding Invoices, credit notes

I'm trying to decide the best way to enter our companies basic opening balances... Bank, cash, tax

In Openerp 7 I created a "opening balances journal" and created a journal entry for each value balances against "3200 Profit and loss account" - probably influenced by Sage software

Now in Odoo 10...


Is this the correct way... as instructed by 

1) DONT create a Opening balance journal

2) Create a "opening balances" account - equity

3) Create and POST journal entry - Opening balance journal - dated last day of the previous financial year

    Bank Journal - "Bank account" value in Debit - with matching value - "Opening balances" value in Credit 

    Credit Card Journal  - "Credit Card account" value in Credit- with matching value - "Opening balances" value in Debit

    Company Cash Journal  - "Company Cash account" value in Debit- with matching value - "Opening balances" value in Credit

     Director Cash Journal - "Director Loans account" value in Credit- with matching value - "Opening balances" value in Debit

     Tax Journal - "Tax owed" value in Credit - with matching value - "Opening balances" value in Debit


Cheers

Avatar
Discard

This forum is for specific questions only, one by one. Please do not mix questions.

Author

:( Sorry - updated

Author Best Answer

My Answer - as guided by Ermin and TLW-Inc

1) DONT create a Opening balance journal

2) Enter all outstanding invoices customer separately 

2) For Bank Balances - Create a "Retained Earnings" account (Accounting>Advisor>Chart of Account>Create - I use Code 303000, Name  "Retained Earnings", Type Equity

3) For each Bank and Cash Journal, Create and POST separate journal entries - dated last day of the previous financial year

    Bank Journal - "Bank account" value in Debit - with matching value - "Retained Earnings" value in Credit 

    Credit Card Journal  - "Credit Card account" value in Credit- with matching value - "Retained Earnings" value in Debit

    Company Cash Journal  - "Company Cash account" value in Debit- with matching value - "Retained Earnings" value in Credit

    Director Cash Journal - "Director Loans account" value in Credit- with matching value - "Retained Earnings" value in Debit

    Tax Journal - "Tax owed" value in Credit - with matching value - "Retained Earnings" value in Debit

Avatar
Discard
Best Answer

Please do read the accounting documentation carefully and then revert back if you have specific questions. There is an implementation guide implemented as a wizard which helps you to properly set up your accounting. By the way, the counter account of "opening statement" is the retained earnings account, but that's accounting 101.

Avatar
Discard
Author

Thanks Ermin, however "your link" then "How to setup Odoo Accounting?" refers to the "implementation guide" which doesnt answer either of my questions. Having scoured the web and found a thousand answers + yours "retained earnings account" I was looking for a definitive answer - see above

The major point is the new accounting approach Odoo realized starting with version 9.0, which has lead to a lot of discussion in the community, and which made the opening and closing procedures some kind of obsolete.

Author

We may have crossed wires. - See latest edit above - I appreciate that between financial years closing and opening accounts is not required - sounds good to me. But we have no account yet other than the closing balance of an old system. Whats is the correct way to input these primary figures?

The recommended way for accounts payable and receivable is to completely post to open invoices with their original dates. For the rest of the balance sheet accounts you can follow the idea of your linked video, but not only for bank accounts (you may use another journal type for that purpose) and post the balances against the retained earnings account.

Best Answer

Hi Cameron,

How have you got on with importing balances?

We are trying to do something similar (Moving from Xero to Odoo 10) and there seems to be a lack of knowledge on this in the Odoo community. 


The wizard is vague at best...



Avatar
Discard
Author

Jas - pretty much as described in my answer above - it worked - Not being an accountant I find the double entry book keeping hard! My only advise is, BEFORE you move to Odoo, set up a data base, get your chart of accounts set up - depending on the size of your company the less the better - play with a database copy until you know whats going on, then play some more - especially the VAT (I still dont know :() Odoo ISNT for the faint hearted, it takes time to set up and tweek properly! Only now(tell a lie another month at least (10 months into odoo10 (after Openerp 7)) are we just about getting it to work nicely - Dam I forgot about the VAT let say Dec 2018