```html

Notion Database Formula Budget Workflow: The Complete Playbook for Financial Tracking

If you're serious about personal or team budgeting in Notion, understanding database formulas is the difference between a static spreadsheet and a dynamic, self-calculating financial system. This playbook walks you through the fundamentals of building a bulletproof budget workflow using Notion database formulas—no coding background required.

Key Takeaways

• Formulas automate calculations—income, expenses, balances, and savings rates update instantly when you enter data.
• Property types matter. Using the right property (Number, Select, Date, Formula) determines which formulas you can write and how reliable your workflow becomes.
• A three-database structure (Transactions, Categories, Summary) is the most sustainable foundation for any Notion budget.
• Relational databases beat rolled-up formulas for accuracy—use rollups and relations instead of trying to force everything into one database.
• Templates within databases cut data entry time and enforce consistency across recurring transactions like rent or subscriptions.

Why Use Notion Formulas for Budgeting?

Most people start with a simple expense tracker and quickly outgrow it. Static numbers don't update. Totals need manual recalculation. The moment you introduce formulas, your Notion budget becomes a living system that scales with your financial complexity.

Formulas handle:

• Calculating net balance (income minus expenses) automatically
• Classifying transactions by category using conditional logic
• Computing savings rate, spending percentage, and budget variance
• Flagging overspent categories with color-coded warnings
• Formatting currency values with proper symbols and decimal places
• Linking transactions to budgets via relational databases

The Core Formula Syntax You Must Know

Notion formulas use a JavaScript-inspired syntax. Below are the building blocks you'll use in every budget workflow.

Basic Arithmetic Operators

• + — Addition (e.g., prop("Income") + prop("Interest"))
• - — Subtraction (e.g., prop("Income") - prop("Expenses"))
• * — Multiplication
• / — Division
• % — Modulo / remainder

Essential Formula Functions

• prop("PropertyName") — References another property's value
• if(condition, value_if_true, value_if_false) — Conditional logic
• format(date_or_number) — Formats dates, numbers, and currencies
• truncate(number) — Rounds down to whole numbers
• abs(number) — Returns the absolute value
• round(number) — Rounds to the nearest integer
• subpageCount() — Counts linked child items (for rollup alternatives)

Date & Text Functions

• format(prop("Date"), "MMMM YYYY") — Returns "July 2026"
• format(now(), "YYYY-MM-DD") — Current date in ISO format
• slice(text, start, end) — Extracts a portion of a string
• format(prop("Amount"), "$0.00") — Currency-formatted output

Three-Database Budget Structure

The most resilient Notion budget uses three interconnected databases. Each serves a distinct purpose and leverages specific formula and relation patterns.

Database 1: Transactions

This is your primary ledger. Every income event and expense goes here.

• Date — Date property; auto-populated with format(now())
• Amount — Number property; always positive (sign handled in formulas)
• Type — Select property: "Income" or "Expense"
• Category — Relation to the Categories database
• Net Amount — Formula: if(prop("Type") == "Income", prop("Amount"), -prop("Amount"))
• Description — Text property
• Recurring — Checkbox for monthly/quarterly automations
• Month Tag — Formula: format(prop("Date"), "MMMM YYYY")

Database 2: Categories

A master list that standardizes your spending labels and feeds the Transactions database.

• Category Name — Title property
• Budget Limit — Number property (monthly cap per category)
• Color — Select property for visual filtering
• Spend vs Budget — Rollup property that sums linked Transaction amounts
• Remaining — Formula: prop("Budget Limit") - prop("Spend vs Budget")
• Overspend Flag — Formula: if(prop("Remaining") < 0, "Over Budget ⚠️", "On Track ✅")

Database 3: Monthly Summary

An overview database pulled together using relations and rollups from the other two databases.

• Month — Title (e.g., "July 2026")
• Total Income — Rollup from Transactions (filtered by Type = Income)
• Total Expenses — Rollup from Transactions (filtered by Type = Expense)
• Net Savings — Formula: prop("Total Income") - prop("Total Expenses")
• Savings Rate — Formula: round(prop("Net Savings") / prop("Total Income") * 100) + "%"
• Budget Status — Formula that evaluates overall adherence

Essential Budget Formulas (Copy and Paste)

Formula Purpose	Property Type	Formula Expression	What It Does
Net transaction amount	Formula	if(prop("Type") == "Income", prop("Amount"), -prop("Amount"))	Makes expenses negative so they reduce the running total
Remaining budget per category	Formula	prop("Budget Limit") - prop("Spend vs Budget")	Shows how much room is left each month
Overspend alert	Formula	if(prop("Remaining") < 0, "Over Budget", "On Track")	Flags categories that have exceeded their limit
Savings rate percentage	Formula	round((prop("Net Savings") / prop("Total Income")) * 100) + "%"	Expresses savings as a percentage of income
Month label	Formula	format(prop("Date"),