Free invoice tracker spreadsheet
An Excel .xlsx workbook that also opens in Google Sheets. Formulas done, no macros. Free direct download: no email, no sign-up.
Download the blank tracker (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)
What it does
- Marks each invoice PAID, PARTIAL, OPEN or OVERDUE from its due date and what you have received
- Shows balance and days overdue per invoice
- Monthly invoiced vs collected, and what each client owes you now
- Ageing table: not yet due, 1-30, 31-60 and over 60 days overdue
- 500 invoice rows and 15 clients
How to track invoices with it
- Download the blank workbook below (or the filled example first, to see it work).
- Settings tab: type your clients (up to 15) and the year. The check date is TODAY() in the blank file, so overdue invoices update by themselves.
- Invoices tab: one row per invoice with number, client, description, invoice date, due date and amount.
- When a payment arrives, type the date and the amount received. Partial payments work: type the running total.
- Open the Dashboard tab: invoiced and collected by month, what each client owes, and an ageing table (not yet due, 1-30, 31-60, over 60 days overdue).
Use it in Google Sheets
Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.
The images are drawn from the example workbook itself: values computed from the file's own formulas. Example clients and amounts are fictional.
How we checked it
Every formula was evaluated by a second spreadsheet engine with 0 errors, and the example's totals (invoiced, received, outstanding) match an independent sum. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, COUNTIF, IFERROR) that Excel supports. If something is wrong, email support@tuper.app.
Need more than an invoice list?
This free tracker covers invoices only. The paid templates add expenses, tax categories, jobs and clients, with the same formulas-done approach:
- Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook
- Contractor job cost tracker (16 USD): for small remodelers, handymen and trades running 3 to 30 jobs who want job costs, margin and invoices in one workbook
- Lawn care business tracker (14 USD): for lawn care and landscaping operators who track customers, visits, invoices and expenses
All 24 templates in one download: 49 USD
Instead of 321 USD one by one. See the bundle or browse all templates.
14 more free spreadsheets
- Free Airbnb income and expense spreadsheet
- Free cleaning business spreadsheet
- Free dog walking spreadsheet
- Free Etsy profit calculator spreadsheet
- Free food truck spreadsheet
- Free job costing spreadsheet
- Free lawn care spreadsheet
- Free mileage log spreadsheet
- Free personal trainer spreadsheet
- Free pet sitting spreadsheet
- Free recipe costing spreadsheet
- Free rental property spreadsheet
- Free Schedule C spreadsheet
- Free wedding budget spreadsheet
Who made this
Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.