How to Track Your Invoices and Income
Sending an invoice is only half the job. The other half is knowing which invoices have been paid, which are late, and how much money you are still waiting for. A simple tracking habit stops invoices from slipping through the cracks and gives you a clear picture of your income.
What to record for every invoice
- Invoice number and client name
- Issue date and due date
- Invoice amount and the amount received so far
- Balance still owed
- Status: Sent, Part paid, Paid or Overdue
Eight columns are enough. The skill is keeping them up to date, ideally the same day a payment arrives.
What each status means
| Status | Meaning | What to do |
|---|---|---|
| Sent | Issued, not yet due, nothing paid | Nothing, unless the due date is close |
| Part paid | Some money received, balance remains | Record the payment and confirm when the rest is due |
| Paid | Balance is zero | Send a receipt if the client needs one |
| Overdue | Due date passed and a balance remains | Send a reminder (see the follow-up guide) |
A worked example
Here is a small tracker on 18 October 2026. The clients and amounts are made up.
| Invoice | Client | Due | Amount | Received | Balance | Status |
|---|---|---|---|---|---|---|
| INV-001 | Northwind Café | 15 Sep | 1,958.00 | 1,958.00 | 0.00 | Paid |
| INV-002 | Brightpath Ltd | 4 Oct | 800.00 | 0.00 | 800.00 | Overdue, 14 days |
| INV-003 | Harbor Studio | 24 Oct | 1,250.00 | 500.00 | 750.00 | Part paid |
| Totals | 4,008.00 | 2,458.00 | 1,550.00 | 800.00 overdue | ||
At a glance: 4,008.00 invoiced, 2,458.00 received, 1,550.00 outstanding, and 800.00 of that is already late and needs a reminder today.
Free invoice tracker (Excel)
It holds up to 200 invoices. Type the invoice number, client, dates, amount and amount received. The balance, status and days overdue calculate for you, and a summary at the top shows total invoiced, total received, outstanding, and the overdue amount. The three example rows match the table above.
Group late invoices by age
Sorting unpaid invoices by how late they are tells you where to focus: current (not due yet), 1 to 30 days late (a friendly reminder), 31 to 60 days late (a firmer message and a phone call), and over 60 days (a final notice and a decision about further steps). The older an invoice gets, the harder it usually is to collect.
A simple routine
- Same day: record every payment you receive.
- Weekly: check for invoices that became overdue and send reminders.
- Monthly: compare invoiced and received amounts and look at income by client.
Numbers worth watching
- Outstanding balance: money you are owed right now.
- Overdue amount: the part of that already past due.
- Average days to get paid: add up the days between issue date and payment for each paid invoice and divide by how many there are. If it is much longer than your payment terms, your terms or follow-up need work.
- Income by client: if one client is most of your income, losing them would hurt, so it is worth knowing.
Tracking in FineInvoice
The Reports page in FineInvoice shows revenue by customer and invoice history with status, and lets you export your data to CSV, so you can keep a spreadsheet like the one above without typing every invoice twice.
Common mistakes
- Forgetting to record part payments, so the balance looks wrong
- Tracking invoices in several places that disagree
- Only looking at the list when money is tight
- Chasing a client for an invoice that was actually paid
Frequently asked questions
Do I need accounting software?
For a handful of invoices a month, a spreadsheet works. Accounting software helps when you need tax reporting, bank matching or several users.
Should I track quotes and draft invoices too?
Only if it helps you. The tracker is meant for invoices that have actually been sent.
How long should I keep invoice records?
Record-keeping periods are set by tax rules and differ by country, so check your tax authority.
This guide is general information about keeping your own records. It is not accounting or tax advice.