Receivables & payables aging: how it works
The aging report lists who owes you money and whom you owe, sorted by how late each amount is. Use it to decide which customers to chase and which supplier bills to pay next.
Lesson 5 of 17 · How it works
How it works
Open «Money → Reports → Receivables & payables aging Receivables are unpaid invoices: money customers owe you. Payables are unpaid bills: money you owe suppliers. Aging sorts them by how many days they are late. More words in the glossary». The report always shows the position as of today, in gross amounts with VAT, because that is what is really owed.
Receivables are all invoices that were sent and still have a balance (sent, viewed, partly paid or overdue). The balance is the invoice total minus the payments recorded on it.
Days are counted from the due date of the invoice. When an invoice has no due date, the issue date plus the standard due days from the finance settings is used.
Payables are all Expenses A bill or cost of the business: rent, materials, fuel, a supplier bill. “Recorded” means it is booked but not yet paid; “Paid” means the money has left. More words in the glossary with the status Recorded that are not paid yet. Expenses have no due date, so they are aged from the bill date.
Every amount falls into one column: not yet due, up to 30 days, 31 to 60, 61 to 90 and more than 90 days late. The tiles show «Receivables (AR)», «Overdue», the DSO and «Payables (AP)».
DSO (days sales outstanding) is the open receivables divided by the gross sales invoiced in the last 90 days, times 90. It tells you how many days customers take to pay on average.
Where to find it
- Money → Reports → Receivables & payables aging
/admin/reports/aging
Settings that change it
- Settings → Finance & documents → Documents & terms
/admin/settings/finance?section=documents
Checklist
Before you move on, check that you can:
- Open Money → Reports → Receivables & payables aging
- Open Money → Reports → Receivables & payables aging.
- Receivables are all invoices that were sent and still have a balance (sent, viewed, partly paid or overdue).
- Days are counted from the due date of the invoice.
- Payables are all expenses with the status Recorded that are not paid yet.
Tips and common mistakes
- A paid invoice still listed? The payment was not recorded on the invoice. Record it there and the balance disappears.
- A supplier bill leaves the payables list only when the expense is set to Paid with its paid-on date.