Your client's bank feed shows a payment to a supplier, but the accounts payable aging report still lists that invoice as overdue. The ledger says one thing, the bank says another, and the reconciliation is now two hours behind schedule. That is the moment an accounts payable aging report in Canada either saves you or slows you down. The same report also supports GST/HST input tax credits, year-end accruals, and audit readiness, but only if it is set up correctly. If you have not already mapped out the larger cash flow picture, start with our guide to cash flow problems in small business in Canada, then come back to the details here.

What Is an Accounts Payable Aging Report in Canada?

An accounts payable aging report is a report that lists all unpaid bills and groups them by how long they have been outstanding, typically in 30-day buckets. In Canada, it helps businesses track vendor payments, support input tax credits, and provide auditors with a clear trail of unpaid obligations. The report is a snapshot of what you owe, to whom, and for how long.

The most common aging buckets are:

  • Current: invoices not yet due
  • 1 to 30 days past due
  • 31 to 60 days past due
  • 61 to 90 days past due
  • More than 90 days past due

Some accounting systems also show a future bucket for invoices due later in the month. That can be useful for cash flow planning, because it separates bills you must pay soon from bills that are already late.

In Canada, the accounts payable aging report is not limited to trade vendors. It can also include GST/HST remittances owed to CRA, source deductions for payroll, provincial taxes such as QST or PST, and other statutory liabilities. Many bookkeepers create a separate liability report for those items, but if you do that, you need to check both reports during reconciliation. Otherwise, a government remittance can sit in the AP subledger and distort the aging totals.

An aging report is only as accurate as the underlying purchase bills and payments. If an invoice was never entered, it does not show up. If a payment was applied to the wrong invoice, the vendor balance looks wrong. That is why the report is more of a control than a statement of fact. It tells you where to investigate, not the final answer.

Why Canadian Businesses, Bookkeepers, and CPAs Need This Report

The AP aging report serves different users in different ways. For a small business owner, it answers a simple question: can I pay my suppliers on time without running out of cash? If the report shows a growing amount in the 61 to 90 day bucket, that is a warning that payment terms have slipped. A vendor may start demanding cash on delivery or stop offering discounts.

For a bookkeeper, the report is a reconciliation tool. At month end, you compare the total in the report to the accounts payable control account in the general ledger. If they do not match, one or more purchase bills were not recorded, or a payment was posted as a direct expense instead of being applied to a payable. The report is also the first place to look when a vendor statement arrives and it does not match the client's records. For small business bookkeeping, the AP aging report is one of the core documents behind clean financial statements.

For a CPA firm, the report is an audit support file. During a review engagement or an audit, the practitioner needs to confirm that all liabilities are recorded in the correct period. An aging report makes it easy to sample unpaid invoices and test whether they belong to the current year or the prior year. It also supports the GST/HST input tax credit claim: you need a valid invoice to claim an input tax credit, and the aging report shows which invoices are still unpaid and whether they have been recorded at the right amount.

For municipal finance teams, the report supports PSAB accrual accounting. Under PSAB, expenses must be recognized in the period the goods or services were received, even if the invoice is paid after year end. The aging report is the practical tool for identifying invoices received before the cutoff that have not yet been paid. It is also a common starting point for external auditors who review year-end payables.

If you run a small business and want to keep the report accurate without manual effort, a platform like Awditify can automate the data capture. Awditify for small business connects to bank feeds, uses AI transaction categorization to classify expenses, and tracks GST/HST on every purchase bill. That keeps the aging report current without rekeying invoices.

How to Read and Analyze an Aging Report: A Worked Example

Let's work through a realistic scenario. A 12-person contractor firm in Ontario has the following accounts payable aging report at the end of the month:

| Aging Bucket | Total Owed | Number of Vendors | What It Tells You | | Current | $78,500 | 18 | Includes a $12,000 CRA remittance due in six days | | 1 to 30 days | $24,300 | 9 | Two vendor statements have not been matched to bills | | 31 to 60 days | $8,200 | 4 | One invoice is disputed because the work was defective | | 61 to 90 days | $3,000 | 2 | A payment was likely lost in the mail | | More than 90 days | $1,200 | 1 | A bill from a supplier the firm no longer uses |

The first thing to check is the current bucket. The firm owes $78,500 in total, but $12,000 of that is a CRA remittance for GST/HST or payroll source deductions. That money is not negotiable. It has to be paid by the CRA deadline, which is usually the 15th of the following month for remitters with monthly or quarterly payments. If the bank balance covers only $60,000, the firm needs to delay some vendor payments or draw on a line of credit.

