DEV Community

Otto
Otto

Posted on

How to Track Your Personal Finances in Notion (Better Than Any Spreadsheet)

Managing Personal Finances Without a Spreadsheet

Most people hate budgeting. They open a spreadsheet, stare at it for 5 minutes, and close it.

Here is the thing — the problem is not budgeting. The problem is that spreadsheets feel like punishment.

Notion changes that.

Why Notion Works for Budgeting

Notion makes finance tracking visual, flexible, and actually enjoyable. Instead of rows and columns, you get databases, filters, and views that make sense to you.

Here is what a proper Notion finance system looks like.

The 4-Database Setup

1. Transactions Database

Properties:

  • Date (date)
  • Description (text)
  • Amount (number)
  • Category (select: Housing, Food, Transport, Subscriptions, Entertainment, Savings, Income)
  • Type (select: Income, Expense)
  • Account (select: Bank, Cash, Credit Card)

2. Monthly Summary View

Create a filtered view for each month. Add a formula property:

if(prop("Type") == "Income", prop("Amount"), -prop("Amount"))
Enter fullscreen mode Exit fullscreen mode

Group by Category to see where money goes.

3. Budget Targets Page

A simple page where you set monthly targets:

  • Housing: €900
  • Food: €400
  • Transport: €150
  • Entertainment: €100
  • Savings: €300

4. Savings Goals Tracker

Goal Target Saved % Done
Emergency Fund €3,000 €800 27%
Vacation €1,500 €420 28%
New Laptop €1,200 €650 54%

The Weekly Review Ritual (10 Minutes)

Every Sunday:

  1. Open your Transactions database
  2. Add all expenses from the week (use the mobile app — it takes 2 minutes)
  3. Check your monthly totals against targets
  4. Update savings progress

That is it. 10 minutes per week.

The Power of Filters

Notion lets you filter by any property. Want to see all subscriptions? One click. Want to see last month versus this month? One click.

You can even build a "Subscription Audit" view to find recurring payments you forgot about. Most people find €40-80/month in forgotten subscriptions the first time they do this.

What People Save in the First Month

When you make spending visible, you make different decisions:

  • Week 1: You realize you are spending €80/month on apps you never use
  • Week 2: You cook more because you see how much you spend eating out
  • Week 3: You start the savings goal you kept postponing
  • Month end: Average saving of €150-300 vs. months without tracking

Getting Started Today

You do not need a perfect system. Start with:

  1. Create a Transactions database
  2. Add this week expenses
  3. Set 3 budget targets
  4. Review every Sunday

The best finance system is the one you actually use.


Want a ready-made system? The Freelancer OS template includes a complete finance tracker alongside project management, CRM, and content planning — all in one Notion workspace for €19.

Top comments (0)