Freelance Rate Calculator and Income Tracker | Hourly Rate, Day Rate, Invoice Tracker | Excel & Google Sheets Template for Freelancers

Stop guessing what to charge. Know your real hourly rate in 10 minutes, then track every invoice against it.

Most freelancers set their rate by copying someone else's or picking a number that "feels right", then wonder why they're busy but broke. This spreadsheet does the maths properly. It works backwards from the income you actually want to take home, accounting for tax, business costs, holidays and the hours you can't bill.

━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE
━━━━━━━━━━━━━━━━━━

• COVER
Add your business name and it appears at the top of every tab. Clickable contents take you straight to each section.

• RATE CALCULATOR
Enter your take-home goal, tax rate, time off and how much of your week is billable. You instantly get:
→ Your minimum hourly rate (never go below this)
→ Your recommended hourly, day and weekly rates
→ Your monthly revenue target
→ A project price helper with built-in contingency for scope creep

• INCOME TRACKER
Log every invoice with client, amount and payment terms. The due date is worked out for you. Pick Paid, Unpaid or Overdue from the dropdown. Unpaid invoices turn red automatically once they pass their due date, with a days-overdue count, so you always know who to chase.

• DASHBOARD
Month-by-month invoiced vs paid vs target, with a chart. See at a glance whether you're on track, how much is outstanding and how much is overdue.

• EXPENSES
List your business costs (software, equipment, insurance, accountant and so on). They feed straight into your rate, so your price covers them.

• START HERE
Simple setup instructions and a colour key. Yellow cells are yours to fill in; everything else calculates itself.

━━━━━━━━━━━━━━━━━━
WHY YOU'LL LIKE IT
━━━━━━━━━━━━━━━━━━

✓ Set up in about 10 minutes, with no spreadsheet skills needed
✓ Works in Microsoft Excel, Google Sheets and Apple Numbers
✓ Works in any currency
✓ Just fill in the yellow cells: everything else calculates itself
✓ Dropdowns and date checks stop typos breaking your totals
✓ Use it every year: just change the year on the dashboard

━━━━━━━━━━━━━━━━━━
PERFECT FOR
━━━━━━━━━━━━━━━━━━

Designers, developers, writers, copywriters, photographers, VAs, consultants, coaches, tutors and anyone going freelance or raising their rates.

━━━━━━━━━━━━━━━━━━
WHAT YOU GET
━━━━━━━━━━━━━━━━━━

• 1 Excel file (.xlsx), which you can open in Excel or Numbers, or upload to Google Drive and open with Google Sheets
• Instant digital download. Nothing physical will be posted.

━━━━━━━━━━━━━━━━━━
GOOD TO KNOW
━━━━━━━━━━━━━━━━━━

The tax rate is a single estimate you enter yourself, so the calculator works in any country. It's a planning tool, not tax or financial advice. Check your local tax rules or ask an accountant.

Because this is a digital download, refunds aren't available once the file has been downloaded. But if anything isn't working, message me and I'll help you sort it out.

Folio & Fox · Smart spreadsheets, templates & printables