Skip to main content
The Aged reports show outstanding balances broken down by how long they’ve been open. Aged Receivables does this for what customers owe you; Aged Payables does it for what you owe vendors. Both work the same way and share the same screen, so they’re documented together here.
  • Aged Receivables: /accounting/reports/aged-receivables
  • Aged Payables: /accounting/reports/aged-payables
📷 Screenshot: Aged Receivables with the per-customer rows, age buckets, and the reconciliation strip — to be added.

​
When to use them

  • Aged Receivables — to drive collections: see who owes you, how much, and how overdue it is so you can chase the oldest debts first.
  • Aged Payables — to plan payments: see what’s due to whom and how long it’s been outstanding so you can manage cash and avoid late penalties.
  • At period-end, to confirm the open-item detail agrees with the receivables/payables control balance on the ledger.

​
How to run them

Both reports show positions as of a date.
  • As of date — the date you want the ageing calculated to. Each open item’s age is measured from its posting date up to this date.
  • Buckets — choose how the age bands are split. Built-in presets are:
    • 30 / 60 / 90 (the default) → Current, 1–30, 31–60, 61–90, >90 days
    • 7 / 30 / 60 / 90 (delinquency) → a tighter early band, useful for chasing slippage
    • 15 / 30 / 45 / 60
The report refreshes automatically; a Refresh button re-pulls the latest figures.
📷 Screenshot: The bucket preset chips with “30 / 60 / 90” selected — to be added.

​
Reading the report

Each row is one customer (for Receivables) or one vendor (for Payables), sorted with the largest outstanding balance at the top. A Totals row at the bottom sums each bucket and the grand total.

​
How items are aged

The report walks each party’s transactions in date order and applies receipts (or payments) to the oldest open charge first — standard open-item, first-in-first-out ageing. Whatever remains open is then placed in the band matching its age at the as-of date. Overpayments show as a negative amount under Current.

​
Reconciliation

Below the table, the report compares its total against the ledger:
  • Ledger balance — the receivables (or payables) control-account balance from the trial balance at the same as-of date.
  • A green Reconciles badge confirms the aged total matches the ledger balance. If they differ, a red Variance badge shows the gap.
A reconciling report is your assurance that the open-item detail is complete and matches the control account. A variance usually means an entry hit the control account without a matching open item (or vice versa) — worth investigating before the period closes.
📷 Screenshot: The reconciliation strip showing the ledger balance and a green “Reconciles” badge — to be added.

​
Drilling in

Click a customer or vendor name to open that contact, where you can see and act on the underlying documents.

​
Exporting

Export offers CSV, Excel (.xlsx), and PDF. The export carries each party with its per-bucket amounts and total, then a Totals row, the Ledger balance (TB), and the Reconciliation delta. The PDF carries your business name and the as-of date in the header.

​
Tips and gotchas

  • Receivables vs Payables are two separate pages with the same layout — make sure you’re on the one you intend (the column header reads Customer or Vendor accordingly).
  • Ageing is measured to the as-of date — move it back to see how balances looked at a past month-end.
  • Items under Unassigned are open balances on the control account with no linked party; if you see a large Unassigned figure, some documents may be missing a customer/vendor link.
  • The Current bucket holds items not yet past their first age band, plus any customer overpayments (shown negative).
  • For a closed/locked period, the figures come from the frozen snapshot taken at close.