Freelancer Income Tracker Spreadsheet | Bookkeeping Template for Excel and Google Sheets | P&L Dashboard, Tax Calculator and Expense Log
Stop guessing what you actually earned this month.
The Freelancer Income & Expense Tracker is a done-for-you bookkeeping spreadsheet for freelancers, contractors, and side-hustlers. Log invoices and expenses once — the monthly P&L dashboard, tax reserve calculator, and charts update themselves.
WHAT YOU GET
- Freelancer Income & Expense Tracker (.xlsx) — instant download
- 5 connected sheets: README Start Here, Invoice Log, Expense Log, Tax Reserve, Monthly P&L Dashboard
- Invoice Log: 100 pre-formatted rows — client, invoice #, dates, amount, Sent / Paid / Overdue dropdown with automatic color-coding
- Expense Log: 200 pre-formatted rows — date, 10-category dropdown, vendor, amount, tax-deductible Y/N flag
- Tax Reserve Calculator: enter your tax rate and get your exact set-aside number, computed from live year-to-date profit
- Monthly P&L Dashboard: pick any month for instant income / expenses / net profit, outstanding-invoices total, income-by-client and expenses-by-category breakdowns, plus a monthly profit bar chart and an expense pie chart
- Realistic sample data pre-filled (clearly marked yellow, deletes in seconds) so every number is live on first open
- 2-page quick-start guide (PDF): 5-minute setup, how to log invoices & expenses, how the tax reserve works, Google Sheets import steps
- Works in Microsoft Excel AND Google Sheets — every formula carries over on import
HOW IT WORKS
- 1. Purchase this listing
- 2. Download your files instantly from the download links in your order confirmation email
- 3. Open in Excel, or import into Google Sheets (File → Import, 30 seconds) — then just start logging
PLEASE NOTE
- This is a DIGITAL product — no physical item will be shipped
- You need Microsoft Excel (desktop, web, or mobile) or a free Google account for Google Sheets
- Currency is shown in USD ($); the format takes seconds to change to your own currency
TERMS OF USE
- For personal use only
- Do not share, resell, redistribute, or claim as your own
This tracker organizes your numbers — it is not tax advice. For tax decisions, talk to a qualified professional in your country.
Questions? Send me a message — I'm happy to help.
Frequently asked questions
Is this a physical product?
No — this is a digital spreadsheet file, delivered instantly. Nothing is shipped.
What do I need to use it?
Google Sheets (free) or Microsoft Excel.
How do I access my file?
Download links are in your order confirmation email, right after purchase.
Can I use it on my phone or tablet?
Yes — Google Sheets and Excel both have free mobile apps.