All templates
Finance
Invoice Tracker
See what you have invoiced, what is paid and what is overdue.
Invoices3 rows
| # | AInvoice | BCustomer | CDate | DDue | EAmount | FPaid | GStatus |
|---|---|---|---|---|---|---|---|
| 1 | INV-1041 | Riverside Cafe | 02 Sep | 02 Oct | 1,240 | Yes | Paid |
| 2 | INV-1042 | Northgate Ltd | 09 Sep | 09 Oct | 3,600 | No | Due |
| 3 | INV-1043 | Bellweather | 12 Aug | 12 Sep | 820 | No | Overdue |
What it tracks
- Invoices raised
- Payment status
- Overdue amounts
Included sheets
InvoicesCustomersSummary
Key calculations
- Status
- =IF(F2="Yes","Paid",IF(TODAY()>D2,"Overdue","Due"))
- Outstanding
- =SUMIFS(E:E,F:F,"No")