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	Replies	Views
Guía~Básica¿Cómo hablo con una persona en vivo en Delta? accounting	0 Nov 25	3
[7191]¿Cómo llamar a Latam Bogotá desde celular? accounting	0 Nov 25	38
«A L A S • Q U E • I N S P I R A N 🌎¿Cómo llamar a Booking en México? accounting	0 Nov 25	4
How can I manipulate the email template when sending an email in Accounting so that my PDF with the XML is inserted instead of the standard view with XML? accounting	1 Nov 25	164
[Copa~@MX telefono]¿Cómo hablo con un agente de Copa? accounting	0 Nov 25	2

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