Income, Expenses, and Tax Prep With a Notion Freelance Finance Tracker

Freelance income is lumpy, expenses are scattered across a dozen apps, and tax season arrives whether or not your records are ready. You do not need accounting software to stay on top of it. A single, well-structured Notion database will track every dollar in and out, and give you a running picture of what you actually earned. This walks through doing exactly that using the free Notable Dashboard.

Start with the free Notable Dashboard

Rather than building a finance system from a blank page, duplicate the free Notable Dashboard at getnotablenotions.com/free-template/. It gives you a Navigation hub that links out to Tasks & Projects, the Financial Tracker, Goals & Habits, a Content Calendar, Academic/Business Milestones, and Order Management. A Quick Stats row across the top surfaces Tasks Due Today, Active Goals, Monthly Revenue, and Upcoming Events at a glance.

For finance, the piece that matters is the Financial Tracker and the Monthly Revenue stat that rolls up from it. Everything below lives inside that one database, which keeps your money data in a single place instead of scattered across spreadsheets.

How the Financial Tracker is built

The Financial Tracker is one Notion database. Each row is a single transaction, described by these fields:

• Name — the title of the transaction (e.g. “Invoice #204 — Acme Co”).
• Amount — a dollar number.
• Date — when the money moved.
• Category — a select field: Groceries, Bills, Client Payment, Client, Salary, Office, Stocks, Freelance, Software.
• Type — Income, Expense, or Investment.
• Status — Completed or Pending.
• Notes — anything you will want later: invoice numbers, project names, receipt reminders.

That is deliberately simple. The power comes from tagging every entry consistently.

Logging income

When a client pays you, add a row. Set Type = Income and Category = Client Payment, put the invoice total in Amount, and set the Date to the day it landed. If the invoice is sent but unpaid, set Status = Pending so you can see outstanding money at a glance; switch it to Completed once it clears. Use the Notes field to record the invoice number and project, which saves you digging through email later.

Because the dashboard’s Monthly Revenue stat rolls up from this database, every income row you complete updates that number automatically. There is no separate report to maintain.

Logging expenses

Treat business costs the same way, with Type = Expense. A recurring design tool or your Notion subscription goes in as Category = Software. Desk supplies or a new monitor are Category = Office. Utilities and phone bills land under Bills. Keep the Amount accurate and drop the vendor or receipt location in Notes.

Consistent categories are what make expenses useful at tax time. When every deductible cost is tagged Software, Office, or Bills, you can filter the database by Category and total each bucket in minutes instead of reconstructing the year from memory.

Getting to a tax-ready picture

Two habits turn this tracker into a genuine tax aid. First, log transactions as they happen rather than in a year-end scramble; a two-minute entry beats a lost receipt. Second, use filtered views. Create a view filtered to Type = Income to see gross earnings, and one filtered to Type = Expense grouped by Category to see deductions by bucket. Your income total minus your business expenses is the net figure that flows onto a Schedule C.

A word of honesty about scope: this template does not generate tax forms or calculate what you owe. It is a clean, categorized record of your money — the raw material an accountant or filing software needs, organized the way it should be. That is most of the battle. If you are in the US and file as self-employed, set aside a portion of each Client Payment for taxes as it comes in, since nothing is withheld for you.

The Investment Type and categories like Stocks exist for tracking money you put to work rather than spend, so keep those separate from your business income and expenses to avoid muddying your freelance net.

Sources & further reading

• IRS — Self-Employed Individuals Tax Center, for what counts as income, deductible expenses, and Schedule C basics.
• Notion Help Center, for working with databases, properties, and filtered views.