Guide · My Expenses

How to track expenses in Notion

Quick answer

To track expenses in Notion, create a database with four properties: Name, Amount (Number, formatted as currency), Category (Select) and Date. Add a view filtered to this month and run a calculation on Amount for the total. It's flexible but slow on a phone; My Expenses is faster for logging on the go.

Updated 2 min readGambit Studio

Build it step by step

  1. Create a new page and add a database in Table view (Notion's default view).
  2. Rename the first column Name (what you bought).
  3. Add Amount as a Number property and format it as currency.
  4. Add Category as a Select property with your categories.
  5. Add Date as a Date property.
  6. Add a view filtered to this month and use the Amount property's calculation option for the total.
  7. Group the view by Category to see each category's subtotal.

Notion's help describes Number ("can also be formatted as currency"), Select ("useful for categorization"), Date and Formula properties, and says the property menu lets you run calculations (Notion Help). Databases can also be shown as a calendar (Notion Help).

Useful extras

  • A Formula property for the month, so you can group by month.
  • A Calendar view on Date to see spending by day.
  • A Checkbox "Planned?" to spot impulse buys.

Limits

  • Adding an expense on a phone takes several taps.
  • Charts by category need extra work.
  • Very large databases get slower.

Faster on the phone

My Expenses, by Gambit Studio, is built for this part: you log amount, description, category and date in seconds, and its charts show each category's share of the month and how it compares with last month. Some people log in the app during the day and review in Notion or a expense spreadsheet at month's end.

Sources

  1. Notion Help: Intro to databases
  2. Notion Help: Database properties

Frequently asked questions

What people ask most about this, answered with the source.

Can you track expenses in Notion?
Yes. A database with Amount, Category and Date properties, a monthly view and a calculation on Amount works as an expense tracker.
How do I make an expense tracker in Notion?
Create a table database, add Amount (Number, currency), Category (Select) and Date, then add a monthly view with a total.
Is Notion good for budgeting?
It's flexible for reviews and plans, but slow for logging each purchase on a phone.
My ExpensesWhere's My Money? Easy Control
Get