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?
- 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.
- Look for rupee signs, commas or trailing spaces inside the cells. These can make a value read as text.
- Check whether a view filter hides rows, for example a month filter set to last month.
- Check the date property. If dates were pasted as text, month groupings will fail.
- 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.
| Symptom | Likely cause | Check |
|---|---|---|
| Total is zero | Amounts stored as text | Property type, symbols in cells |
| Month view empty | Date as text or filter | Date type and view filters |
| Category totals missing | Relation not linked | Open a row and look at the relation |
| Formula error | Renamed or deleted property | Rebuild 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.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

