Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Outstanding (all invoices) | 8,570.00 | Invoiced this year |
|---|---|---|
| Overdue | 5,950.00 | Collected this year |
| Overdue invoices | 4 | Hours logged this year |
| Unbilled work | 4,500.00 | Payments with unknown invoice |
| Bucket | Amount | Invoices |
| Not yet due | 2,620.00 | 2 |
| 1-30 days overdue | 4,600.00 | 3 |
| 31-60 days overdue | 0.00 | 0 |
| 61+ days overdue | 1,350.00 | 1 |
| Total | 8,570.00 | 6 |
Example from the “Dashboard” tab, with the numbers and formulas that are in the file.
What is inside
- Dashboard: What clients owe you, the overdue amount and number of overdue invoices, unbilled work, invoiced and collected this year, and hours logged. An aging table sorts unpaid money into not yet due, 1-30, 31-60 and 61+ days overdue, and a month-by-month table feeds three charts: invoiced against collected, money owed by lateness, and outstanding by client.
- Projects: One row per project: code, name, client, Fixed price or Hourly, the fee or rate, start date and status. It adds hours logged, project value, amount invoiced, amount paid, unbilled work and the effective rate per hour. Room for 200 projects.
- Time Log: Date, project code, hours and a note for each work session, with the project name looked up for you. Room for 2,000 entries.
- Invoices: Invoice number, issue date, project and amount, with optional terms in days. It adds the client, due date, amount paid, balance, status (Paid, Part paid, Due or Overdue) and days overdue. Room for 1,000 invoices.
- Payments: Each payment with its date, the invoice it settles, amount and method. The client and project are filled in from the invoice, and a payment pointing at an unknown invoice is highlighted. Room for 1,000 payments.
- Clients: Your client list (up to 50) with, for each client, the number of projects, total invoiced, total paid, outstanding and overdue.
- Settings: Your name, the currency symbol, the as-of date, the year to report on and your usual payment terms in days.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most freelance trackers stop at a list of invoices marked paid or unpaid. This one connects the four things a freelancer actually juggles: the project, the hours, the invoice and the payment. That is why it can tell you not only who is late, but also which finished work you have not billed and which fixed-price project paid you the least per hour. The sample is a freelance designer with seven projects and nine invoices in autumn 2026, so every sheet is working before you type your own data.
How do I track freelance invoices in Excel?
Give every invoice a number, an issue date, the project it belongs to and an amount. From the issue date and your payment terms the sheet works out the due date. Each time money arrives, add a row on Payments with the invoice number it settles. The balance, status and days overdue update by themselves.
In the sample, as of 2026-11-16, there are four overdue invoices worth 5,950.00 in total. The oldest, INV-0999 for 1,350.00, is 62 days late and shows up in the 61+ days bucket of the aging table.
How do I know how much work I have not invoiced?
For an hourly project the value is hours logged times your rate. For a fixed-price project it is the agreed fee. Subtract what you have already invoiced and you have the unbilled work. The Projects sheet does this for every row and the Dashboard adds up the positive amounts.
In the sample, unbilled work comes to 4,500.00, for example 1,600.00 left on the Brand identity fee and 1,100.00 on the Landing page design. A negative figure on one project (the Monthly site support project, where 5,550.00 has been invoiced against 5,400.00 of logged time) means you have billed ahead of the hours.
How do I work out my real hourly rate on a fixed-price project?
Log your hours on fixed-price projects as well as hourly ones. The last column on Projects divides the project value by the hours, so you can compare projects. In the sample, the Website redesign paid 81.36 an hour (4,800.00 over 59 hours) while the Brand identity is at 96.97 an hour so far (3,200.00 over 33 hours).
If a fixed price is paying well under your hourly rate, that is the number to use when you quote the next similar project.
How to use it
- On Settings type your name, the currency symbol, the "as of" date (the day you are looking at the numbers), the year to report on, and your usual payment terms in days.
- On Clients list the people and companies you work for. On Projects add one row per project: code, name, client, Fixed price or Hourly, the fee or hourly rate, start date and status.
- On Time Log add a row for each work session: date, project code, hours and a short note. Log hours on fixed-price projects too: that is how you see what the project really paid per hour.
- On Invoices add each invoice you send: number, issue date, project code and amount. Leave the terms blank to use your usual payment terms, or type a number of days for that invoice.
- On Payments add each payment you receive with the invoice number it settles. If one transfer covers several invoices, add one row per invoice.
- Open Dashboard to read what clients owe you, what is overdue and by how long, work not yet invoiced, and invoiced against collected by month. Update the as-of date whenever you open the file.
Before you start:
- Hourly project value = hours logged x hourly rate. Fixed-price project value = the fee you typed; hours are logged for your own information.
- Unbilled work = project value - amount invoiced. A negative number means you have invoiced more than the work so far (a deposit, for example).
- Due date = issue date + terms. An invoice is Overdue when its due date is before the as-of date and a balance is left. Other statuses: Paid, Part paid (some money received, not yet due) and Due.
- Overdue invoices are sorted into 1-30, 31-60 and 61+ days overdue on the Dashboard.
- An invoice whose project code is not on Projects shows Unknown project, and a payment whose invoice number is not on Invoices shows Unknown invoice. Both are highlighted.
- Capacity: 200 projects, 50 clients, 2,000 time entries, 1,000 invoices and 1,000 payments. Use one currency in one workbook. This sheet does not calculate taxes; check your local rules.
Still running this on Excel?
This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.
| In this sheet | In Custom Software from Softwiro |
|---|---|
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |
Frequently asked questions
Is this freelance invoice tracker really free?
Yes. It is free to use, change and share. There is no macro and no sign-up. A blank copy without the sample data is available from the template page.
Does it create invoices?
No, it tracks them. You issue invoices in your invoicing tool or in a document, then record the number, date, project and amount here. If you need a printable invoice, see the invoice template.
Does it work in Google Sheets and LibreOffice?
Yes. It uses only common functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR), so it works in Excel 2016 or later, LibreOffice and Google Sheets.
How does it decide an invoice is overdue?
An invoice is Overdue when its due date (issue date plus terms) is before the as-of date on Settings and a balance is left. Change the as-of date whenever you open the file, because the sheet does not use today's date by itself.
Can I use it in another currency, or for taxes?
Use any currency: the symbol on Settings is only a label, and amounts are plain numbers. The sheet does not calculate taxes. Check your local rules for what you need to record and report.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
More free templates for: Services and business
More free templates
- Event Planning Checklist and Budget Template for Excel
- Fleet Fuel and Maintenance Log Template for Excel
- Ad Performance Tracker for Excel (ROAS, CPA)
- A/B Test Log Template for Excel (Experiment Tracker)
- Ecommerce Profit Margin Calculator for Excel
- Installment Payment Tracker for Excel
- Social Media Content Calendar Template for Excel
- Class Schedule Maker for Excel