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}

Related Posts	Odgovori	Prikazi
Facing QuickBooks Error 6123? @ +1-804-(985)-1002 Here’s the Easiest Fix accounting	0 nov. 25	3
{{GUIA`$Avianca$𓆩×͜×𓆪 𝐏𝐀}}¿Cómo llamar a Avianca desde Panamá? accounting	0 nov. 25	58
Invoice Printing Error in Odoo V19 – GCC/Saudi Localization accounting	1 nov. 25	166
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	1 nov. 25	203
I found a small typo in the Odoo 19 Chart of Accounts — and it made my day 😆 Solved accounting	2 nov. 25	358

This question has been flagged

Enjoying the discussion? Don't just read, join in!

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