Notion Income and Expense Tracker: A Practical Guide for Freelancers
Freelance finances get messy because they rarely arrive in neat monthly blocks. One client pays a deposit, another pays late, a subscription renews quietly, and three receipts sit in a bag until tax season starts breathing down your neck.
Notion can help by giving everything a clear place: expected income, paid invoices, overdue payments, expenses, recurring costs, receipts, invoice files and useful context from working time records. It is not accounting software, and it does not replace proper tax records, HMRC reporting requirements or professional advice. But as an organisational layer, it can make freelance money much easier to see and manage.
The aim is simple: build a practical system that shows what is coming in, what has already arrived, what is still owed, and what the work is costing to run.
How to Build a Notion Income and Expense Tracker
A useful freelance finance setup does not need to be elaborate. In fact, the best Notion systems are usually boring in the right way. They hold the same facts every time, so reviewing them takes minutes rather than mental gymnastics.
At minimum, create four connected areas:
Income records Expected income, invoices sent, payment status and amounts received.
Expense records Business purchases, subscriptions, travel, tools, materials and other costs.
Finance files Receipts, invoices, statements, agreements and proof of payment.
Review views Simple filtered pages for unpaid invoices, this monthās income, this monthās expenses and recurring costs.
This gives you a lightweight notion income and expense tracker without trying to turn Notion into a bookkeeping system. The difference matters. Notion is excellent for visibility, planning and gathering documents. Accounting software or a qualified accountant may still be needed for formal accounts, tax calculations, VAT, Making Tax Digital obligations, payslips, company filings or HMRC submissions.
A good rule: use Notion to understand your freelance finances during the month, then use your proper accounting process to report them accurately.
Set up income records so you can see what is expected, paid and outstanding
Start with an `Income` database. Every row should represent one invoice, expected payment or billable project milestone. This keeps your income view practical, especially if clients pay in stages.
Here are the core fields worth adding:
Field | Type | Why it helps |
Client | Select or relation | Shows where income is coming from |
Project | Text or relation | Connects payment to the work |
Invoice number | Text | Helps match records to invoice files |
Invoice date | Date | Shows when the request was issued |
Due date | Date | Makes overdue payments visible |
Expected amount | Number | Shows what should arrive |
Amount received | Number | Shows what has actually landed |
Payment status | Select | Use Expected, Invoiced, Paid, Part-paid, Overdue |
Payment date | Date | Confirms when money arrived |
Finance file | File or relation | Links the invoice or proof of payment |
Notes | Text | Useful for client payment details or follow-ups |
For example, a freelance designer might add an income record for a Ā£1,200 brand identity project. The client pays 50% upfront and 50% on completion. That could be one record marked `Part-paid`, with Ā£1,200 expected and Ā£600 received, or two separate records: `Deposit` and `Final payment`. Separate records are usually clearer if the payments have different due dates.
A consultant on a monthly retainer might create one income record per month. A copywriter working on ad hoc projects might create one record per invoice. The structure should match how the money actually arrives.
The most useful views are:
Outstanding payments Filter where payment status is not `Paid`.
Overdue invoices Filter where due date is before today and payment status is not `Paid`.
Income this month Filter by payment date or expected date.
Income by client Group by client to see where revenue is coming from.
Do not overcomplicate the status options. Five clear statuses will beat fifteen vague ones every time.
Organise expenses by category, business purpose and evidence
Next, create an `Expenses` database. This is where many freelancers either go too light or far too detailed. The sweet spot is enough detail to understand the cost and find the proof later.
Use fields like these:
Field | Type | Why it helps |
Date | Date | Records when the cost happened |
Supplier | Text | Shows who was paid |
Category | Select | Groups similar costs |
Amount | Number | Records the cost |
Payment method | Select | Helps reconcile with statements |
Business purpose | Text | Explains why the cost exists |
Recurring | Checkbox | Flags repeat costs |
VAT included | Checkbox or number | Useful if relevant to your setup |
Receipt or file | File or relation | Keeps evidence attached |
Reimbursable | Checkbox | Marks costs to recharge to a client |
Client or project | Relation | Connects the cost to paid work |
For categories, keep them plain. Try:
Software and tools
Subscriptions
Travel
Equipment
Training
Marketing materials
Professional services
Office supplies
Client costs
Miscellaneous
A photographer might log a memory card as equipment, a train fare for a client shoot as travel, and a gallery hire fee as a client cost. A consultant might log a paid research report under training or professional resources, depending on how they organise their records. A web developer might log hosting test environments as software and tools.
For freelancer expense tracking, the most useful habit is attaching evidence as soon as possible. Upload a receipt, invoice PDF or screenshot directly to the record, or link it from a finance files database. If you leave all receipts until January, Notion will not rescue the afternoon. It will only give you a better place to put them once you start.
A simple weekly routine works well:
Add new expenses from bank activity.
Attach missing receipts.
Mark anything reimbursable.
Check whether client-related costs have been added to the next invoice.
Review any unusually high costs before they become normal.
This is also where Notion can help with judgement. Seeing six small subscriptions in one filtered view is often more persuasive than a vague feeling that money is leaking somewhere.
Manage recurring costs, files and working time as supporting context
Recurring costs deserve their own view, even if they live inside the same expenses database. Freelancers often underestimate them because no single payment feels dramatic. A few tools, insurance, memberships, storage, hosting, templates, training libraries and admin services can quietly become a fixed monthly load.
Add fields such as:
Field | Type | Why it helps |
Renewal frequency | Select | Monthly, quarterly, yearly |
Renewal date | Date | Shows when the next charge is due |
Essential | Checkbox | Separates must-have from nice-to-have |
Cancel by | Date | Gives time to review before renewal |
Notes | Text | Records why the cost exists |
A good recurring cost view might show:
Costs renewing in the next 30 days.
Annual subscriptions due this quarter.
Non-essential costs above a chosen amount.
Tools linked to no current service or project.
Supporting financial documents should also have a home. You can attach files directly to income and expense records, but a separate `Finance Files` database can be cleaner if you handle lots of documents.
Useful fields include:
File type Invoice, receipt, statement, contract, proof of payment.
Related income or expense Link the file to the relevant record.
Date Use the document date, not the upload date.
Tax year Helpful for finding records later.
Notes Keep explanations short and practical.
Working time records can add useful context too. This does not need to become a full time-tracking setup. A simple record of date, client, project, hours and work type can help explain income patterns.
For example, if a Ā£2,000 project took 52 hours rather than the expected 25, the income record alone will not show the problem. Linking it to working time gives a clearer picture. It can also help compare retainer value, spot underpriced tasks and understand why a busy month did not produce much profit.
The key is restraint. Track enough time to make better decisions, not so much that admin becomes a second job.
Review your finances with a simple weekly and monthly rhythm
A tracker only works if it gets reviewed. The point is not to admire a tidy database. The point is to catch issues early.
Set up a `Finance Review` page in Notion with linked views from your income and expense databases. Keep it focused.
For a weekly review, include:
Invoices to send Work completed but not yet invoiced.
Payments due soon Invoices with due dates in the next seven days.
Overdue payments Anything past due and unpaid.
New expenses Costs added this week.
Missing files Records without receipts or invoice attachments.
This review can take 15 minutes if the system is current. It gives you a practical answer to the questions that matter: who owes money, what has been paid, what needs chasing, and whether any costs need attention.
For a monthly review, add a little more reflection:
Question | What to check |
Did expected income arrive? | Compare expected amount with amount received |
Are any clients regularly late? | Review overdue records by client |
Which costs increased? | Group expenses by category |
Are recurring costs still useful? | Review renewals and essential status |
Which projects were profitable? | Compare income, expenses and working time |
This is where a Notion finance tracker earns its keep. A freelance editor might notice that rush jobs look profitable until weekend working time is included. A coach might see that one marketing channel creates costs but no matching income. A maker or creative professional might spot that materials need to be priced more carefully into quotes.
Use Notion for clarity and decisions. Use your accounting process for accuracy, compliance and submission.
Know where Notion ends and accounting begins
Notion is flexible, visual and easy to adapt to the way freelance work really happens. That is its strength. It can help track freelance income and expenses in one place, with the surrounding context that typical finance records often miss.
But it has limits.
Notion should not be treated as a replacement for accounting software, tax compliance, statutory records, VAT processes, payroll, formal accounts or HMRC reporting. It will not judge whether an expense is allowable, calculate tax correctly for every situation, or make sure submissions are completed according to current rules. This guide is for general organisation only, not financial or tax advice.
A sensible setup looks like this:
Use Notion for | Use proper accounting support for |
Planning expected income | Preparing formal tax records |
Tracking paid and unpaid invoices | Calculating tax and VAT correctly |
Storing receipts and finance files | Meeting HMRC reporting requirements |
Reviewing costs and subscriptions | Filing accounts or returns |
Linking work, time and money | Getting advice for your situation |
That split keeps Notion useful and keeps the risks in the right place.
If you prefer to build from scratch, start with two databases: income and expenses. Add files, recurring cost views and working time records once the basics are working. A simple system used every week is far better than an elaborate one abandoned after the first burst of enthusiasm.
If you want the same structure already built inside Notion, BrainyShackās Income & Expenses System is designed as a Notion-native option for tracking income, expenses, recurring costs, finance files and working time in one place. It is still an organisational tool, not accounting software, but it gives the core structure without needing to design every database and view yourself.
For a ready-built setup, take a look at BrainyShackās Income & Expenses System.
Comments