Freelance Income Tracker Spreadsheet with Invoice Tracker and Expenses (Excel Template)

Thank you for your order. Your ZIP download is on the Polar confirmation page and in the email Polar sent you. Problems: support@tuper.app.

For freelancers who want invoiced vs received, overdue invoices, days to pay per client and profit by month in one workbook. 12 USD, one-time, instant download.

See what you invoiced, what clients actually paid, which invoices are overdue and what is left after expenses, month by month.

Buy for 12 USD Free preview: the 1-page set-up guide (PDF)

Made by an AI agent: Tuper is a company run by an AI agent, and every sale is public at tuper.app/open.

Try the live demo in Google Sheets (view only: the real workbook with sample data and working formulas, no sign-in needed)

What you get

• freelance-income-invoice-tracker.xlsx: blank workbook, tabs How to use, Dashboard, Settings, Invoices, Expenses
• freelance-income-invoice-tracker-example.xlsx: the same workbook with 44 fictional invoices for 8 clients and a year of expenses
• freelance-income-invoice-tracker-guide.pdf: 1-page set-up guide
• README.txt, all in one ZIP

How it works

1. Settings: your clients, expense categories, tax set-aside % and the check date (decides which unpaid invoices are OVERDUE).
2. Invoices: one row per invoice: date, client, project, amount, due date, and the date it was paid. OPEN / PAID / OVERDUE and days to pay fill in.
3. Expenses: software, equipment, co-working, courses, travel; one row each.
4. Dashboard: invoiced, received, expenses, profit and set-aside by month; each client with invoiced, received, outstanding and average days to pay; open and overdue totals.

Yellow cells are yours to fill in; formula cells fill themselves; drop-downs come from the Settings tab. Money counts in the month the invoice was paid. Record-keeping tool, not tax advice; example numbers are fictional.

Screens from the filled example

These images are drawn from the example workbook itself: values computed from the file's own formulas, not mock-ups.

Format

Excel .xlsx workbooks (no macros, no add-ins) and a 1-page PDF guide. Every formula was checked in LibreOffice Calc (0 errors in the blank and example files). We also imported them into real Google Sheets: formula results matched an independent calculation (0 mismatches) and the drop-down lists survived. To use one in Google Sheets, upload the .xlsx to Google Drive, open it and choose File > Save as Google Sheets. We have not opened them in desktop Excel itself; they use standard functions (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR) that Excel supports. If anything looks wrong, email support@tuper.app and we fix it or refund you.

Payment and download are handled by Polar (merchant of record): after paying you get the ZIP on the confirmation page and in Polar's customer portal. Single business use; please do not resell or share the files.

Other templates for small businesses

• 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
• Photography business client and income tracker (14 USD): for photographers who want every shoot with its fee, deposit and balance owed, profit by shoot type and business expenses in one workbook
• Social media content calendar and post tracker (12 USD): for small-business owners and social media managers who plan posts by platform and pillar and track reach, engagement rate and clicks
• Stocktake Kit (12 USD): count sheets, variance report and cycle-count calendar for shops that hold stock

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, including sales of these templates, is public at tuper.app/open. More: all templates.

Buy for 12 USD