Running a solo business usually means your work is scattered everywhere: tasks in one app, content ideas in your notes, client details in your email, money in a spreadsheet you forget to update. The problem is not discipline. The problem is that a one-person business has no "operations team" — so the system has to do that job.
This guide shows a simple Notion setup built around five databases and one dashboard that covers projects, content, clients, money, and reviews. It takes about an hour to build, and a weekly 30-minute review keeps it alive.
The principle: one home for everything
Solo operators don't need more tools; they need fewer places to look. Every piece of work in your business should answer three questions at a glance:
- What is it?
- What state is it in?
- What happens next?
The five databases below are designed so that any item — a task, a post, a client, an invoice — can be described that way.
Database 1: Projects & Tasks
Your execution list. Properties:
- Name (title)
- Status: Inbox → Next → Doing → Done
- Area: Product / Content / Clients / Admin / Money
- Due date
- Energy: Low / Medium / Deep work
The key view is a board grouped by Status, filtered to hide Done items older than a week. Your rule: anything in "Doing" for more than 7 days gets finished, delegated, or deleted. As a solo operator, you are the bottleneck, and this view makes the bottleneck visible.
Database 2: Content Pipeline
Every post, video, newsletter, and article moves through the same stages:
Idea → Drafting → Editing → Scheduled → Published
Add properties for Platform, Publish date, and a Repurpose checkbox. The repurpose habit is where solo creators win: one strong idea should become a post, a short video script, and a newsletter section. A calendar view of this database becomes your publishing schedule — no separate social media planner needed.
Database 3: Clients & Leads (CRM)
A lightweight CRM beats a "real" CRM for one-person businesses because you'll actually keep it updated. Properties:
- Name / Company
- Stage: Lead → In conversation → Proposal sent → Active → Past client
- Last contact (date)
- Next step (text)
- Value
Create a view filtered to "Last contact more than 14 days ago." That single view is your follow-up system, and follow-ups are where most freelance revenue hides.
Database 4: Money Tracker
Track Income and Expenses in one database with an Amount, Type, Category, and Date. Roll the amounts up on your dashboard by month. You don't need accounting software to answer the only three money questions that matter weekly:
- What came in this month?
- What's still owed to me?
- What did I spend to earn it?
Database 5: Weekly Reviews
One page per week, created from a template with four prompts:
- What shipped this week?
- What made money (or moved toward money)?
- What is stuck, and why?
- What are the 3 priorities for next week?
This database feels optional until week three, when it becomes the reason the other four stay current. The review is the operating rhythm of the whole system: 30 minutes, same time every week, no exceptions.
The dashboard that ties it together
Create one page — your daily home — with linked views:
- Today: Tasks with Status = Doing or Due today
- This week: Content scheduled in the next 7 days
- Money this month: Income rollup from the Money Tracker
- Follow-ups: Clients untouched for 14+ days
- Latest weekly review
Open this page every morning instead of your inbox. Your business, on one screen, in under a minute.
Common mistakes to avoid
- Building before using. A beautiful system you don't open daily is worthless. Build the ugly version, use it for two weeks, then improve it.
- Too many properties. Every property is a small tax on every entry. If you haven't used a field in a month, delete it.
- Separate systems per project. One database with an Area filter scales; five separate workspaces don't.
- Skipping the review. The weekly review is not admin — it's the meeting where you are both the CEO and the team.
Want the whole system pre-built as a step-by-step guide?
If you'd rather follow a complete walkthrough than assemble this from scratch, I put together Solo Creator OS — a 25-page step-by-step build guide that walks you through this exact system in your own free Notion workspace: the dashboard layout, all 5 databases with every property and view, copy-paste page templates, the weekly review system, and the operating rhythm to keep it running in 30 minutes a day.
👉 Get Solo Creator OS ($19): https://miyoshiwork.gumroad.com/l/lojdi
More tools for solo creators and freelancers — AI prompts, freelance templates, and new systems every week — are at https://miyoshiwork.gumroad.com
Top comments (0)