Category: Reports Author: DII Editorial Team

When to Look at Aged Receivables

Introduction

Aged receivables are most useful before cash pressure becomes urgent.

Many small business owners look at unpaid invoices only when the bank balance feels weak. By that point, the business may already be under pressure. Supplier bills may be due. VAT or tax money may be needed. Owner pay may be delayed. Subcontractors may be waiting. The business may start borrowing or using personal money to cover gaps.

Aged receivables help prevent that surprise.

They show which customers owe money, how much they owe, and how long the invoices have been unpaid.

In plain English, aged receivables answer:

Who owes the business money, and how old is that debt?

This report is important because invoices are not cash. A business can issue invoices and show revenue, but the money is not useful until customers pay.

For the foundation, read Invoice vs Payment: Why They Should Not Be Mixed Up.


What aged receivables means

Aged receivables is a report that groups unpaid customer invoices by age.

It usually shows invoices in age bands such as:

Age band What it means
Current / not due yet Invoice has been issued but payment date has not passed
1–30 days overdue Payment date has passed recently
31–60 days overdue Cash risk is increasing
61–90 days overdue Stronger chasing may be needed
Over 90 days overdue High risk of non-payment, dispute or serious delay

The exact age bands can vary by system, but the idea is the same.

The report turns unpaid invoices into a visible payment risk map.

Instead of thinking:

“Some customers have not paid.”

The owner can see:

  • which customer owes money,
  • which invoice is unpaid,
  • how much is overdue,
  • how long it has been overdue,
  • which invoices need chasing first.

This makes the next action clearer.


Why aged receivables matter

Aged receivables matter because unpaid invoices can create false confidence.

A business may have strong sales on paper, but weak cash in the bank.

Example:

Area Amount
Sales invoices issued this month £12,000
Customer payments received £5,000
Unpaid customer invoices £7,000
Supplier bills due soon £4,500
Bank balance £1,800

The business has charged customers £12,000.

But only £5,000 has arrived.

The unpaid £7,000 may arrive later, but the business has to survive until then.

Aged receivables show whether the unpaid amount is normal, risky, or becoming urgent.

For the wider cash flow effect, read Late Payments and Their Cash Flow Impact.


Aged receivables are not only for accountants

Some owners think aged receivables are an accountant report.

They are not.

They are a business survival report.

Aged receivables help the owner decide:

Question Why it matters
Who should we chase first? Saves time and protects cash
Which invoices are overdue? Shows immediate collection risk
Which customers regularly pay late? Shows behaviour pattern
How much cash is trapped in unpaid invoices? Explains bank pressure
Can we safely pay suppliers or withdraw money? Links customer cash to outgoing commitments
Are our payment terms too generous? Helps improve future terms
Is one customer creating too much risk? Shows concentration risk

A business can be profitable and still unsafe if customers are not paying.

That is why aged receivables should be reviewed regularly.


The best time to look at aged receivables

The best time to look at aged receivables is before the business feels desperate.

Do not wait until the bank is almost empty.

A small business should look at aged receivables:

Timing Why it helps
Weekly Keeps late invoices visible
Before paying large supplier bills Checks whether customer cash is expected
Before owner withdrawals Shows whether cash is genuinely safe
Before VAT or tax payments Protects reserved money
Before month-end close Improves reporting confidence
Before taking on more work for a customer Avoids increasing exposure
Before chasing customers Gives the correct priority list
Before applying for finance Shows customer debt quality
Before year-end Supports cleaner records

Aged receivables are not only a report for when things go wrong.

They are a report that helps stop things from going wrong.


Weekly aged receivables review

A weekly aged receivables review is useful for active businesses.

It does not need to be long.

The owner can ask:

  • Which invoices became overdue this week?
  • Which invoices are due soon?
  • Which customers promised payment?
  • Which customers ignored reminders?
  • Which invoice is now more than 30 days overdue?
  • Which customer owes the largest amount?
  • Which unpaid invoice could affect supplier payments?
  • Do we need to pause work for any customer?

A simple weekly view might look like this:

Customer Amount unpaid Age Action
Customer A £1,200 Not due yet Monitor
Customer B £900 5 days overdue Send friendly reminder
Customer C £2,400 22 days overdue Follow up and ask for payment date
Customer D £3,000 48 days overdue Escalate
Customer E £750 92 days overdue Review recovery options

This is much stronger than vague stress.

The business can see exactly what needs attention.


Month-end aged receivables review

