Free Google Sheets Budget Tracker Template (Copy-Paste 2026)

On January 3, 2025, I opened my HDFC statement in Bangalore and saw ₹47,000 in variable spending from the previous month that I could not account for. Not fraud. Just me. Swiggy orders at 11pm, three subscription trials I forgot to cancel, one Uber to Whitefield that cost ₹680 because of surge pricing, and a Blinkit habit that had quietly turned into a lifestyle instead of a convenience.

I had tried YNAB, Walnut, Wallet by BudgetBakers, and two Notion budget templates that a Twitter thread swore were life changing. Every one wanted me to import bank data or fill in a form that felt like filing income tax. The friction won every time. By week two, I stopped opening the app. By week four, I was back to guessing.

So I built a Google Sheet. Categories down the side, dates going across. Eighteen months later, I have logged every rupee since February 2025 and my monthly variable spend dropped from ₹47,000 to ₹28,000. Not because I budgeted harder. Because I finally saw where the money was going. The template below is what I actually use, and you can copy it and be tracking by dinner.

What A Budget Tracker In Google Sheets Actually Needs

A budget tracker in Google Sheets needs four things to survive past week two: one tab for logging every transaction, category-based auto-tallies using SUMIF, a monthly rollup that compares actual spending against planned, and a savings-goal progress bar you can read at a glance. Everything else is decoration. If your template has more than three tabs, you will abandon it within a month. Keep it boring. Keep it fast.

The mistake most free templates make is trying to look impressive. They add net worth pages, investment pies, debt payoff calculators, and a landing dashboard. All of that is fine in month one when you are excited. By month three, the sheet feels like homework and you stop opening it. Mine has three tabs, six formulas, and one chart, and it has survived job changes, a laptop migration, and a two-week stretch of logging 41 transactions from a beach in Gokarna.

The Three-Tab Layout That Refuses to Die

Tab one is Transactions. Five columns: Date, Category, Description, Amount, and Payment Method. That is it. Every rupee, dollar, or euro you spend goes here as one row. When I bought a coffee at Third Wave in Indiranagar this morning, I logged: 2026-07-18, Food, Third Wave latte, 320, GPay. Ten seconds on my phone.

Tab two is Categories. Column A holds the category names: Food, Rent, Transport, Subscriptions, Utilities, Groceries, Health, Fun, Gifts, Miscellaneous. Column B holds the planned monthly budget for each. Column C shows the actual spend, pulled with SUMIF from the Transactions tab. Column D shows the difference. Column E shows a progress bar. Ten rows, done.

Tab three is Monthly. One row per month, one column per category. This is where you spot trends. My Food column has dropped from ₹18,000 in Feb 2025 to ₹11,200 in June 2026, not from willpower, but from seeing the ₹18,000 number in the same row as my Rent for eight months in a row and finally getting embarrassed.

I keep a Data Validation dropdown on the Category column: Data > Data validation > List from range > Categories!A2:A11. Every new transaction becomes a two-tap selection on mobile. No typos. No misspellings that break the SUMIF. This one setting saved me from at least four sheet-breaking bugs in the first month.

Category Auto-Tallies With A Single SUMIF

The formula that makes this whole budget tracker Google Sheets template work is SUMIF. In the Categories tab, cell C2 (Actual for Food) uses: =SUMIF(Transactions!B:B, A2, Transactions!D:D). That formula scans the Category column on the Transactions tab, matches every row where the category equals A2 (which is Food), and adds up the Amount column for those matches. Drag it down for every category.

This is where a spreadsheet stops being data entry and starts being a tool. You log a Swiggy order for ₹380 under Food, tab back to the Categories page, and the Food total has already jumped by 380. The reward loop is instant, which is the entire reason the tracker survives long enough to change behavior.

