Excel · SheetsEvery invoice, payment, balance and days overdue, with aging buckets and customer totals.
What's included:
- Invoice register with due dates from your terms
- Balance and days overdue from today's date
- Aging: current, 1-30, 31-60, 61-90, 90+
- Per-customer totals and average days to pay
- Summary for follow-ups or your accountant
- Excel, Google Sheets and LibreOffice
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Default payment terms (days) | 14 |
Summary Summary
- Total invoiced
- Total outstanding
- Overdue
- Average days to pay (paid invoices)
- Current
- 1-30
- 31-60
- 61-90
Sheet Invoices — One row per invoice. Today's date drives the aging.
| Invoice # | Date | Customer | Amount | Custom due date | Due date | Paid | Paid on | Balance | Days overdue | Aging | Days to pay | Note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INV-0101 | 2026-09-02 | Hale Dental | 1,200.00 | auto | 1,200.00 | 2026-09-15 | auto | auto | auto | auto | ||
| INV-0102 | 2026-09-20 | Birch & Co | 860.00 | auto | 0.00 | auto | auto | auto | auto | |||
| INV-0103 | 2026-10-14 | Hale Dental | 450.00 | auto | 200.00 | auto | auto | auto | auto |
Sheet Customers — Totals per customer.
| Customer | Invoiced | Outstanding | Overdue | Avg days to pay | |
|---|---|---|---|---|---|
| Hale Dental | auto | auto | auto | auto | |
| Birch & Co | auto | auto | auto | auto | |
| Northside Gym | auto | auto | auto | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com