Skip to Content
This question has been flagged
accountingimporting data from excel file
4 Replies
941 Views
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
Discard
Wei Qi
Author

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
Discard
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
Discard
Avatar
Don Chau
Best Answer

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

Avatar
Discard
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
Discard
Related Posts Replies Views Activity
Codabox connection
accounting
Avatar
0
Aug 25
16
How to format a General Ledger import from QBO?
accounting
Avatar
Avatar
1
Aug 25
239
Listing all Invoices with their line items and custom Product fields
accounting
Avatar
0
Aug 25
403
simplified chart of accounts for non-profit organization
accounting
Avatar
1
Aug 25
444
Why does the same bank transaction appear on different bank statements? How can I fix it?
accounting
Avatar
0
Aug 25
372