
The question we hear every time
Odoo Community records invoices, entries and payments well. But when the accountant asks for the trial balance, the balance sheet or the aged balances in the form they know, they are in Enterprise, which is paid per user.
That leaves two costly options: a licence for every user, or exporting to Excel at the end of each month and putting the figures together by hand. The second is the riskier one, because its mistakes only surface at the audit.
What we built
We wrote a financial statements module on Odoo 19 Community, now part of Yaqeen ERP:
- A trial balance with opening, movement and closing balances.
- A general ledger with a running balance per account, filtered by accounts and partners.
- Profit and loss with gross profit, against the same period last year.
- A balance sheet at a date that checks itself: assets equal liabilities plus equity.
- Aged receivables and payables at a date.
- On screen, as a PDF in Arabic or English by the user's language, and in Excel.
Two details many miss
First: profit and loss accounts start each fiscal year at zero. Unless earlier years' earnings move to a line of their own in equity, the trial balance will not balance. Our module does that by itself.
Second: aged balances at a past date. If a customer paid after that date, the invoice must show as open on it, because it was. That is how an auditor reads it, and how the module works it out.
A screen instead of a monthly email
Our first idea was to email the reports at the start of each month. Then we saw that what a manager needs is a screen to open whenever they like, with no dates to fill in and no reports to choose.
So we built the financial dashboard: revenue and net profit for the month and the year to date against last year, cash and banks, what customers owe and how much is overdue, what is owed to suppliers, and the last 12 months. Every figure opens the statement behind it with the same dates, so the dashboard and the report never disagree.
Before you trust any figure
Reports read what is in the books, nothing more. If account types are wrong, or stock is not valued automatically with every move, the figures carry the same mistake however good the report is. That is why every project of ours starts by checking these basics.

Mahmoud Ali Haloul
Founder, Yaqeen Digital Solutions
A finance leader who has built the systems finance runs on since 2013. He heads finance at estaie in Dubai, and before that led the finance team at Orient Films and worked at United Company of Pharmacists. He works on every Yaqeen setup himself, and writes here what he learns on the job.
Message us on WhatsApp
