An invoice can be sent without being paid. A small invoice tracker helps you separate the work you have billed from the money you have actually received, and keeps follow-up dates in one place.
This guide shows a simple manual setup you can build in Excel. You do not need to buy a template to use the method.
1. Use one row per invoice
Start with these seven columns: invoice number, client, due date, invoice total, payments received, balance due and status. Use a consistent invoice reference so you can match each row to the original document.
- Invoice total: the full amount shown on the invoice.
- Payments received: the amount the client has paid against that invoice, including any partial payments.
- Balance due: the amount still unpaid.
Store due dates as real Excel dates and amounts as numbers. If you work in different currencies, add a currency column and review each currency separately. Adding a dollar sign or changing a cell format does not convert currencies.
2. Calculate what is still outstanding
If invoice total is in column D and payments received is in column E, enter =MAX(0,D2-E2) in F2 and copy it down your invoice rows. This shows the remaining balance without displaying a negative balance for an overpayment. Record and investigate overpayments separately rather than losing that detail.
Here is an illustrative example using one currency:
| Invoice | Total | Paid | Balance |
|---|---|---|---|
| INV-001 | 500 | 200 | 300 |
| INV-002 | 250 | 250 | 0 |
| INV-003 | 400 | 0 | 400 |
The total billed is 1,150, but payments received are 450 and the outstanding balance is 700. Those figures answer different questions; keep them separate.
3. Make unpaid invoices easy to review
For completed rows, with due date in C2 and balance in F2, a basic status formula is =IF(F2=0,"Paid",IF(C2<TODAY(),"Overdue","Open")). Enter every required value before using the status, and check that the formula has copied correctly.
This rule labels an unpaid invoice as overdue after its due date. It does not interpret contract terms, extensions, disputes or grace periods. Add a notes column when a payment arrangement changes, and review those cases manually.
4. Keep a short weekly follow-up routine
- Match new payments to invoices using your bank or payment-provider records.
- Update partial payments and review the remaining balance.
- Filter for unpaid invoices and check due dates.
- Record the last follow-up date, the client's response and the next action.
- Save a backup before making larger changes.
A courteous reminder can identify the invoice number, original due date and remaining amount, then ask whether the client needs another copy or has an expected payment date. Check the records first so you do not chase an invoice that has already been paid.
5. Keep fees separate from the client's payment
If a client pays 500 and a payment provider deposits 485 after a 15 processing fee, do not automatically mark 15 as still owed by the client. Check the payment record and your agreement. Track the provider fee separately from the amount the client paid.
Build your own tracker or use a prepared workbook
A basic worksheet is enough if you only need an invoice list. For a prepared manual system, the Bolzei Freelancer Finance Dashboard includes an invoice log with balance-due calculations and overdue status, a transaction tracker, monthly summaries and a quick-start guide.
It is an editable Excel download with no macros or bank connection. Check the product previews and full contents before choosing it. For a wider routine, read our beginner's guide to freelance finance tracking.
This is a practical recordkeeping example, not accounting or tax advice. Verify your entries against source documents and obtain appropriate professional advice for reporting obligations.