How to Track Freelance Income and Expenses in Google Sheets

Busy all month, broke at month-end

Kiran is a freelance video editor in Kochi. June was his busiest month ever — 25 working days, five clients, invoices totalling ₹95,000. On July 1st he checked his bank balance: ₹11,400. He stared at the screen, genuinely confused. Where had it gone?

Software renewals he forgot about. A new microphone. Fuel for client visits. Eating out between shoots because he was too tired to cook. None of it felt like spending at the time. Kiran didn't have an income problem. He had an expense problem he couldn't see.

If you don't track income and expenses, you don't know whether you're profitable — you only know your bank balance. This tracker takes 10 minutes to set up and 10 minutes a week to maintain, and it answers the one question that matters: how much of what you earned did you actually keep?

(If you haven't set your rates yet, start with our guide to pricing freelance work — tracking only helps once the numbers coming in are right.)

In this guide

• Sheet 1: Income — what actually landed
• Sheet 2: Expenses — where it leaked
• Sheet 3: The monthly summary
• A worked example: ₹95,000 earned, how much kept?
• Weekly vs monthly tracking
• Your Friday 10-minute routine
• 5 tracking mistakes that hide your real profit
• Frequently asked questions

Sheet 1: Income — what actually landed

Create a tab called Income with these columns:

• A: Date (payment received, not invoice sent)
• B: Client
• C: Project
• D: Invoice No (link it to your invoice tracker sheet)
• E: Amount Received
• F: Payment Method (UPI / Bank / PayPal)
• G: Notes

Record money when it lands in your account, not when you invoice. An invoice is a hope; a payment is income. This one distinction fixes most "but I earned so much" confusion.

At the bottom, add your monthly total: =SUM(E2:E100) (adjust the range to your data).

Sheet 2: Expenses — where it leaked

Create a tab called Expenses with these columns:

• A: Date
• B: Category (Internet / Tools / Travel / Software / Food / Other)
• C: Description
• D: Amount
• E: Receipt? (Yes / No)

Categories are the whole point. A single "expenses" column tells you nothing; categories show you patterns. Kiran's "eating out between shoots" only became visible once it had its own category — ₹8,500 in one month.

Record expenses the day they happen, even small ones. A ₹200 auto ride you forget is a ₹200 hole in your profit math. Cash expenses especially: record them the same day or they're gone from memory by Friday.

Sheet 3: The monthly summary

Create a third tab called Summary. This is the one you'll actually look at. Four lines:

• Total Income (month): =SUM(Income!E2:E100)
• Total Expenses (month): =SUM(Expenses!D2:D100)
• Profit: Income − Expenses
• Tax to set aside: a fixed percentage of profit, moved to a separate savings account (ask your CA what percentage fits your situation — don't guess this)

Profit is the only number that tells you if freelancing is working. Revenue is vanity; profit is reality. If profit is thin three months in a row, you have a pricing problem, a spending problem, or both — and now you have the data to know which.

A worked example: ₹95,000 earned, how much kept?

Worked example — Kiran's June (illustrative numbers):

Expense category	Amount
Software subscriptions	₹6,500
Internet	₹1,200
Fuel and travel	₹9,000
Equipment (microphone)	₹14,000
Eating out between shoots	₹8,500
Phone	₹800
Miscellaneous	₹18,000
Total expenses	₹58,000

Now the summary math:

Measure	Amount
Total income	₹95,000
Total expenses	− ₹58,000
Profit	₹37,000
Tax set aside (10% of profit, example)	− ₹3,700
Actually kept	₹33,700

He thought he earned ₹95,000. He kept ₹33,700 — and now he knows exactly where the rest went. That visibility is the product. Next month, the miscellaneous column gets interrogated, the food spending gets a packed lunch, and the three unused subscriptions get cancelled.

Weekly vs monthly tracking

	Weekly (10 min Friday)	Monthly (one big session)
Time per month	~40 minutes	~2–3 hours
Missing receipts	Caught within days	Forgotten
Cash expenses	Recorded same week	Often missed entirely
Overdue invoices spotted	Early	A month late
How it feels	Light routine	Painful chore

Weekly beats monthly every time. The data is fresher, the session is shorter, and problems get caught while they're still small. Nobody has ever said "I'm glad I waited a month to check my money."

Your Friday 10-minute routine

Same slot every week — Friday afternoon works for most freelancers:

• ☐ Add all payments received this week to the Income tab
• ☐ Add all expenses to the Expenses tab (check your UPI/bank app for ones you forgot)
• ☐ Mark any missing receipts in the Receipt column
• ☐ Glance at the Summary: profit on track, or drifting?
• ☐ Move your tax percentage to a separate savings account

Ten minutes, once a week, and you always know exactly where you stand. That feeling — opening the Summary tab and seeing the truth — is worth more than any budgeting app.

5 tracking mistakes that hide your real profit

1. Mixing personal and business money in one sheet. Even if it's the same bank account, keep separate tabs. Mixed records make tax time miserable and hide your real business profit.

2. Recording invoices as income. Income is money received. An unpaid invoice is not income — it's a hope with a due date. (Track invoices separately with an invoice tracker.)

3. Tracking only when you "feel like it." Motivation-based tracking dies in week two. Schedule-based tracking (Friday, 10 minutes) survives.

4. A "misc" category with no limit. If miscellaneous is your biggest category, it's not miscellaneous — it's unexamined spending. Break it down.

5. Ignoring small cash expenses. Five forgotten ₹200 expenses a week is ₹4,000 a month — more than most software subscriptions. Small leaks sink the number.

Frequently asked questions

Do I need accounting software instead of Sheets? Not at the start. Sheets is fine until you have high transaction volume or GST filing requirements. When your CA starts asking for proper reports, that's the signal to upgrade — talk to them first.

How do I handle cash payments? Record them the same day, with a note saying "cash." Cash forgotten is profit forgotten. If a client pays partly in cash, record both parts separately.

Should I open a separate bank account for freelancing? It helps a lot — it makes the Income tab nearly automatic and keeps personal spending out of your business math. Not mandatory on day one, but strongly worth doing once income is regular.

What percentage should I set aside for tax? Ask your CA — it depends on your income slab, registration, and location. The important part is setting aside something every month, not getting the percentage perfect on day one.

What if my profit is negative this month? That's exactly what the tracker is for — it told you early. Check whether it's a one-off (equipment purchase) or a pattern (spending creep, underpricing). One bad month is data; three is a decision.

---

This post is educational information, not tax or accounting advice. Tax rules vary by location and situation — check with your CA.