An invoice tracking spreadsheet is a simple, customizable tool for recording when you send invoices, when they are due, and when you receive payment. You can build one in under an hour using basic spreadsheet software, and it gives you a clear view of your cash flow without paying for accounting software.
Why Use a Spreadsheet Instead of Software
Many small business owners, freelancers, and contractors start with a spreadsheet because it is free, flexible, and requires no learning curve. Unlike invoicing software, a spreadsheet lets you add exactly the columns you need and change them anytime. You can track not just invoices but also client contact info, project names, payment methods, and notes. If you already use Excel, Google Sheets, or LibreOffice Calc, you can start immediately without a subscription or an internet connection (except for Google Sheets).
The main drawback is that a spreadsheet does not automate reminders, send payment links, or generate reports for you. You have to update it manually and check it regularly. But for a small volume of invoices (say, under 50 per month), a well-organized spreadsheet can be more efficient than paying for software you do not fully use.
Key Columns Every Tracker Should Have
At a minimum, your invoice tracker should include these columns:
- Invoice number – a unique identifier for each invoice
- Client name – who you billed
- Invoice date – the date you issued the invoice
- Due date – when payment is expected (often 30 days after invoice date)
- Amount – the total due, including tax
- Status – e.g., Sent, Paid, Overdue, Partial
- Payment date – when you actually received the money
- Payment method – check, bank transfer, PayPal, etc.
- Notes – any relevant details, like a purchase order number or a promise to pay on a specific date
You can add more columns later, such as “Amount paid” for partial payments, “Tax rate” for different jurisdictions, or “Reminder sent” to track your follow-ups. The goal is to keep all the information you need to answer the question, “What is outstanding right now?”
How to Set Up a Simple Tracker in 5 Steps
- Open a new spreadsheet and name it “Invoice Tracker.” Create a second sheet called “Clients” if you want to store client addresses and contact info separately.
- Add the column headers listed above in row 1. Freeze the top row so you can scroll without losing the headers.
- Format the Amount column as currency. Format the Date columns as dates (e.g., YYYY-MM-DD) so you can sort and filter correctly.
- Add a few sample rows to test your setup. Enter a fake invoice with a date, due date, and amount to see if the formatting looks right.
- Create a summary area at the top or on a separate sheet. Use formulas like
=SUMIF(Status, "Unpaid", Amount)to show total outstanding. You can also use conditional formatting to highlight overdue rows in red.
Once you have the basic structure, you can add filters (Data > Create a filter in Google Sheets) to quickly view only unpaid invoices or only a specific client.
Common Problems and How to Avoid Them
The biggest issue with a manual tracker is forgetting to update it. If you do not record a payment the day it arrives, you will lose track of what is actually owed. To avoid this, set a weekly reminder to review the tracker and reconcile it with your bank account.
Another common problem is duplicate invoice numbers. If you reuse a number, you will confuse yourself and your client. Always start a new invoice with the next sequential number, and if you void an invoice, keep the row but mark it “Void” so the number is not reused.
Spreadsheets also have a limit on rows (about 1 million), but that is rarely an issue for a small business. A more practical limit is your own patience – if you find yourself spending more than 30 minutes a week on the tracker, consider moving to invoicing software.
Template: Blank Invoice Tracker
| Invoice # | Client | Invoice Date | Due Date | Amount | Status | Payment Date | Payment Method | Notes |
|---|---|---|---|---|---|---|---|---|
Sample row: 2024-001 | Acme Corp | 2024-03-01 | 2024-03-31 | $1,250.00 | Unpaid | | | PO #12345
Copy the table above into your spreadsheet. Replace the sample row with your own data. The blank rows are ready for your first real invoices.
How to Choose Between Spreadsheet and Invoicing Software
If you send fewer than 10 invoices per month and your clients pay within 30 days, a spreadsheet is probably enough. If you have recurring invoices, automatic payment reminders, or international clients with different currencies, software will save you time. Software also gives you a professional-looking invoice template with your logo, while a spreadsheet is just for tracking – you still need to create the actual invoice separately (e.g., in a word processor or PDF).
Some freelancers use a hybrid: they create invoices in a word processor or PDF, then log them in the spreadsheet. That works well and gives you the best of both worlds.
Costs and Alternatives
A spreadsheet tracker costs nothing if you already have spreadsheet software. Google Sheets is free, and Microsoft Excel is part of Office 365 (about $10 per month). There are also free online invoicing tools with limited features, but they often watermark your invoices or restrict the number of clients. Paid invoicing software typically starts around $15–$20 per month, which may be worth it if you value automation.
Other alternatives include paper ledgers (rarely recommended for tax purposes), accounting software with full double-entry bookkeeping, or using your bank’s online invoicing feature if it offers one. For most freelancers, a spreadsheet is the most cost-effective starting point.
Frequently Asked Questions
Can I track partial payments in a spreadsheet?
Yes. Add a column for “Amount Paid” and a column for “Remaining Balance.” Use a formula like =Amount - Amount Paid to calculate the balance automatically. Update the “Amount Paid” column whenever you receive a partial payment, and change the status to “Partial” until the balance is zero.
How do I calculate overdue invoices in my tracker?
Add a column called “Days Overdue” and use a formula like =IF(AND(Status="Unpaid", DueDate
Should I include taxes in the invoice amount column?
Yes, the “Amount” column should be the total amount the client owes, including any sales tax or VAT. If you need to track tax separately for your own filings, add a separate “Tax” column and a “Subtotal” column. The “Amount” column should equal Subtotal + Tax.
Can I use a spreadsheet for recurring invoices?
You can, but you will need to create a new row for each invoice. Some spreadsheet programs allow you to duplicate a row easily, but there is no automatic scheduling. If you have many recurring invoices, consider software that generates them automatically on a schedule.
Is a spreadsheet secure enough for my financial data?
It depends on how you store it. If you keep the file on your computer with a strong password and back it up regularly, it is reasonably secure. If you use Google Sheets, enable two-factor authentication on your Google account. Avoid sending the spreadsheet via email or storing it on a shared drive without protection. For sensitive data, consider using encryption or a password-protected file.
What if I have a lot of invoices – will the spreadsheet slow down?
Spreadsheets handle thousands of rows without issue, but very large files (over 100,000 rows) may become sluggish. If you have more than a few thousand invoices, you are likely better off with database-based software. For most small businesses, a spreadsheet will be fine.