How to Track Unpaid Invoices
If you cannot list what you are owed this week, unpaid invoices are running the business, not you. Learning how to track unpaid invoices does not require a large accounting suite. It requires a short, current list and a habit of updating it when you send or receive money. This guide gives you that list.
Keep One Table, Not Five Folders
Create a sheet with these columns: invoice number, client, issue date, due date, amount, status and last follow-up. Status can be Draft, Sent, Part paid, Paid or Void. Update the row the day you send the PDF and the day payment arrives. That is enough for most freelancers and small shops.
Store the PDF in a folder named by year. The sheet points to the number; the folder holds the file. Invoice records for tax time explains the longer archive.
| Number | Client | Due | Amount | Status |
|---|---|---|---|---|
| INV-10410 | Northside Bakery | 14 July | 630.00 | Sent |
| INV-10411 | Lake Clinic | 1 July | 1,200.00 | Overdue |
| INV-10412 | Hale Studio | 20 July | 480.00 | Paid |
Review Weekly, Follow Up on a Schedule
Once a week, sort by due date. Anything overdue gets a reminder. Anything due in a few days can get a polite heads-up if the client is usually slow. Use the wording in payment reminder emails and the steps in the overdue follow-up timeline.
Tip: Put the invoice number in the bank payment reference so matching a payment to a row takes seconds.
Do Not Track Drafts as Money
A draft is not an unpaid invoice. Only mark Sent after the client has the PDF. Counting drafts as receivables fools you into thinking cash is coming. Create the real document on our invoice generator when you are ready to send, then add the row.
Tracking unpaid invoices is a weekly hygiene task, not a once-a-year panic.
Frequently Asked Questions
Should I use accounting software?
When the sheet becomes painful, yes. Until then, a careful list is better than unused software.
What if a client pays the wrong amount?
Mark the invoice Part paid, record the amount received and invoice or credit the difference. See credit notes if you need to reduce a bill.
How long should I chase a balance?
Follow your contract and local rules. Keep notes of each reminder so you know what you already tried.
Send the next one so you have something accurate to track. Create a free invoice.