An invoice tracking sheet is a simple tool—typically a spreadsheet—that records every invoice you send and receive, along with its status, due date, and payment date. It gives you a single place to see who owes you money, what you owe others, and which payments are late.
Why You Need One
If you send or receive more than a handful of invoices each month, your memory and email inbox are not reliable enough. Invoices get lost, payment terms are forgotten, and late payments slip through. A tracking sheet prevents that by turning scattered information into one clear list.
For freelancers and small businesses, the main benefit is cash flow visibility. You can see at a glance how much money is coming in and when. For accounts payable, it helps you avoid late fees and keep supplier relationships healthy.
What to Track
A good invoice tracking sheet includes fields for the essential details. Here are the core columns to include:
- Invoice number – your own or the vendor’s
- Client or vendor name
- Issue date
- Due date
- Amount
- Status – e.g., sent, paid, overdue, partial
- Payment date
- Payment method – check, bank transfer, credit card, etc.
- Notes – for any follow-up or special terms
You can add more columns for tax rates, purchase order numbers, or project codes, but the above list covers the essentials.
How to Set One Up
You can use any spreadsheet program—Excel, Google Sheets, or LibreOffice—to create your own. Here is a step-by-step approach:
- Create a new spreadsheet with the column headers listed above.
- Freeze the top row so the headers stay visible when you scroll.
- Add data validation to the Status column to keep entries consistent (e.g., a dropdown list with “Sent,” “Paid,” “Overdue”).
- Set up conditional formatting to highlight overdue invoices in red or paid ones in green.
- Add a summary section at the top or in a separate tab to show totals: outstanding amount, paid this month, and overdue amount.
This basic setup takes about 15 minutes and works for most small businesses.
Common Mistakes and How to Avoid Them
Even with a tracking sheet, people make errors. Here are the most frequent ones and how to prevent them:
- Not updating it regularly – set a recurring reminder to update the sheet every day or every Friday.
- Inconsistent status names – use a dropdown list so everyone uses the same terms.
- Forgetting to record credit notes or refunds – add a separate column or a negative amount row to keep totals accurate.
- Mixing sent and received invoices in one sheet – use separate tabs or separate columns for clarity.
- Ignoring overdue invoices – use conditional formatting to make them stand out, and schedule follow-up emails.
Spreadsheet vs. Software
Spreadsheets are flexible and free, but they require manual entry and are prone to human error. Accounting software like QuickBooks or Xero can automate invoicing, send reminders, and generate reports. However, those tools have a learning curve and a monthly cost.
If you are just starting out or have a low volume of invoices, a spreadsheet is sufficient. As you grow, you might outgrow it. A good middle ground is to use a free template from a site like Vertex42 or Smartsheet, or to use a simple cloud-based tool like Wave (free for basic invoicing).
Template
| Invoice # | Client/Vendor | Issue Date | Due Date | Amount | Status | Payment Date | Payment Method | Notes |
|---|---|---|---|---|---|---|---|---|
Sample (fictional): INV-2024-001, Acme Corp, 2024-05-01, 2024-05-15, $1,250.00, Sent, , , Net 15 terms.
You can copy this table into your spreadsheet and add as many rows as needed.
Frequently Asked Questions
How do I track invoice statuses?
Set up a Status column with a dropdown list containing options like “Draft,” “Sent,” “Paid,” “Overdue,” and “Partial.” Update it manually when you send an invoice or receive payment. You can also use conditional formatting to color-code the statuses.
What if I have many invoices?
If you have hundreds of invoices, a spreadsheet becomes unwieldy. Consider using accounting software that can import and export data, or at least use pivot tables to summarize the information. You can also split the sheet by year or by client.
Can I use a spreadsheet for both sent and received invoices?
Yes, but it is better to use separate tabs or separate columns to avoid confusion. For example, you could have one tab for “Accounts Receivable” and another for “Accounts Payable.” This keeps totals accurate and simplifies reporting.
How do I calculate overdue days?
Add a column called “Days Overdue” and use a formula like =IF(TODAY()>DueDate, TODAY()-DueDate, 0). This will show the number of days an invoice is past due. You can then sort by that column to prioritize follow-ups.
What should I do if a client never pays?
First, send a polite reminder. If that fails, check your contract for late payment terms and consider sending a formal demand letter. For significant amounts, you may need to consult a collection agency or a lawyer. This is not legal advice—for specific situations, please ask a qualified professional.
Final Thoughts
An invoice tracking sheet is a small investment of time that pays off in reduced stress and better cash flow. Start with a simple spreadsheet, keep it updated, and you will always know where your money is.