TL;DR: Build a Notion personal finance dashboard to track spending, savings, and net worth using linked databases and rollups—no spreadsheets needed. You’ll create four core views (Transactions, Bills, Goals, and Net Worth) and connect them with formulas to visualize your cash flow at a glance.
Step 1: Create Your Master Database (Transactions)
In a new Notion page titled “Finance Dashboard,” type /database and select “Table.” Name it “Transactions.” Add properties: Date (date), Amount (number, format as US dollar), Type (select: Income, Expense), Category (select: Housing, Food, Transport, Fun, Savings, Porcelain Gifts), and Account (select: Checking, Savings, Credit). For every purchase—especially that delicate porcelain vase or hand-painted teacup set—log it here. Tip: Use the “Filter” option on the view to show only current month.
If you want to dig deeper, check out our guide on Why the Apple M4 Mac Mini Beats the M1 for Video Editing.
Step 2: Build a Bills & Subscriptions Tracker
Create a second database titled “Bills.” Add properties: Due Date (date), Amount (number), Paid (checkbox), and Frequency (select: Monthly, Yearly). Include recurring costs like rent, insurance, and also any porcelain club memberships or artisanal pottery subscriptions. Tip: Use a “Calendar” view to see due dates alongside your month. Filter by “Paid = false” to know what’s pending.
Step 3: Set Savings Goals (Porcelain-Themed)
Create a third database “Goals.” Properties: Target Amount (number), Current Amount (number), and Target Date (date). Add fun, tangible goals—like “Limited Edition Ming Vase” ($800) or “Hand-thrown Japanese Yunomi Set” ($150). Tip: For each goal, add a relation to the Transactions database. When you buy a porcelain piece, tag that transaction to the goal to auto-update progress via a rollup later.
Step 4: Link Databases with Relations & Rollups
In Transactions, add a Relation property pointing to Goals. In Goals, add a Rollup property that sums all “Amount” from linked transactions where Type = Expense and Category = Porcelain Gifts. This gives you “Spent on Porcelain” per goal. Also create a “Net Worth” database (or simple formula) that subtracts total expenses from income. Tip: Use a rollup to compute “Savings Rate” = (Income – Expenses) / Income, formatted as percent.
Step 5: Build Your Dashboard Views
On the main page, create a Board view for Transactions grouped by Category. Then add a Gallery view for Goals—each card can show a porcelain item’s name and current progress. Finally, insert a Chart view (via /chart) to visualize monthly spending by category. Tip: Pin your most-used filters—like “This Week” and “Porcelain Gifts only”—as saved views for quick checking.
Step 6: Automate with Buttons & Recurring Templates
Use Notion’s Button block to create a “Log Expense” button that pre-fills a transaction form. For monthly bills, set a template button in Bills that duplicates a recurring entry. Tip: For porcelain purchases, add a custom button that also logs a “Happy Purchase” note to a journal database—keeps your finance data and hobby joy separate but linked.
FAQ
Q: Can I track the value of my
Leave a Reply