Use one cutoff for invoices and payments
At 15 October, INV-01 has A$700 left from the entered A$1,000 total and A$300 settled payment. Its 15 September due date is 30 days earlier. The 16 October payment does not reduce this historical balance. INV-02 contributes A$400 not yet due, while the draft is excluded. Positive outstanding is therefore A$1,100 in this example.
Age from the entered due date
Buckets are current or due today, 1–30, 31–60, 61–90 and 91+ days overdue. Calendar dates are used rather than elapsed hours, so a local daylight-saving change does not move a debt between buckets. Future-issued, draft and void invoices are excluded. Overpayments and credits are displayed separately rather than hiding another customer’s debt.
Historical accuracy needs historical statuses
Enter statuses as they were at the chosen cutoff. This page cannot infer when an invoice was voided or a payment settled from today’s status alone. Review unusual dates and missing opening balances before following up. The output is an entered-record ageing view, not automatic bank reconciliation or a decision that an invoice is collectible.
Keep a review record
Run the check again whenever an input changes. Invalid or incomplete input clears the previous live result and disables download, so an old answer is not presented as current. Downloads contain the check table only; they are not a tax invoice, payment receipt or successful invoice export. They do not update drafts, history, login or payment status.
Xero: as-of-date receivables reporting concepts · Reference for the underlying recordkeeping or calculation concept; not an endorsement of this helper.