How to Find the Number of Entries and Total Amount Recorded for a CoA in a Financial Year in Odoo 16?

Question

I need to analyze a specific account in Odoo 16 to find the *number of entries* and the *total amount (debit/credit)* recorded for it during a particular financial year (e.g., April 1, 2024, to March 31, 2025).
Could someone guide me on the best way to:
Filter the entries for a specific Chart of Accounts (CoA) in the General Ledger for a given financial year? Retrieve the total debit and credit amounts as well as the count of entries for that period? Optionally export this data for further analy

Andrea Spamer (and) · Accepted Answer

Hello,
The best way to retrieve this information is the journal items you can create dynamic reports with the filters and groupings you need. All accounting reports take information from the journal items.
To do that you have  to first activate developer mode by going to settings and under Developer tools select " Activate the developer mode"
image [1]

Step two: With developer mode activated you can now view the Journal Items menu in accounting (see image below) image [2]
Step 3: you can use th

Econ Odoo · Answer

Every journal entry I believe is recorded in the  account_move_line model. Maybe you can filter with the move_type='entry' and the account_id of the account you want
For each entry, you can sum the credit and debit and balance. Actually with python, when you have a list of the entry, the suming is super easy.
Making it works in Odoo maybe a little harder. Maybe you'd create a view, or I'd prefer to create a wizard for this report.

Publicaciones relacionadas	Respuestas	Vistas
How can I assign specific account-chart accounts for banks? accounting bank payments journals odooV8	0 sept 15	3757
i cant print journal entry Resuelto accounting journalentry	3 jul 25	2319
Paid Capital is shown as Retained Earnings in Balance Sheet accounting chartofaccount	1 may 25	3809
How to Fix Incoming Payments Posted to the Wrong CoA in Odoo 16? payment journals chartofaccount journalentriers Accounting CoA	1 ene 25	830
How do you account for shipping of raw materials accounting chartofaccount	1 dic 24	5190

Se marcó esta pregunta

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