How I Track My Monthly Spending With Google Sheets (+ FREE TEMPLATE)

TL;DR: I track my monthly spending in Google Sheets because it is simple, free, private enough for my workflow, and fully customisable. My template has 5 sheets: Dashboard, Income, Expenses, Worth, and Fixed Expenses. You can use it as a free expense tracker, monthly budget tracker, and basic net worth tracker without paying for another finance app.

Quick note: This is not financial advice. It is simply the spending tracker I use personally. The goal is awareness first, optimisation later.

I started tracking my monthly spending properly after one awkward accountant conversation.

He asked me a simple question: how much did I spend on business expenses last month?

I had no clean answer.

I had expenses in UPI apps, card statements, email receipts, bank messages, hosting invoices, subscription renewals, and random notes. I knew I was earning. I knew money was going out. But I did not know the pattern properly.

That is a bad place to be, especially if you run small online projects, use multiple cards, pay for software, and want to understand where your money actually goes.

I tried expense tracking apps. Some were good, but I always stopped using them after a few weeks. Either the app was too cluttered, the useful features were paid, or I did not like putting every small financial detail into another app I may stop trusting later.

So I built a basic system in Google Sheets.

Not beautiful. Not fancy. Just practical.

And that is exactly why it stuck.

Why I use Google Sheets instead of an expense tracking app

Short answer: because Google Sheets gives me control.

I am not against expense tracking apps. If an app helps you stay consistent, use it. But for me, most apps created more friction than clarity.

The common problems were simple:

• Too many premium prompts for simple reports.
• Categories that did not match my real life.
• Limited export options.
• Data locked inside someone else’s product.
• Bank syncing that looked convenient but made me lazy.

Google Sheets solved most of that for me.

• It is free – no subscription just to track my own money.
• It is flexible – I can add, delete, rename, or split categories any time.
• It works everywhere – phone, laptop, tablet, browser, or app.
• It is easy to export – CSV, Excel, PDF, or copy-paste into another file.
• It makes me conscious – manual entry forces me to notice what I spend.

That last point is important.

Automatic tracking is convenient, but it can become invisible. Manual tracking is slower, but it makes you feel the expense once more. For me, that small friction is useful.

My view: The best spending tracker is not the one with the most features. It is the one you will actually update for 3 months without quitting.

What my Google Sheets expense tracker includes

Short answer: it has 5 connected sheets.

I kept it simple because overcomplicated money trackers die fast. If you need 20 tabs, 50 formulas, and a tutorial video just to add dinner expense, you will stop using it.

My template has these sheets:

These five sheets cover almost everything I need personally.

The Dashboard is where I look. Income and Expenses are where I enter data. Worth gives me the bigger financial picture. Fixed Expenses keeps recurring costs visible instead of letting them quietly drain money every month.

1. Main Dashboard: the page I check first

Short answer: this is the control room.

The Main Dashboard gives me a quick answer to the question I actually care about:

Am I spending more than I should this month?

It pulls numbers from the Income, Expenses, and Fixed Expenses sheets and shows the totals in one place.

• This month – how much came in and how much went out.
• This year – year-to-date income and expense summary.
• Last year – comparison to understand whether I am improving or slipping.
• Category summary – where the money is going.
• Fixed costs – the money already committed before the month even starts.

This is where Google Sheets becomes useful. I do not manually calculate everything. The formulas do the boring work.

For example, a monthly income total can use a formula like this:

=SUMIFS(Income!B:B, Income!A:A, ">="&EOMONTH(TODAY(), -1)+1, Income!A:A, "<="&EOMONTH(TODAY(), 0))

You do not need to understand every formula to use the template. I am sharing the formula because it shows the logic: filter by date, then sum the matching amounts.

If you like spreadsheet formulas, you may also like my guide on using the GOOGLEFINANCE formula in Google Sheets. I use similar spreadsheet thinking when tracking investments and currency rates.

2. Income sheet: every rupee coming in

Short answer: record every income source, not only salary.

Most people track expenses and forget income details. That is a mistake if your income is not exactly the same every month.

My income sheet has five columns:

You can adjust the categories based on your life. Mine are usually simple:

