Unpaid invoices are one of the most common cash flow problems small businesses face — and most of the time it isn't because clients refuse to pay. It's because invoices slip through the cracks. They get sent and then forgotten. The due date passes without a follow-up. Weeks later you realize you're still waiting on money that should have arrived a month ago.
A simple invoice tracker in Excel solves this completely. You'll always know exactly what's been paid, what's outstanding, and what's overdue — so nothing gets lost and you always know the state of your receivables. Here's how to build one.
Before building anything, decide what you need to see at a glance. A useful invoice tracker answers four questions instantly: How much is currently outstanding? Which invoices are overdue and by how many days? What did I collect this month? And which clients are my slowest payers?
Your invoice log is a simple table — one row per invoice — with columns capturing everything you need to know about each one. Here's the full column setup:
| Column | What to Enter |
|---|---|
| Invoice # | Your invoice number — keep these sequential and consistent |
| Client | Who the invoice was sent to |
| Description | Brief note on what the invoice was for |
| Invoice Date | The date you sent the invoice |
| Due Date | When payment is due — calculated automatically based on your terms |
| Amount | The total invoice amount |
| Amount Paid | What has actually been received — enter 0 until paid |
| Balance Due | Automatically calculated: Amount minus Amount Paid |
| Payment Date | The date payment was received — leave blank if unpaid |
| Status | Automatically calculated — Paid, Overdue, or Pending |
| Days Overdue | Automatically calculated — how many days past due |
These three formulas do the heavy lifting — calculating due dates, payment status, and days overdue automatically so you never have to update them manually.
Due Date — automatically calculated from invoice date (30-day terms):
Change 30 to whatever your payment terms are — 14 for two weeks, 60 for 60-day terms. You can also make this dynamic by referencing a terms cell so you can change it in one place.
Balance Due — amount still owed:
Status — automatically shows Paid, Overdue, or Pending:
Days Overdue — how many days past the due date:
Here's what a typical invoice log looks like with these formulas in place:
Your summary sheet gives you the full financial picture of your receivables in one view. These formulas pull directly from your Invoices table and update automatically as you add new invoices or mark existing ones as paid.
Total outstanding (unpaid invoices):
Total overdue amount:
Total collected this month:
Number of open invoices:
Revenue by client (great for spotting your best clients):
The tracker itself doesn't chase payments — you do. But with a well-built tracker, your weekly follow-up routine becomes fast and systematic instead of stressful and ad hoc.
Once a week — Monday morning works well — open your invoice tracker and filter by Status = Overdue. Every invoice in that filtered view needs a follow-up. Sort by Days Overdue so the longest outstanding ones are at the top. Work through them in order.
Add a Notes column to log the last contact date and what was said. This becomes invaluable when a payment dispute arises — you have a complete timeline of every follow-up attempt in one place.
An invoice tracker doesn't just tell you what clients owe you — it gives you visibility into your cash flow. When you can see at a glance that $12,000 is coming in over the next two weeks but $6,000 is already overdue, you can make better decisions about expenses, timing, and which clients need attention right now.
Combined with an expense tracker, your invoice log becomes the foundation of a real financial picture for your business — without expensive accounting software or a bookkeeper on retainer.
If you'd like a custom invoice tracker built for your specific billing setup — with your payment terms, your client list, and your reporting needs — that's exactly what we do at HelpMyData.
Tell us how you bill and what you need to track. We'll build a clean, automatic invoice tracker that keeps your receivables organized and your cash flow visible — starting at just $75.
📧 Get Started Today