Odd 18 Journal entry import.

Question

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_co

Ray Carnes (ray) · Answer

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

image [1]

image [2]

[1] /web/image/71421334-a509968b/image.png?access_token=d6627170-62ae-48b0-b87a-3df97b998e94
[2] /web/image/71421335-b0e09fe7/image.png?access_token=8a682104-33c8-437b-a207-775895550d3c

Mansi Sukheja (masu) · Answer

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

200007  100000.00 Royal Peak Project   Here is the correct format to use.
By using the previous format, there were two entries read by the system.

Don Chau · Answer

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

Dhrumi (Wan Buffer Services) · Answer

To import journal entries in *Odoo 18*, follow these steps:
** Journal Entry Import**
*Go to:*
Accounting → Journal Entries → Journal Items

*Click:*
⚙️ /“Favorites”/ → /“Import Records”/

*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)

*Balance Check:*

Ensure *each journal entry balances* (tota

Publicaciones relacionadas	Respuestas	Vistas
Reset Finance transactions accounting	0 nov 25	17
How start de official accounting in a DDBB, already in use. accounting	1 nov 25	139
Pickup Date for E-Commerce accounting	0 nov 25	4
PDF facture de vente s'imprime trop large accounting	1 nov 25	176
{{Contacta ya}} ¿Cómo puedo llamar a Copa Airlines desde México? accounting	0 nov 25	2

Se marcó esta pregunta

Journal Entry Import

¿Le interesa esta conversación? ¡Participe en ella!

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