Receivables aging

Reviewed by Ijaz Ali, ACCA · Updated November 2026

In this lesson you will learn to

  • Explain the accounting behind the examples.
  • Post the transactions and reconcile debits and credits.
  • Identify the records to review in the workplace.

The basics

An aging report groups the unpaid portions of invoices by days past due.

Why it works

With the same report date and scope, unpaid invoices reconcile to the receivables control balance.

Worked examples at Great Lakes Supply Ltd.

Great Lakes Supply Ltd. is a fictional wholesale distributor in Mississauga, Ontario. Amounts are in Canadian dollars. Examples that specify an Ontario taxable supply use 13% HST.

Example 1

Invoice A, now 15 days overdue, was originally $1,000 plus $130 HST.

Journal entry (CAD)
AccountDebitCredit
Accounts receivable — A$1,130
Sales revenue$1,000
HST payable$130
Total$1,130$1,130

Example 2

Invoice B, now 45 days overdue, was originally $500 plus $65 HST.

Journal entry (CAD)
AccountDebitCredit
Accounts receivable — B$565
Sales revenue$500
HST payable$65
Total$565$565

Example 3

Invoice C, still current, was originally $800 plus $104 HST.

Journal entry (CAD)
AccountDebitCredit
Accounts receivable — C$904
Sales revenue$800
HST payable$104
Total$904$904

Example 4

Apply $300 to invoice A. The aging is $830 at 1–30 days, $565 at 31–60 days and $904 current, for $2,299 total.

Journal entry (CAD)
AccountDebitCredit
Cash$300
Accounts receivable — A$300
Total$300$300

Across the four examples, debits and credits each total $2,899.

Common mistakes

  1. Posting to the wrong account. In Example 1, use Accounts receivable — A $1,130 on the debit side.
  2. Recording the amount from memory. Match the amount to the supporting document and use 13% HST when the exercise specifies an Ontario taxable supply.
  3. Missing a line when several accounts change. Compare the full entry to the transaction before posting.
  4. Assuming equal totals confirm the classification. Check the account, date and supporting evidence as well.

Check your understanding

Question 1

Invoice A, now 15 days overdue, was originally $1,000 plus $130 HST. Which accounts and amounts go on each side?

Show answer

Debit Accounts receivable — A $1,130. Credit Sales revenue $1,000 and HST payable $130.

Question 2

Invoice B, now 45 days overdue, was originally $500 plus $65 HST. Which accounts and amounts go on each side?

Show answer

Debit Accounts receivable — B $565. Credit Sales revenue $500 and HST payable $65.

Question 3

Invoice C, still current, was originally $800 plus $104 HST. Which accounts and amounts go on each side?

Show answer

Debit Accounts receivable — C $904. Credit Sales revenue $800 and HST payable $104.

Question 4

Apply $300 to invoice A. The aging is $830 at 1–30 days, $565 at 31–60 days and $904 current, for $2,299 total. Which accounts and amounts go on each side?

Show answer

Debit Cash $300. Credit Accounts receivable — A $300.

In the workplace

In SAP, run the customer open-item report as at month-end, include credits and document cut-off and due-date parameters.

Key takeaways

  • An aging report groups the unpaid portions of invoices by days past due.
  • With the same report date and scope, unpaid invoices reconcile to the receivables control balance.
  • Verify the timing, account classification and supporting records before posting.

About the tutor

Ijaz Ali is an ACCA-qualified Senior Accountant with over 10 years of experience in financial reporting, month-end close and SAP FICO. He is a former SAP FICO instructor and runs The Accounting Nest YouTube channel.

Watch on YouTube