Invoice tracker template
Every invoice you have sent, who it is to, how much, and whether it has been paid.
Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.


What is in it
Invoices, clients, amounts and whether each is paid, with the total invoiced. The figures are examples to type over.
| Client Invoice Tracker | |||
| Invoice # | Client Name | Amount ($) | Status |
| INV-1001 | Acme Corporation | 4500 | Paid |
| INV-1002 | Starlight Media | 2800 | Pending |
| INV-1003 | Apex Logistics | 6200 | Paid |
| INV-1004 | Vanguard Labs | 3100 | Pending |
| Total Invoiced Revenue | =SUM(C4:C7) |
Worked out for you
These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.
- Amount ($)
=SUM(C4:C7)
Filling it in
- Number invoices in one unbroken sequence. Gaps are the first thing an accountant asks about.
- Add the date each was sent and the date it is due, so what is overdue can be sorted to the top.
- Chase on the day after the due date. Late payments get later the longer they are left.
The next step
More templates
- Cash-flow forecastSix months of money in and out, each month opening where the last one closed, and the lowest balance picked out.Open in Sheets
- Sales pipelineEach deal with its company, stage, value and expected close, the chance of winning it from its stage, and the pipeline’s weighted total.Open in Sheets
- Operating budgetBudget against actual for each category, with the variance and the totals worked out.Open in Sheets