NextERP Documentation
ROEN

Reports · Article 01

Aged balances generated as a document

Applies to Odoo 19 · 20

The aged balance of customers or suppliers shows, at a given date, the amounts still not collected or not paid, per partner and per overdue interval relative to the due date. From the ANAF Declarations menu you generate it as a document, as PDF and as a spreadsheet, to keep in the closing file or to give to the auditor.

When to use

  • At the end of the month or year, as an annex to the stocktake of receivables and payables.
  • The auditor asks for outstanding balances per partner at a date.
  • You want a fixed document, not the interactive report under Reporting.

Before you start

  • Payments and receipts are reconciled with the invoices: an unreconciled payment leaves the invoice outstanding.
  • Invoices have payment terms filled in, so the ageing is calculated from the due date.

Steps in Odoo

1. Open the reports

ANAF Declarations › Reports and select Aged Receivable (customers) or Aged Payable (suppliers) in the Report list.

2. Choose the date

The report only has an end date: the amounts open at that date. The window reminds you that the grouping is by days past the due date.

3. Choose the options

Option What it does
Detail per Document (selected by default) The open documents of each partner: number, date, due date, original amount and remaining amount
Per Account One section per account (for example 4111, 4118, 461)
Extra Receivable / Payable Accounts (selected by default) Includes sundry debtors and creditors tracked per partner
Non-trade Accounts (selected by default) Includes receivable and payable accounts that are not trade accounts

4. Generate the report

Click Generate and download the files from Files.

What it contains

For each partner, with the tax ID: the amount not yet due and the amounts per overdue interval of 1–30, 31–60, 61–90, 91–180, 181–365 and over 365 days. For foreign-currency documents the currency and the remaining amount in currency are also shown. The total for an account equals the account balance at the chosen date.

Variants

  • The interactive report, with filtering and opening of invoices, is described in the chapter Receipts, payments and bank, article "Aged balances".
  • Automatic monthly generation: add Aged Receivable or Aged Payable in Declarations and Registers; see Legal registers.

Common mistakes

  • A paid invoice shows as outstanding. The payment is not reconciled with the invoice; reconcile it and generate again.
  • The total does not match the 4111 balance. You cleared the extra accounts or chose Per Account; compare the account total, not the grand total.
For the accountant: use

At the annual stocktake, receivables and payables are confirmed with partners, and doubtful or time-barred ones are reviewed for impairment adjustments. The aged balance at 31 December is the basis for this review and for the balance confirmation letters (chapter Receipts, payments and bank, article "Balance confirmation").

Documentation by the NextERP team.