Aged debtors and creditors

These two reports answer the cash-flow questions: who owes you money, who you owe, and how long it has been outstanding.

• Aged Debtors lists unpaid invoices, grouped by customer.
• Aged Creditors lists unpaid bills, grouped by supplier.

They are mirror images, so they work identically and are usually read as a pair at the end of a period.

Run the report

1. Go to Reports and choose Aged Debtors or Aged Creditors.
2. Set Ageing by to either Invoice date or Due date. Ageing by due date tells you how late a payment is; ageing by invoice date tells you how long the debt has existed.
3. Set the report Date - the "as at" date. Everything still unpaid on that date appears. It defaults to today, so pick a period end to see the position as it stood then.

The subtitle confirms what you are looking at, for example As at 31 Dec 24 ageing by invoice date.

Read the report

Each row is one contact, with the amount outstanding split across four ageing columns:

• 0-30 Days
• 31-60 Days
• 61-90 Days
• >90 Days

Anything not yet due sits in the 0-30 Days column rather than a column of its own, and the further right an amount appears, the longer it has been outstanding.

The columns are Total, VAT, and then the four buckets, with a Grand Total row at the foot.

See the documents behind a figure

Click a contact to expand it, or use Expand all, and each unpaid document is listed with its own row: the reference, the Invoice date (or Bill date), the Due date, and its amount in the single ageing column it falls into.

Click a document to open the invoice, bill, or credit note itself.

Things worth knowing

• Figures are shown in your organisation's own currency. Where a document was raised in another currency, its face amount is shown alongside - see Foreign currency and FX.
• A negative total is not an error: it means the contact is in credit, usually because of an unapplied credit note.
• Credit notes appear too, since they offset what is owed. See Apply or refund a credit note and Bill credit notes.
• An amount you expect to see missing is usually a document that was never sent - a draft has no effect on your accounts.

Related

• Account transactions
• Balance sheet
• Send a statement of account