To restrict SUMIF to only the current month, use SUMIFS: =SUMIFS(Transactions!D:D, Transactions!B:B, A2, Transactions!A:A, ">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1), Transactions!A:A, "<"&DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)). Ugly, yes. But it rolls over on the first of every month with zero maintenance. I set this up in February 2025 and have not touched it since. For the Difference column, use =B2-C2 with green if positive, red if negative. The Categories tab now reads like a scoreboard.

The Monthly Rollup That Shows Where The Money Actually Went

The Monthly tab is where personal finance stops being a monthly game and starts being a trend line. Column A holds month labels: Feb 2025, Mar 2025, Apr 2025. Columns B through K hold your ten categories. Each cell uses SUMIFS to pull the total for that category in that month. Formula in B2 (Food for Feb 2025): =SUMIFS(Transactions!D:D, Transactions!B:B, B$1, Transactions!A:A, ">="&DATE(2025,2,1), Transactions!A:A, "<"&DATE(2025,3,1)). Write it once, drag across and down. Half an hour of setup gives you a rolling 24-month view of your life.

The trend column at the far right uses SPARKLINE to draw a tiny line chart inside a single cell. For Food's trend: =SPARKLINE(B2:B25, {"charttype", "line"; "color", "green"}). Now every category has a miniature graph next to it showing whether the number is going up or down over time. This is the part that changed my behavior more than any category total. Seeing the line for Subscriptions climb over three months made me cancel two Netflix accounts and Spotify Duo in one Saturday morning.

A Savings-Goal Progress Bar You Can Read In One Second

The savings goal progress bar is my favorite trick in this template. It uses REPT to draw a text-based bar inside a single cell. No chart, no add-on. The formula: =REPT("█", ROUND(C2/B2*20, 0)) & REPT("░", 20-ROUND(C2/B2*20, 0)). B2 is your goal amount (say, ₹200,000 for an emergency fund). C2 is what you have saved so far. The bar is 20 characters wide, filled based on the ratio. At 40% of goal, you see 8 solid blocks and 12 empty ones.

I stack three of these at the top of the Categories tab: Emergency Fund, Trip to Ladakh, Laptop Fund. Every time I log a transfer to my SBI savings account under a Savings category, the corresponding bar fills a little more. It is the single most motivating thing in the whole sheet, and I found the REPT trick on r/googlesheets after six months of tracking without it.

For the color feel, wrap the formula in conditional formatting: below 25% is red, 25 to 75% is yellow, above 75% is green. Now the bar is not just progress, it is a status signal. When my Emergency Fund bar turned green in November 2025, I actually took a screenshot. That screenshot lives on my phone lock screen for another two weeks as a reminder that this stuff works.

The Phone-Friendly Checkoff Row For 3-Second Logging

The biggest reason budget trackers fail is friction on the log step. If entering a coffee takes more than 10 seconds, you will stop. I have measured mine, and each new transaction on the Google Sheets iOS app takes me under 3 seconds because I designed the row for one-thumb entry.

The trick: pin the first row (View > Freeze > 1 row) and set it up as a quick-entry template. Column A holds =TODAY() so the date prefills. Column B has the Category dropdown. Column C is Description. Column D is Amount. Column E is Payment Method dropdown. Tap into row 2, hit the dropdown, type the amount, hit Enter. On both iOS and Android, add the sheet as a home-screen shortcut so opening it takes fewer taps than opening Instagram.

Conditional Formatting For Overspend Warnings

Numbers alone do not scare you into stopping. Colors do. The Categories tab uses three conditional formatting rules that turn cells red when I overspend, yellow when I am close, and green when I have breathing room. This turns the sheet from a passive log into an active warning system.

Select the Difference column (D2:D11). Format > Conditional formatting > Custom formula is: =D2<0 with red fill (#F4C7C3). Add =AND(D2>=0, D2<B2*0.2) with yellow fill (#FCE8B2), triggering when less than 20% of budget remains. Add =D2>=B2*0.2 with green fill (#B7E1CD). Now the whole column reads like a traffic light every morning.

The Monthly tab gets a Color Scale rule instead: white minimum, red maximum, applied across all monthly totals. Now the highest-spend months in each category glow loudest. When my Transport row lit up dark red in April 2026, I noticed I had been taking Ubers instead of the Bangalore Metro purple line for three weeks straight. Behavior changed the next day.

Splitting A Shared Budget Without Login Drama

One underrated win of the sheet over apps like Splitwise or Walnut Split is sharing. Click Share, add your partner's Gmail, give them Edit access, and both people log into the same file in real time. No account creation, no invite emails, no subscription tier for shared budgets.

For couples or roommates, add a Person column to the Transactions tab. Then add two SUMIFs at the bottom of the Categories tab: =SUMIF(Transactions!F:F, "Murali", Transactions!D:D) and =SUMIF(Transactions!F:F, "Partner", Transactions!D:D). The sheet does month-end settlement math for you. Whoever paid less transfers the difference. A friend's household of five in Bangalore runs on this exact setup, ₹0 per month.

When The Spreadsheet Isn't Enough: Reminders And Nudges

The sheet is not perfect. It cannot ping you when a subscription renews, cannot remind you to log yesterday's Uber, and will happily sit unopened for a week while your Blinkit habit runs unchecked. A scoreboard is only useful if you actually look at it.

This is where Mursa closes the loop for me. Whenever an SMS or email tells me about a subscription renewal or an upcoming bill, I forward the WhatsApp message and Mursa captures it as a task with the amount and due date already parsed. On the first of every month, it sends me a WhatsApp reminder to open the sheet and review the previous month's rollup. The sheet still does the budgeting. Mursa just remembers the review ritual so I do not have to. My write-up on workflow automation for solo founders walks through the full stack.

Getting Started In Under 2 Minutes

Open Google Sheets. Create a new blank spreadsheet. Rename it Budget 2026. Rename Sheet1 to Transactions and add row 1 headers: Date, Category, Description, Amount, Payment Method. Thirty seconds in.

Add a second tab called Categories. Column A holds your ten category names. Column B holds the planned monthly amount for each. In C2 paste: =SUMIF(Transactions!B:B, A2, Transactions!D:D). Column D: =B2-C2. Column E: =REPT("█", ROUND(C2/B2*20, 0)) & REPT("░", 20-ROUND(C2/B2*20, 0)). Add a third tab called Monthly with categories across row 1 and month labels down column A, then drop in the SUMIFS formula from earlier. Two minutes in, and you have a template that scales for years.

Log your first transaction today. Not tomorrow, not on the first of next month. The muscle of logging, more than any formula in the sheet, is what makes this stick.

If you want to go further, my guide on Google Sheets vs Notion for personal task management covers the same tradeoff for your task list. The roundup of best productivity apps for 2026 covers what I stack alongside this sheet, and the best productivity apps in India for 2026 goes into tools optimized for UPI and Indian bank statements. For the habit-tracking version of this same philosophy, the free Google Sheets habit tracker template is the sibling post.