Freelancer Invoice Tracker in Google Sheets – Find Your REAL Hourly Rate (Free Template)

You think you earn €40 an hour. This Google Sheets system shows what you REALLY earn per client – and who still owes you money. 👉 FREE TEMPLATE with example data (see how it works): https://docs.google.com/spreadsheets/... 👉 FREE BLANK TEMPLATE (start with your own clients): https://docs.google.com/spreadsheets/... What the template does: ✅ Finds work you forgot to invoice (unbilled hours) ✅ Invoice status: due, overdue, part paid, paid ✅ Reminder emails in one click – friendly, firm, final notice ✅ Your REAL hourly rate per client, including unpaid revisions and calls ✅ Client grades A–D and a plain-words verdict ✅ Predicts WHEN you will actually get paid ✅ Cash forecast for 30 / 60 / 90 days ✅ Fixed-price budget warning ✅ Retainers, multiple currencies, VAT & EU reverse charge ✅ Printable invoice → PDF in 10 seconds ✅ Works in Google Sheets and Excel – no scripts, no add-ons Series: Google Sheets PRO – 7 Real Problems, 7 Working Systems Project 2 of 7. Next: Sales Pipeline. Chapters: 0:00 He thinks he earns €40 an hour 0:17 The freelancer chaos 0:39 The dashboard reveal 1:00 Free template – what we build 1:18 Settings 1:40 Clients 2:02 Work log – log every hour 2:25 Billable: Yes, No or Retainer 2:43 Unbilled work finder 3:05 Create an invoice 3:24 Link hours to the invoice 3:44 Fixed price, retainers, VAT & reverse charge 4:05 Printable invoice → PDF 4:27 Payments & part payments 4:45 Invoice status 5:02 Reminder email in one click 5:22 Friendly → firm → final notice 5:43 The real hourly rate 6:07 €40 became €17.14 6:27 Client grades A–D 6:50 What to do with a grade D client 7:06 When will you really get paid? 7:26 Cash forecast & overdue by age 7:44 Fixed-price projects 8:05 Budget burn warning 8:25 Retainers 8:43 Multiple currencies 9:03 Dashboard: goal & tax 9:24 Dashboard: best & worst clients 9:44 Designers, translators, developers 10:05 Photographers, trades, tutors 10:24 Let's try to break it 10:49 The weekly routine 11:08 Free template & next episode #googlesheets #freelancer #invoice #freetemplate #smallbusiness