Invoice tracking means recording every invoice you send, with its number, client, amount and dates, and following its status until it's paid. It tells you who owes you what and which invoices are overdue. You can track invoices in a spreadsheet with about a dozen columns and a few formulas, or in invoicing software that updates the status when payments are recorded. Either way, update it when payments arrive and review it on a regular schedule, such as weekly.
Why track invoices
- Cash flow. You can see what money is due in and when.
- Faster follow-up. You see an invoice go overdue when it happens, not weeks later.
- Nothing missed. Every invoice is on one list, so none goes unbilled, unchased or billed twice.
- Bookkeeping and taxes. The IRS lists invoices among the supporting documents for the entries in your books, and suggests organizing them, for example by year and type of income (IRS: What kind of records should I keep).
What to record for each invoice
| Field | Why it matters |
|---|---|
| Invoice number | A unique reference for each conversation and payment (what is an invoice number) |
| Client | Who owes you |
| Invoice date | Often the date payment terms start counting from |
| Due date | When the invoice becomes overdue |
| Amount | What you billed |
| Amount paid | Handles partial payments |
| Balance due | What's still owed |
| Status | For example Sent, Partially paid, Paid, Overdue, Overpaid, Void |
| Payment date and method | Lets you match the payment to your bank statement |
| Notes and last follow-up | When you last reminded the client, and what you sent |
How to track invoices in a spreadsheet (Excel or Google Sheets)
Use one row per invoice. The example below is a fictional freelancer's tracker with four invoices, all on net 30 terms counted from the invoice date, shown as of Monday, November 16, 2026. Column K holds each invoice's payment terms in days, and column L marks canceled invoices.
| A: Invoice # | B: Client | C: Invoice date | D: Amount | E: Due date | F: Paid | G: Balance | H: Days overdue | I: Aging | J: Status | K: Terms (days) | L: Void |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 3301 | Alder Street Bakery | Sep 28, 2026 | $3,000.00 | Oct 28, 2026 | $3,000.00 | $0.00 | 0 | Paid | 30 | ||
| 3302 | Lumen Health | Oct 1, 2026 | $455.00 | Oct 31, 2026 | $0.00 | $455.00 | 16 | 1–30 | Overdue | 30 | |
| 3303 | Maple Dental | Oct 20, 2026 | $880.00 | Nov 19, 2026 | $0.00 | $880.00 | 0 | Current | Sent | 30 | |
| 3304 | Ridgeway Builders | Aug 28, 2026 | $2,400.00 | Sep 27, 2026 | $1,000.00 | $1,400.00 | 50 | 31–60 | Overdue | 30 |
Columns M and N are useful additions that the example leaves out to stay readable: payment date and method, and notes on the last follow-up.
Formulas
Put headers in row 1, enter these in row 2 and copy them down. They use standard functions that both Excel and Google Sheets support.
- Due date (E2):
=C2+K2, where K2 is the number of days in the terms (30 for net 30). This counts from the invoice date. If your agreement starts the clock on another date, such as delivery or receipt of the invoice, put that date in its own column and use it instead of C2. See invoice payment terms explained. - Balance (G2):
=IF(L2="Void",0,D2-F2). A canceled invoice keeps its original amount in column D for your records, but its balance is zero. If the client overpays, the balance goes negative. - Days overdue (H2):
=IF(G2<=0,0,MAX(0,TODAY()-E2)). Format the column as a number, not a date. TODAY() changes daily; the example uses November 16, 2026. - Aging bucket (I2):
=IF(G2<=0,"",IF(H2=0,"Current",IF(H2<=30,"1–30",IF(H2<=60,"31–60",IF(H2<=90,"61–90","90+"))))) - Status (J2):
=IF(L2="Void","Void",IF(G2<0,"Overpaid (credit)",IF(G2=0,"Paid",IF(H2>0,"Overdue",IF(F2>0,"Partially paid","Sent"))))). Overdue takes priority, so invoice 3304 shows Overdue even though it's partly paid; the Paid column shows the $1,000.00 received.
Canceled and overpaid invoices. To cancel an invoice, type Void in column L and leave the formulas in place. The balance drops to zero, the status shows Void, and the row stays in the list as a record. Don't type over the Balance or Status cells: copying the formulas down again would undo a manual change. If the client had already paid part of an invoice you cancel, record the refund or credit separately. If a client pays more than the amount due, for example $550.00 on a $500.00 invoice, the balance shows −$50.00 and the status shows Overpaid (credit), so you can refund it or apply it to their next invoice.
Tips
- Add conditional formatting so rows with days overdue above 0 stand out.
- Use a filter or pivot table on Client and Aging to build the aging summary below.
- If you start a new tab each year, keep every unpaid invoice in the tab you work from, so older balances stay in your follow-up and aging report. Don't reuse invoice numbers.
Build a simple aging report
An accounts receivable aging report groups unpaid balances by how far past due they are. From the example tracker as of November 16, 2026:
| Aging | Balance | Share of total |
|---|---|---|
| Current | $880.00 | 32% |
| 1–30 days | $455.00 | 17% |
| 31–60 days | $1,400.00 | 51% |
| 61–90 days | $0.00 | 0% |
| 90+ days | $0.00 | 0% |
| Total outstanding | $2,735.00 | 100% |
In a spreadsheet, each balance is a SUMIF on the Aging column, for example =SUMIF(I2:I5,"31–60",G2:G5). For the total, use =SUMIF(G2:G5,">0") so a client's overpayment doesn't reduce what other clients owe; list credits separately. Shares are rounded to whole percentages. Follow up on the oldest balances first.
A weekly invoice tracking routine
- Match payments. Check your bank account and payment processor, and record each payment with its date and method.
- Update balances, including partial payments.
- Sort by days overdue and send a reminder for each late invoice. Many businesses start with a polite reminder in the first week and get firmer after 30 days. Our guide to the past due invoice covers the wording and next steps.
- Log the follow-up: the date and what you sent.
- Decide what to do with long-overdue invoices, for example a phone call, pausing work, or a formal demand letter.
For a single customer with several invoices, a statement of account shows all their open invoices on one page.
Invoice tracking numbers worth watching
- Total outstanding (accounts receivable): $2,735.00 in the example.
- Overdue amount and share: $1,855.00 of $2,735.00 is overdue in the example, about 68%.
- Days sales outstanding (DSO): roughly how many days, on average, it takes to get paid. A common formula is
DSO = (accounts receivable ÷ net credit sales for the period) × days in the period(Xero: What is accounts receivable). Credit sales are sales you invoice rather than get paid for at the time of sale; leave out cash sales, because including them makes DSO look shorter than it is. For example, for a business that invoices all its sales, with $12,000 receivable at the end of a 90-day period and $36,000 of credit sales in that period: (12,000 ÷ 36,000) × 90 = 30 days. This simple version uses the closing balance; some businesses use the average receivable over the period instead. Either way, DSO is a simplified indicator, not the exact average time each invoice took to be paid. - Average days late per client: shows which clients might need shorter terms or a deposit.
Spreadsheet vs invoicing software
| Spreadsheet | Invoicing software | |
|---|---|---|
| Cost | No extra cost if you already have Excel or Google Sheets | Usually a subscription |
| Setup | You build it | Ready to use |
| Status updates | You update each one | Updated when payments are recorded; often automatic for online payments |
| Reminders | You send them | Can usually be automated |
| Error risk | Typos, broken formulas, duplicate numbers | Lower for numbering and math |
| Suits | A few invoices a month | Regular invoicing for many clients |
A spreadsheet works as long as you keep it updated. Consider switching when updating it starts taking real time each week, or when a late invoice slips past you.
Tracking invoices you receive
On the buyer side (accounts payable), track each vendor invoice: vendor, invoice number, amount, due date, who approved it, and payment date. Matching vendor invoices to purchase orders and delivery records helps you avoid paying the same invoice twice.
How to check that an invoice is real
Before you pay an invoice you weren't expecting, or one with new payment details:
- Match it to a purchase order, contract or delivery you can confirm.
- Check the sender's email address character by character. The FBI's Internet Crime Complaint Center advises making sure the address matches who the email claims to be from, especially on a phone (FBI IC3: Business Email Compromise).
- Confirm changed bank details through a second channel, such as a phone number you already have, not one in the email. IC3 gives the same advice for requests to change account information.
- Look for duplicates: the same number, amount or date as an invoice you've already paid.
- Be wary of pressure to pay immediately and of vague line items you can't tie to work you received.
If anything's off, hold the payment until you've confirmed it with the vendor. If you've already paid a fraudulent invoice, IC3 advises contacting your bank right away and filing a complaint at ic3.gov. More warning signs are in our invoicing best practices guide.
General information, not legal or tax advice.
Track invoices in InvoiceQuick
Keeping the list accurate. InvoiceQuick numbers each invoice automatically and keeps its due date. When a client pays by card online through your own connected Stripe account, the payment is recorded and the invoice is marked paid. You record other payments yourself, including partial ones, and the status changes from Partial to Paid.
Knowing what happened to an invoice. InvoiceQuick shows whether the invoice email was delivered, opened or bounced. It also shows when the client viewed or downloaded the invoice, and the invoice status changes to Viewed. You can choose to get an alert for each of these (account notifications).
Following up. InvoiceQuick can send automatic reminders 7 days before the due date, on the due date, and 7, 14 and 30 days after it.
Seeing the whole picture. The web dashboard shows what you're owed, how much is past due, and a past-due aging chart. In the web app's reports, a customer statement lists one client's invoices and payments up to a date you choose.
Getting the data out. You can export your invoice list as CSV, XLS or XLSX and open it in Excel or Google Sheets. For a one-off invoice, there's the free invoice generator.
Other questions
What is an invoice tracking system? Any software or set process that records invoices and moves them from sent to paid, often with reminders and reports.
Sources and further reading
- IRS: What kind of records should I keep (invoices as supporting documents; organizing records)
- FBI Internet Crime Complaint Center: Business Email Compromise (verifying sender addresses and account changes; what to do after a fraudulent payment)
- Xero: What is accounts receivable (DSO formula using net credit sales)
- Invoice payment terms explained
- Past due invoice: how to tackle and prevent payment delays
- Statement of account

