From the due dateQuickBooks, with no setting to change it
report date − due date = 14 days
The better measure of lateness, because lateness is what the report is for. It only exists if the due date exists: an invoice with no terms is treated as due on receipt, so it is overdue the next morning rather than current for a month.
From the invoice dateBlackLine, AccountingTools and two more
report date − invoice date = 44 days
The same invoice, one column further along. The gap between the two readings is exactly your payment terms, so on net 60 they are two columns apart. Nothing on either report says which of them you are looking at.
Four of the ten pages Google ranks for this count the days from the due date and four count them from the invoice date. Neither half thinks it is doing anything unusual, and the same unpaid invoice sits in a different column depending on which clock your software runs.
What I checked
The same unpaid invoice lands in a different column depending on which half your software belongs to, and neither half thinks it is doing anything unusual. If you only want the ratio rather than the report, there is a free days in A/R calculator on this site. This guide is about the table underneath it.
On 1 September 2026 I opened the pages Google returns for accounts receivable aging report and for a query about whether ageing runs from the due date or the invoice date. Twelve pages. Two would not load for me at all, and I am counting them out rather than guessing: the QuickBooks blog article timed out on every attempt, and NetSuite returns 403 to anything without a browser session.
That leaves ten pages I read. One question for each, fixed before I started: does this page say which date the days are counted from? Not how many buckets it prints, and not what it says about collections.
An even split, and both sides are plain about it. The tenth page is a curiosity rather than a camp: Indiana University counts from a workflow approval date, a timestamp inside one university's ERP standing in for the invoice date.
Counting from the due date. Stripe measures "the number of days between the invoice due date and the current date". Corporate Finance Institute defines a column as invoices "31 to 60 days past their due date". Chaser is the most explicit of all, defining days past due as "The number of days that have elapsed since the invoice's due date". Allianz Trade says the method "divides accounts receivable into different categories based on the elapsed time since invoices were due".
Counting from the invoice date. BlackLine says the status of each group "reflects the time that has elapsed since an invoice was issued to the customer". AccountingTools is blunter still, describing a left-hand column of "invoices that are 30 days old or less", and it works an example that removes all doubt: on net 15 terms, a 16 day old invoice "drops into the second column, which highlights that they are now overdue for payment". Chargebee's opening line counts "unpaid invoices since the time the sales invoice was issued". TreviPay says "Invoice Date is critical for determining how long a payment has been outstanding, which feeds into the aging periods."
What that does to one invoice
Say you invoice 4,000 dollars on 1 June, on net 30 terms, so payment is due 1 July. You run the report on 15 July and the customer has not paid.
- Counted from the due date, the invoice is 14 days late. It lands in 1 to 30.
- Counted from the invoice date, it is 44 days old. It lands in 31 to 60.
One invoice, one report date, two columns, both labelled the same way. Nothing about the customer changed. If you hand a lender the second version and your covenant is written against the first, you have just reported a problem you do not have. If you read the first version and think nothing is aging, you have missed that the money left your hands 44 days ago.
The gap is exactly your payment terms. On net 30 the two reports are one column apart. On net 60 they are two.
The columns are not the same width either
The 30 day column is a convention, not a rule, and the software you already own may not follow it.
QuickBooks Online ages by the due date and gives you no choice about it. Its own help page says "the aging is based on the due date of a transaction". It also handles the case none of the ten pages covered: "If there is NO due date, the transaction is considered due upon receipt and is driven by the transaction date." So an invoice with blank terms is not treated as current for 30 days. It is late tomorrow.
Zoho Books does give you the choice, saying the report shows what customers owe "based on the invoice due date or the invoice date". But its columns are not 30 days wide by default. They run 1 to 15, then 16 to 30, then 31 to 45. Our 14 day late invoice sits in the first past due column of both systems, and those two columns are not the same thing: at QuickBooks it means up to a month late, at Zoho up to a fortnight.
The third thing the report hides
An aging report is a photograph, not a film. Every number in it is true for one date and no other. Run it again on Monday and invoices cross into the next column on their own, without anyone doing anything wrong.
Corporate Finance Institute makes this point before I do, and adds the premise that matters: most companies bill toward the end of the month and run the report days later. If that is how you bill, and you run on the 1st with net 30 terms, a whole month of invoices had just become due. Run on the 28th instead and the same receivables look healthier.
None of this is a scandal. It only becomes one when the number crosses a boundary: into a lender's covenant, into a benchmark you found online, into a comparison with last quarter that was run on a different day.
Three things to pin down
Which date your report counts from
Look for the setting first. QuickBooks has none and uses the due date; Zoho lets you pick. If the help page does not say, do not keep reading it: post a dated test invoice with terms you choose, run the report, and see which column it lands in. That answers the question in a minute, whatever the documentation does or does not admit.
Whether your invoices have terms at all
Ageing by due date is the better measure of lateness, because lateness is what you are trying to see. But it only exists if the due date exists. An invoice with no terms is not gently current: in QuickBooks it is overdue the next morning.
What to do when the two do not match
If your report ages from the invoice date and the covenant, benchmark or board pack you are feeding is written in days past due, restate before you send it. Subtract your standard terms from every column boundary, and say on the page that you did.
Where this sits in our own tool
I should say what mine does, because the same question applies to it, and the honest answer is less flattering than the one I first wrote.
KPI Vitals reads the invoice list you already keep. It ages by due date, and it invents the due date: invoice date plus a hard-coded 30 days. So the 44 day old invoice above lands in its "1 to 30" column, which is the due date answer. It says the assumption on the card: your file has no terms column, so 30 days from the invoice date is assumed.
Three limits follow from that, and none of them is in the sales copy. There is no setting. It does not read a terms or a due date column even when your export has one. And if your customers are on anything other than net 30, my columns are shifted by the difference, which is the exact error the rest of this article is about. It also needs a paid on date to know what is still open, so without that column the whole cash page dims and tells you why.
What it does get right is the as of date: the buckets are fixed to the last date in your file rather than to today, so the period buttons do not quietly move invoices between columns while you look at them.
Related reading
- A/R Days: how to calculate days in A/R, and what good looks like covers the healthcare version, where the definitions are settled rather than split
- Revenue cycle KPIs: the six numbers that decide if you get paid
- Net collection rate: the revenue leak most clinics miss
- Breakeven ROAS: the one field no calculator asks for
Questions people actually ask
Both are in use and neither has won. Of ten page-one explainers I read, four counted from the due date and four from the invoice date, one used a workflow approval date and one never said. QuickBooks Online ages by the due date and gives no option. Zoho Books lets you pick either. Check your own report before you compare its numbers with anything.
If the settings and the help page do not say, test it. Post a dated invoice with terms you choose, run the report, and see which column it lands in. That answers the question in a minute and does not depend on the documentation being honest or complete.
Current, 1 to 30, 31 to 60, 61 to 90 and over 90 is the common set, but it is a convention rather than a rule. Zoho Books ships 15 day intervals by default: 1 to 15, 16 to 30, 31 to 45. Two reports can both put an invoice in the first past due column and mean different things by it.
It depends on the system, and the answer is rarely gentle. QuickBooks treats a transaction with no due date as due on receipt, driven by the transaction date, so it is past due the day after it is issued rather than current for a month.
An aging report is a balance on one date. Invoices cross into the next column as days pass, with nobody doing anything wrong. If you bill toward the end of the month and run on the 1st, a whole month of invoices has just become due. That is why the run date belongs on the report.
No. The aging report splits what you are owed by how late it is. Days sales outstanding compresses the same receivables into a single number of days. The report tells you where the money is stuck; the ratio tells you how long the average dollar waits.
WRITTEN BY
Olha · clinic data analyst
I build the reporting our managers open every morning at a multi-branch medical clinic — and package it so other practices don't have to start from scratch.
Published on 1 September 2026. Four limits worth stating outside the body text. The sample is two search phrasings, one market, one day, and two of the twelve pages would not load at all: rerun the method rather than trust the counts, which is why the method is written out. It is also a sample of small business accounting tools and the vendor glossaries that explain them, and of nothing else: it contains no accounting standard and no professional body, so read the claim as being about that world rather than about every context in which receivables are aged. The worked figures are invented, because I do not publish numbers from anyone’s books. And an earlier version of this piece reported a wall of silence that was not there, because I searched the pages for words instead of reading them; the correction is the second source below. I sell a $39 file that draws these columns, which is why the article says what date it counts from, what it assumes, and where that assumption is wrong.