Automated receivables and payables aging report
Reading time: 6 min
Updated: June 20, 2026
1. Structure by buckets
Group invoices by aging buckets: 0-30, 31-60, 61-90 and over 90 days. Each bucket sums the overdue unpaid amount for customers or suppliers.
2. Calculation with ARRAYFORMULA
With the due date and the balance, classify each invoice into its bucket with date comparison formulas. Avoid manual cells that go stale.
3. Act on the result
An aging report is not read, it is managed: prioritize collections in the over-90 bucket and renegotiate terms with the most delayed suppliers.
Want to automate this process?
Connect all your QuickBooks accounts to Google Sheets with FinBoard and forget about copy and paste.
Try FinBoard Free