Aged receivables should also be checked at month end.

Month end is when the owner usually reviews profit, cash, invoices, bills and reports.

The aged receivables report helps explain why cash and profit may not match.

For example:

Month-end measure Amount
Profit for the month £4,000
Customer invoices unpaid £6,500
Overdue invoices £3,200
Bank balance £1,400

The business may be profitable, but cash is weak because customers have not paid.

This is not a contradiction.

It is a timing problem.

For more on that difference, read Cash vs Profit: Why They Are Not the Same Thing.


Before paying suppliers

Aged receivables should be checked before paying large supplier bills.

This does not mean the business should avoid paying suppliers.

It means the business should understand the timing.

Example:

Area Amount
Bank balance £3,000
Supplier bills due this week £2,700
Customer invoices expected this week £4,500
Overdue invoices £2,000

The business may be able to pay suppliers, but it needs to know whether customer payments are reliable.

If expected customer payments do not arrive, cash may become tight quickly.

Aged receivables help the owner see:

  • whether customer cash is due,
  • whether any cash is already late,
  • whether supplier payments need planning,
  • whether customer chasing should happen before large outgoing payments.

This is how receivables connect to payables.


Before owner withdrawals

Aged receivables should be reviewed before the owner takes money out of the business.

A bank balance can look safe while customers still owe money and bills remain unpaid.

Example:

Area Amount
Bank balance £5,000
Overdue customer invoices £4,000
Supplier bills due soon £3,200
VAT or tax reserve needed £1,000
Suggested owner withdrawal Needs careful review

The owner may think there is £5,000 available.

But after known commitments, the free cash may be much lower.

Aged receivables help the owner avoid taking money out while the business is still waiting for customer payments.

For the wider bank-balance warning, read Why Bank Balance Is Not Business Performance.


Before doing more work for the same customer

Aged receivables are very important before accepting more work from a customer who has unpaid invoices.

If a customer already owes money, new work increases exposure.

Before continuing, ask:

Question Why it matters
Is the customer overdue? Shows payment risk
How much do they owe? Shows exposure
Did they promise payment? Shows reliability
Have they broken payment promises before? Shows pattern
Is the next work expensive to deliver? Shows additional risk
Should work pause until payment is received? Protects the business

A customer who pays late once may simply have a process issue.

A customer who repeatedly pays late is a business risk.

Aged receivables show the pattern.


Before chasing invoices

Aged receivables should guide invoice chasing.

Do not chase randomly.

The report should show priority.

Priority may depend on:

Factor Why it matters
Invoice age Older invoices carry more risk
Invoice amount Larger invoices affect cash more
Customer history Repeat late payers need attention
Promised payment date Broken promises need escalation
Dispute status Disputes need resolution
Customer importance Strategic customers may need careful handling
Cash pressure Some invoices affect survival more immediately

A good chasing process starts with the report, not emotion.

For the chasing process, read How to Chase Overdue Invoices.


Aged receivables and late payment stages

Aged receivables can support a clear chasing workflow.

Age of invoice Suggested action
Not due yet Monitor
Due in next 3–5 days Optional polite reminder for larger invoices
1–7 days overdue Friendly reminder
8–14 days overdue Follow up and ask for payment date
15–30 days overdue Stronger reminder and escalation
31–60 days overdue Escalate to accounts team, manager or decision-maker
60–90 days overdue Formal reminder or recovery review
Over 90 days overdue Serious risk review

The exact timing depends on the business, customer, amount and relationship.

But the principle is clear:

Older invoices need stronger attention.

Do not let invoices quietly age until they become difficult to collect.


What aged receivables reveal about customers

Aged receivables do not only show invoices.

They show customer behaviour.

A useful customer view might show:

Customer Normal payment behaviour Risk
Customer A Usually pays within terms Low
Customer B Pays 10–20 days late Medium
Customer C Needs repeated chasing High
Customer D Has disputed recent invoices Needs review
Customer E Large customer but slow payer Concentration risk

This helps the business decide future terms.

A reliable customer may keep normal terms.

A slow payer may need shorter terms.

A new customer may need a deposit.

A repeated late payer may need work paused until payment.

Aged receivables help move payment decisions from feeling to evidence.


Aged receivables and deposits

If customers regularly pay late, deposits may reduce risk.

A deposit means the customer pays part of the money before the work is complete.

This helps the business avoid carrying the full cost while waiting for payment later.

Example:

