Skip to content
DevMarket
Odoo ModulesWordPress PluginsWordPress ThemesShopify ThemesApp TemplatesScripts & UtilitiesBlogSell on DevMarket

Financial Reports for Odoo 19 Community documentation

A guide to the financial reports: running them, the trial balance, the general ledger, profit and loss, the balance sheet, printing and exporting, and the limits.

Documents version 1.0.0Updated Oct 23, 2026

Start here

In plain words: Odoo Community records everything, but the four reports every accountant, auditor and bank asks for are Enterprise features. Financial Reports adds them: the trial balance, the general ledger, the profit and loss and the balance sheet, for any period, on posted entries or all, with a comparison, on screen, in PDF and in Excel.
The trial balance, the profit and loss compared with the previous period, and the balance sheet.
The trial balance, the profit and loss compared with the previous period, and the balance sheet.
Tip: Every figure comes from your journal items, with no copy of the data. The trial balance and the balance sheet show a difference that must be zero.

What you get

ReportWhat it shows
Trial BalanceOpening balance, debits, credits and closing balance of every account, with the totals.
General LedgerEach account with its opening balance, every journal item (date, entry, partner, label) and a running balance.
Profit and LossIncome, cost of revenue, gross profit, other income, expenses and net profit, with a comparison column.
Balance SheetAssets, liabilities and equity on any date, with the earnings of the year and of the previous years, with a comparison.
OptionWhat it does
Posted or all entriesPosted entries only, or the drafts too.
Journals and accountsLimit a report to some journals, or the ledger to some accounts.
ComparisonAgainst the previous period or the same period last year.
Fiscal yearsIncome and expense accounts start from zero each fiscal year; their past results are in the unallocated earnings.
OutputOn screen, PDF and Excel. Arabic and right to left.

Requirements

ItemDetails
Odoo19.0 (Community or Enterprise)
Apps neededInvoicing / Accounting (account) with a chart of accounts
LicenseOPL-1 (Odoo Proprietary License v1.0)

Install

  1. Unzip the package. Inside is taqnix_financial_reports.zip; unzip it to get the folder taqnix_financial_reports.
  2. Copy the folder into one of the addons_path folders of your Odoo server and restart Odoo.
  3. Log in as an administrator, activate Developer mode, open Apps and press Update Apps List.
  4. Remove the “Apps” filter, search Financial Reports and press Install.
# or from the command line
./odoo-bin -c odoo.conf -d YOUR_DATABASE -i taqnix_financial_reports --stop-after-init

Run a report

In plain words: Open Invoicing → Reporting → Financial Reports and choose a report. Choose the period and the options, then press Show the report.
The options of a trial balance: period, entries, journals, accounts.
The options of a trial balance: period, entries, journals, accounts.
FieldMeaning
Period (From, To)The dates of the report. The default start is the first day of the fiscal year. The balance sheet needs only the date it is as of.
EntriesPosted entries, or all entries (drafts included, cancelled never).
Compare withProfit and loss and balance sheet: the previous period, or the same period last year.
Journals, AccountsEmpty means all.
Hide empty accountsLeaves out the accounts with nothing to show.
Tip: The Difference field must show zero. On the trial balance it is debits minus credits; on the balance sheet, assets minus liabilities and equity.

Trial balance

Every account with its opening balance, the debits and credits of the period and the closing balance.
Every account with its opening balance, the debits and credits of the period and the closing balance.
ColumnMeaning
OpeningThe balance before the first day. For income and expense accounts, the balance since the start of the fiscal year; the results of earlier years are in the line Unallocated Earnings (previous years), so that the openings add up to zero.
Debit, CreditThe movements of the period.
BalanceOpening plus debit minus credit. A negative balance is a credit balance.

General ledger

In plain words: For each account: the opening balance, every journal item of the period with a running balance, and the totals. Limit it to some accounts or journals for a quick look; a period with more than 20,000 items must be narrowed.
The bank account in September: the opening balance, each item and the running balance.
The bank account in September: the opening balance, each item and the running balance.

Profit and loss

In plain words: Income, minus the cost of revenue, is the gross profit; plus other income and minus the expenses it is the net profit. Each account is listed under its section.
The third quarter compared with the second.
The third quarter compared with the second.

Balance sheet

In plain words: Assets (receivables, bank and cash, current, prepayments, non-current, fixed), liabilities (payables, credit cards, current, non-current) and equity, with the earnings of the current year and of the previous years. Total assets equal total liabilities and equity.
The balance sheet on 30 September, compared with 30 June.
The balance sheet on 30 September, compared with 30 June.
In plain words: Each report has Print (PDF) and Export to Excel.
The printed profit and loss.
The printed profit and loss.

Who can use it

In plain words: Users of the accounting groups: Accounting readonly, Accountant and Adviser. The reports are created and thrown away by Odoo; nothing is kept for long.

Arabic and right to left

The trial balance in an Arabic interface.
The trial balance in an Arabic interface.

Limits

LimitDetail
Company currencyThe reports are in the company currency, as recorded in the journal items.
No year-end closingThe reports do not close the year. Income and expense accounts restart each fiscal year in the reports; no closing entry is needed.
One company at a timeThe report of the company you choose; no consolidation.
LayoutThe statements follow the account types of Odoo, not a country's legal layout.
SizeThe general ledger is limited to 20,000 items; narrow the period.

For developers

In plain words: Skip this chapter if you only use the module.
report = env['taqnix.fin.report'].create({
    'report_type': 'profit_loss', 'date_from': '2026-01-01', 'date_to': '2026-09-30', 'comparison': 'year',
})
report.action_compute()
for line in report.line_ids:
    print(line.kind, line.name, line.balance, line.compare)

Troubleshooting

ProblemWhat to do
The Difference is not zeroOn a trial balance with a journal or an account filter, a difference is expected. Otherwise look for unbalanced draft entries when you include drafts.
An account is missingIt has no movement and no balance in the period, and Hide empty accounts is on.
I do not see the menuYou need an accounting right (Readonly, Accountant or Adviser).
The general ledger refusesMore than 20,000 items: shorten the period or choose accounts or journals.

Updating and removing

Replace the folder with the new version, restart Odoo and run -u taqnix_financial_reports. The module stores nothing permanent.

Support

Installation help and bug fixes are included for 6 months, with lifetime updates. Contact us through the marketplace page where you bought the module or write to support@taqnix.com with your Odoo version and a screenshot.