I cannot tell exactly who still owes me.
Build a two-table invoice and payment workflow that preserves partial-payment history and calculates the remaining balance.
Track Unpaid Invoices in ExcelINVOICE & CASH FLOW KNOWLEDGE HUB
Money is earned. Now make the unpaid part visible.
Start with the problem in front of you: a client still owes money, a partial payment changed the balance, an invoice is overdue, or you need a clearer follow-up queue. Use one free guide or tool at a time.
START WITH THE PROBLEM
What is getting lost in your invoice workflow?
Each path answers a different question. Do not build a bigger spreadsheet until you know which question is actually causing the problem.
I know money is late, but not how late.
Understand Current, 1–30, 31–60, 61–90 and 90+ aging, then test one invoice in the browser.
Read Invoice Aging ExplainedI keep chasing invoices from memory.
Turn overdue follow-up into a visible queue with last contact, promise-to-pay and next follow-up dates.
Build a Follow-Up ProcessA client paid part of an invoice and my sheet became confusing.
Keep the original invoice intact, record each payment separately and age only the remaining unpaid balance.
See the Partial-Payment WorkflowWhy this matters for cash-flow visibility
Revenue on an invoice is not the same as cash already received. A small business can look busy while still having a growing amount of money tied up in unpaid balances. A practical receivables workflow makes four facts visible: what was billed, what has been paid, what remains unpaid and what needs attention next.
Use aging as a prioritization signal, not as the whole process
Aging tells you how old an unpaid balance is. It does not replace the invoice history, the payment log or the next follow-up action. The useful workflow connects all four so an older balance can be reviewed without losing the payment history or client context.
When a ready-made workbook becomes useful
If you understand the workflow but do not want to build the formulas and views yourself, review the Invoice & Payment Follow-Up Tracker. The product page shows the real workbook, included files and limitations. The free guides and calculator remain usable without buying anything.