Free Google Sheets Expense Tracker Template (2026, Copy-Paste)

In February 2026, I sat down to file my quarterly GST return for Mursa and realized I had 214 business expenses scattered across three UPI apps, two credit cards, and a folder of Zomato screenshots I never renamed. My chartered accountant sent me a template. I ignored it, built my own expense tracker google sheets file in a single evening, and closed the filing in one afternoon instead of the two full days it had swallowed the previous quarter.

Before that, I had tried every option. YNAB at 15 dollars a month felt expensive for a solo founder in Bangalore. Mint shut down in 2024. Money Manager and Wallet by BudgetBakers were fine, but neither exported cleanly into the format my CA wanted. Splitwise handled group trips and nothing else. I kept bouncing between apps and never trusted any single one as the source of truth.

The Sheets version stuck for one reason. I was already in Sheets every day for my content calendar, Mursa SaaS metrics, and keyword tracker. Adding one more tab took zero mental overhead. Six months in, I have 1,847 expenses logged, three quarters of clean GST filings behind me, and a system that costs nothing.

What a Good Google Sheets Expense Tracker Actually Needs

A good expense tracker google sheets file captures date, category, description, amount, and payment method for every transaction, then auto totals spending by month and by category using SUMIFS formulas. It also needs a category dropdown to stop typos from silently breaking your formulas, a running balance column so you always know what you have left, and a receipts field linked to Google Drive so tax season is a single export instead of a manual scavenger hunt.

Most templates I found in 2026 miss at least two of these pieces. Google's own Monthly Budget lumps everything into hardcoded categories. Shoeboxed and Smartsheet skip the receipt link workflow. Vertex42 nails the checkbook feel but leaves you to build category summaries yourself. The template below combines the pieces that matter for freelancers, solo founders, and anyone who dislikes paying 12 dollars a month to look at their own numbers.

The Three-Tab Structure That Scales Past 500 Transactions

The template uses three tabs and the split is deliberate. One captures raw transactions. One holds settings, mostly your category list and starting balance. One shows the dashboard where SUMIFS aggregations live. When a tracking spreadsheet dies after three months, it is almost always because someone put summary formulas on the same tab as the raw data and broke row references.

Tab one is called Transactions. Columns run: Date, Category, Description, Amount, Payment Method, Receipt, Notes, Running Balance. Each new expense goes on a new row. No merged cells, no color coding, no notes above row 1. Keep it a pure list. I freeze row 1 so the headers stay visible while I scroll, and I keep the sheet sorted by Date descending so today's expenses sit at the top.

Tab two is called Settings. It holds three ranges: category names in column A, payment methods in column B, and a starting balance in cell D2. That is it. When you want to add a new category, you edit one cell in Settings and the dropdown on Transactions updates automatically. Switch banks, edit the payment method list. Everything downstream inherits from this tab.

Tab three is called Dashboard. It reads from Transactions and Settings using SUMIFS and lookups. Monthly totals live here. Category breakdowns live here. Any chart you build lives here. Because it never touches raw data, you can restyle it, break it, and rebuild it without losing a single expense row.

Building the Category Dropdown Without Breaking Formulas

The single feature that keeps this tracker alive past month two is the category dropdown. Without it, you type 'Food' one day, 'food' the next, 'meals' Sunday, and 'restaurant' at midnight. Your SUMIFS totals split into four fake categories. By month three you stop trusting the numbers and abandon the sheet.

Here is the setup. On the Settings tab, put your category names in A2 through A20. Mine are: Food, Groceries, Rent, Utilities, Internet, Software, Travel, Fuel, Health, Education, Entertainment, Gifts, Client, Investment, Uncategorized. Keep the list under 15 if you can. If you cannot decide where an expense belongs, use Uncategorized and reclassify it later during your weekly review.

Now go to the Transactions tab, select column B from row 2 down to row 1000. Right click, choose Data validation. In the popup, set criteria to 'Dropdown from a range' and enter Settings!A2:A20. Check 'Reject input' so anything outside the list gets blocked. Save. Every cell in that column now shows a dropdown arrow, and every entry has to match a category you approved.

The Three Formulas That Do Most of the Work

Three formulas handle 90 percent of the analytical work in this expense tracker. SUMIFS handles category and month breakdowns. A running balance formula gives you a live bank-style ledger. A simple SUM on the Amount column gives you lifetime totals for quick sanity checks. That is it. No macros, no Apps Script, no ARRAYFORMULA gymnastics unless you love them.

For monthly category totals on the Dashboard tab, use: =SUMIFS(Transactions!D:D, Transactions!B:B, $A5, Transactions!A:A, ">="&B$2, Transactions!A:A, "<="&EOMONTH(B$2,0)). Column A holds category names from Settings. Row 2 holds the first of each month. The formula sums the Amount column where the category matches and the date falls inside the month. Drag across 12 months, down for every category.

For running balance in column H on Transactions, use: =IF(ROW()=2, Settings!$D$2-D2, H1-D2). If this is the first data row, start from the Settings balance minus today's expense. Otherwise take yesterday's running balance and subtract today's expense. Log income as a negative amount and the running balance handles both directions.

