Odoo Help


3 Risposte

Kevin McMenamin Nuova Zelanda

--Kevin McMenamin--

| 5 3 8
Auckland, Nuova Zelanda
--Kevin McMenamin--

Kevin McMenamin Nuova Zelanda
07/03/13, 16:00

You can put in your opening balances by using a general journal - see menu item accounting / journal entries . journal entries.

This way you are not limited to only balance sheet accounts - for example, you may be part way through the year and want to do a journal for each month including expense account balances.

The only tricky part is receivables and payables. In OpenERP these are part of the GL (rather than a separate ledger like most systems) so in your journal you will need to include the relevant partner account.

2 Commenti
AD LIBITOM, michel Guénard Francia
08/03/13, 09:40

Kevin could you explain "This way you are not limited to only balance sheet accounts - for example, you may be part way through the year and want to do a journal for each month including expense account balances." as opening balances are restricted to begin a new accounting period with "on going" items.

Solnet Solutions Limited, Kevin McMenamin Nuova Zelanda
10/03/13, 16:49

If you "go live" at the start of the year, then all you need to create are your opening balance sheet accounts. Howver, if you go live during the year you will want to have expense account data in their as well. You could so this by data conversion if you want the detail, or you could do by journal entry if all you want is balances. You can use a general journal to do this - effectively your journal is the trial balance movements for each period.

Farook India
15/02/14, 13:22

Dear Jheszica, You can create Opening Entries as explained below

1) Create an Opening Entries Journal: In most of the Chart of Accounts this comes by default. If it's not present, create a journal "Opening Entries Journal" with Type="Opening/Closing Situation". Check the "Centralized Counterpart" option. 1a) create an Account "Opening Expense Account" of Internal Type="Regular" and Account Type="Expense" and set this as the Default Debit Account for the above journal 1b) create an Account "Opening Income Account" of Internal Type="Regular" and Account Type="Income" and set this as the Default Credit Account for the above journal

2) Now go to Accounting->Journal Entries-> Journal Entries and click "Create" to create the opening journal entry

3) Now select Journal="Opening Etnries Journal" and add all your Accounts here with their Opening balances. Make sure you enter the amount in credit or debit columns based on the opening balance type of respective accounts

4) Once all entries are made, save the journal entry and post it. If the opening entries you entered are unbalanced (means sum of credits are not equal to sum of debits), then automatically the balance amount will be posted to the Default Debit Account or Default Credit Account of the Journal created in the first step

1 Commento
EBITS TechCon, Saravanan Sakthivel India
28/11/14, 04:07

Hi Farook, Is it possible to hide OBC account in COA View


michel Guénard Francia

--michel Guénard--

| 5 5 10
--michel Guénard--

VP operations & finance Social entrepreneur Certified Public Accountant Past Chief internal auditor

michel Guénard Francia
01/03/13, 07:16

Opening balances deals with accounts; * A journal* is a formatted method to record the business and financial operations into the appropriate accounts.

In a sense they are specialized by the nature of the transactions to be recorded.

The (almost) universal practice defines several journals:

  • Sales journal
  • Purchasing journal
  • Bank journal
  • (petty) Cash journal
  • Miscellaneous journal
  • Opening (balances) Journal. Other journals can be designed depending onto your needs (credit notes journal for instance).

The Opening (balances) Journal is the sole journal dealing with recording balances of accounts from the previous acounting period (if a previous period exists). In this journal, you will use only balance sheet accounts. OpenErp has a workflow to transfer the balances from one closed period to the next current one. When you start working with OpenErp, you need to record every closing balances (from another system, be it manual or not) into your "new" booking system. To do that you will post these individual balances (your previous balance sheet), using the opening balances journal.


1 Commento
jheszica Filippine
02/03/13, 09:15

Hi, can you give me a step by step tutorial in recording Opening balances... in the Opening Journal.? Thank you very much.

Fai una domanda
Keep Informed
1 follower(s)
About This Community

This platform 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.

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now