Most small business owners know their business is profitable — roughly. They have a sense that more is coming in than going out. They check the bank balance when they need to make a significant purchase. They pull numbers together at tax time and are sometimes surprised by what they find.
That “roughly” is the gap this template closes. The Business Finance Tracker gives you a precise, real-time picture of your revenue, expenses, cash flow, and profitability — without accounting software, without a bookkeeper, and without a spreadsheet that requires an hour of maintenance every time you need to add a row.
This is a full walkthrough of what the template contains, how each section works, and how to set it up in a single afternoon.
The Business Finance Tracker template is available at createdigitaltools.com. To use it you need a Notion workspace — create your free account here.
The Business Finance Problem Notion Solves
The finance management tools available to small businesses exist on two extremes. At the simple end: a spreadsheet or a notes app where income and expenses are listed. Flexible but hard to query, easy to break, impossible to analyse without significant manual effort. At the complex end: accounting software like Xero or QuickBooks. Powerful but expensive, designed for accountants, overkill for businesses that do not need double-entry bookkeeping or bank reconciliation.
Between those extremes — a structured database system that tracks every transaction, automatically calculates summaries, lets you analyse by category and time period, and surfaces the information you actually need to make business decisions — there is a gap. The Business Finance Tracker fills it.
It is not accounting software. It does not replace your accountant at tax time. It does give you a real-time financial dashboard that makes you a better-informed business owner every day — and makes the information your accountant needs much faster to compile when they need it.
What the Template Covers
Two core databases — Revenue and Expenses — connected by shared category and date properties to a central dashboard. Six pre-built views in each database. A monthly summary page that calculates profit, margin, and cash position automatically. A tax preparation view that exports everything your accountant needs. And a source analysis view showing which revenue streams are performing and which expense categories are growing.
The Revenue Database: Every Pound In
One row per revenue transaction. Properties: Description (title — what the payment is for), Client (Relation to your Clients database if you have one, or a text field), Revenue Type (Select: Client Payment, Retainer, Product Sale, Affiliate Income, Consulting Fee, Licence Fee, Other), Amount (number, currency), Date (when received), Invoice Reference (text), VAT Collected (number — for businesses that charge VAT), and Net Amount (formula: Amount minus VAT Collected).
The Revenue Type property is the most important in this database. It enables the income source analysis that tells you whether your business is growing in the right directions. A business that is increasing total revenue but seeing retainer income decline while one-off project income rises is a different business than it appears from the top-line number. The Revenue Type breakdown makes that pattern visible.
Views: This Month (filtered to Date = current month, sorted by Date descending), By Client (grouped by Client, with Sum calculations on Amount showing revenue per client), By Revenue Type (grouped by Type with Sum on Amount), and All Revenue (unfiltered, complete record). The This Month view with its Sum calculation at the bottom gives you current month revenue in one glance.
The Expense Database: Every Pound Out
One row per expense transaction. Properties: Description (title), Supplier (text), Category (Select: Salaries and Contractors, Software and Subscriptions, Marketing and Advertising, Professional Services, Office and Equipment, Travel and Accommodation, Training and Development, Insurance, Bank Charges, Other), Amount (number, currency), Date, Payment Method (Select: Bank Transfer, Credit Card, Direct Debit, Cash), Tax Deductible (checkbox), VAT Paid (number), and Net Amount (formula: Amount minus VAT Paid).
The Category property drives the expense analysis. Month over month, the category breakdown shows you where costs are growing fastest. Software and Subscriptions tends to creep upward invisibly — thirty small monthly charges that nobody individually questions but collectively represent a significant overhead. The By Category view with Sum calculations makes this visible and actionable.
The Tax Deductible checkbox is the property that earns its place at tax time. Every expense marked as Tax Deductible appears in the Tax Ready filtered view — a clean list your accountant can use directly, with amounts, dates, descriptions, and VAT already separated. What takes most small business owners an afternoon of spreadsheet archaeology becomes a five-minute filtered view export.
The Cash Flow View: The Number That Actually Matters
The Cash Flow page is a linked view showing both Revenue and Expenses transactions sorted by date, with the running balance calculated at each point. This is the view that answers the question most business owners actually want answered: on any given day, was more coming in than going out, and by how much?
The monthly cash flow summary — total revenue minus total expenses for each month — is shown as a bar chart using Notion’s built-in chart view. Months where expenses exceeded revenue appear as negative bars. The pattern over twelve months tells you more about the health of your business than any single month’s number does in isolation.
The Income Sources Analysis
The By Revenue Type view in the Revenue database, with Sum and Percent of Total calculations enabled on the Amount column, shows the revenue mix at a glance. Retainer income as a percentage of total revenue is one of the most important metrics for a service business — it tells you how predictable your revenue base is. A business where sixty percent of revenue comes from retainers has a fundamentally different risk profile than one where sixty percent comes from one-off project fees.
Filter this view by date range to see revenue mix in any specific period. Compare the current quarter to the same quarter last year. See whether the revenue mix is shifting in the direction you intended — more retainers if that was the goal, more product sales if that was the strategy.
The Expense Category Breakdown
The By Category view in the Expense database shows total spend per category for any filtered time period. Enable the Percent of Total calculation to see each category as a proportion of total expenses. This breakdown is the foundation of expense management: you cannot reduce costs without knowing where they are.
Filter by the current month and compare to the previous month to see which categories are growing. Filter by the current year and compare to last year’s total to see overall expense trajectory. The data is all there — the views just present it in different configurations depending on what question you are trying to answer.
The Monthly Summary Dashboard
The Monthly Summary page is the most-referenced page in the template for business owners who check their numbers regularly. It shows: Total Revenue This Month (linked Sum from Revenue database), Total Expenses This Month (linked Sum from Expense database), Net Profit (formula: Revenue minus Expenses), Profit Margin (formula: Net Profit divided by Revenue multiplied by 100), and YTD Revenue and YTD Expenses (year-to-date figures from wider-filtered linked views).
Every number on this page is live — calculated automatically from the underlying transaction databases. Open it on the first of any month and you see the previous month’s complete financial picture without preparing a report. Open it mid-month and you see the current month’s running totals. The business owner who checks this page once a week has a better understanding of their business finances than one who reviews a monthly P&L from an accountant six weeks after the period ends.
The Tax Preparation View
Two filtered views built specifically for tax preparation. The Deductible Expenses view filters the Expense database to Tax Deductible = true, showing all deductible expenses for the tax year with amounts, dates, categories, and VAT paid — the exact information an accountant needs. The VAT Summary view shows all VAT collected on revenue and VAT paid on expenses, with Net VAT Liability calculated automatically for VAT-registered businesses.
Neither view eliminates the need for professional tax advice — but both eliminate the manual work of compiling that information, which is typically where small business owners spend most of their tax preparation time.
Connecting to Your Other Business Databases
The Revenue database can link to a Clients database through a Relation property — making each revenue entry traceable to its source client. Add a Rollup to the Clients database summing Total Revenue per client and you have an automatic client value ranking. The most valuable clients bubble to the top of a sorted view without any manual analysis.
The Expense database can link to a Projects database — making project costs traceable and enabling per-project profitability analysis. A Rollup on the Projects database summing project-specific expenses, combined with a Rollup summing project-specific revenue, gives you an automatic profit and loss per project. Knowing which projects are your most profitable, not just your largest in revenue, changes how you prioritise new business.
The Daily Finance Habit
The template works when every transaction is logged the day it occurs. Not at the end of the week. Not at the end of the month. The day it happens. This takes two to three minutes per transaction and the discipline is the difference between a real-time financial dashboard and a historical ledger that tells you what happened rather than what is happening.
The habit is easiest to maintain when logging is frictionless. Keep the template bookmarked or pinned at the top of your sidebar. Set a daily reminder if that helps. Log each transaction immediately when you receive a payment or make a purchase — before the receipt gets lost and the memory of what it was for fades. Two minutes now versus thirty minutes reconstructing it from bank statements later.
When to Move Beyond This Template
This template handles business finance well until the point where you need bank reconciliation (matching transactions to bank statements automatically), payroll management, multi-currency support, or integration with accounting software for statutory reporting. At that point, Notion becomes an input tool feeding proper accounting software rather than the primary finance system.
For most businesses under one million in annual revenue with a single currency, straightforward expense categories, and an accountant who handles statutory compliance, this template covers everything needed for day-to-day financial management and decision making. The move to accounting software is a growth milestone — something to plan for rather than implement prematurely.
The Business Finance Tracker template is available at createdigitaltools.com. If you are running a project-based business and want project-level profitability tracking alongside the business-level overview, combining it with the Freelance Management System gives you both layers of financial visibility in one connected workspace. Start with a free Notion account here.
Disclosure: This post contains affiliate links. If you sign up for Notion through the links in this post, we may earn a small commission at no extra cost to you. The Business Finance Tracker is our own product and we have a financial interest in recommending it — but everything written above reflects how the template actually works.
0 Comments