For month to date total across all categories, drop this in a Dashboard cell: =SUMIFS(Transactions!D:D, Transactions!A:A, ">="&EOMONTH(TODAY(),-1)+1, Transactions!A:A, "<="&TODAY()). I keep this cell in a bright yellow box at the top so I see the number the second I open the file.

Adding a Receipts Column That Links to Google Drive

The receipts column is what separates a hobby tracker from something a chartered accountant will accept during a GST or income tax audit. Every business expense in India above 5,000 rupees needs a supporting document, and in the US the IRS requires records for any deduction over 75 dollars. The Google Drive link approach turns receipt storage from a shoebox nightmare into a copy-paste.

Create a folder in Google Drive called Receipts 2026 with 12 monthly subfolders inside. For paper bills, use the Google Drive iOS or Android app's Scan option. It auto crops, converts to PDF, and uploads. For digital receipts from Zomato, Swiggy, Amazon, or SaaS bills, use Gmail's Save to Drive button on the attachment.

Once the file is in Drive, right click and choose 'Get link.' Paste that URL into the Receipt column on the Transactions tab. Google Sheets automatically renders it as a clickable link. If you want cleaner text instead of a raw URL, wrap it: =HYPERLINK("paste-link-here", "View"). One character in the cell, one click to open the receipt in a new tab. Auditors love it, and you never dig through a physical folder again.

The Monthly Dashboard: One Screen, Every Insight

The dashboard is where the raw list of transactions becomes a story. Mine has six blocks arranged so I can read the entire month in 30 seconds. Total spend this month. Total income. Net. Category breakdown table. Small pie chart. And a 12-month trend line for total spending.

Building it takes 20 minutes if you copy the structure. The category grid uses SUMIFS with conditional formatting that highlights any category where spend jumped more than 30 percent versus last month. That single conditional format has caught two subscription renewals I forgot about and one duplicate charge from my hosting provider.

The dashboard is not decorative. Every element is there because I look at it monthly and it changes a real decision. If software costs jumped 40 percent, I open my subscription list. If travel is trending down for three months, I know I have been stuck in Bangalore too long. The tracker is only useful if it feeds back into behavior, and the dashboard is where that feedback loop lives.

Exporting for Tax Season Without Re-Entering Anything

Every January and April in India, and every March or April in the US, someone hands this data to an accountant. The whole point of a well-structured expense tracker google sheets file is that the export is one click. Here is exactly what I do for both GST and income tax filings.

For GST, I filter Transactions by Category equals Client, Software, Internet, or any business category. I copy the filtered rows into a new sheet, add columns for GST rate and GST amount, and share view-only access with my CA. He reformats into the GSTR schema and files. Two days of Excel wrangling became 45 minutes.

For income tax, I filter by Category equals Investment or Health for 80C and 80D deductions. Receipt links go with the shared sheet. Because every deductible expense already points to a PDF in Drive, the CA has proof of every claim without me making a single phone call. My last filing had zero clarifying questions. First time in five years of self-employment.

Capturing Expenses on the Go With WhatsApp

The biggest failure mode for any expense tracker is not the tracker itself. It is the 47 receipts you never entered because you were between meetings. Here is what actually works, especially in India where UPI notifications hit 20 times a day.

For UPI, PhonePe and Google Pay both push notifications with the exact amount and merchant. I long press, tap Share, and send to my own WhatsApp number as a note to self. The message sits in chat until my evening batch entry. Same for Zomato and Swiggy: screenshot, forward, done. Three seconds per expense.

This is where Mursa fits in. I forward the WhatsApp expense message to Mursa and it captures a task like 'Log 340 rupee Zomato expense in tracker.' The task appears in my Mursa inbox with the original message attached, and I get a WhatsApp reminder every evening at 7 pm to knock out my batch. Mursa does not enter the row for me, that still happens in Sheets, but it makes sure no expense slips past me because I forgot to open the file.

When You Have Outgrown the Spreadsheet

This template scales further than most people expect. I know solo founders using the same structure with 5,000 transactions per year and no performance issues. The real ceiling is not row count, it is workflow complexity. Once your flow touches team members, multiple currencies, or invoicing, the sheet stops being enough.

Signals you have outgrown the spreadsheet: more than one business bank account and you want automated reconciliation. Multi-currency support with live FX. Teammates logging expenses without edit access to your master sheet. Or you have crossed into accounting territory where inventory, invoices, and payroll live together.

At that point, look at Zoho Books at 6 dollars a month, QuickBooks Simple Start at 15 dollars a month, or Wave which is still free. All three import CSVs cleanly from this template, so the transition is a one day project. Your six months of clean Sheets history becomes your first six months of accounting software history.

If you want to see how this fits into a wider personal system, I built a similar walkthrough for a google sheets habit tracker, and a comparison of Google Sheets vs Notion for tasks. For solo founders juggling five tools, my guide on workflow automation for solo founders covers the wider stack, and both my best productivity apps in 2026 roundup and the best productivity apps in India for 2026 include the tools that pair cleanly with this sheet.