• Salary
• Freelance
• Business
• Refunds
• Interest
• Others

The important thing is consistency.

If you call the same income source “Client Work” one month and “Freelance” next month, your summaries become messy. Pick category names and stick to them.

Quick note: I add income as soon as it hits the account. If I wait until the end of the month, I forget small refunds and interest credits.

3. Expense sheet: where the truth appears

Short answer: this is the most important sheet.

The Expense sheet is where I enter daily spending. It uses the same basic structure as the Income sheet, so it is easy to maintain.

My common expense categories are:

• Groceries – household essentials and monthly shopping.
• Bills – electricity, internet, mobile, gas, water.
• Food – restaurants, cafes, delivery, snacks.
• Travel – fuel, cab, train, flight, hotel.
• Business – domains, hosting, tools, software, subscriptions.
• Health – medicine, doctor visits, tests, insurance-related spends.
• Personal – shopping, grooming, random personal buys.

The description column is underrated.

Do not write only “Food”. Write “Dinner at XYZ with friends” or “Swiggy order after work”. It feels small, but after 30 days, those descriptions explain your habits better than any chart.

This also helps with business expenses. If I paid for hosting, a domain, a tool, or a SaaS product, I write the vendor name properly. Later, when I need to find the invoice or calculate yearly software spend, I do not have to dig through memory.

If you use credit cards heavily, this also helps you understand whether the card is genuinely saving money or simply making spending feel easier. I follow the same logic when reviewing cards like the PhonePe SBI SELECT Black Credit Card and the ICICI Emeralde Private Metal Credit Card: rewards are useful only when you already understand your spending.

My honest take: Tracking expenses does not magically save money. But it makes waste visible. Once waste is visible, ignoring it becomes harder.

4. Worth sheet: the reality check

Short answer: income is not wealth.

This sheet tracks assets and liabilities so I can see my actual financial position, not just monthly cash flow.

Assets can include:

• Bank balances
• Cash
• Fixed deposits
• Mutual funds
• Stocks
• Gold or silver
• Money owed to you

Liabilities can include:

• Credit card bills
• Personal loans
• EMIs
• Pending payments
• Borrowed money you need to return

The basic formula is simple:

=SUM(Assets) - SUM(Liabilities)

When I first started tracking net worth, it felt uncomfortable. Monthly income looked okay, but once I included card bills, pending payments, and commitments, the picture became more honest.

That discomfort was useful.

It pushed me to think about liquidity, emergency funds, debt, and recurring commitments instead of only looking at bank balance after salary day.

5. Fixed expenses sheet: the silent money leak

Short answer: this sheet shows what your month already costs before you do anything.

Fixed expenses are dangerous because they become invisible.

A subscription feels small monthly. A tool renewal feels normal. A domain renewal feels necessary. But when you annualise everything, the number can surprise you.

This sheet helped me find unused subscriptions, duplicate tools, and renewals I did not care about anymore.

My rule is simple: if something renews automatically, it belongs in Fixed Expenses.

• Rent
• EMIs
• Insurance premiums
• Phone and internet bills
• Streaming subscriptions
• Software subscriptions
• Hosting and domain renewals
• Credit card annual fees

Once you know your fixed monthly cost, budgeting becomes less emotional. You are not guessing anymore. You can see how much money is already committed and how much is actually flexible.

The formulas that make the tracker useful

Short answer: you only need a few formulas.

The template already has the formulas, but these are the ones that make the system work:

For example, to calculate one category’s expense this month, you can use logic like this:

=SUMIFS(Expenses!B:B, Expenses!C:C, "Food", Expenses!A:A, ">="&EOMONTH(TODAY(), -1)+1, Expenses!A:A, "<="&EOMONTH(TODAY(), 0))

This looks complicated at first, but the idea is simple: add all expenses where category is Food and the date is inside this month.

Once you understand that logic, you can build almost any simple finance dashboard in Google Sheets.

How to use the free template

Short answer: make a copy first, then start from today.

Please do not request edit access to the original template. Use the copy link, save it to your own Google Drive, and then edit your own version.

