How to Track Invoices and Payments + Free Tracker

How to track invoices and payments in seven steps

1. Give every invoice its own number. Keep that number on the PDF, in the spreadsheet and in the payment reference. Do not reuse a number for a different invoice.
2. Record the client and issue date. Add a project name in Notes if the same client has several jobs. Record the date you issued the invoice separately from the due date.
3. Write the actual payment deadline. Agree on payment terms first. The invoice due date calculator can turn Net 7, 15, 30 or custom calendar-day terms into a date. If your agreement starts the clock from receipt or approval, use that starting point.
4. Enter the final invoice total. Use the amount shown on the issued invoice, after the taxes, discounts and other adjustments that apply. Use one currency per tracker so its totals can be added meaningfully.
5. Record confirmed payments. Enter zero when nothing has arrived. After a payment clears, update the cumulative Paid amount and retain its date and reference in Notes or in your separate payment records.
6. Check the balance and status. In the template, Balance is invoice total minus payments received. A positive balance becomes Overdue only after the due date passes. A due date of today is still on time.
7. Choose the next follow-up date. Use the Follow-up column for your next action. Keep it separate from the original due date, and update your notes after the client replies.

In the download, columns A–F and J–K are inputs. The shaded G–I columns contain formulas. The summary covers rows 12–211. Leave the formulas in place, and use a new copy for another batch unless you deliberately extend all the ranges together.

A worked invoice-tracking example

The following fictional USD invoices are reviewed as of October 18, 2026:

Total invoiced is 2,600. Payments received are 1,300. Outstanding is 1,300, of which 800 is already overdue. Counting only the number of paid invoices would hide that partial payment on INV-1001.

The tracker download and workbook preview show the same example. Your downloaded workbook starts blank.

How to record partial payments and overpayments

Keep one row for the invoice. If a 1,200 invoice receives 400, its balance is 800. If another 300 arrives later, change the cumulative Paid amount to 700 and retain both payment references in your payment records. Its balance is now 500. Do not create another full 1,200 invoice row for the second payment.

If the client pays more than the invoice total, the template shows a negative balance and an Overpaid status. Review the difference with the client. The spreadsheet does not silently use that credit to cancel another client's unpaid invoice.

The tracker is an invoice-level list, not a bank feed or a transaction ledger. If you need a separate entry for every payment, maintain a payment log linked by invoice number and reconcile it to your bank or payment processor.

How to organize invoice PDFs

Keep the original invoice PDF in a folder for its year and month. A filename such as 2026-10_INV-1001_Example-Studio.pdf makes the date, number and client easy to search. Keep the number consistent across your tracker, PDF and payment references.

Use a stable file location, then record the filename or a location you control in Notes. A spreadsheet status does not replace the invoice document, a receipt or evidence of a payment. Keep those records together and back up your tracker regularly.

You can use a private folder on your computer or a cloud storage service you choose. Check access permissions before sharing a workbook with a bookkeeper, because it may contain client names and financial details. Record-retention and tax rules depend on your location and business, so confirm the requirements that apply to you rather than using a universal retention period.

A weekly invoice review that takes the guesswork out

• Match incoming payments to invoice numbers and confirm they have arrived.
• Update cumulative payments and review outstanding balances.
• Filter Overdue invoices and check whether there is a dispute or a missing document before sending a reminder.
• Record the next follow-up date and any agreed action without overwriting the original due date.
• Save a backup of the tracker and keep the invoice PDFs available.

A simple reminder you can adapt

Hi [Client name], I am following up on invoice [Number], due on [Date]. The remaining balance is [Amount and currency]. Could you confirm when payment is expected? If it has already been sent, please share the payment reference so I can check my records. Thank you, [Your name].

Check the balance and payment details before sending. The spreadsheet does not send messages, schedule follow-ups or collect money.

Using the tracker with CatInvoice

Create a free invoice PDF in CatInvoice, review it and send it to the client yourself. Then record that invoice in the spreadsheet. CatInvoice's saved invoice records stay in your browser; the spreadsheet is a separate file and does not sync with them.

Export a JSON backup from Saved invoices to protect those browser records. Keep that backup separate from the Excel tracker: they are different formats and one does not import the other. Downloaded PDFs are useful for sending and record keeping, while the backup preserves data that can be restored in CatInvoice.

For a more detailed starting checklist, read how to make an invoice. For deposits and agreed deadlines, read the freelance payment-terms guide.

Invoice tracking questions

What is the simplest way to keep track of invoices?

For a small list, use one spreadsheet row per invoice, record actual payments and review unpaid balances weekly. Keep the original PDFs and a backup. If several people edit records at once or you need bank reconciliation, choose a system that supports those workflows.

Can I track invoices in Google Sheets?

Yes. Download the Excel template, then use File → Import → Upload in Google Sheets to create a new spreadsheet from it. Check imported dates, formulas and filters before entering real records. Google's import instructions explain the options.

Does an unpaid invoice count as received money?

No. In this tracker, Invoiced is the amount you billed and Paid is what you have actually received. Outstanding is what remains unpaid. This is an operational payment list, not a statement of how your business should recognize revenue for accounting or tax.

Why does the date or overdue status not update?

The As of cell uses TODAY(), so the result changes when the spreadsheet recalculates. In Excel, check that calculation is set to Automatic. You can deliberately replace the formula with a fixed date when you need a dated snapshot.