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.

Related Posts	Replies	Zobrazenia
How can I assign specific account-chart accounts for banks? accounting bank payments journals odooV8	0 sep 15	4537
Plan comptable français en 8 chiffres (v18) accounting chartofaccount	1 sep 25	823
i cant print journal entry Solved accounting journalentry	3 júl 25	3007
Paid Capital is shown as Retained Earnings in Balance Sheet accounting chartofaccount	1 máj 25	4688
How to Fix Incoming Payments Posted to the Wrong CoA in Odoo 16? payment journals chartofaccount journalentriers Accounting CoA	1 jan 25	1561

This question has been flagged

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