Yaqeen Digital Solutions

Aged balances in Odoo too high? Start with the account type

A small chart of accounts mistake makes the aged balances mislead you from the first month. I found it at a client before their first entry, and you can find it in two minutes.

Mahmoud Ali Haloul

Mahmoud Ali Haloul

· 2 min read

What I found before the first entry

Before a client of ours, a food company, started posting entries in Odoo, I went through the chart of accounts moved over from their old system. Everything looked fine until I filtered the accounts by type.

Their input VAT account was typed "Receivable", their output VAT "Payable", and every staff advance account "Receivable". Had entries started on that setup, purchase VAT would have shown in aged receivables as money a customer owed, and every employee's advance as a customer paying late.

Why it happens

The report does not know what an account means, only its type. Aged balances and partner ledgers in Odoo read every account typed Receivable or Payable, whatever its name.

It happens most when a chart of accounts comes from older software or a spreadsheet, and the type is picked in a hurry because the account "has partners on it".

Find it yourself in two minutes

Open the chart of accounts from the Invoicing or Accounting configuration and filter by type:

  • Receivable should hold customer accounts only.
  • Payable should hold supplier accounts only.
  • Anything else in either filter needs a look. The usual ones: input and output VAT, and staff advances and petty cash.

The fix

Change each one to its proper type: input VAT to Current Assets, output VAT to Current Liabilities, staff advances to Current Assets. If you close each advance on its own, keep Allow Reconciliation on the account.

It is easiest before entries are posted. If they have started, take a backup first, then check the aged balances and partner ledgers on a date whose figures you know.

The wider lesson

Most report errors I have seen were not in the report. They were in a setup made weeks earlier that nobody checked. An hour of review before the first entry saves months of reconciliations after it.

Mahmoud Ali Haloul

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

Want us to check your chart of accounts?

In a free review on your data, we load a month of your invoices into a demo copy and show you your reports, and any problem like this one.