Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilité
Inventaire
PoS
Projet
MRP

All apps

Toutes les publications Personnes Badges

Étiquettes (Voir toutl)

odoo accounting v14 pos v15

À propos de ce forum

Aide

How would I generate an IFRS financial report where I needed to sum balances from individual accounts?

accounting reports sum balances IFRS GAAP

1 Répondre

90 Vues

Community Question

I want to generate Financial Reports based on both the GAAP and IFRS reporting standards.

One of the requirements is to sum balances from several individual accounts used in our GAAP report and shown them as a single balance in our IFRS report.

If I have five expense accounts under GAAP but wanted a single balance under IFRS how would I do this in Odoo?

I have been reading https://www.odoo.com/documentation/19.0/applications/finance/accounting/reporting/customize.html and it seems that perhaps I can tag the accounts and define our IFRS reports to group by the Tag?

The Line Grouping part of the documentation discusses creating a new field on the Journal Item but I am unsure if this is the correct approach and have not been able to create a Tag based field due to the error "Field x_tag_ids of account.move.line cannot be used in a groupby expression."

Ray Carnes (ray)

Meilleure réponse

You are on the right track.

If you always use a single Tag and there is no calculation involved when you merge / sum balances this is a great solution.

Create your custom field like this:

Be sure to tag each individual GAAP based account with a single Tag to represent the IFRS rollup:

Then, remove grouping by account_id and replace it by your custom field on each report line on the IFRS report (which you can create by duplicating the GAAP one):

The GAAP report will show the individual balances:

The IFRS report will show the sum, using the Tag as the label:

When you drill down into the sum from the IFRS report, you will see the individual journal items and the source accounts:

If instead we tag the Accounts so our Journal Items are recorded like this:

The report would show this:

If you need to move balances between accounts at month end, automated Transfers can be setup using an IFRS Journal that is excluded from your GAAP reports.

Leverage the Multi-ledger feature explained at https://www.odoo.com/documentation/19.0/applications/finance/accounting/get_started/consolidation.html

We also recommend watching our Odoo Experience Video from 2024 - at https://www.youtube.com/watch?v=IeEyvOr2Kmc

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !

Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !

S'inscrire

Publications associées	Réponses	Vues
Intercompany Eliminations accounting reports	2 juin 25	2302
Accounting reports accounting reports	0 févr. 23	3727
Error: undefined accounting reports	1 mai 22	4614
Why Account Liabilities and Equity sign negative value in general ledger report accounting reports	1 mars 21	3720
Cash Flow Statement missing from reports Résolu accounting reports	1 juin 17	4987

Cette question a été signalée

Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !