View all posts

How to Track your Net Worth in Notion

How to track your current and historical net worth and account balances in Notion with Finta.

Screenshot of tracking Net Worth in Notion

April 25, 2023

Notion
How To

What is Net Worth and Why Does it Matter?

Net worth is a measure of your financial health. Essentially, it's the difference between what you own (your assets) and what you owe (your liabilities). It's what you would have left over if you sold everything you own and paid off all your debts.

Knowing your net worth is important for several reasons. Most importantly, it gives you a comprehensive picture of your financial situation. This can help you make better decisions about how to manage your money and plan for your future.

How to Calculate Your Net Worth in Notion

To calculate your net worth, you need to add up the value of all your assets and subtract the value of all your liabilities. Assets can include things like your home's value, car, investments, and savings accounts. Liabilities can include things like your mortgage, car loan, student loans, and credit card debt.

Account Balance Data

You could manually check all of your bank accounts and enter their balances into Notion, or you can use Finta to sync this data automagically every day. To get started:

  1. Sign up - try us out for 7 days no credit card needed
  2. Connect your bank accounts - We partner with Plaid to securely connect to your accounts.
  3. Create a destination - Copy one of our many Notion budgeting templates

Account Table Formulas

Next, let's add two helpful formulas to the accounts table.

First, create a new formula column "Is Asset?" with the following formula:
or(prop("Type") == "depository", prop("Type") == "investment")
Formula for calculating if an account is an asset

This field will be checked for all asset accounts and unchecked for all liability accounts

Next, create another formula column "Net Worth" with the following formula:

if(prop("Is Asset?"), prop("Current"), -prop("Current"))
Formula to calculate an account's net worth impact

This field will return the account balance as a positive number if the account is an asset and a negative number if the account is a liability.

Finally, sum the "Net Worth" column to calculate your total net worth!

Accounts table with a column for net worth

Visualize Your Net Worth in Notion

In addition to tracking your net worth, it can also be helpful to visualize your account balances. Although Notion doesn't have a built-in chart feature, you can use Finta to create and embed charts right within your doc. published

Pie chart of account balances by account type

Tracking Net Worth Over time

Once you have calculated your net worth, you can track it over time to see how your financial situation is changing. For example, during your monthly financial review, jot down the total value of your assets, your total liabilities, and your calculated net worth. After awhile, you’ll be able to see how these numbers change over time.

Table of historical account balances Chart of net worth over time

Ideally, you want your net worth to increase, which means you are building wealth and becoming more financially secure.

Overall, knowing your net worth is an important part of maintaining good financial health. By understanding your assets and liabilities and tracking your net worth over time, you can make informed decisions about your finances and work toward your long-term financial goals.

Ready to start syncing your financial data to Notion?

Get Started with Finta