Most small businesses don’t have a sales problem so much as a “where is that money?” problem. You send the invoice, the job is done, and three weeks later you can’t remember whether the client paid, paid half, or is now 40 days late. An invoice tracker fixes that with one line per invoice: who owes what, when it’s due, what came in, and what to do next.
This page gives you a free invoice tracker template in Excel. You type the invoice number, customer, date and amount, and later the payment. The sheet works out the due date, balance, status (Paid, Open, Due soon or Overdue), days past due, aging bucket and an optional late fee. A dashboard shows your open and overdue balance, the ten most overdue invoices, each customer’s average days to pay and invoiced vs. collected by month. You can also use the online version on this page without downloading anything.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Includes 150 invoice rows, a customer list with per-customer payment terms, a customer balance summary with a suggested next step, an aging table and two charts.
Free online invoice tracker
Set your “as of” date, default payment terms, a “due soon” window and, if your terms include one, a monthly late fee. Then add your invoices, or click Load example. The report shows the open and overdue balance, an aging table, a follow-up list sorted by days late, a summary for each customer and a six-month chart of invoiced vs. collected. You can print it, save it as a PDF, download it as Excel, Word or CSV, or email a link to your bookkeeper.
3. Invoice tracker report
Aging of the open balance
Invoiced vs. collected by month
Follow-up list
Customers
All invoices
Due date = invoice date + terms. Days past due = as-of date − due date. Late fee = balance × monthly rate ÷ 30 × (days past due − grace days); a calculation only, charge it only if your terms allow. Collected is counted in the month of the payment date.
Made with the free invoice tracker at bookkeepingsheets.com
What is an invoice tracker?
An invoice tracker is a running list of every invoice you’ve sent and what happened to it. It sits between your invoicing tool and your books. Even if you create invoices in Word, Canva or our free invoice generator, you still need one place that answers:
- Is it paid? Paid in full, partly paid, or nothing yet.
- When is it due? The invoice date plus your payment terms (Net 15, Net 30, Net 45).
- How late is it? Days past due, grouped into aging buckets.
- Who do I need to chase today? A short list, oldest first.
An invoice tracker and an accounts receivable aging report overlap. The tracker is the day-to-day list of invoices, and the aging report is the summary view your accountant or lender asks for at month end. This template gives you both: the Invoices sheet is the tracker and the Dashboard builds the aging from it.
What’s inside the template
- Setup: business name, “as of” date (type
=TODAY()to keep it current), default terms, “due soon” window, late fee rate per month and grace days, and the first month for the monthly chart. - Customers: one row per customer with contact and payment terms. Leave terms blank to use the default. To the right, each customer gets an invoice count, total invoiced, paid, open and overdue balance, oldest days past due, average days to pay, calculated late fees, share of your open balance and a suggested next step.
- Invoices: 150 rows. You enter the invoice #, customer (dropdown), invoice date, optional terms, amount, amount paid, last payment date and a note. Everything else is calculated, and the header has filters so you can show only Overdue or one customer.
- Dashboard: totals, overdue %, due soon, average days to pay, % paid on time, the oldest overdue invoice, aging buckets with a chart, the ten most overdue invoices and a 12-month invoiced vs. collected table and chart.
How to use the invoice tracker
- Fill in Setup. Pick the terms you put on most invoices. If you don’t charge late fees, set the rate to 0.
- List your customers. Give slow payers or larger clients their own terms (for example Net 45 for a retailer, Net 15 for a small client).
- Add each invoice the day you send it. Invoice number, customer, date and amount are enough. The row shows as Open, then Due soon as the due date gets close.
- Record payments when they land. Type the total received so far in Amount paid and the latest payment date. A partial payment shows as “Open (partial)” or “Overdue (partial)”.
- Check the Dashboard once a week. Work down the “Most overdue invoices” list and follow the suggested step.
Example: a small design studio in November
Northpoint Design Studio has six clients and 15 invoices from July to November 2026, mostly on Net 30. The tracker is run as of November 16, 2026, with a 7-day “due soon” window and a 1.5% monthly late fee after 5 grace days. These are the same numbers you get with Load example above.
| Invoice | Customer | Due date | Balance | Status | Days past due | Late fee |
|---|---|---|---|---|---|---|
| 1009 | Bright Path Tutoring (Net 15) | Aug 11, 2026 | $1,125.00 | Overdue | 97 | $51.75 |
| 1015 | Northwind Fitness (Net 14) | Sep 28, 2026 | $3,300.00 | Overdue | 49 | $72.60 |
| 1006 | Greenleaf Cafe | Oct 8, 2026 | $1,400.00 | Overdue (partial) | 39 | $23.80 |
| 1007 | Maple & Co. Realty | Oct 21, 2026 | $2,150.00 | Overdue | 26 | $22.58 |
| 1008 | Summit Outdoor Supply (Net 45) | Nov 15, 2026 | $7,800.00 | Overdue | 1 | $0.00 |
| 1011 | Greenleaf Cafe | Nov 18, 2026 | $2,600.00 | Due soon | 0 | $0.00 |
| 1012–1014 | 3 invoices, 3 customers | Nov 25 – Dec 24 | $11,230.00 | Open | 0 | $0.00 |
The studio invoiced $51,630.00 and has collected $22,025.00. The open balance is $29,605.00, and $15,775.00 of it (53.3%) is overdue across five invoices. By aging bucket: $13,830.00 current, $9,950.00 at 1–30 days, $4,700.00 at 31–60 days, nothing at 61–90 and $1,125.00 over 90 days. The six paid invoices took 31.8 days on average, and two of them were paid late.
The tracker also points to the real issue. More than half of the overdue money is one invoice, Summit Outdoor Supply’s $7,800, and that one is only a day late, so a polite email is enough. The $1,125 from Bright Path Tutoring, 97 days past due, is the one at risk of never being paid. The calculated late fees add up to $170.73, but they’re only owed if the studio’s invoices actually say so.
The formulas, explained
- Terms used: the invoice’s own terms if you typed them, otherwise the customer’s terms, otherwise the default. In Excel that’s
IF+INDEX/MATCHon the customer list. - Due date = invoice date + terms used.
- Balance = amount − amount paid.
- Status: Paid if the balance is zero; Overdue if the as-of date is after the due date; Due soon if the due date is within the window; otherwise Open. “(partial)” is added when some money has come in.
- Days past due = as-of date − due date (zero if not yet due or paid).
- Aging bucket: Current, 1–30, 31–60, 61–90 or 90+ days past due.
- Late fee = balance × monthly rate ÷ 30 × (days past due − grace days). For invoice 1015: $3,300 × 1.5% ÷ 30 × (49 − 5) = $72.60. Our late fee and interest calculator handles one invoice with other methods (flat fee, compounding).
- Days to pay = last payment date − invoice date, for fully paid invoices only. “Paid late” if the payment came after the due date.
- Customer totals use
SUMIFSandCOUNTIFS; the “most overdue” list usesLARGEon a helper column, so it works in older Excel and Google Sheets withoutFILTERorSORT.
A simple follow-up routine
The template suggests a next step based on how late the oldest invoice is. Adjust it to your own policy:
| Days past due | Suggested step |
|---|---|
| Due within the window | Courtesy reminder with the invoice attached |
| 1–15 | Friendly reminder email |
| 16–45 | Second notice with a statement; add the late fee if your terms allow it |
| 46–90 | Phone call; pause new work until the account is current |
| 90+ | Final demand letter, then a collection agency or small claims |
Common mistakes
- Writing “paid” over the amount. Keep the original amount and enter the payment in its own column. Otherwise partial payments disappear and your days-to-pay history is lost.
- Leaving the as-of date fixed. If you type a date, update it before you look at the Dashboard, or use
=TODAY(). - Charging late fees your invoice never mentioned. A late fee usually needs to be in your contract or on the invoice, and some states limit the rate. The template only calculates it.
- Spelling a customer two ways. “Maple & Co.” and “Maple and Co” are two customers to
SUMIFS. Use the dropdown. - Counting unpaid invoices as income on a cash basis. If you use the cash method, income is recorded when you’re paid, not when you invoice.
Unpaid invoices and taxes
If an invoice is never paid, whether you can deduct it depends on your accounting method. The IRS says a business bad debt is deductible only if the amount was already included in your income. Most cash-method businesses never reported the unpaid invoice as income, so there’s nothing to deduct (IRS Topic No. 453, Bad debt deduction). Accrual-method businesses that booked the sale can generally write off the worthless part on Schedule C or their business return. Ask your tax professional which applies to you.
FAQ
What’s the difference between an invoice tracker and an A/R aging report?
The tracker lists every invoice and its status; the aging report groups the unpaid balance by how late it is. This template builds the aging on the Dashboard from the tracker, so you only enter invoices once.
How do I record a partial payment?
Enter the total received so far in Amount paid and the date of the latest payment. The balance and status update, and the invoice shows “(partial)”.
Can I track invoices for several businesses?
Use one file per business. The customer list, terms and late fee settings are per file.
Does it work in Google Sheets?
Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. The dropdowns, formulas and colors carry over; the charts may look slightly different.
When should I move from a spreadsheet to accounting software?
When you send more than a few dozen invoices a month, want online payment links or automatic reminders, or need the invoices to post to your books on their own. Our Excel vs. QuickBooks vs. Xero calculator compares the costs.
Related calculators and templates
- Accounts Receivable Aging Report Template
- Free Invoice Generator
- Late Fee and Interest Calculator
- 13-Week Cash Flow Forecast Template
- Chart of Accounts Template
- Small Business Bookkeeping Spreadsheet
This guide and template are for general record-keeping and information. They aren’t accounting, tax or legal advice. Late fee and interest limits, and the tax treatment of unpaid invoices, depend on your state, your contracts and your accounting method. For questions about your own business, talk to a qualified accountant, tax professional or attorney.