Notion Finance Tracker, Made Easy

If you're looking for a simple and effective way to track your personal and/or business finances, Notion is a great option. Notion is a powerful productivity tool that can be used for a wide range of purposes, including tracking your finances.

In this article, I’ll show you how to build your own aesthetic Notion finance tracker, step by step. We'll also provide you with a free Notion template that you can duplicate to get started right away.

‍

Why Use Notion for Your Finances?

Notion is a great choice for tracking your finances because it's highly customizable. You can create your own finance tracker that's tailored to your specific needs and preferences. Notion also makes it easy to organize your finances, so you can see all of your accounts, transactions, and budgets in one place. If you're a freelancer, entrepreneur or startup, you can also link your Invoices database to your Finance Tracker system.

‍

How to Build Your Own Notion Finance Tracker

Here are the steps to building your own Notion finance tracker:

‍

Setup

Set up your Notion page: Create a new page in Notion and call it "Finance Tracker." This is the parent page for all your databases.

‍

Build your expense tracker

‍

Add a new Notion database to your page. Select “Table” view and name your database “Expenses”.

Then, add the following properties:

1. Name (title): it’s the name that appears on your bank statements
2. Amount: set up the currency of your choice (click the “123” button on the left)
3. Date: set up the date format (click the date, then click “date format & timezone”)
4. Type: create different expenses categories (subscription, taxes, freelancer, etc.)
5. Notes: if you want to add notes to specific transactions

‍

Build your income tracker

‍

Add a new Notion database to your page. Select “Table” view and name your database “Income”.

Then, add the following properties:

1. Name (title): it’s the name that appears on your bank statements
2. Amount: set up the currency of your choice (click the “123” button on the left)
3. Date: set up the date format (click the date, then click “date format & timezone”)
4. Type: create different income categories (salary, freelancing, digital products, etc.)
5. Notes: if you want to add notes to specific transactions

‍

In the content of each income or expense cards, you can add notes to give more details about the transaction.

‍

Monthly reports

‍

Add a new Notion database to your page. Select “Gallery” view and name your database “Months”.

Then, add the following properties:

1. Relation to Income (2-way relationship)
2. Relation to Expenses (2-way relationship)
3. Rollup that gets the Sum of all Income
4. Rollup that gets the Sum of all Expenses
5. Balance formula that calculates the difference between Income & Expenses
6. Labels (text): Income, Expenses & Balance
7. Formulas that get the data from the Income & Expenses rollups (they will be used for the Years database, but should be hidden in the Months database)

‍

‍

Now, go to the database templates, and create a new one:

1. Add a linked view of the Income database
2. Filter that view by “Month” contains “Name of the current template” (”Untitled, if you haven’t changed it)
3. On the same block, add a new view of the Expense database. Apply that same filter.
4. Fill out the Labels properties such as “Label income” equals “Income”, “Label expenses” equals “Expenses”, & “Label balance” equals “Balance”
5. Add this template to be used by default

‍

‍

Finally, you need to select which properties you want to display in the gallery view:

1. In the database settings, set “Card preview” as “None”
2. In the properties section, display in that order: Label income, Income, Label expenses, Expenses, Label balance, Balance.

‍

Yearly reports

‍

Replicate the same process as for the Months database, with a few exceptions:

1. Add a relation property to Months instead of Expenses & Income
2. Extract the total sums of Income, Expenses & Balance using rollups
3. No need to create formulas out of the rollups, as we're not going to aggregate this data into another database
4. Don’t forget to add the same labels

‍

Build your own tracking dashboard

‍

The layout that I found works the best, and that is aesthetic, is using columns to separate these four databases.

First, add two columns and drag and drop the Months database to the left, and the Years database to the right. Drag the column to right as you’ll need more space for Months than for years.

Then, add two new columns beneath: drag the Income database to the left, and the Expenses database to the right. Leave them bot the same space as their length is quite the same.

That’s it! You now should have a cool-looking dashboard.

‍

Free Notion Template

‍

To help you get started, I’ve created a free Notion template that you can use to manage your life and business finances with ease. Simply click the link below to download the dashboard and duplicate it into your Notion workspace:

‍

Notion Finance Tracker Template

‍

Conclusion

With Notion, tracking your finances & managing your money has never been easier. By following the steps above, you can create your own customized, aesthetic finance tracker that will help you stay on top of your finances and achieve your financial goals.

If the process feels too complicated, you can still use the free Notion template I provided!

Start now & create your Notion account 🙃
(#NotionPartner)