Invoice Tracker Spreadsheet – Aged Receivables & Overdue Report (AUD)
An invoice tracker spreadsheet that ages unpaid invoices into Current, 1–30, 31–60, 61–90 and 90+ days and shows who owes you by client. Due dates and status (Open, Part paid, Overdue, Paid) are set automatically, with overdue invoices highlighted. A$19.
Know who owes you, how much, and for how long. Enter your invoices and payments, and the dashboard ages your receivables into Current, 1–30, 31–60, 61–90 and 90+ days, with balances by client so you know who to chase first.
• Due dates calculated from terms per invoice, or from your default terms
• Status set automatically (Open, Part paid, Overdue, Paid)
• Overdue rows highlighted, with 60+ days in red; filter-ready
• KPIs for total outstanding, overdue amount, number overdue and average days overdue
• Ageing table and chart, and outstanding/overdue by client
• "As at" date that you can fix to report on any past date
Contact: workassist.andrei@proton.me
Templates built with AI assistance and checked by hand. General record-keeping tools, not tax, financial or BAS advice.