How to create Transactions tracker in Notion

notion image
In the previous lesson, we learned to create a property portfolio to help us manage our properties. In this lesson, we will learn how to create a simple but powerful dashboard for all our transactions in one place. I use this setup in my personal workspace to manage all my real estate transactions, including rent, maintenance, and remodeling transactions. Let's review ouк problems and try to find a solution for them before setting our goals.
There are a few common problems with managing real estate transactions:
  • It can get difficult to find the source of income and expenses because they’re spread out across various documents and databases.
  • It is hard to keep track of where your money is going, and you might miss something important.
  • There’s no way to see an overview of all the transactions for your properties in one place. Instead, you have to look through each property individually, which can be time-consuming.
In order to create a great transaction managing tool we to achieve the following:
  • Create a database for transactions
  • Be able to easily add a new transaction/template.
  • Be able to quickly see an overview of your transactions in one place – the income, expenses, and balance. This will help you know exactly where your money is going!
Let me take you by hand and show you how I am building my databases for iManage! so you can replicate it in your workspace.

Create a new inline/page database.

The first step is to create a new database. To do this, type “/database” anywhere in your workspace. Select a “Database - Inline” object and give this database a name (for example "My Transaction"). Remember that you can always come back and change this later.
notion image

Create the following columns for your database

You want to create as many columns as you find useful. Here are some ideas of the columns and types you can add:
  • Amount (Number - US Dollar) e.g $1,500
  • Type (Select) e.g. Income
  • Date (Date & time) e.g 5/1/21
  • Tags (Multy-select) e.g. Rent, Maintenance
  • Property (Relation) e.g. 1092 Preston Street
  • Description (Text) e.g. May rent from Luis Mendez
  • Account (Text) e.g. personal checking
  • Contact (Text) e.g. Luis Mendez
  • Taxes (Text) e.g. Illinois 2022
  • Status (Select) e.g. Paid
  • Any other fields you want
notion image

Fill Out Data

Next, you need to fill out your database with data. To do this, import all your transactions into the database. Use corresponding tags and types. Feel free to add and modify anything you want in the process. This will help you keep track of your transactions and see them in a different way.
A good way to get started is by including:
  • The date of the transaction
  • The type of property
  • An address or description
  • The amount
notion image

Create Templates for each transaction type

After you’ve filled out your database with data, you can create templates for later use. To do this, click “New Template” on a blue button. Pre-select default values for this template, give it a proper name, and that's it!. Repeat for all property types.
Here are some examples of what templates you can create for the transaction database:
  • Rents
  • Maintenance
  • Association Fees
  • Insurance
  • Taxes
  • and more...
notion image

Create Database Views

Lastly, you can create database views. This will help you see your data in a different way and make it easier to find what you’re looking for. To do this, click “Add View”. Name a view, select view type, add custom filters/sort. Repeat for all views.
Here are some examples of the different types of views you can create:
  • Income
  • Rents
  • By Date
  • By Type
  • By Property
  • By Status
  • Calendar
  • ...and more
notion image

And that’s it! Now you know how to create a Transaction database in Notion.

Want to get more lessons? Follow me on Twitter (@IanDikhtiar)