The Freelancer Finance Dashboard in Notion
"Am I actually profitable?" is the question every freelancer should be able to answer in ten seconds. With a Notion finance dashboard, you can. Here's how to build one that pulls real numbers from your income and expense data — automatically.
Step 1: Keep an Expense database
Before a dashboard, you need inputs. Create an Expense database with: Date, Category (Software, Marketing, Equipment, Tax set-aside, Other), Amount, and a Relation to Projects if you want project-level costing.
Step 2: Create a "Monthly Finance" summary
Make a database where each row is a month (January, February…). Use Rollups to pull totals:
- Income — Rollup summing the Income database's Amount for that month.
- Expenses — Rollup summing the Expense database's Amount for that month.
- Net Profit — a Formula:
prop("Income") - prop("Expenses"). - Target Income — a Number you set per month.
Step 3: Add a progress bar
With a Formula like round(prop("Income") / prop("Target Income") * 100) you get a clean percentage. Pair it with Notion's progress bar display to see, at a glance, whether you hit your goal. Green when you're over, red when you're behind.
Step 4: Review on the 1st
Make it a ritual. The first of every month, open the dashboard, read last month's net profit, and decide: raise rates? cut a subscription? pitch three more clients? One page turns vague anxiety into a clear number and a clear next move.
Don't build it by hand?
The Finance Dashboard above — 8 expense categories, monthly rollups, net-profit formulas, and a target bar — is built into Freelancer OS. Duplicate it and your first-of-month review takes thirty seconds.
Get the dashboard + 4 more systems
Freelancer OS ships the Finance Dashboard, CRM, Project Tracker, Income log, and Time tracker — linked and ready.
Get Freelancer OS — $19Related: How to Track Income & Invoices in Notion · Notion vs Spreadsheets for Freelancers