Getting started

Budget planner spreadsheet not working? Fixes for sums and formulas

Budget planner not working or showing wrong totals? Check calculation mode, text-formatted numbers and protected view, with a worked example in rupees.

Editorial illustration for Budget planner spreadsheet not working? Fixes for sums and formulas

When a budget planner spreadsheet stops working, the cause is almost always one of four things: calculation set to manual, numbers stored as text, the file opened in a read-only or protected view, or a formula range that no longer covers your new rows. Each takes a minute to test, and you can usually tell which one it is by looking at what the totals do when you change a number.

First, what exactly is "not working"?

Planners that people download or open online fail in different ways, and the fix depends on the symptom. Match yours before touching anything.

What you seeMost likely causeQuick test
Totals do not change when you typeCalculation is set to manualPress F9 in Excel; if totals jump, it was manual
A column adds up to zeroNumbers are stored as textClick a cell; if it is left-aligned or shows a green triangle, it is text
You cannot type in cellsProtected view or a locked sheetLook for a yellow bar saying the file is read-only
New rows are ignoredFormula range stops earlyClick the total and see which cells are outlined
Online version will not loadBrowser, extension or sign-in issueTry a private window

Fix 1: manual calculation

In Excel, open the Formulas tab and look at Calculation Options. If it says Manual, switch it to Automatic. In Google Sheets this does not apply, because it recalculates on its own; look at the other causes instead. A planner copied from someone else's file can carry the manual setting with it, which is why it feels random.

Fix 2: numbers that are really text

This is the most common culprit when you paste figures from a bank statement or a website. Say your EMI cell shows 7,800 but is stored as text. A formula like =SUM(C2:C10) skips it, and your total spending comes out too low.

  1. Select the column and set its format to Number rather than Text.
  2. Retype one cell and see whether it now adds up. If it does, the whole column needs converting.
  3. To convert in bulk, put =VALUE(C2) in a spare column, fill it down, copy, and paste as values over the originals.
  4. If the number carries a ₹ sign or a trailing space, use =VALUE(SUBSTITUTE(SUBSTITUTE(C2,"₹",""),",","")) instead.

Why does my total ignore rows I added at the bottom?

Most planners sum a fixed range such as =SUM(C2:C20). If you type a new expense in row 21, it sits outside the range. Either insert new rows in the middle of the list, so the range stretches, or change the formula to a generous range such as =SUM($C$2:$C$500). Spare blank cells do not hurt a sum.

Worked example with made-up numbers

Say your planner shows income of ₹52,000, rent ₹16,000, groceries ₹9,500, transport ₹3,200, EMI ₹7,800 and eating out ₹4,100. Spending adds up to 16,000 + 9,500 + 3,200 + 7,800 + 4,100 = ₹40,600, so what is left is 52,000 - 40,600 = ₹11,400.

Now suppose the sheet claims ₹23,300 is left. The gap is 23,300 - 11,400 = ₹11,900, and 7,800 + 4,100 = 11,900 exactly, so the EMI and eating-out cells are being skipped. That points straight at two cells stored as text. A gap that matches the sum of specific rows is the quickest clue you will get.

What if the planner is an online tool, not a file?

  • Reload in a private window to rule out extensions and stored data.
  • Try another browser or your phone to see whether the problem follows the device.
  • Do not paste bank logins, card numbers or OTPs into any planner.
  • Copy your figures out before you clear browser data, because online tools often keep entries only in the browser.

When a sheet stops being enough

Some people outgrow a planner because typing every expense becomes the real problem. SpendixAI lets you upload bank statements in PDF, CSV or Excel, review the rows and categorise them, so the totals come from your records rather than from formulas you have to maintain. If your planner works again after the checks above, that is a perfectly good way to carry on.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports