Accounting & Budgeting OS: Freelancer Dashboard [Template]
Advanced
|
120 minutes

Use this template

👋 Psst... you can Preview any Landmark template as a guest with the 'Preview' button below.
All blocks
>
Notion Budget & Accounting Template For Freelancers [Full 2022 System With Charts]

Notion Budget & Accounting Template For Freelancers [Full 2022 System With Charts]

Take control of your finances with this comprehensive notion budgeting and accounting system template.

Models For This Step

Financial life as a freelancer or solo business owner can be... unstable, to say the least.

In fact, one of the highest stressors reported by freelancers is ‘cashflow’, and with good reason.

There are some hard realities about freelancing which contribute to this—sometimes, the flow of clients and opportunities really does just dry up (even if you put in the same amount of effort), and sometimes luck is simply against you.

However, a large factor also comes down to financial planning. That’s not meant to be a jab at freelancers—I myself had absolutely no sense of financial planning when I was starting out (and for the first couple of years into freelancing, still, if I’m honest), and it led to real moments of panic, chronic anxiety and stress—all for little to no reason.

The truth is, if you have a skillset to offer, know where to find clients, and have set your freelance rates correctly—there’s no reason to chronically stress over money as a freelancer.

And for those of you high earners out there thinking, ‘Hey, I’m not stressed about my cashflow, I just want a cleaner system to manage my finances...’, stick around.

In this post, we’ll walk through a Notion Budgeting & Accounting template—though it’s really more of a ‘system’—to help you stay on top of:

  • Cashflow management;
  • Revenue & expenses tracking;
  • Financial goals and targets;
  • Statements and documents; and
  • Even a CRM for your paying clients.

Let’s dive in.

Budget and Accounting Dashboard

The first piece of this template system is the home dashboard. Here, you’ll see 5 charts in the right column and 2 statistics in the left-hand column.

These charts are generated from other sections and databases of the workspace, so we’ll be covering each later. The main focus here is to simply give you a quick one-glance overview of your current financial position.

In the left-hand column, you also have a menu of tabs that will help you navigate through the setup—let’s go to the first tab, ‘Cashflow’, now.

Cashflow

Cashflow is the lifeblood of any business—but it’s especially critical for solo businesses.

Why? Well, for one thing, because the financing options available to sole traders, freelancers and micro businesses are often far more limited to even the typical SME. Go to a bank looking for a loan as a freelancer and, well, good luck getting a response.

The cashflow setup of this workspace tracks:

  • Cash in bank;
  • Expenses; and
  • Income

It does so as a projection into the next 30 days. So, ‘Day 0’ will always show today’s current cash in bank, expected expenses and expected revenue. And the same holds for each of the next 30 days—giving a chart to help you view the dips, the highs and any potential ‘$0 balance’ difficulties.

This 30-day cashflow chart is generated by a linked Google Sheet. You can go into the Google Sheet and adjust the expected values by day manually. Or, if you input your revenue and expenses with a date attached, the chart will pull those values automatically.

Revenue

The revenue dashboard has 3 sections:

  • Revenue by weeks;
  • Revenue by categories; and
  • Gross revenue inputs.

This is going to be where we keep track of the money coming into our business. This can be from client projects, product sales, affiliate commissions, retainers, grants—whatever the income source, simply be sure to list it in the ‘Category’ dropdown of the Notion table.

Before we get to inputting your revenue data, let’s first take a look at the charts.

Revenue By Weeks will provide a 52-week breakdown of revenue in your business. When you work to a given salary, this chart would be incredibly boring—but for freelancers and solo businesses, it can be helpful to get an idea of the ebbs and flows of your incoming revenue across the year.

Revenue By Category, on the other hand, helps you break down your income by various sources. This can help to better understand which areas of business are bringing in the most value—and which are not.

Revenue inputs can be made in the Notion table/database at the bottom of the page. You’ll notice a few fields for inputs:

  • Name
  • Amount
  • Category
  • Due
  • Quantity
  • Rate
  • Client/Owner
  • Project
  • Project Value

Each revenue input should be given a ‘name’ to help you know what its referencing. It should also be given a ‘category’—by default, the categories in the dropdown include: ‘Services/Project’, ‘Retainer’, ‘Product’ and ‘Other’. Feel free to adjust these tags as best suits your business.

Giving each revenue item a ‘due’ date is important. For items that you’ve already received, simply input the date that it was received. For those that are based in the future, do your best to input the date you expect to receive the payment—this will be important for the Cashflow and other charts.

By default, the table is setup to list revenue items as a ‘quantity’ * ‘rate’. This lets you list all sorts of revenue sources, from product sales to high-value projects. Further, if you want to list the item by ‘hourly rate’, you can list your rate and the number of hours spent on a project—then the ‘amount’ column will automatically fill with the correct value.

The ‘Client/Owner’ field is a rollup property—you won’t be able to fill that directly. Instead, when you fill the ‘Project’ field, it will automatically lookup the owner of that project from the linked CRM. Same with the ‘Project Value’ amount.

More about Projects and the CRM later though...

Expenses

The expenses dashboard is similar to the revenue dashboard, showing a few charts in the top section, then providing a table for inputs at the bottom.

This guide is still be written. Stay posted for the remaining content in the coming days.

clarity os

Your whole business in one place.

This template is part of our integrated solo business workspace: Clarity OS.

No more flipping between tabs, repeating entries and losing track of how it all fits together--keep your business in one place with Clarity.

Learn more about Clarity OS
🎉  Block added
Oops! Something went wrong while trying to save this block.
👋 To save this block to your dashboard, you'll need a member dashboard first. You can create yours here, free.

(If you already have an account, you might not be logged in: you can log-in here to save this block to your dashboard)
Oops! Something went wrong while trying to save this block.
Next block in this ability stack →

Related articles

No items found.
Privacy Policy