Accounting template
Invoice Tracker Template
Keep every invoice in one list. Days overdue and outstanding totals are calculated automatically.
Starts with 25 free credits. No card needed.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Invoice | Client | Amount | Due date | Paid | Days overdue |
| 2 | 1001 | Client A | 12,000 | 2027-02-01 | No | =MAX(0,TODAY()-D2) |
| 3 | Outstanding | =SUMIF(E:E,"No",C:C) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
F2 =MAX(0,TODAY()-D2)
Days past the due date, never negative.
C3 =SUMIF(E:E,"No",C:C)
Total of unpaid invoices.
Make it yours by asking
Try a request like this in Tabstra:
"Create an invoice tracker with invoice number, client, amount, issue date, due date, paid status, days overdue and total outstanding"