How can I import Journal Entries with Analytic Distributions in Odoo 18

Question

I tried to import journal entries with analytic distribution, I tried to put them in a JSON form but when I made the import the analytic distribution was empty
this form I tried:
{"analytic account name": percentage}

here is an example

01/04/2025
JV
Tax invoice# CR-13531
Materials
& Raw Materials
625.00
{"Al Khan G + 15 -
211": 100}

Vat 5%
31.25

Suppliers & Creditors
Al Dammam Elect. & Sanit. Ware Trdg.
656.25

what should I do so the analytic distribution is imported correctly

Cybrosys Techno Solutions Pvt.Ltd · Accepted Answer

Hi,

In Odoo, analytic distributions must be imported using the analytic account’s external ID or database ID, not its name. When you tried {"Al Khan G + 15 - 211": 100}, Odoo couldn’t match the name, so the distribution was left empty. To fix this, you should first get the external ID of the analytic account (via Settings → Technical → External Identifiers), then use that in the JSON field, for example {"analytic_al_khan_211": 100}. If you need to split across multiple accounts, you can add mor

Ray Carnes (ray) · Answer

The most reliable and dependable way to understand how to import anything in Odoo is to first create a record representing what you want to import and EXPORT it first.
You will then see that the format of the Analytic Distribution field is the ID (ie: 90) of the Analytic Account:
{"90", 100.0}

Publicaciones relacionadas	Respuestas	Vistas
New date format odoo 19 accounting	2 dic 25	1527
Bank Suspense vs Bank Suspense Account on Odoo Chart of Accounts default Resuelto accounting	2 dic 25	464
Peppol - Envoie de mails à mon comptable pour WinAuditor accounting	3 dic 25	1611
{{LL@mar Mexico}} ¿Cómo hablar con una persona en Air France? accounting	0 dic 25	4
Why is the invoice PDF showing an error in the right corner accounting	1 dic 25	1329

Se marcó esta pregunta

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

01/04/2025	JV	Tax invoice# CR-13531	Materials & Raw Materials	625.00		{"Al Khan G + 15 - 211": 100}
			Vat 5%		31.25
			Suppliers & Creditors	Al Dammam Elect. & Sanit. Ware Trdg.		656.25