Purpose and scope
What this dashboard measures
Group invoices into aging buckets as of a selected date.
Age invoices as of, Invoices, and Bucket size days feed the breakdown values beneath the Accounts Receivable Aging-Date Calculator headline; Keep Bucket size days in its entered unit for comparison.
Instructions
How to use this calculator
Set Age invoices as of and Invoices from the Accounts Receivable Aging-Date Calculator source record, then keep Bucket size days in their recorded units.
- Set Age invoices as of and Invoices from one Accounts Receivable Aging-Date Calculator reporting period.
- Set Bucket size days without changing the Bucket size days unit.
- Build the Accounts Receivable Aging-Date Calculator and compare its headline with breakdown values.
Interpretation
Interpreting the headline metric
The dashboard describes age exposure and does not establish delinquency without applying payment terms.
Inspect Age invoices as of, Invoices, and Bucket size days beside the Accounts Receivable Aging-Date Calculator headline; Bucket size days reveals rounding across the breakdown values.
After the Accounts Receivable Aging-Date Calculator, open the Invoice Due-Date Terms Calculator to calculate payment due and grace dates from invoice terms and day-count basis.
Calculation
Method used
Each invoice age is measured through the as-of date and assigned to a fixed-width day bucket.
The Accounts Receivable Aging-Date Calculator evaluates Age invoices as of, Invoices, and Bucket size days separately; keep Bucket size days visible outside any percentage, rate, or total.
Calculation method last reviewed: June 21, 2026.
Worked scenario
Example calculation
Compare Bucket size days with the Accounts Receivable Aging-Date Calculator breakdown values before judging the Bucket size days headline scale or units.
Visual audit
Reading the supporting metrics
The Accounts Receivable Aging-Date Calculator dashboard places breakdown values beside Age invoices as of, Invoices, and Bucket size days. Inspect Bucket size days in its original unit before accepting the breakdown values or headline status.
Boundaries
Important edge cases and limitations
Payment terms, credits, disputes, partial receipts, currency, and accounting policy are not interpreted.
Change Bucket size days in the Accounts Receivable Aging-Date Calculator before reading the breakdown values or headline.
Input audit
Checklist for this calculation
- Inspect the Accounts Receivable Aging-Date Calculator period and Age invoices as of and Invoices units.
- Compare Bucket size days with the Accounts Receivable Aging-Date Calculator breakdown values.
- Build a fresh Accounts Receivable Aging-Date Calculator after any Bucket size days change.
Practical use
Recommended workflow
Reconcile credits and receipts, then review the oldest and largest balances with their actual due dates.
The Renewal and Expiration Planner covers the related step of helping you calculate review, cancellation, expiration, and grace-period dates.
Questions
Frequently asked questions
Why age from invoice date instead of due date?
This calculator uses invoice age; organizations that age from due date should adjust the source dates or method.
What changes when Bucket size days is adjusted in the
Keep Age invoices as of and Invoices unchanged and change Bucket size days once in the Accounts Receivable Aging-Date Calculator. Compare the Bucket size days component with breakdown values to identify a proportional or threshold effect.
How does Bucket size days qualify the accounts receivable aging-date calculator headline?
The Accounts Receivable Aging-Date Calculator headline compresses Age invoices as of and Invoices, so compare it with Bucket size days and breakdown values. The Bucket size days denominator then exposes rounding in the Accounts Receivable Aging-Date Calculator.