Aged Debtors & Creditors

What it does

Aged Debtors shows money owed to you by customers. Aged Creditors shows money you owe to suppliers. Both break amounts into ageing buckets so you can prioritise.

The report respects two things the headline number used to ignore:

• Partial payments. If a customer has paid £400 of a £1,000 invoice, the report shows the £600 outstanding — not the full £1,000.
• Active bad-debt provisions. Specific provisions on individual invoices and the general provision (% per bucket) are both netted out of the displayed total. The headline reflects what you actually expect to collect.

How to use it

1. Go to Reports and select Aged Debtors or Aged Creditors.
2. Set the "as at" date (defaults to today).
3. Review the summary table — amounts grouped by contact with buckets: Current, 1–30 days, 31–60 days, 61–90 days, 90+ days.
4. Click any contact row to expand to individual invoices, showing outstanding (not gross) per invoice.

Tips

• Colour coding runs from green (current) to red (90+ days).
• Use Aged Debtors to prioritise customer chasing. The 90+ bucket is where you'll typically be raising specific bad-debt provisions — see Create a specific bad-debt provision.
• Use Aged Creditors to plan upcoming payments and avoid late fees.
• Export to CSV or PDF to share with your accountant. The PDF shows the same partial-aware + provision-aware totals as the screen.
• Run at month-end as part of your regular bookkeeping routine, and at year-end as the input to your bad-debt review (see the Year-end checklist series).