1. Open the template link and choose Make a copy.
2. Rename the file to something simple like Personal Expense Tracker.
3. Update income categories based on your real money sources.
4. Update expense categories based on how you actually spend.
5. Add fixed expenses like subscriptions, rent, EMIs, bills, and renewals.
6. Add current balances in the Worth sheet if you want net worth tracking.
7. Start entering expenses from today instead of trying to recreate the past year.

That last step matters.

Many people fail because they try to backfill old data perfectly. Do not do that on day one. Start with today. After the habit is built, you can add older data if it is genuinely useful.

My daily tracking routine

Short answer: I keep it boring.

If your tracking routine needs motivation, it will fail. Mine is simple enough that I can do it even when I am tired.

• Morning – I glance at the dashboard if I am planning spending for the day.
• Evening – I add the day’s expenses from UPI, card, cash, and receipts.
• Weekly – I update bank balances and worth sheet.
• Monthly – I review categories and cancel or reduce anything wasteful.

The daily update usually takes less than 5 minutes if I do it regularly.

If I skip a week, it becomes annoying. That is the whole lesson. Small daily update beats one painful monthly cleanup.

Quick note: Do not aim for perfect tracking. Aim for useful tracking. If you capture 90-95% of spending consistently, you will still learn a lot.

What this tracker helped me notice

Short answer: the small leaks.

Big purchases are obvious. You remember buying a phone, laptop, flight ticket, or expensive tool.

Small repeated expenses are the real problem.

• Food delivery that became a habit.
• Subscriptions I was not using properly.
• Software tools I bought for one project and forgot.
• Annual renewals that felt small monthly but looked stupid yearly.
• Credit card spends that looked rewarding but were not always necessary.

The point is not to stop enjoying life.

The point is to know what is happening. If I knowingly spend money on something I value, fine. If I am spending because I forgot, ignored, or never checked, that is different.

Limitations of using Google Sheets for expense tracking

Short answer: it is not perfect, and I do not want to pretend it is.

• Manual entry is required. If you hate entering data, this will feel annoying.
• No automatic bank sync. That is better for privacy, but worse for convenience.
• No fancy app notifications. You need your own habit or reminder.
• Charts are basic unless you customise them. This template focuses on clarity, not fancy visuals.
• Mobile editing can feel slower. Google Sheets on phone works, but desktop is easier for cleanup.

For me, these tradeoffs are acceptable because the system is free, portable, and easy to modify.

But if you want bank syncing, automatic SMS parsing, reminders, and app-level reports, a dedicated finance app may suit you better.

FAQ

Is this Google Sheets expense tracker free?

Yes. The template is free to copy and use. Open the link, make a copy in your own Google Drive, and customise it for your income, expenses, categories, and fixed costs.

Do I need to know formulas?

No. The main formulas are already inside the template. Basic Google Sheets knowledge helps, but you can start by only entering income, expenses, fixed costs, and balances.

Can I use this for business expenses?

Yes, but keep your categories clean. Add vendor names, invoice notes, and document references in the description or document column so tax-time review becomes easier.

Should I enter old expenses?

Not at the beginning. Start from today. Once the habit is stable, you can add older data if you need it, but do not delay tracking because historical data is incomplete.

Can I use it on mobile?

Yes. Google Sheets works on mobile, but larger edits are easier on a laptop. I usually add quick entries from phone and clean anything messy later from desktop.

Is Google Sheets safe for personal finance tracking?

It depends on what you enter and how secure your Google account is. I avoid storing sensitive account passwords, card numbers, or full bank details. Use a strong password and two-factor authentication on your Google account.

Summing Up!

My Google Sheets expense tracker is not the fanciest finance system. That is exactly why I like it.

It gives me a clear view of income, expenses, fixed costs, and net worth without forcing me into another paid app. The manual entry also keeps me aware of what I am doing with money, which is half the battle.

If you are not tracking anything right now, start simple. Make a copy of the template, enter today’s expenses, and keep going for one month. After that, your own numbers will tell you what needs to change.

Are you currently tracking expenses in an app, notebook, or spreadsheet? Tell me in the comments. I would love to know what system is working for you.