How to use Invoice Aging Report
- Choose Report as-of date, then replace the sample Invoices with a unique ID, customer, issue date, due date and original amount for each invoice. Use one currency.
- Enter Partial payments as invoice ID | payment date | amount, or leave that list empty. IDs must match a listed invoice and payments cannot precede its issue date.
- Select Calculate result. The report subtracts valid payments dated on or before the as-of date from invoices issued by that date. Later-dated records are excluded from that snapshot but still checked for invalid references or overpayments.
- Review invoice rows, Customer total rows and Grand total. Due on the as-of date is Not due; overdue starts the next calendar day. Download calculation.csv for the complete table.
Example: Invoice Aging Report
As of March 31, the first $500 invoice has a $200 payment, leaving $300 overdue by 59 days in the 31–60 bucket. The second $300 invoice is due that day, so it remains Not due. Total unpaid: $600.
Supported inputs and limits
- Use 1 to 100 invoices and optionally up to 100 payment rows, with at most 100,000 characters in each list.
- Pipe-separated cells must be nonempty.
- Invoice IDs are unique;
- IDs and customer names allow 80 characters.
- Dates must be real calendar dates from 1900 through 2200.
More details
Due date cannot precede issue, and payments must reference a listed invoice and be dated no earlier than its issue.
Amounts are nonnegative and at most 1,000,000,000 each, entered as plain decimals without grouping commas or currency symbols.
Each invoice/payment rounds half up to cents before totaling.
Total recorded payments cannot exceed an invoice’s amount, including payments later than the report date.
Invoices issued later and payments dated later are excluded from the snapshot; fully paid invoices are omitted.
Buckets are Not due, 1–30, 31–60, 61–90 and 91+ calendar days overdue.
Customer grouping uses the exact name, including case.
There is no currency conversion, credit/write-off handling, account import or collection forecast.
Processing is local without automatic saving.
Where your input is processed
This tool does not upload your inputs. See the limits for anything saved on your device.
Questions about Invoice Aging Report
Is an invoice due today overdue?
No. An invoice due on the as-of date remains in the not-due bucket. The first overdue bucket starts the following calendar day.
How are payments after the as-of date handled?
They must still have a valid invoice reference and date, and all payments together must not overpay that invoice. After validation, only payments dated on or before the as-of date reduce that report’s balance.
Can the report combine different currencies or credits?
No. Use one currency. Overpayments and credit balances are outside this aging report and are rejected rather than hidden.