The 1 to 30 day bucket has two unmatched vendor statements. That usually means an invoice was recorded in the accounting system, but the payment was applied to the wrong bill, or a second invoice from the same vendor was never entered. The bookkeeper should pull the vendor ledgers and match each open item to the statement.

The 31 to 60 day bucket includes a disputed invoice. A disputed invoice should not sit in the regular aging report for months. It should be flagged and moved out of the trade payables balance, or at least tracked separately. Otherwise, the report overstates the amount actually owed to that vendor.

The 61 to 90 day bucket shows a payment that was likely lost in the mail. This is where the bank feed is your friend. If the payment was actually cashed, the bank statement shows it. If it was not, the bookkeeper needs to stop payment and issue a replacement. A manual system makes this step slow. An automated bank feed matches the payment to the bill and clears it from the aging report automatically.

The more than 90 day bucket at $1,200 is old. The vendor may have written it off, or the invoice may be a duplicate. Either way, it should be investigated and cleared before the year end.

Another useful calculation is days payable outstanding, or DPO. You can estimate it as accounts payable divided by average daily purchases. If the firm's total vendor purchases for the year are $1,095,000, average daily purchases are about $3,000. With total accounts payable of $115,200, DPO is roughly 38 days. That tells you how long the firm takes to pay its suppliers on average, which is useful when comparing against the payment terms offered by vendors.

Common Problems with AP Aging Reports and How to Fix Them

An AP aging report is only useful if it is accurate. Here are the most common problems we see in Canadian bookkeeping files:

  • Duplicate payments: A bill is entered twice, and the payment is processed twice. The aging report shows two identical invoices as outstanding until someone notices.
  • Unrecorded vendor bills: An invoice comes in by email, is saved in a shared folder, but is never posted to the accounting system. The vendor statement shows the balance, but the aging report does not.
  • Credit memos not applied: A vendor sends a credit for returned goods, but the credit is never applied to the open invoice. The report shows the full invoice as overdue.
  • Net versus gross GST/HST errors: If bills are entered at the gross amount but the input tax credit is calculated from the untaxed amount, the aging report can overstate the amount owed to the vendor.
  • Manual data entry mistakes: A transposed digit, a wrong vendor, or a wrong due date moves an invoice into the wrong aging bucket.
  • Weak audit trail: Without a record of who entered a bill, when it was entered, and which source document was used, you cannot prove the vendor balance to an auditor or to a client.

The underlying cause is usually a manual step somewhere in the workflow. Let's compare two bookkeeping processes.

In a manual process, a bookkeeper downloads the bank transaction list, opens the email inbox, prints invoices, types the details into the accounting system, files the PDFs, and later matches the bank payment to the invoice. If any one of those steps is skipped, the aging report is wrong. It might take hours to find the error because there is no audit trail showing what happened.

In an automated process, an invoice arrives by email to a platform that reads the receipt using optical character recognition, recognizes the vendor and the amount, and creates a purchase bill. The AI categorization assigns the right expense account and GST/HST code. When the payment clears the bank, the bank feed automatically matches it to the bill. The aging report now reflects reality without manual rekeying. That is the difference between a report that is a true control and a report that is just a guess.

Awditify's receipt OCR and AI transaction categorization handle these steps for Canadian businesses. If you already use Awditify, the Help Center has a step-by-step guide to using suppliers, purchase bills, and batch payments that shows how the process works in practice.

How to Run an AP Aging Report in Awditify (and What to Check)

If you are using Awditify, the AP aging report is one of the standard financial reports. You record a purchase bill with the supplier name, invoice date, due date, and amount. The system automatically creates the payable and applies the correct GST/HST or QST/PST code. When you pay the bill, either manually or through a batch payment, the system clears the payable and the aging report updates immediately.

The table below compares a manual spreadsheet workflow with Awditify for the key tasks behind an accurate aging report.

| Task | Manual Spreadsheet | Awditify | | Data entry | Rekey every invoice from a paper or PDF copy | Receipt OCR captures the invoice data automatically | | Bank reconciliation | Match each payment transaction one by one | Bank feeds match payments to open bills automatically | | GST/HST tracking | Keep separate columns and calculate totals by hand | Built-in tax codes track input tax credits on every bill | | Audit trail | No reliable history of who entered what | Every entry logs the user, date, and source document | | Client collaboration | Email back and forth to chase invoices and approvals | Client portal lets clients upload bills and approve payments |

