Invoice Tracking for Small Business

You sent an invoice three weeks ago and the client says they never got it. You can’t remember the date you sent it. To keep track of invoices and payments, give every invoice one of five statuses (draft, sent, viewed, paid, overdue), record the due date, and spend five minutes each Monday sorting unpaid invoices by how late they are. A spreadsheet handles this fine until it doesn’t.

This guide walks through that system step by step, from a free Google Sheets tracker to the point where an app saves you time.

What invoice tracking means for a small business

Invoice tracking is knowing, at any moment, which invoices you sent, which are paid, and which are still outstanding. That’s it. No ledger, no accountant-speak. You are answering one question: who owes me money, and how late is it?

It matters because late money is the norm, not the exception. Intuit QuickBooks’ 2025 small business late payments report found that 56% of US small businesses had unpaid invoices, and those businesses were owed $17,500 on average. Another 47% reported some invoices more than 30 days overdue.

You can’t chase what you can’t see. A basic invoice tracking system fixes that.

What are the five statuses every invoice goes through?

Every invoice moves through five statuses: draft, sent, viewed, paid, and overdue. Keep delivery and payment separate in your head. An invoice can be viewed and overdue at the same time.

Draft. You’ve started it but the client hasn’t seen it. Action: finish it and send it before you leave the job site.
Sent. It’s out the door. Record the date sent. Action: confirm it landed, especially on text or email to a new client.
Viewed. The client opened it. Action: if the due date is close, a short nudge now beats a chase later.
Paid. Money is in your account. Action: mark it paid only after the deposit shows up, not when the client says “it’s coming.”
Overdue. The due date passed and the balance is still open. Action: follow the schedule in the next section.

Add a sixth status, partially paid, if you take deposits or split payments. Keep the original due date and track the remaining balance. For setting up deposits, see the deposit invoice template guide.

How do you track overdue invoices? Use aging buckets

Sort every unpaid invoice by days past the due date: 1-30, 31-60, 61-90, and 90+. This is what accountants call an aging report. You can call it “how late is it?” and run it in five minutes. For the formal version, see the accounts receivable aging report guide.

Count from the due date, not the invoice date. Pick one and stay consistent.

Bucket	What it means	What you do
Current	Not due yet	Nothing. Check the due date.
1-30 days	Slightly late	Friendly reminder by text or email
31-60 days	Properly late	Phone call, restate the amount and due date
61-90 days	Serious	Pause new work, send a firm written notice
90+ days	At risk	Decide on collections or write-off

The follow-up email templates for every stage cover the wording for each row. For the relationship side, read how to handle late-paying clients.

The Monday check

Pick one time a week. Open your tracker, sort by days overdue, and work from the top. Anything in the 1-30 bucket gets a nudge. Anything older gets a call. Five minutes, once a week, beats a panicked hour at month end.

How do you set up a free invoice tracker in Google Sheets or Excel?

Create one row per invoice and ten columns. This works as an invoice tracking template in Google Sheets or as a payment tracker Excel template, and it takes under ten minutes with no course required.

Column	What goes in it
A. Invoice number	One unique number per invoice, never reused
B. Client	Who you billed
C. Date sent	The day it actually went out
D. Due date	Real date-formatted cell
E. Amount	Invoice total
F. Amount paid	Zero until money arrives
G. Balance due	Formula
H. Days overdue	Formula
I. Aging bucket	Formula
J. Notes	Last reminder sent, how they pay, anything else

Paste these formulas into row 2 and drag them down. They work in both Excel and Google Sheets:

Balance due (G2): =MAX(0,E2-F2)
Days overdue (H2): =IF(F2>=E2,0,MAX(0,TODAY()-D2))
Bucket (I2): =IF(F2>=E2,"Paid",IF(TODAY()<=D2,"Current",IF(TODAY()-D2<=30,"1-30",IF(TODAY()-D2<=60,"31-60",IF(TODAY()-D2<=90,"61-90","90+")))))

Then sort by column H, largest first. The top of the sheet is your chase list.

A few habits keep the sheet honest:

Make the due date a real date, not text. Formulas break otherwise.
Update the sheet the same day you send an invoice or get paid.
Keep a backup. In Google Sheets, check version history. In Excel, save a dated copy weekly.
Keep voided invoice numbers in the sheet, marked void. Don’t delete the row or reuse the number. More on numbering in the invoice number best practices guide.

Keep your records longer than you think. The IRS recordkeeping guidance says to keep records as long as they matter for your tax return, and three years is a common rule of thumb. Check the page for your situation, or ask your CPA.

Need to build the invoice itself first? The guide to creating an invoice in Word, Excel, and Google Docs covers it.

