Freelance Invoice Template in Google Sheets: Set It Up in 15 Minutes

The ₹25,000 invoice everyone forgot

Aisha is a freelance content writer in Hyderabad. In March, she finished articles for three clients, shared quotes on WhatsApp, and emailed invoices to two of them. The third invoice she meant to send "tomorrow." By May, she had quietly accepted it as a dead client — until the client messaged asking why she had never billed them, and paid ₹25,000 the same week.

The work was done. The money was owed. She almost gave it away because her tracking system was "I'll remember."

Most freelancers don't have a pricing problem. They have a tracking problem: no invoice numbers, no due dates, no single list of who owes what. This guide fixes that in 15 minutes with a free Google Sheets setup — one tracker sheet, one invoice sheet, and a Friday routine that takes 10 minutes.

In this guide

• Step 1: Build the invoice tracker
• Step 2: Add your monthly total formulas
• Step 3: Build the invoice sheet clients actually read
• A worked example: where your money really is
• Copy-paste follow-up email templates
• Your Friday 10-minute routine
• Spreadsheet vs paid invoicing tools
• 5 invoice mistakes that delay payment
• Frequently asked questions

Step 1: Build the invoice tracker

Create a Google Sheet and name the first tab Invoices. Set up these columns in row 1:

• A: Invoice No (INV-001, INV-002…)
• B: Client Name
• C: Date Sent
• D: Work / Project
• E: Amount
• F: Due Date
• G: Status (Sent / Paid / Overdue)
• H: Payment Method (UPI / Bank / PayPal)
• I: Notes

Now do two small things that make the sheet ten times more useful: freeze row 1 (View → Freeze → 1 row) and add a filter (Data → Create a filter). You can now sort by Status and instantly see everyone who owes you money.

Number every invoice, even for friends and repeat clients. "Invoice" without a number is a message; "INV-014" is a record you can search, sort, and follow up on.

Step 2: Add your monthly total formulas

Below your data (or at the top in a small summary block), add three formulas:

• Total invoiced: =SUM(E2:E100)
• Total paid: =SUMIF(G2:G100,"Paid",E2:E100)
• Total overdue: =SUMIF(G2:G100,"Overdue",E2:E100)

These three numbers are your real cash position. Your bank balance lies to you — it mixes last month's payments with this month's dues. The overdue total tells the truth.

If your overdue total is consistently more than 20% of what you invoiced, your problem isn't your rates — it's collection. Fix the follow-up routine before you raise prices.

Step 3: Build the invoice sheet clients actually read

Create a second tab called Invoice Template. This is the document the client sees, so keep it clean and complete:

• Your name, email, phone, and UPI/bank details
• Client name and address
• Invoice No, Date, and Due Date (always set a due date — "due on receipt" is fine)
• Line-item table: Description | Qty/Hours | Rate | Amount
• Subtotal, Tax (only if applicable to you — check with your CA), Total in bold
• Payment terms line: "Due within 7 days. Please mention the invoice number in your payment note."
• One thank-you line at the bottom

For each new invoice: File → Make a copy of the template tab, rename it INV-015, fill it in, then File → Download → PDF to send. Your tracker tab stays the master record; the PDF is what the client gets.

A worked example: where your money really is

Worked example — a freelance writer's March tracker (illustrative numbers):

Invoice	Client	Amount	Due Date	Status
INV-001	Rohan Mehta Studio	₹30,000	Mar 9	Paid
INV-002	Brightline Media	₹25,000	Mar 17	Overdue
INV-003	Kavya Nair	₹23,000	Mar 27	Paid

Apply the three formulas:

Measure	Formula result
Total invoiced	₹78,000
Total paid	₹53,000
Total overdue	₹25,000

That is 32% of the month's revenue sitting unpaid. One polite follow-up email (see the template below) usually recovers most of it within a week. Without the tracker, this freelancer wouldn't even know ₹25,000 was missing — exactly what happened to Aisha.

Copy-paste follow-up email templates

Use the first nudge 2–3 days after the due date. Use the firmer one after 10+ days. Always include the invoice number and amount — it makes paying you a one-step task.

Template 1 — the polite nudge:

Subject: Quick check-in on INV-002 (₹25,000) Hi [Name], Just checking on INV-002 for ₹25,000, which was due on [date]. Let me know if you need me to resend the invoice or if there's anything holding it up on your side. Thanks, [Your Name]

Template 2 — the firm follow-up (10+ days overdue):

Subject: Follow-up: INV-002 (₹25,000) — now [X] days overdue Hi [Name], I'm following up on INV-002 for ₹25,000, due on [date]. Could you please confirm when I can expect the payment? If there's an issue with the invoice, I'd rather sort it out now. Thanks, [Your Name]

What makes these work: they're short, specific, and assume a process problem rather than bad intent. Never threaten, never guilt-trip — you're a vendor doing routine accounts, not a friend asking a favour.

Your Friday 10-minute routine

Set a weekly reminder. Every Friday:

• ☐ Mark Paid invoices green, Overdue invoices red (conditional formatting does this automatically once set up)
• ☐ Send one follow-up for every invoice overdue more than 3 days (use the templates above)
• ☐ Add invoices for all work completed this week — never let a finished week pass unbilled
• ☐ Check the overdue total: is it growing month over month?

Ten minutes every Friday beats a panicked two-hour session at month-end. Regularity is the whole system.

Spreadsheet vs paid invoicing tools

	Google Sheets tracker	Paid invoicing software
Cost	Free	Paid subscription (check the vendor's current pricing)
Setup time	~15 minutes	~30–60 minutes
Payment reminders	Manual (your Friday routine)	Automatic emails
Recurring invoices	Manual copy	Built-in
Tax reports	Manual	Built-in
Best for	1–10 invoices a month	High volume, GST filing, teams

Start with the spreadsheet. Move to paid software when you're sending 15+ invoices a month or your CA asks for proper tax reports — not before. Most freelancers pay for features they never open.

5 invoice mistakes that delay payment

1. No invoice number. Without one, you can't track, search, or reference the invoice. Every invoice gets a number, starting at INV-001.

2. No due date. "Pay whenever" means "pay never." State a due date on every invoice — 7 days is standard for freelancers.

3. Sending the invoice late. Invoice the same week the work is done, while the value is fresh in the client's mind. Late invoices get deprioritised.

4. Mixing personal and business money in one sheet. Keep a separate tracker (or at least a separate tab) for business. Mixed records make tax time miserable.

5. Not following up. A polite reminder is normal business, not rudeness. Clients are busy, not malicious — most overdue invoices just need a nudge.

Frequently asked questions

Should I charge GST on my invoices? It depends on your registration status and where your client is located. This is a "talk to your CA" question, not a "Google it" question — getting it wrong is expensive.

What if a client wants a different invoice format? Send the PDF in whatever layout they need, but keep your tracker sheet as the master record. The sheet is for you; the PDF is for them.

Can I use Excel instead of Google Sheets? Yes. The same columns and formulas work in Excel. Sheets just makes sharing and accessing from your phone easier.

What if a client still doesn't pay after two reminders? Pause new work for that client and send a final written notice with a clear deadline. If the amount is significant, talk to your CA or a legal professional about your options — this post isn't legal advice.

How long should I keep old invoices? Keep them for at least the financial year plus the period your CA recommends for tax records. Digital copies in a dedicated Drive folder cost nothing.

---

This post is educational information, not tax or legal advice. Invoice and tax rules vary — check with your CA for your situation.