Notion Tutorial: Build a Personal Finance Dashboard in 15 Minutes

Written by

in

TL;DR: You can build a personal finance dashboard in Notion in about 15 minutes by creating a single database for transactions, adding summary views, and linking rollups into a dashboard page. Follow the steps below to track income, expenses, and net worth without spreadsheets.

Step 1: Create the Transactions Database

Open a new page and type /database to insert an inline database. Name it “Transactions.” Add these properties: Date (Date), Description (Title), Category (Select), Type (Select: Income/Expense), Amount (Number, currency format), and Account (Select). Add 5–10 sample rows so your formulas have data to work with.

If you want to dig deeper, check out our guide on How the Viral Crocs Jibbitz Trend Is Reshaping Sneaker Cultu.

Step 2: Build Summary Views

Create a second database called “Monthly Summary.” Add properties: Month (Title), Income (Rollup), Expenses (Rollup), and Net (Formula). In the Rollup properties, select the Transactions database, relate by Month, and sum the Amount where Type equals Income or Expense. Use the formula prop(“Income”) – prop(“Expenses”) for Net.

Step 3: Assemble the Dashboard

Create a top-level page called “Finance Dashboard.” Add linked views of Transactions filtered to “This Month,” a gallery view of Monthly Summary, and callout blocks for your top three spending categories. Use /callout for quick notes like savings goals.

Step 4: Add Tips for Speed

Use templates inside the Transactions database for recurring entries like rent or salary. Color-code the Type select property (green for income, red for expenses). Pin the dashboard to your sidebar with the star icon for one-click access. Set a weekly reminder to update entries.

FAQ

Q: Do I need a paid Notion plan?
A: No. Rollups, formulas, and linked databases work on the free personal plan.

Q: How do I connect bank transactions automatically?
A: Notion has no native bank sync; use a CSV import or a third-party automation tool like Zapier.

Q: Can I track multiple accounts?
A: Yes. Add an Account select property and filter or group views by account on your dashboard.

Related Articles

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *