Losing track of which invoices are paid, overdue, or still pending is one of the most common small business admin problems. Here's a simple system to fix it.
Keep one master list
Whether it's a spreadsheet or a notebook, maintain a single running list of every invoice you send: number, client, amount, issue date, due date, and status.
Use just four statuses
Keep it simple: Sent, Paid, Overdue, and Disputed. Too many status categories make the system harder to maintain than it's worth.
Review it on a fixed schedule
Set a weekly recurring reminder — every Monday, for example — to scan the list for anything overdue and follow up immediately rather than letting it slide.
Color-code overdue items
If using a spreadsheet, a simple red highlight for anything past its due date makes overdue invoices immediately visible at a glance.
Archive paid invoices, don't delete them
Move paid invoices to a separate 'completed' section or sheet rather than deleting them — you'll want this record for tax season and historical reference.
When to upgrade from a spreadsheet
If your invoice volume grows past what you can track in one glance, a dedicated invoicing platform with built-in status tracking becomes worth the investment. Until then, a disciplined spreadsheet habit is enough.