Skip to Content
This question has been flagged
accountingimporting data from excel file
4 Respostes
2873 Vistes
Avatar
Wei Qi

I try to import whole year Journal entries to Odoo, but failed, I am sure my entry is balanced, but why always be told not balanced?

Error at row 0: "An error has occurred. The move (Draft Entry MISC/2023/10/0001) is not balanced. The total of debits equals 100,000.00 ₱ and the total of credits equals 0.00 ₱. You might want to specify a default account on journal "Miscellaneous Operations" to automatically balance each move."


journal_code move_name date partner_id Journal_Label account_code Journal_debit Journal_credit Analytic Distribution
MISC MISC/2023/10/0001 2023-10-16 Received Payment for @royal peak project 100001 100000.00
MISC MISC/2023/10/0001 2023-10-16 Received Payment for @royal peak project 200007 100000.00 Royal Peak Project

Avatar
Descartar
Wei Qi
Autor

But when I leave row 2 blank as suggestion. still error:  Missing required value for the field 'Number' (name). Model: Unknown - create/update: a mandatory field is not set - delete: another model requires the record being deleted, you can archive it instead at multiple rows

MANAR ABD ALSALAM ABD ALAZEEM

(First 4 column leave them empty that mean they are in the same journal entry ( first number of journal entry
and so on >> start journal entry data and leave other columns empty for remaining items related to same journal entry

Bijal Shah

What about taxes, how do these appear when imported?

Avatar
Ray Carnes (ray)
Best Answer

Use the template we provide from Accounting --> Configuration --> Settings:



Avatar
Descartar
Chris TRINGHAM

So, @Ray, you suggest uploading Journal Items rather than Journal Entries.

Ray Carnes (ray)

No. You can't import Journal Items. I am suggesting using the template which although we label Journal Items is for multiple Journal Items grouped as Journal Entries.

Avatar
Mansi Sukheja (masu)
Best Answer
journal_codemove_namedatepartner_idJournal_Labelaccount_codeJournal_debitJournal_creditAnalytic Distribution
MISCMISC/2023/10/00012023-10-16Received Payment for @royal peak project100001100000.00




200007100000.00Royal Peak Project

Here is the correct format to use.

By using the previous format, there were two entries read by the system.


Avatar
Descartar
Avatar
Don Chau
Best Answer

in the second row, first 5 columns, you do not include the information, leave them blank

Avatar
Descartar
Avatar
Dhrumi (Wan Buffer Services)
Best Answer

To import journal entries in Odoo 18, follow these steps:

 Journal Entry Import

  1. Go to:
    Accounting → Journal Entries → Journal Items
  2. Click:
    ⚙️ “Favorites” → “Import Records”
  3. Use the correct format in your import file (usually .csv or .xlsx):
    • Journal (code or ID)
    • Date
    • Account (code or ID)
    • Label (optional)
    • Partner (optional)
    • Debit
    • Credit
    • Currency (if needed)
    • Analytic account / tags (optional)
  4. Balance Check:
    • Ensure each journal entry balances (total Debit = total Credit).
    • Odoo will reject unbalanced entries.
  5. Click “Test” before importing live to check for validation issues.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
dfgfdgdf fgfgf xcvdf fgdf dsf
accounting
Avatar
0
de nov. 25
3
{{GUIA`$Avianca$𓆩×͜×𓆪 𝐏𝐀}}¿Cómo llamar a Avianca desde Panamá?
accounting
Avatar
0
de nov. 25
58
Invoice Printing Error in Odoo V19 – GCC/Saudi Localization
accounting
Avatar
Avatar
1
de nov. 25
205
After Odoo 18 to Odoo 19 upgrade - how do I manage Bills for products that already posted to the interim account? - مشكلة بعد الترقية من Odoo 18 إلى Odoo 19.
accounting
Avatar
Avatar
1
de nov. 25
234
I found a small typo in the Odoo 19 Chart of Accounts — and it made my day 😆 Solved
accounting
Avatar
Avatar
Avatar
2
de nov. 25
410