Accounts receivable aging report: the oldest column is income you already booked
The aging report is a statement about your books before it is one about your customers. What the total should tie to, what is really sitting in the 90-plus column, and which lines are not receivables at all.
The total of your accounts receivable aging report should equal the receivables line on your balance sheet on the same date, with both reports run on the accrual basis; when it does not, the books are wrong somewhere and no number on either report can be acted on until you know where.
Under an accrual method, IRS Publication 538, revised January 2022, states that you generally report income in the year it is earned, so every invoice in the 90-plus column is revenue already in your books and already reported, whether the customer ever pays or not.
IRS Topic no. 453 states that an accrual-method taxpayer can claim a bad debt deduction for an uncollectible receivable only if the amount was previously included in income, and only in the year the debt becomes worthless.
An accounts receivable aging report sorts every unpaid invoice by how long it has been outstanding. Read as a report about your customers, it tells you who to call. Read as a report about your books, it answers two harder questions: whether the total is right, and what the oldest column has already cost you.
Twenty pages will draw you the buckets. This one starts with the number at the bottom, because if the total does not agree with your balance sheet, none of the columns above it mean anything yet.
Does your aging report total tie to the receivables line on your balance sheet?
It should tie exactly, on the same date, with both reports on the accrual basis. When it does not, one of the two is wrong, and until you know which one, no decision taken off either is safe.
Three things break the match, and only one of them is a bookkeeping error. Intuit's QuickBooks documentation on matching the two reports, read in September 2026, states that the A/R Aging Summary is always run on an accrual basis while the balance sheet can be run on either basis, so a cash-basis balance sheet will never agree with it. The same documentation states that the aging report's aging method defaults to current rather than the report date, which quietly ages every invoice to today instead of to the date you asked about. Set both reports to the same date and the same basis before you conclude anything. If they still differ, the difference is real, and it is usually something posted straight to the receivables account with no invoice behind it.
The table below is the whole check. It is the same exercise as reading each balance sheet line against the document behind it, narrowed to one account and the report that supports it.
What you are reading | What it should tie to | What a difference usually means |
|---|---|---|
The total of the aging report at a date | The accounts receivable line on the balance sheet at the same date, both on the accrual basis | A different accounting basis, an aging method set to current rather than report date, or a journal entry posted directly to receivables with no invoice behind it |
The list of open invoices you believe are outstanding | The detail version of the same report | An invoice was entered twice, or one you sent was never entered at all |
A customer showing a negative amount | Nothing. It should not be there | A payment or a credit memo was recorded and never applied to an invoice |
A customer whose amounts offset to zero | Nothing. It should not be there either | An invoice sits in one bucket and an unapplied credit sits in another, so both buckets are wrong while the total is right |
Accounts receivable on a cash-basis balance sheet | Zero | An unapplied payment, or a transaction posted to the receivables account. Intuit's documentation, read September 2026, names those two as the usual causes |
The 90-plus column | What you actually expect to collect from it | The gap is bad debt nobody has recorded, and it is sitting in your assets and in your profit |
Invoices age against their due date rather than their invoice date, so the payment term you agreed with that customer is what decides which column the invoice lands in. Two invoices sent the same Monday, one on net 15 and one on net 60, sit in different columns six weeks later with nothing having happened to either.
Run your accounts receivable aging summary and your balance sheet on the same date, both on the accrual basis, and put the two receivables totals next to each other. If they differ by a cent, that difference is the first thing to find, before anyone picks up a phone. Then write the date of the oldest invoice in the 90-plus column at the top of the page, because that date is what the report is actually telling you.
What is in the 90-plus column that you have already reported as income?
All of it, if you are on an accrual method. Under an accrual method, IRS Publication 538, revised January 2022, states that you generally report income in the year it is earned, and that you include an amount in gross income for the tax year in which all events have occurred that fix your right to receive it and you can determine the amount with reasonable accuracy. The customer paying is not one of those events. An invoice raised in March and unpaid in September is March's revenue, it is in March's profit, and it is on today's balance sheet as an asset.
That is the sentence the collections framing hides. A 90-plus bucket that never moves is not first a collections problem. It is an overstated asset and an overstated profit, and both errors point the same way: the business looks better than it is.
Work it on one invoice. A $12,000 job finished in March, invoiced on net 30, still unpaid at the end of September. March's income statement carries $12,000 of revenue and the margin that went with it. The balance sheet carries a $12,000 asset. If that customer is never going to pay, both numbers were wrong from the day it became clear, and the profit figure the owner has been steering by since March was overstated by the whole amount. The same $12,000 is sitting on the income statement as revenue and on the balance sheet as an asset, which is why one bad receivable moves two reports.
FASB Concepts Statement No. 8, Chapter 4, issued December 2021, defines an asset as a present right of an entity to an economic benefit. A receivable from a customer who stopped answering in April is a fair test of that definition, and the aging report is where the question gets asked.
The oldest column is the only part of your balance sheet where doing nothing keeps the number exactly the same and makes it less true every month.
The tax side runs the other way from what most owners assume. IRS Topic no. 453, read in September 2026, states that an accrual-method taxpayer can claim a bad debt deduction for an uncollectible receivable only if the amount was previously included in income, and that a bad debt is deductible only in the year it becomes worthless. The same page states that a cash-method taxpayer generally cannot take a bad debt deduction for unpaid fees, rents or interest at all, because those amounts were never included in income to begin with. IRS Publication 334, the 2025 Tax Guide for Small Business, adds that you must be able to show you took reasonable steps to collect.
Which lines on your aging report are not really receivables?
Five kinds, and none of them is fixed by calling the customer. Each one is a bookkeeping error wearing a collections costume, and each one makes the report say something that is not true about the business.
What you see on the report | What it usually is | What it does to the numbers |
|---|---|---|
A customer with a negative balance | A payment or a credit memo recorded and never applied to an invoice | Understates receivables, and the invoice it belonged to is still sitting open in a bucket |
A customer whose amounts offset to zero | An open invoice in one bucket and an unapplied credit in another | The buckets are wrong even though the total is right, so the 90-plus figure overstates what is owed |
An invoice you are certain was paid | The payment was banked and matched to the deposit rather than to the invoice | Revenue counted twice, once on the invoice and once on the deposit, and receivables never clear |
The same invoice twice | A duplicate, usually from a re-send or an import | Revenue and receivables both overstated by the full amount |
A deposit or retainer taken before the work | Money held against work not yet done, which is a liability | Revenue recognized early, and a receivable that was never owed to you |
Sorting these is ordinary monthly work: matching what was invoiced against what was collected, applying every credit and payment to the invoice it belongs to, and clearing what has been settled. Intuit's QuickBooks documentation, read in September 2026, describes finding unapplied payments through the Customer Balance Detail report and applying them from the Receive Payment window. It is an hour a month, and it is the difference between an aging report you can act on and one you can only worry about. If you would rather it were not your hour, having someone reconcile it monthly is the alternative.
Where does your receivables figure end up on your tax return?
On the balance sheet the return asks for, when the return asks for one. Schedule L of the 2025 Form 1065 carries “Trade notes and accounts receivable” on line 2a, with “Less allowance for bad debts” on line 2b directly beneath it. Schedule L on the 2025 Form 1120-S lists the same trade notes and accounts receivable line for an S corporation, second in the asset section after cash. Whatever your aging report totals at year end is what belongs on that line, which is the reason the tie-out matters beyond your own curiosity.
Two thresholds decide whether anyone outside the business ever sees the figure at all, and both are worth knowing for what they mean rather than for what they require.
Entity | The threshold, for tax year 2025 | What it means |
|---|---|---|
Partnership or multi-member LLC filing Form 1065 | Schedule B question 4: total receipts under $250,000, total assets under $1 million at year end, Schedules K-1 furnished on time, and no Schedule M-3 required | Answer yes to all four and Schedules L, M-1 and M-2 are not required at all |
S corporation filing Form 1120-S | Schedule B question 11: total receipts under $250,000 and total assets under $250,000 at year end | Answer yes and Schedules L and M-1 are not required |
Read the right-hand column as a signal rather than a filing rule. Below those thresholds no balance sheet leaves the business, so nothing external will ever catch a receivables figure that has been wrong for three years. Above them, the number on your return is the number in your books, and a preparer who finds the two disagree has to reconcile them before filing, usually in March, usually at your expense in time. Both thresholds are in the 2025 instructions for Form 1065 and the 2025 instructions for Form 1120-S.
Whether a particular old invoice is worthless in a given year is a filing position, not a bookkeeping one. Work out what is real, then take the list to whoever files your return rather than deciding it off the aging report.
What do you do about a bucket that never moves?
Compare the 90-plus total at two consecutive month-ends. If the figure is the same and the invoices behind it are the same invoices, the aging report has stopped being a collections report and has become a statement about your balance sheet, and it wants a different response.
Three steps, in this order.
Confirm each one is a real receivable. Run the five checks in the table above against every invoice in the column before treating any of them as a debt. A duplicate is deleted, not chased.
Write down what you have already done to collect, with dates. IRS Publication 334, the 2025 Tax Guide for Small Business, states that you must be able to show you took reasonable steps to collect a debt, and an email thread with dates in it is that evidence. This is bookkeeping, and doing it in September beats reconstructing it in March.
Take the survivors to your preparer with the age of each one. Whether a debt is worthless this year is their call with you, and it is the point where the aging report hands over to the tax return.
One mechanical warning, because it is the most common way this gets worse. Do not delete the old invoice to make the report look clean. Deleting it removes the revenue from the month it was earned, which changes a period you have already closed, already reported on, and possibly already filed. Recording a write-off leaves March alone and puts the loss in the month you recognized it. The report looks the same afterward. The books do not.
How do I run an AR aging report in QuickBooks?
In QuickBooks Online, go to Reports, then Standard reports, and under “Who owes you” select Accounts receivable aging summary. Intuit's documentation, read in September 2026, describes the summary as showing total outstanding balances and how long they are past due, and a second report, Accounts receivable aging detail, as listing the individual transactions behind those totals.
Change one setting before you read it. Under Customize report and the General options panel, Intuit's documentation states that the Aging dropdown offers a Report date option, and that selecting it is what makes the aging report agree with the balance sheet or trial balance for the same date. Left on the default, the report ages every invoice to today, which is fine for a phone list and useless for a tie-out.
What are the standard aging buckets?
Current, meaning not yet due, then 1 to 30, 31 to 60, 61 to 90, and 91 and over days past due. Some systems split the tail further into 91 to 120 and over 120, which is worth doing if you have anything living out that far.
Those brackets are a convention rather than a rule. No accounting standard and no part of the tax code sets them, which is why a report from one system does not always compare with a report from another, and why the column headings are worth checking before you compare this month with last. What matters is not the number of columns but whether the same invoice would land in the same one twice.
How is accounts receivable aging calculated?
For each open invoice, take the date of the report and subtract the invoice's due date. The result is the days past due, and the invoice falls into the bucket that number lands in. Anything with a due date in the future is current.
An invoice due August 20, read on a report dated September 30, is 41 days past due and sits in the 31 to 60 column. Note what the calculation does not use: the invoice date. An invoice sent on August 5 with 60-day terms is not yet due on September 30 and sits in current, while one sent the same day on 15-day terms is 26 days past due. The report is aging your terms, not your work.
The totals then roll up by customer, so a customer with three invoices appears once with an amount in each column those invoices reach.
What is an aging report in accounting?
An aging report is a subsidiary ledger: a list of the individual items making up the balance of a single account in your general ledger, sorted here by how overdue each one is. For accounts receivable, it is every unpaid customer invoice that adds up to the receivables line on your balance sheet. There is an equivalent report for accounts payable, which does the same job for what you owe suppliers.
Calling it a subsidiary ledger rather than a collections tool is what makes the tie-out obvious. A subsidiary ledger that does not add up to the account it supports has an error in one of the two, and that is a bookkeeping question with a right answer rather than a judgment call about which customers to chase.
Know what your receivables are actually worth
Deciding what to do about the oldest column starts with being able to trust the total above it. If your aging report and your balance sheet disagree and you would rather not spend a Saturday working out why, we can go through your books with you and show you where the two split.
This article explains how the rules generally work. It is not tax advice for your situation.
Former FP&A analyst who now reads P&Ls the way other people read box scores. Covers spend patterns, margin trends, and what the numbers say before the owner notices.
