What is an accounts receivable aging report, and how do I read and use it?
Source-verified · Reviewed 2026-09-12 · How we verify answers
- [United States (US accounting publisher; the article itself states no jurisdictional limit) · any business that issues customer invoices] An accounts receivable aging is a report that lists unpaid customer invoices and unused credit memos, organised by date ranges.
- [United States · illustrative company (Gem Merchandise Co.) using accounting software · accrual basis (the basis used throughout this explanation)] In the worked illustration, the software examines each customer's accounts receivable activity and compares the date of each unpaid sales invoice with the date of the report — so the report is struck as at a stated report date.
- [United States (US accounting publisher; the article itself states no jurisdictional limit) · any business that issues customer invoices] In a typical (not universal) aging report, invoices are listed in 30-day 'buckets' presented as columns.
- [US (AccountingTools is a US accounting publisher; the article itself cites no jurisdiction-specific rules) · entities reconciling an aged accounts receivable report to the general ledger] The totals on the aged accounts receivable report are compared to the receivable total in the general ledger.
- [United States (US accounting publisher; the article itself states no jurisdictional limit) · collections personnel of a business with customer invoices] The aging report is the primary tool collections personnel use to determine which invoices are overdue for payment.
What this page establishes
- The records the report lists, the date it speaks as at, and the totals it builds — Partly established
- How aging buckets are conventionally defined and labelled — Established
- How the report's total relates to the receivables balance carried in the ledger — Not established
- Recognised uses of the aging report and the limits of what it shows — Partly established
- Where the report is found in QuickBooks Online, Zoho Books and Wave, and the settings that change what it shows — Not established
- What an A/R aging report is, and what one line on it means — Partly established
- Which date the age is counted from, and what a bucket column is holding — Partly established
- Reading the customer subtotal, the bucket total and the grand total — and checking the grand total against the ledger — Not established
- Credits, unapplied receipts and negative rows, and what they do to the totals around them — Not established
- Turning the report into a shortlist: real collection problems, ageing risk, and rows that are recording errors — Partly established
- What the report is used for — and the questions it cannot settle on its own — Partly established
- Why two runs of the same report disagree: as-at date, aging basis, bucket definition and reporting basis — Partly established
What an A/R aging report is, and what one line on it means
An accounts receivable aging is a report that lists unpaid customer invoices and unused credit memos, organised by date ranges. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: any business that issues customer invoices)
“An accounts receivable aging is a report that lists unpaid customer invoices and unused credit memos by date ranges.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: What is the Accounts Receivable Aging Report? — first sentence. Verified 2026-09-09.
The aging of accounts receivable report is prepared from the detailed information held in the accounts receivable subsidiary ledger. (jurisdiction: United States, entity_scope: companies with an accounts receivable subsidiary ledger, accounting_basis: accrual basis (the basis used throughout this explanation))
“The detailed information in the accounts receivable subsidiary ledger is used to prepare a report known as the aging of accounts receivable .”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, second paragraph). Verified 2026-09-09.
The aging report is typically produced by sorting the unpaid sales invoices held in the subsidiary ledger, first by customer and then by sales invoice date — so its population is unpaid sales invoices and it is ordered per customer. (jurisdiction: United States, entity_scope: companies with an accounts receivable subsidiary ledger of unpaid sales invoices, accounting_basis: accrual basis (the basis used throughout this explanation), conditions: described as what typically happens, not as the only way the report can be generated)
“The aging of accounts receivable report is typically generated by sorting unpaid sales invoices in the subsidiary ledger—first by customer and then by the date of the sales invoices.”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, third paragraph). Verified 2026-09-09.
In the worked illustration, the software examines each customer's accounts receivable activity and compares the date of each unpaid sales invoice with the date of the report — so the report is struck as at a stated report date. (jurisdiction: United States, entity_scope: illustrative company (Gem Merchandise Co.) using accounting software, accounting_basis: accrual basis (the basis used throughout this explanation), conditions: presented as an example ("For example"), not as a requirement)
“For example, Gem Merchandise Co.’s software looks at each of its customer’s accounts receivable activity and compares the date of each unpaid sales invoice to the date of the report.”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, fourth paragraph — Gem Merchandise Co. illustration). Verified 2026-09-09.
The report becomes the basis for collection call activity, and a collections person can read from it the invoice number, the invoice date and the amount unpaid — indicating that a report line carries these per-invoice details. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: collections staff of a business with customer invoices)
“This becomes the basis for collection call activity, where the collections person can reference the report to identify the invoice number, invoice date, and amount unpaid.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: How to Use an Accounts Receivable Aging Report > Basis for Collection Activities (second section so headed) — second sentence. Verified 2026-09-09.
Partly established. Established: which records make up the report's population (S01, S03); that it is a position as at a stated date rather than a period activity report (S04). Missing: what a single row on it represents.
The records the report lists, the date it speaks as at, and the totals it builds
Multiplying the totals shown on the aging report (the per-bucket totals) by the probabilities of not collecting gives the expected amount of uncollectible receivables. (jurisdiction: United States, entity_scope: companies using the allowance method and an aging report, accounting_basis: accrual basis, financial statement reporting, conditions: probabilities are the company's own assumptions based on past experience, illustrated with example percentages)
“If we multiply the totals from the aging of accounts receivable report by the probabilities of not collecting, we arrive at the expected amount of uncollectible receivables.”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable > Aging Used in Calculating the Allowance. Verified 2026-09-09.
Partly established. Established: the records an accounts receivable aging report presents (S01, S03); that it is a position at a stated date (S04). Missing: what a single row on it represents; what the per-customer subtotal aggregates; what the per-bucket total aggregates; what the grand total aggregates.
Which date the age is counted from, and what a bucket column is holding
The article defines aging of accounts as the practice of itemizing certain types of transactions into time buckets in order to show how far in the past those transactions were initiated — i.e. the age dimension runs from when the transaction was initiated. (jurisdiction: not jurisdiction-specific; general bookkeeping practice as described by a US-based accounting publisher (AccountingTools, US CPE provider), entity_scope: businesses preparing aging analyses of transactions (certain types of transactions only, per the source), conditions: applies to 'certain types of transactions', not all transactions)
“Aging of accounts is the practice of itemizing certain types of transactions into time buckets, to show how far in the past they were initiated.”AccountingTools, Inc. (author Steven Bragg) — The aging of accounts, 2026-02-10; Section "What is the Aging of Accounts?", opening sentence. Verified 2026-09-09.
The article states that the term 'aging of accounts' is inaccurate because what is aged is the transactions listed within an account; accordingly an accounts receivable aging report states the age of individual transactions within the accounts receivable account, not the age of the account balance as a whole. (jurisdiction: not jurisdiction-specific; general bookkeeping practice as described by a US-based accounting publisher (AccountingTools, US CPE provider), entity_scope: aging reports generally; the illustration given is the accounts receivable aging report, conditions: the author's own terminology assessment)
“The "aging of accounts" terminology is inaccurate, since it is actually the aging of transactions listed within an account. Thus, an accounts receivable aging report states the age of individual transactions within the accounts receivable account.”AccountingTools, Inc. (author Steven Bragg) — The aging of accounts, 2026-02-10; Section "The Inventory Aging", closing paragraph of the article body. Verified 2026-09-09.
In a typical (not universal) aging report, invoices are listed in 30-day 'buckets' presented as columns. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: any business that issues customer invoices, conditions: described as typical structure, not a required one)
“A typical aging report lists invoices in 30-day "buckets," where the columns contain the following information:”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: Structure of an Accounts Receivable Aging Report — lead-in sentence to the column list. Verified 2026-09-09.
By way of example (not as a general requirement), the article says that with net 15 day payment terms the left-most column's date range should cover only the first 15 days, and that this change drops 16-day old invoices into the second column, highlighting them as overdue — illustrating that the choice of bucket boundaries relative to payment terms moves items between columns. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: businesses with net 15 day payment terms (illustrative example), conditions: stated as an example; payment terms of net 15 days)
“For example, if payment terms are net 15 days, then the date range in the left-most column should only be for the first 15 days. This drops 16-day old invoices into the second column, which highlights that they are now overdue for payment.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: Structure of an Accounts Receivable Aging Report — worked example in the paragraph on reconfiguring date ranges. Verified 2026-09-09.
In the illustration, with the report dated August 31 and net 30 day terms, unpaid August-dated invoices are classified as current, unpaid July-dated invoices as 1 – 30 days past due and unpaid June-dated invoices as 31 – 60 days past due, and so on — the buckets being set by comparing each unpaid invoice's date with the report date. (jurisdiction: United States, entity_scope: illustrative company (Gem Merchandise Co.), accounting_basis: accrual basis (the basis used throughout this explanation), conditions: assumed report date of August 31; assumed credit terms of net 30 days; bucket list is open-ended ("and so on"))
“If we assume the report is dated August 31 and that Gem’s credit terms are net 30 days, any unpaid sales invoices with an August date will be classified as current . Any unpaid invoices with a date in July are classified as 1 – 30 days past due . Any unpaid invoices with a date of June are classified as 31 – 60 days past due , and so on.”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, fourth paragraph — Gem Merchandise Co. illustration). Verified 2026-09-09.
In QuickBooks Online, a transaction with no due date is considered due upon receipt, its aging is driven by the transaction date, and once a day has elapsed it will be noted as past due. (jurisdiction: United States (QuickBooks en-US help centre edition), entity_scope: Users of the QuickBooks Online plans and Intuit Enterprise Suite listed on the article (Advanced, Plus, Simple Start, Essentials), platform: QuickBooks Online, platform_edition: US edition; article updated 8/3/2026, conditions: applies only where the transaction has no due date)
“If there is NO due date, the transaction is considered due upon receipt and is driven by the transaction date, once a day has elapsed, the transaction will be noted as past due.”Intuit Inc. — Why aging reports have both Current and 1-30, 2026-08-03; Body, fourth paragraph under heading "Why aging reports have both Current and 1-30". Verified 2026-09-09.
The Aging Summary has an "Aging By" setting which generates the report based on either the Invoice Due Date or the Invoice Date. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“Aging By Generate the report based on the Invoice Due Date or the Invoice Date.”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > To customize this report — fields table, "Aging By" row. Verified 2026-09-09.
The Aging Summary lets the user choose the length and the number of aging intervals (the buckets). (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“Aging Intervals Choose the length and the number of intervals.”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > To customize this report — fields table, "Aging Intervals" row. Verified 2026-09-09.
The Aging Summary has a "Show By" setting that generates the report based on either the Outstanding Invoice Amount or the Invoice Count, so a bucket column can be counting amounts or numbers of invoices. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“Show By Generate the report based on the Outstanding Invoice Amount or the Invoice Count.”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > To customize this report — fields table, "Show By" row. Verified 2026-09-09.
Partly established. Established: from which date an item's age is measured (S07, S12); what a bucket column is actually counting (S08, S10). Missing: why measuring from the invoice date rather than the due date moves items between columns.
Required authority: high quality professional secondary reference. Highest achieved: high quality professional secondary reference, official platform documentation.
How aging buckets are conventionally defined and labelled
The article presents one common (not exclusive or mandatory) set of aging time buckets, expressed in days of age and labelled: 0-30 days old as current, 31-60 days old as slightly overdue, 60-90 days old as decidedly stale, and 90+ days old as very old and requiring action. The intervals are stated as printed by the source, which gives the third bucket as '60-90' rather than 61-90. (jurisdiction: not jurisdiction-specific; general bookkeeping practice as described by a US-based accounting publisher (AccountingTools, US CPE provider), entity_scope: aging reports generally; the article's examples centre on accounts receivable and accounts payable, conditions: described as 'a common set', i.e. one conventional set among others; the same article states these buckets can be altered in many accounting software packages)
“A common set of time buckets used for aging is as follows: 0-30 days old (considered current) 31-60 days old (considered slightly overdue) 60-90 days old (decidedly stale) 90+ days old (very old, action required)”AccountingTools, Inc. (author Steven Bragg) — The aging of accounts, 2026-02-10; Section "What is the Aging of Accounts?", bulleted list following the first paragraph. Verified 2026-09-09.
Reading the customer subtotal, the bucket total and the grand total — and checking the grand total against the ledger
The general ledger account Accounts Receivable usually holds only summary amounts and is called a control account. (jurisdiction: United States, entity_scope: companies that sell goods or services on credit and keep an Accounts Receivable general ledger account, accounting_basis: accrual basis (the basis used throughout this explanation), conditions: stated as what usually happens, not as an invariable rule)
“The general ledger account Accounts Receivable usually contains only summary amounts and is referred to as a control account .”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, first paragraph). Verified 2026-09-09.
The sum of all details in the accounts receivable subsidiary ledger must equal the amount reported in the Accounts Receivable control account in the general ledger. (jurisdiction: United States, entity_scope: companies keeping an accounts receivable subsidiary ledger behind a general ledger control account, accounting_basis: accrual basis (the basis used throughout this explanation))
“The total amount of all the details in the subsidiary ledger must be equal to the total amount reported in the control account.”AccountingCoach, LLC (Harold Averkamp, CPA, MBA) — Accounts Receivable and Bad Debts Expense: In-Depth Explanation with Examples, Undated standing web explanation ("In-Depth Explanation with Real-World Examples"); page carries "Copyright © 2026 AccountingCoach, LLC"; snapshot retrieved 2026-09-08; Aging of Accounts Receivable (section body, first paragraph). Verified 2026-09-09.
The totals on the aged accounts receivable report are compared to the receivable total in the general ledger. (jurisdiction: US (AccountingTools is a US accounting publisher; the article itself cites no jurisdiction-specific rules), entity_scope: entities reconciling an aged accounts receivable report to the general ledger, conditions: report run as of the final day of the reporting period)
“The totals on this report are then compared to the receivable total in the general ledger.”AccountingTools, Inc. (author Steven Bragg) — How to reconcile accounts receivable, 2026-05-15; Article body, bulleted item "Receivables detail" (second of the two information sources); "this report" is the aged accounts receivable report named in the preceding sentence. Verified 2026-09-09.
The opening balance shown on the A/R Aging summary report should match the total Accounts Receivable amount shown on the Balance Sheet or Trial Balance. (jurisdiction: United States (en-US QuickBooks Online help edition), entity_scope: QuickBooks Online users comparing the A/R Aging summary with the Balance Sheet or Trial Balance, platform: QuickBooks Online, accounting_basis: Balance Sheet / Trial Balance run on Accrual, per the article's earlier note, conditions: stated of the opening balance on the A/R Aging summary report)
“Check the opening balance on your A/R Aging summary report. The balance should match the total amount of Accounts Receivable that shows on your Balance Sheet or Trial Balance.”Intuit Inc. — Match your aging reports, 2026-08-04; Heading 'Check for other possible reasons for a mismatch', fourth bullet. Verified 2026-09-09.
Intuit states that in QuickBooks the balance sheet, trial balance and accounts receivable aging reports should match, and that when they do not match the usual cause is that the aging report defaults to 'current'. (jurisdiction: United States (en-US QuickBooks Online help edition), entity_scope: QuickBooks Online users running A/R aging, balance sheet and trial balance reports, platform: QuickBooks Online, platform_edition: QuickBooks Online (article lists Advanced, Essentials, Plus, Simple Start, Intuit Enterprise Suite), conditions: cause of mismatch stated as the usual, not the only, reason)
“Your balance sheet, trial balance, and accounts receivable aging reports should match in QuickBooks to maintain a healthy cash flow. If they don't, it’s usually because the aging report defaults to current.”Intuit Inc. — Match your aging reports, 2026-08-04; Article body, introductory paragraph before the heading 'Change the aging method to report the date'. Verified 2026-09-09.
Wave states that the aged receivables report may not always balance with the user's accounts receivable account. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“Your aged receivables report may not always balance with your accounts receivable account.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", final paragraph. Verified 2026-09-09.
Wave states that because the aged receivable report shows only unpaid and overdue invoices, a discrepancy against the accounts receivable account balance could result. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“The aged receivable report only shows the unpaid and overdue invoices, which could result in a balance discrepancy.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", final paragraph. Verified 2026-09-09.
The Aging Summary shows a Total column giving the total amount outstanding for each customer. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“Total amount outstanding for them (Total).”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary — "In this report, you can see the following details of your customers:" second bullet. Verified 2026-09-09.
Each row of the Wave aged receivables report lists overdue invoice totals for a single customer. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“Each row in the report lists overdue invoice totals for one customer.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", paragraph introducing the columns. Verified 2026-09-09.
The bottom of the Wave aged receivables report shows, for each column, the total amount due from all customers. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“At the bottom of the report are the total amounts due from all customers for each column.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", paragraph following the column list. Verified 2026-09-09.
An invoice paid after the selected As of date still appears as overdue on the Wave aged receivables report for that As of date. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated, conditions: Payment recorded after the selected As of date)
“If an invoice was paid after your selected As of date, it will still appear as overdue on the current report.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", paragraph on the As of date. Verified 2026-09-09.
Not established from an authoritative source.
Required authority: authoritative professional or accounting standard, high quality professional secondary reference. Highest achieved: high quality professional secondary reference, official platform documentation.
How the report's total relates to the receivables balance carried in the ledger
When the reconciliation is performed, the aged receivables total and the general ledger receivables total may differ. (jurisdiction: US (AccountingTools is a US accounting publisher; the article itself cites no jurisdiction-specific rules), entity_scope: entities reconciling receivables detail to the general ledger, conditions: stated as a possibility, not an expectation)
“When the reconciliation is conducted, there may be differences between the two amounts.”AccountingTools, Inc. (author Steven Bragg) — How to reconcile accounts receivable, 2026-05-15; Section "Accounts Receivable Reconciling Items", introductory sentence. Verified 2026-09-09.
The report primarily contains invoices, but it may also contain credit memos that customers have not used, or that have not yet been matched against an unpaid invoice — so a row need not be an invoice. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: any business that issues customer invoices and credit memos)
“The report primarily contains invoices, but it may also contain credit memos that have not been used by customers, or which have not yet been matched against an unpaid invoice.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: Structure of an Accounts Receivable Aging Report — final paragraph. Verified 2026-09-09.
Not established from an authoritative source.
Required authority: authoritative professional or accounting standard. Highest achieved: high quality professional secondary reference, official platform documentation.
Credits, unapplied receipts and negative rows, and what they do to the totals around them
An aging report may contain unapplied credits; where it does, the article directs the reader to clean up the report by researching which invoices those credits should have been applied against, which may reduce the overdue receivables shown. (jurisdiction: Not stated in the document; general receivables-analysis guidance from a US-based publisher (AccountingTools, Inc.), illustrations in US dollars, entity_scope: Companies analysing an accounts receivable aging report, conditions: applies where unapplied credits are present; reduction in overdue receivables is hedged as 'may')
“There may be unapplied credits on the report. If so, clean up the report by researching which invoices they should have been applied against. Doing so may reduce the amount of overdue receivables listed on the report.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable analysis, 2026-05-11; Section: How to Analyze the Aging Report, bullet 'Unapplied credits'. Verified 2026-09-09.
Researching unapplied credits may also suggest ways to clear some customer credits off the report, such as by contacting customers about new purchases paid for with those credits. (jurisdiction: Not stated in the document; general receivables-analysis guidance from a US-based publisher (AccountingTools, Inc.), illustrations in US dollars, entity_scope: Companies analysing an accounts receivable aging report, conditions: 'such as' — the method given is one open example)
“This analysis may also suggest ways to eliminate some customer credits from the report, such as by contacting customers to see if they want to make new purchases, using these credits for payment.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable analysis, 2026-05-11; Section: How to Analyze the Aging Report, bullet 'Unapplied credits'. Verified 2026-09-09.
The Aging Summary lets the user choose to display customers' Credit Notes or Manual Journals, if any, affecting what the report shows. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08, conditions: only where such credit notes or manual journals exist)
“Credit Notes Choose to display the Credit Notes or the Manual Journals of the customers (if any).”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > To customize this report — fields table, "Credit Notes" row. Verified 2026-09-09.
Not established from an authoritative source.
Required authority: authoritative professional or accounting standard. Highest achieved: high quality professional secondary reference, official platform documentation.
Turning the report into a shortlist: real collection problems, ageing risk, and rows that are recording errors
Invoices sitting in buckets older than 30 days are treated as cause for an increasing sense of alarm, especially once they reach the oldest bucket. (jurisdiction: Not stated in the document; general receivables-analysis guidance from a US-based publisher (AccountingTools, Inc.), illustrations in US dollars, entity_scope: Companies analysing an accounts receivable aging report, conditions: stated as a graduated 'increasing sense of alarm', not a threshold rule)
“Any invoices falling into the time buckets representing periods greater than 30 days are cause for an increasing sense of alarm, especially if they drop into the oldest time bucket.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable analysis, 2026-05-11; Section: How to Analyze the Aging Report. Verified 2026-09-09.
Where management may have authorised unusually long credit terms for particular customers or particular invoices, those items may appear severely overdue on the aging report when they are in fact not yet due for payment. (jurisdiction: Not stated in the document; general receivables-analysis guidance from a US-based publisher (AccountingTools, Inc.), illustrations in US dollars, entity_scope: Companies analysing an accounts receivable aging report, conditions: applies only where individually authorised longer credit terms exist)
“Management may have authorized unusually long credit terms to specific customers, or perhaps only for particular invoices. If so, these items may appear to be severely overdue for payment when they are, in fact, not yet due for payment at all.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable analysis, 2026-05-11; Section: How to Analyze the Aging Report, bullet 'Individual credit terms'. Verified 2026-09-09.
Errors commonly found during an accounts receivable reconciliation include duplicate invoices, omitted cash receipts, unapplied payments, misapplied customer payments, unsupported credit memos, unapproved write-offs, incorrect customer coding, stale debit or credit balances, and manual entries posted directly to the control account; the list is given as examples of common errors, not as a closed set. (jurisdiction: US (AccountingTools is a US accounting publisher; the article itself cites no jurisdiction-specific rules), entity_scope: entities reconciling accounts receivable with a control account and customer-level detail, conditions: open list, introduced by 'include')
“Common accounts receivable reconciliation errors include duplicate invoices, omitted cash receipts, unapplied payments, misapplied customer payments, unsupported credit memos, unapproved write-offs, incorrect customer coding, stale debit or credit balances, and manual entries posted directly to the control account.”AccountingTools, Inc. (author Steven Bragg) — How to reconcile accounts receivable, 2026-05-15; Section "Accounts Receivable Reconciliation FAQs", question "What are common errors found during a reconciliation?". Verified 2026-09-09.
A reconciliation can help identify bad debts by highlighting customer accounts with long-outstanding or disputed balances, and such overdue receivables may indicate collection issues or a need to evaluate collectibility. (jurisdiction: US (AccountingTools is a US accounting publisher; the article itself cites no jurisdiction-specific rules), entity_scope: entities reconciling customer receivables balances, conditions: hedged: the reconciliation 'can help' identify, and the balances 'may indicate' a problem)
“A reconciliation can help identify bad debts by highlighting customer accounts with long-outstanding or disputed balances. These overdue receivables may indicate collection issues or the need to evaluate collectibility.”AccountingTools, Inc. (author Steven Bragg) — How to reconcile accounts receivable, 2026-05-15; Section "Accounts Receivable Reconciliation FAQs", question "Can a reconciliation identify bad debts?". Verified 2026-09-09.
The collection period gives only a general idea of a company's ability to collect; the aging report is what identifies which specific invoices are causing collection problems; trend analysis shows whether those problems have been changing over time. (jurisdiction: Not stated in the document; general receivables-analysis guidance from a US-based publisher (AccountingTools, Inc.), illustrations in US dollars, entity_scope: Companies analysing accounts receivable)
“You can use the accounts receivable collection period to get a general idea of the ability of a company to collect its accounts receivable, add an analysis of the aging report to determine exactly which invoices are causing collection problems, and then add trend analysis to see if these problems have been changing over time.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable analysis, 2026-05-11; Section: How to Conduct a Ratio Analysis, closing summary. Verified 2026-09-09.
Partly established. Established: which rows indicate ageing that needs attention (S34); which rows are more likely to be recording errors that should be investigated before anyone contacts the customer (S36). Missing: which rows indicate a real collection problem.
What the report is used for — and the questions it cannot settle on its own
The aging report is the primary tool collections personnel use to determine which invoices are overdue for payment. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: collections personnel of a business with customer invoices)
“The aging report is the primary tool used by collections personnel to determine which invoices are overdue for payment.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: What is the Accounts Receivable Aging Report? — second sentence. Verified 2026-09-09.
The aging report is used as a tool for estimating potential bad debts, and those estimates are then used to revise the allowance for doubtful accounts. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: businesses that maintain an allowance for doubtful accounts)
“The accounts receivable aging report is used as a tool for estimating potential bad debts , which are then used to revise the allowance for doubtful accounts .”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: How to Use an Accounts Receivable Aging Report > Bad Debt Estimation — first sentence. Verified 2026-09-09.
The report gives a good indication (an indication, not a determination) of customers' near-term financial situation. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: any business that issues customer invoices)
“Nonetheless, the report does give a good indication of the near-term financial situation of customers.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: How to Use an Accounts Receivable Aging Report > Basis for Collection Activities (first section so headed) — third sentence. Verified 2026-09-09.
Using the aging report for credit-limit review is not an ideal use of it, because the credit department should also review invoices already paid in the recent past — which the report of unpaid items does not show. (jurisdiction: United States (US accounting publisher; the article itself states no jurisdictional limit), entity_scope: credit department of a business with customer invoices)
“This is not an ideal use of the report, since the credit department should also review invoices that have already been paid in the recent past.”AccountingTools, Inc. (author Steven Bragg) — Accounts receivable aging definition, 2026-07-11; Heading: How to Use an Accounts Receivable Aging Report > Basis for Collection Activities (first section so headed) — second sentence. Verified 2026-09-09.
Partly established. Established: the report's recognised uses (S38, S39, S40, S41). Missing: that it does not answer whether an amount is collectible; that it does not answer whether the customer agrees it is owed; that it does not answer whether it is disputed.
Recognised uses of the aging report and the limits of what it shows
Partly established. Established: the recognised uses of an accounts receivable aging report in small-business bookkeeping and review (S38, S39, S40, S41); the questions about a balance that it cannot answer on its own (S35, S42); the recognised indications by which a row is read as ageing that warrants attention (S34); the recognised indications by which a row is read as a likely recording artefact such as an unapplied receipt or an invoice recorded twice (S36). Missing: the recognised indications by which a row is read as a genuine collection problem.
Why two runs of the same report disagree: as-at date, aging basis, bucket definition and reporting basis
See The Aging Summary lets the user choose the length and the number of aging intervals (the buckets).
Aging time buckets can be altered in many accounting software packages — the bucket definition is a changeable setting in many (not stated to be all) packages. (jurisdiction: not jurisdiction-specific; general bookkeeping practice as described by a US-based accounting publisher (AccountingTools, US CPE provider), entity_scope: users of accounting software packages, conditions: 'many accounting software packages' — no specific product named, not asserted of all packages)
“These time buckets can be altered in many accounting software packages.”AccountingTools, Inc. (author Steven Bragg) — The aging of accounts, 2026-02-10; Section "What is the Aging of Accounts?", paragraph following the time-bucket list. Verified 2026-09-09.
A user who wants to see which customers have past due balances and how long each transaction is past due can run an A/R Aging detail report. (jurisdiction: United States (QuickBooks Online US edition, en-us help site), entity_scope: QuickBooks Online subscribers, platform: QuickBooks Online, platform_edition: US edition; article updated 8/5/2026, effective_from: 2026-08-05, conditions: stated as the option when transaction-level past-due detail is wanted)
“If you want to see which customers have past due balances and how long each transaction is past due, you can run an A/R Aging detail report.”Intuit Inc. — Run an accounts receivable aging report in QuickBooks, 2026-08-05; Section 'Accounts receivable aging detail report', opening sentence. Verified 2026-09-09.
The A/R Aging report in QuickBooks Online has an Aging Method setting that the user changes when running the report. (jurisdiction: United States (en-US QuickBooks Online help edition), entity_scope: QuickBooks Online users running the A/R Aging report, platform: QuickBooks Online)
“Change the Aging Method when you run your A/R Aging report”Intuit Inc. — Match your aging reports, 2026-08-04; Heading 'Change the aging method to report the date', instruction line. Verified 2026-09-09.
The General Options panel of the Accounts receivable aging summary report contains an Aging dropdown offering a 'Report date' option, which is the setting selected to age by report date. (jurisdiction: United States (en-US QuickBooks Online help edition), entity_scope: QuickBooks Online users running the Accounts receivable aging summary report, platform: QuickBooks Online)
“Select the Aging ▼dropdown, then select the 🔘 Report date radio button.”Intuit Inc. — Match your aging reports, 2026-08-04; Heading 'Change the aging method to report the date', step 4 (General Options panel). Verified 2026-09-09.
For the comparison, the Balance Sheet or Trial Balance report must be run with Accrual selected as the Accounting method. (jurisdiction: United States (en-US QuickBooks Online help edition), entity_scope: QuickBooks Online users comparing an A/R aging report with a Balance Sheet or Trial Balance, platform: QuickBooks Online, accounting_basis: Accrual (QuickBooks Accounting method setting), conditions: stated for the Balance Sheet or Trial Balance run for this matching exercise)
“Note : Make sure you run the Balance Sheet or Trial Balance report using Accrual as the Accounting method .”Intuit Inc. — Match your aging reports, 2026-08-04; Heading 'Change the aging method to report the date', Note following the closing line. Verified 2026-09-09.
The Aging Summary has an "As of" setting for the time interval the report is generated for, or a custom period the user sets. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“As of Select the time interval for which you want to generate the report or set a custom period of your own.”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > To customize this report — fields table, "As of" row. Verified 2026-09-09.
In the Wave aged receivables report, the As of date is the starting point of the report. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“The As of date is the starting point of the report.”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "Understand your aged receivables report", paragraph on the As of date. Verified 2026-09-09.
Partly established. Established: the as-at date setting that governs what the report shows (S29, S51, S53); the aging basis setting that governs what the report shows (S15, S47, S48); the bucket definition setting that governs what the report shows (S16, S44). Missing: the reporting basis setting that governs what the report shows.
Required authority: high quality professional secondary reference, official platform documentation. Highest achieved: high quality professional secondary reference, official platform documentation.
Where the report is found in QuickBooks Online, Zoho Books and Wave, and the settings that change what it shows
See The Aging Summary lets the user choose the length and the number of aging intervals (the buckets).
See The Aging Summary shows a Total column giving the total amount outstanding for each customer.
See Each row of the Wave aged receivables report lists overdue invoice totals for a single customer.
The Accounts receivable aging summary report is selected from the 'Who owes you' section of Standard reports. (jurisdiction: United States (QuickBooks Online US edition, en-us help site), entity_scope: QuickBooks Online subscribers, platform: QuickBooks Online, platform_edition: US edition; article updated 8/5/2026, effective_from: 2026-08-05)
“In the Who owes you section, select Accounts receivable aging summary .”Intuit Inc. — Run an accounts receivable aging report in QuickBooks, 2026-08-05; Section 'Accounts receivable aging summary report', second step. Verified 2026-09-09.
The Aging Summary report is found at Reports > Aging Summary, under the Receivables section. (jurisdiction: United States (Zoho Books US-EN help edition), entity_scope: Zoho Books organizations, platform: Zoho Books, platform_edition: US-EN help edition, undated, retrieved 2026-09-08)
“Go to Reports > Aging Summary under the Receivables section.”Zoho Corporation (Zoho Books US Help) — Receivables Reports | Help | Zoho Books, undated; snapshot retrieved 2026-09-08; Receivables > Aging Summary > "To view this report:". Verified 2026-09-09.
In Wave's Reports area the aged receivables report is opened by clicking Aged Receivables in the Customers section. (jurisdiction: Not jurisdiction-specific in the document; applies to the Wave web application as documented in Wave's English (en-us) Help Center, entity_scope: Businesses using Wave invoicing, platform: Wave, platform_edition: Web version of Wave; no product version or date stated)
“In the Customers section, click Aged Receivables .”Wave Financial Inc. (Wave Help Center) — View and understand your aged receivables report, Wave web version; no product version or article revision stated in the pinned text (edition not retrievable - host returned HTTP 403 on 2026-09-08); Section "View your aged receivables report", numbered step. Verified 2026-09-09.
See In the Wave aged receivables report, the As of date is the starting point of the report.
Not established from an authoritative source.
Not yet fully established from an authoritative source
- Establish what an accounts receivable aging report is: the records it presents, the fact that it is a position at a stated date, and what a single row on it represents, together with what each level of total on it aggregates - the per-customer subtotal, the per-bucket total and the grand total. (partly established)
- Establish the relationship between the aging report's total and the receivables balance carried in the general ledger, and how customer credits and unapplied receipts are presented within the report, including how they and any other negative row change the bucket total and the customer subtotal when those totals are read as net figures. (not established; below the required authority class)
- Establish the recognised uses of an accounts receivable aging report in small-business bookkeeping and review, and the questions about a balance that it cannot answer on its own, including the recognised indications by which a row is read as a genuine collection problem, as ageing that warrants attention, or as a likely recording artefact such as an unapplied receipt or an invoice recorded twice. (partly established)
- Establish how mainstream small-business accounting systems produce the aging report, where it is found, and which settings change its output, including the as-at date, the aging basis, the bucket definition and the reporting basis. (not established)
- Establish what the report is: which records make up its population, that it is a position as at a stated date rather than a period activity report, and what a single row on it represents. (partly established)
- Explain the aging dimension: from which date an item's age is measured, why measuring from the invoice date rather than the due date moves items between columns, and what a bucket column is actually counting. (partly established; below the required authority class)
- Explain what each total on the report means — the customer subtotal, the bucket total and the grand total — and establish that the grand total corresponds to the receivables balance carried in the ledger, so the report can be sanity-checked rather than trusted blindly. (not established; below the required authority class)
- Explain how credit balances, unapplied receipts and negative rows appear on the report, and how they change both a bucket total and a customer subtotal when read as a net figure. (not established; below the required authority class)
- Show how a reader moves from the report to action: which rows indicate a real collection problem, which indicate ageing that needs attention, and which are more likely to be recording errors that should be investigated before anyone contacts the customer. (partly established)
- Establish the report's recognised uses and, equally, the questions it does not answer — whether an amount is collectible, whether the customer agrees it is owed, and whether it is disputed. (partly established)
- Explain the settings that govern what the report shows — the as-at date, the aging basis, the bucket definition and the reporting basis — so that a user comparing two runs, or comparing the report against another figure, can explain a difference rather than assume an error. (partly established; below the required authority class)
Reference date 2026-09-07. Statements are quoted verbatim from their sources; scope and verification dates are shown on each.