Getting started

Notion finance templates not working: formulas, rollups and empty totals

When a Notion finance template shows blank totals, wrong sums or broken formulas, check property types and relations first, then decide if a sheet will do.

Editorial illustration for Notion finance templates not working: formulas, rollups and empty totals

When a finance template in Notion shows zero totals or blank cells, the cause is usually one of four things: the amount column holds text rather than numbers, a relation or rollup points at the wrong database, a filter hides your rows, or the formula refers to a property you renamed. Check them in that order, and test with one row before touching the rest.

Templates differ, so this article does not describe any particular one. It shows how to find the break in any template that sums spending, and where the limits of that approach lie.

Why is my total showing zero or blank?

  1. Open the amount property and check its type. If amounts were pasted from a bank file, they can arrive as text, and text does not sum. Convert the property to a number type, then check a few rows.
  2. Look for rupee signs, commas or trailing spaces inside the cells. These can make a value read as text.
  3. Check whether a view filter hides rows, for example a month filter set to last month.
  4. Check the date property. If dates were pasted as text, month groupings will fail.
  5. Check the rollup: confirm which relation it follows, which property it reads and what calculation it uses, such as sum.

What if a formula returns an error?

Read the error text first. A formula that worked yesterday and fails today usually refers to something that changed: a renamed property, a deleted column or a different type. Rewrite it with the property chosen from the list, not typed by hand. Test a small version, such as a formula that only returns the amount, and then add logic step by step. If a duplicated template shows broken links, the copy may point at the original template's database rather than your own, so check where each relation goes.

A worked example: why ₹0 appeared

Say you paste a CSV of five expenses: ₹450, ₹1,200, ₹300, ₹2,150 and ₹899. The monthly rollup shows ₹0. You find the amounts were imported as text with a rupee sign and a comma. After converting the property to numbers and cleaning the signs, the rollup shows ₹450 + ₹1,200 + ₹300 + ₹2,150 + ₹899 = ₹4,999. Always add the rows by hand once so you know the target.

SymptomLikely causeCheck
Total is zeroAmounts stored as textProperty type, symbols in cells
Month view emptyDate as text or filterDate type and view filters
Category totals missingRelation not linkedOpen a row and look at the relation
Formula errorRenamed or deleted propertyRebuild from the property list

When does a template stop being enough?

Templates are flexible, but each statement you paste needs cleaning by hand, categories are yours to maintain, and nobody checks for duplicates. If you spend more time repairing the system than reading the numbers, that is a signal rather than a failing on your part.

What is the alternative for statement-based tracking?

SpendixAI takes bank or card statements as PDF, CSV or Excel for the account you pick, lets you review the rows before saving, categorises them in stages that start with your own rules, and offers CSV downloads and a Report builder. It is not a place to design your own database, so if you enjoy building a custom system, keep it for that.

A final tip on templates in general: change one thing at a time and look at the totals after each change. If you rename three properties, edit two formulas and import a file in one sitting, you will not know which step broke the sum. Keep a duplicate of the working version before every experiment, and write a one-line note of what you changed.

A small repair routine

  • Keep one amount column, number type, no symbols.
  • Clean each pasted file before adding it.
  • Add one test row after any change.
  • Duplicate the template before experimenting.
  • Export a copy of your data monthly.
SPENDIXAI JOURNAL

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

Explore your reports