Project value No deposit 30% deposit
Total project £3,000 £3,000
Cash received before work £0 £900
Balance exposed after work £3,000 £2,100

Deposits do not remove all risk, but they reduce exposure.

If aged receivables show repeated late payment, the business should review whether deposits, stage payments or payment before final delivery would be healthier.

A related guide is Should You Take Deposits From Customers?.


Aged receivables and payment terms

Aged receivables can show whether payment terms are working.

If many invoices are overdue, the issue may not only be customer behaviour.

It may also be the business process.

Ask:

  • Are payment terms clear?
  • Are invoices sent quickly?
  • Are due dates visible?
  • Are payment details easy to find?
  • Are invoices going to the right person?
  • Are purchase order numbers included when needed?
  • Are customers reminded before or after due dates?
  • Are long terms creating unnecessary cash pressure?

Aged receivables show the outcome of your payment terms.

If the report keeps getting worse, the terms or process may need to change.

For invoice timing, read When to Issue an Invoice in the UK.


Aged receivables and payment timing

Aged receivables also help explain payment vs revenue timing.

Revenue may appear when an invoice is issued.

Payment appears when the customer pays.

The aged receivables report shows the gap between those two events.

Example:

Item Amount
Revenue invoiced this month £10,000
Payments received this month £6,000
Unpaid invoices remaining £4,000
Overdue invoices £1,500

The business has revenue, but not all cash has arrived.

This is why aged receivables should be read with revenue and bank reports.

A deeper guide is Payment vs Revenue Timing Problems.


Aged receivables and reports

Aged receivables should be read with other reports.

Report Question it answers
Aged receivables Who owes us money?
Profit and loss Did we make profit during the period?
Bank summary What cash actually arrived?
Cash flow view Will cash arrive before bills are due?
Aged payables Who do we need to pay?
Reconciliation report Are payments matched correctly?
Balance sheet What is owed to and by the business?

Aged receivables alone are useful.

But aged receivables plus cash flow is stronger.

Aged receivables plus aged payables is stronger again.

Aged receivables plus reconciliation helps confirm whether invoices are really unpaid.

For reconciliation, read Why Reconciliation Matters.


Reconciliation before chasing

Before chasing an invoice, check reconciliation.

Sometimes a customer has paid, but the payment is not matched.

This can happen when:

  • the customer used the wrong reference,
  • the payment came from a different company name,
  • payment came through a payment provider,
  • several invoices were paid together,
  • the bank feed has not been updated,
  • the payment was part-paid,
  • the payment went to another bank account,
  • the invoice was credited or corrected.

Chasing a customer who already paid can damage trust.

Before sending a strong reminder, confirm:

Check Why it matters
Bank account reviewed Payment may already be there
Payment reference checked Customer may have used wrong reference
Payment provider checked Settlement may be delayed
Credit notes checked Invoice may have been adjusted
Part-payments checked Invoice may not be fully unpaid
Customer account checked Payment may relate to multiple invoices

Aged receivables are powerful, but they rely on accurate matching.


Aged receivables and cash flow forecasting

Aged receivables help cash flow forecasting because they show expected incoming cash.

But not all receivables are equally reliable.

A new unpaid invoice that is not due yet may be low risk.

An invoice that is 75 days overdue may be much less reliable.

A cautious cash flow forecast should treat old receivables carefully.

Example:

Receivable type Forecast confidence
Not due yet from reliable customer Higher confidence
Slightly overdue from reliable customer Medium confidence
Long overdue invoice Low confidence
Disputed invoice Very low confidence
Customer with broken promises Low confidence
Part-paid invoice Review remaining balance

The business should not plan cash as if every unpaid invoice will arrive on time.

Aged receivables help separate expected cash from risky cash.


Aged receivables and bad debt risk

Some invoices may become doubtful.

That means the business is no longer confident the customer will pay in full.

Warning signs include:

  • customer ignores reminders,
  • customer breaks payment promises,
  • customer disputes after long silence,
  • invoice is more than 90 days overdue,
  • customer has financial problems,
  • customer has stopped trading,
  • customer pays only small amounts without plan,
  • customer avoids contact,
  • customer keeps requesting more work without paying old invoices.

This does not automatically mean the invoice should be written off.

But it does mean the business should investigate and consider escalation, advice or recovery steps.

Aged receivables help identify these problems before they disappear into memory.


Aged receivables and VAT

VAT can make unpaid invoices more important for VAT-registered businesses.

VAT treatment depends on the VAT scheme, timing, invoice status, payment status, evidence and business situation.

For beginners, the practical point is:

If VAT applies, unpaid invoices still need accurate VAT records.

A VAT-registered business should know:

  • which invoices include VAT,
  • the VAT amount,
  • the invoice date,
  • the payment status,
  • the VAT period,
  • whether any credit note or correction exists,
  • whether the invoice is still unpaid.

Do not treat VAT as ordinary profit or free cash.

For the beginner explanation, read What VAT Really Is.


Aged receivables and the balance sheet

Aged receivables are connected to the balance sheet.

Unpaid customer invoices are usually part of what the business is owed.

That means they may appear as receivables on the balance sheet.

But the age of those receivables matters.

A balance sheet may show:

Balance sheet item Amount
Trade receivables £12,000

That number is useful, but it is not enough.

Aged receivables explain the quality of that £12,000.

Age band Amount
Not due yet £5,000
1–30 days overdue £3,000
31–60 days overdue £2,500
61–90 days overdue £1,000
Over 90 days overdue £500

The total is £12,000, but some of it is riskier than the rest.

For the wider balance sheet explanation, read What a Balance Sheet Actually Tells You.


What good aged receivables review looks like

A good aged receivables review is not just looking at the total.

The owner should check:

Review question Why it matters
What is the total unpaid amount? Shows cash still waiting
What is overdue? Shows cash that should already have arrived
What is over 30 days overdue? Shows growing risk
What is over 60 days overdue? Shows stronger collection risk
Which customer owes the most? Shows concentration
Which customers are repeat late payers? Shows behaviour pattern
Which invoices are disputed? Needs resolution
Which payments were promised? Needs follow-up
Which invoices should be escalated? Turns report into action
Are payments reconciled? Prevents false chasing

The report should lead to decisions.

If it does not lead to action, it becomes just another screen.


A simple aged receivables workflow

A simple workflow can look like this:

Step Action
1 Review aged receivables weekly
2 Check invoices due soon
3 Send reminders for important upcoming payments
4 Chase invoices 1–7 days overdue
5 Follow up invoices 8–14 days overdue
6 Escalate invoices 15–30 days overdue
7 Review invoices 30+ days overdue carefully
8 Pause further work for repeat late payers if needed
9 Record customer promises and responses
10 Reconcile payments before stronger chasing
11 Review payment terms for repeat problems
12 Consider deposits or stage payments for risky customers

This workflow turns aged receivables into practical cash control.


Common mistakes

Mistake 1: Looking only at total unpaid invoices

The total matters, but age matters too.

£5,000 not due yet is different from £5,000 overdue for 90 days.

Mistake 2: Waiting until cash is urgent

Aged receivables should be reviewed before cash pressure becomes serious.

Mistake 3: Chasing without checking reconciliation

A customer may already have paid.

Always check payment matching before strong reminders.

Mistake 4: Treating every customer the same

A reliable customer and repeat late payer should not always receive the same terms.

Mistake 5: Ignoring small old invoices

Small overdue invoices can reveal process problems.

They also create clutter and uncertainty.

Mistake 6: Letting disputed invoices age silently

A disputed invoice needs resolution, not only reminders.

Mistake 7: Not recording promises

If the customer promises payment, record the date and follow up.

Mistake 8: Continuing work for customers who do not pay

This increases exposure.

Pause or change terms when needed.

Mistake 9: Not connecting receivables to cash flow

Receivables show expected cash.

Cash flow shows whether that cash arrives before bills are due.

Mistake 10: Not reviewing payment terms

If aged receivables are always weak, the payment process may need changing.


Final summary

Aged receivables show who owes the business money and how old those unpaid invoices are.

They are most useful before cash pressure becomes urgent.

A business should look at aged receivables:

  • weekly,
  • before chasing customers,
  • before paying large supplier bills,
  • before owner withdrawals,
  • before VAT or tax deadlines,
  • before month-end close,
  • before taking more work from a late-paying customer,
  • before reviewing cash flow.

The report helps the owner see:

  • total unpaid invoices,
  • overdue invoices,
  • high-risk customers,
  • repeated late payers,
  • disputed invoices,
  • risky old balances,
  • cash still waiting,
  • collection priorities.

The main lesson is simple:

An invoice is not cash until the customer pays.

Aged receivables help the business see where cash is trapped before the bank balance becomes urgent.

Good businesses do not wait until panic to chase payment.

They use aged receivables early, calmly and consistently.