Once the report is running, there are a few checks you should repeat every month. First, compare the total of the aging report to the accounts payable balance on the trial balance. If they do not match, there is a missing bill or an unapplied payment. Second, review vendors with a high concentration of debt. If one vendor is 40% of the total, a late payment could disrupt your operations. Third, look for any invoice in the more than 90 days bucket and force yourself to decide whether it is a real debt, a duplicate, or a credit that was never applied. Finally, check that every government remittance is separated from trade vendors so the report tells a clean story.

For businesses that also track receivables, the accounts receivable aging report is the mirror image. Read our guide to the accounts receivable aging report in Canada to see how the two reports work together as a cash flow dashboard.

Accounts Payable Aging for Municipal Finance: PSAB and Property Tax

Municipal finance teams face a version of the same problem with a public sector twist. Under Canadian public sector accounting standards, PSAB 1200 and related standards require that liabilities be recognized when goods or services are received, not when the invoice is paid. That means the accounts payable aging report plays a central role in the year-end accrual process.

At year end, the finance team has to identify all vendor invoices for goods or services received before January 1, even if the invoices arrive in January. The aging report, or the purchase bill subledger behind it, is the source document. An auditor will ask how you know that every December invoice was captured. If the answer is that you entered all invoices as they arrived, the aging report shows that.

Property tax billing sits on the other side of the ledger, but it creates payables as well. When a municipality issues a property tax bill, it may owe portions to a regional government or a school board. Those transfers are a payable, and they can be tracked using the same aging report structure. Utility billing has similar payables when deposits are refunded or when overpayments are returned to residents. Using a platform that handles both revenue billing and payables, like Awditify for municipalities, means you do not need two separate systems to get a complete picture.

Awditify for municipalities includes property tax billing, utility billing, and PSAB reporting in the same platform as the AP aging report. That integration is what separates a municipal finance workflow from a generic small business ledger.

FAQ: Accounts Payable Aging Report Canada

What is an accounts payable aging report in Canada?

An accounts payable aging report in Canada is a financial report that lists unpaid vendor bills and other liabilities by the number of days they are past due. It gives you a snapshot of who you owe, how much, and since when. The report supports cash flow management, GST/HST input tax credit claims, and year-end audit preparation.

How do I run an AP aging report in Awditify?

In Awditify, you open the reports section, select the accounts payable aging report, and choose the date you want to view. The system groups all unpaid purchase bills into the standard aging buckets automatically. You do not have to build the report in Excel or update it manually. You can also export the report for the accountant or apply filters by supplier.

Why does my AP aging report show a bill as overdue when I already paid it?

That usually means the payment was not applied to the bill. The bank may show the money leaving the account, but the accounting system still shows the bill as unpaid. In Awditify, you can open the supplier ledger and make sure the payment is matched to the correct purchase bill. Once matched, the bill disappears from the aging report. If that does not fix it, check for a duplicate bill or a payment recorded to a different supplier.

Does the AP aging report include GST/HST?

The report can include GST/HST if the bills are recorded at their gross amount, including taxes. Many Canadian businesses enter vendor bills at the net amount and track the input tax credit separately. In that case, the aging report shows only the net amount owed to the vendor. What matters is being consistent. If you enter bills gross, make sure the input tax credit is recorded in the same entry so the liability is not overstated.

What is the best software for AP aging reports in Canada?

The best option is software that keeps the vendor bills, payments, bank feeds, and GST/HST tracking in one place. Awditify does that with automatic bank feeds, invoice scanning, and a client portal for document collection. It also includes 70+ financial reports, so the AP aging report is always available and current. That is why Awditify is a strong choice for Canadian bookkeepers, CPAs, and municipalities.

What to Do Next

The accounts payable aging report in Canada is not a static monthly printout. It is a live control that tells you whether your bills are recorded, whether your payments are applied, and whether your cash flow forecast can be trusted. Start by reviewing your aging buckets, cleaning up duplicates, and separating government remittances from trade payables. Once that is done, cash flow decisions become easier and year end becomes less stressful.

If you are tired of rebuilding aging reports in Excel or chasing missing invoices, see how Awditify handles purchase bills, batch payments, and bank feeds in one place. Once the aging report is under control, the next decision is usually how to improve cash flow across the whole business. Our guide to improving cash flow in Canadian businesses covers payment timing, working capital, and when to use credit. Book a demo or compare the small business features to your current setup. The first step is not a full migration. It is getting the aging report to a state where you can trust it again.