How do you find one invoice by its number?

Search the exact invoice number in your sheet or app, then check three things: the status, the balance, and the bank deposit. In a sheet, press Ctrl+F (Cmd+F on Mac) and type the number. In an app, use its search box.

Then confirm it the way a careful bookkeeper would:

Check the status and the date sent.
Check whether the client opened it. An app with read receipts shows this; email tracking can too.
Match any “paid” status to an actual deposit.
Look for a credit memo or refund that changes the balance. See the credit memo template guide.

This is the fastest way to answer a client who says, “I never got invoice 1047.”

When does a spreadsheet stop working?

A spreadsheet stops working when you start missing things. The sheet itself is fine at low volume. The trouble starts when you do the same work twice or forget to follow up.

Watch for these signs:

Double entry. You type each invoice into your invoicing tool, then again into the sheet.
Missed follow-ups. An invoice hit 45 days late before you noticed.
Volume. More than roughly 20 open invoices at once is a rough guide, not a rule. It’s editorial judgment, not a study.
Field work. You do most of your work from your phone, and editing a sheet there is a pain.
Two people. A partner or helper also sends invoices, and the sheet falls out of date.
Recurring and partial payments. Keeping those straight by hand gets error-prone fast.

If two or more apply, software probably pays for itself in time.

What should you look for in invoice tracking software?

Look for the things that remove the double entry: invoices that track their own status, payment reminders, a phone app, and an export. Then check the limits before you build anything, because limits sprung after sign-up are the top complaint about invoicing apps.

Ask these questions before you commit:

Is the free version actually usable? Can you build and send a real invoice before you pay?
What are the caps? Per-month invoice limits, client limits, and amount limits.
Does it take a cut? Some apps process payments through their own system and take a percentage. Others let you connect your own Stripe or PayPal account.
Does it work without signal? Basements and rural job sites don’t care about your Wi-Fi.
Can you get your data out? Look for an export, so switching later doesn’t mean losing your client list and old invoices.
How does renewal work? Check for auto-renewal and what a cancellation looks like.

Where the alternatives fit

Competitors have real strengths here. Pricing below comes from each company’s pricing page and changes often; check the page before you decide.

Invoice Simple limits how many invoices you can send per month on its lower tiers, with the lowest at 3 and the next at 10 (pricing page, captured 2026-10-27). It has a large user base and a well-reviewed app if you send a handful of invoices a month.
FreshBooks limits how many clients you can bill on its lowest tier and charges extra per team member (pricing page, captured 2026-10-27). If you want full accounting software, FreshBooks is the better fit, not an invoicing app.
Invoice Ninja has a free plan with 5 clients and unlimited invoicing, plus time tracking and projects (pricing page, captured 2026-10-27). If you need those extras or want to self-host, pick it.
Billdu includes invoice status tracking on its entry plan, with a client cap (pricing page, captured 2026-10-29).

For side-by-side detail, see best Invoice Simple alternatives and best FreshBooks alternatives. Full disclosure: Pronto Invoice is our product.

Common invoice tracking mistakes

No date sent. Without it, you can’t prove when the clock started.
Marking paid too early. “Check’s in the mail” is not a deposit.
No owner for follow-up. If nobody checks the list weekly, nobody chases.
Reusing or deleting invoice numbers. It wrecks your records.
Skipping the due date. An invoice with no due date can never be overdue, and it will never get paid on time. See invoice payment terms.

Sending faster also helps. The guide to getting customers to pay invoices faster covers more ways to shorten the wait.

FAQ

What is an invoice tracker?

An invoice tracker is a list, in a spreadsheet or an app, that records every invoice you’ve sent, its due date, how much has been paid, and its status. It tells you who’s paid and who hasn’t.

Can I track invoices in Google Sheets?

Yes. Use the ten columns above and the three formulas. It’s free, takes under ten minutes, and works well at low volume.

Do I need software to track invoices?

No. A spreadsheet is enough while you send a few invoices a month and update it the same day. Switch when double entry or missed follow-ups start costing you money.

How often should I check how late my invoices are?

Weekly. A five-minute Monday check catches an invoice at day 3 instead of day 45.

Track it from your phone

If you’d rather skip the spreadsheet, Pronto Invoice is an invoicing app built for your phone. Build the invoice in five steps, send it before you leave the driveway, and see what’s outstanding from the same place. Payment reminders and reports sit on paid plans, and you connect your own Stripe or PayPal account, so there’s no cut of your payments. Check the pricing page for current plan limits before you start, and try the free tier at prontoinvoice.com.

For reminders that actually get answered, read automated invoice reminders that work.