Home›Templates›Google Sheets›Freelancer Invoice Tracker - Google Sheets Template
sheets_rtl Google Sheets

Freelancer Invoice Tracker - Google Sheets Template

★★★★★NewBe the first to review
30.000₫

One-time payment · Yours forever

How delivery works: Complete your payment - we'll send your Google Sheets link within 24 hours.

  • FormatGoogle Sheets
  • Tabs3 tabs included
  • Formulas18 pre-built
  • Sample dataPre-filled, easy to clear
  • UpdatesFree for life

Built and tested in Google Sheets (free). Works in any browser - no Excel required.

e09e7d997890cea3254e11cfcd8b7f96

Want to see more? Request additional screenshots

What's it does

Built for freelancers who hate chasing invoices

Most invoice spreadsheets start clean and go messy fast. This one doesn't. Every row is an invoice: client, amount, due date, status. Totals and overdue counts update automatically as you mark invoices paid.

The formula tab shows every calculation in plain language so you understand what's happening — no black-box functions, no locked cells.

Sample data comes pre-filled so you can see exactly how the tracker works before you clear it and make it yours. Takes about five minutes to set up for real.

  • Auto-calculates total billed, total paid, and outstanding balance
  • Flags overdue invoices automatically based on due date
  • Tracks multiple clients in one sheet with per-client subtotals
  • Currency-agnostic — works in any currency, any locale
  • Monthly income summary tab for tax time
  • No scripts, no add-ons, no Google Workspace plan needed

Who It's For

Made for independent workers

laptop_chromebook
Freelance developers & designers

You send 5–30 invoices a month across several clients and need to know at a glance what's paid and what's overdue.

edit
Consultants & Coaches

You bill by project or retainer, want a clean paper trail, and don't need a full invoicing app with a monthly fee.

camera_enhance
Photographers & creatives

You invoice for gigs, events, and packages. You want something simple that doesn't make tax season a nightmare.

workspace_premium
Solo operators & side hustlers

You run a lean operation and need to track money in without paying for software you'll only use once a week.

info

Not the right fit if you need to generate and send invoice PDFs directly from your tracker - this is a tracking tool, not an invoice generator.

what's Included

3 tabs, ready on day one

Invoice Log

One row per invoice. Client name, invoice number, issue date, due date, amount, and payment status. Conditional formatting highlights overdue rows automatically.

Monthly Summary

Pulls from the Invoice Log to show total billed, collected, and outstanding per calendar month. Print this for your accountant at tax time.

Formula Reference

Every formula used in the template documented in plain English. Understand what's happening before you edit anything. 18 formulas total.

Frequently asked

Good questions, real answers

  • After we confirm your payment, we'll send a Google Drive link to your email within 24 hours. Click the link, choose File → Make a copy and it lands in your own Drive. You own it permanently — no subscription, no expiry.

  • The template is built and tested in Google Sheets. You can export it to Excel (.xlsx), but some formatting and Google-specific formulas — like ARRAYFORMULA and conditional date rules — may not transfer perfectly. For the best experience, use Google Sheets (free with any Google account).

  • Because digital files are delivered after purchase, we don't offer refunds. If anything in your file doesn't work as described - a broken formula, a missing tab - contact us and we'll fix it same day.