FreelanceScope: Solo Consultant Revenue & Pipeline Tracker

A lightweight planning tool that turns a solo consultant's opportunities and active projects into a weekly revenue forecast, capacity view, and client concentration warning.

Internal ToolProfessional ServicesMonthly or annual solo subscription.
MVP time4-6 weeks
DifficultyBeginner to intermediate
Infra cost$7-$90
RevenueSubscription
Review the decision summary
12,474 views
Updated August 2, 2026

Decision snapshot

Is this worth validating?

Build this if

Solo consultants can track work but cannot connect pipeline timing to delivery capacity and client risk.

Avoid this if

The real need is team CRM, accounting, time tracking, or automated bank reconciliation.

Validate first

Have 10 consultants enter their live 90-day book and compare the tool's forecast, capacity, and top-client share with their own manual calculation.

Problem and target customer

Why this exists

Customer problem

Independent consultants often keep sales leads, signed projects, delivery dates, and cash expectations in different sheets or notes. They cannot see whether a promising month is double-booked or whether too much future revenue depends on one client.

Who pays

Independent consultants and fractional specialists who sell project-based work and personally manage both sales and delivery capacity.

Business model

Low-cost monthly subscription with an annual solo plan.

Editorial note

The dashboard should help one person make a Monday decision, not imitate an enterprise CRM. Forecast timing, booked delivery days, and client concentration belong together because each can make an apparently healthy pipeline misleading.

Every number should remain inspectable. Stage probability is an editable assumption, capacity comes from project allocations, and concentration states its date range and denominator. That transparency matters more than predictive sophistication.

Choose your next step

What do you need next?

Evaluate the operating tradeoffs quickly, or inspect how to build the MVP.

Evaluate this ideaSee the cost and deployment preview

Compare the three operating paths at the default workload before opening the full calculator.

See cost preview Build this ideaInspect the build blueprint

Review MVP scope, workflow, states, data rules, architecture, and acceptance criteria.

Open blueprint

Evaluation preview

What would it take to run?

Directional infrastructure estimates for the current 500 pipeline updates assumption. Open the full calculator when you are ready to change it.

Open full cost and deployment
ManagedSelected
$5-$35/ month

Railway hosts the application and PostgreSQL database.

Lowest operating effort
Lean self-hosted
$7-$20/ month

A Hetzner cloud server runs the app and database.

Lowest baseline cost
More control
$25-$90/ month

Dedicated or larger resources isolate reporting and transactional load.

Most separation and control

Build blueprint

Build the first paid use case

Product goal

Who it serves and what it must change

Target user
A solo consultant reviewing sales and delivery commitments each week.
Problem
Pipeline value looks healthy in isolation but does not reveal timing, delivery capacity, or dependency on one client.
Measurable outcome
A pilot consultant can answer expected revenue, unallocated delivery days, and largest-client exposure for the next 90 days from one screen.

MVP scope

What ships now and what waits

Included

  • Track clients and opportunities with amount, stage, probability, expected close, and delivery window.
  • Convert won work into projects with booked days and expected invoice dates.
  • Calculate weighted monthly revenue, remaining weekly capacity, and client concentration.

Excluded

  • Accounting reconciliation and tax reporting.
  • Time tracking, invoicing, and payment collection.
  • AI forecasting or multi-user CRM management.

UX and user flow

Screens, actions, and states

Weekly Outlook

Show weighted revenue, committed work, capacity gaps, and concentration alerts for 90 days.

Change horizonOpen riskAdd opportunity
Pipeline

Move opportunities through explicit stages and edit probability, value, and expected dates.

Update stageAdjust probabilityMark won or lost
Capacity Plan

Place project days on weeks and expose overbooking or unused capacity.

Allocate daysMove delivery windowInspect client share

Primary flow

  1. The consultant records a qualified opportunity with expected value and delivery dates.
  2. Stage changes update the weighted forecast using editable probabilities.
  3. Winning the opportunity creates a project and carries value into the delivery plan.
  4. The weekly outlook recalculates capacity and client concentration for the selected horizon.

Loading, empty, and error states

  • Opportunity: lead, qualified, proposal, won, lost
  • Project: planned, active, complete, canceled
  • Invoice expectation: planned, issued, paid, overdue

Core entity outline

Entities and business rules

Client

Groups opportunity, project, and revenue exposure for one customer.

Fields
name, status, risk_note
Relations
Has opportunities and projects
Opportunity

Stores sales stage, amount, probability, close date, and proposed delivery window.

Fields
client_id, stage, amount, probability, expected_close, delivery_start, delivery_end
Relations
May create one project
Project

Represents won work, booked delivery days, and expected billing schedule.

Fields
client_id, opportunity_id, fee, starts_at, ends_at, status
Relations
Has weekly allocations and invoice expectations
WeeklyAllocation

Records planned consulting days for a project in one week.

Fields
project_id, week_start, days
Relations
Contributes to capacity totals

Business rules

  • Weighted revenue equals amount multiplied by the current stage probability and is labeled as a forecast, not booked revenue.
  • Winning an opportunity may create only one project and removes it from weighted open pipeline.
  • Client concentration uses confirmed project fees in the selected horizon and shows the denominator.

Architecture and data flow

Components, integrations, and controls

Planning application

Serve pipeline, outlook, capacity, and settings views.

Forecast service

Calculate weighted revenue, weekly load, and concentration from persisted records.

Relational database

Persist clients, opportunities, projects, allocations, and stage history.

Integrations

  • CSV export for accountant or backup
  • Optional Make intake from a qualified lead form after validation

Data flow

  1. Each edit writes the source record and recalculates affected forecast buckets.
  2. A won transition creates a linked project idempotently in one transaction.
  3. The dashboard reads precomputed weekly aggregates with a visible last-calculated timestamp.

Failure handling

  • Keep the edit form populated after validation errors
  • Roll back the won transition if project creation fails
  • Show stale-data status and recalculate action if aggregate refresh fails

Security

  • Encrypt commercially sensitive values at rest
  • Require reauthentication before account export or deletion
  • Never share one consultant's client names in benchmarks

Rate limits

  • Limit import and export jobs
  • Throttle repeated forecast recalculation
  • Cap login attempts

Deliverables and acceptance

Definition of done for the MVP

Deliverables

  • Responsive private dashboard
  • Pipeline and project forms
  • Forecast and capacity calculations
  • CSV export
  • Calculation test fixtures

Acceptance criteria

  • Changing an opportunity probability updates the correct month without altering confirmed revenue.
  • Marking an opportunity won creates one project even after a repeated request.
  • Allocating more days than weekly capacity creates a visible conflict tied to the affected projects.
  • If aggregate calculation fails, source records remain saved and the user can retry from a stale-state notice.

Recommended stack

Enough technology for the first version

Application

Next.js and TypeScript

A single private app is enough for forms and planning charts.

Database

PostgreSQL

Relational links preserve forecast and project conversion integrity.

Charts

Recharts

Simple time-series and concentration views need no analytics platform.

Auth

Auth.js

The solo account needs secure sessions and export protection.

Why this is sufficient

Transparent arithmetic is the product. A small relational monolith makes every dashboard number traceable to an opportunity, project, or allocation and avoids unnecessary AI or analytics infrastructure.

Not required for the MVP

LLM APIWorker queueObject storagePayment processor
Next stepTurn the blueprint into an execution plan

Copy the build prompt, model the operating cost, and choose where to deploy.

Build and ship

Execution

Build, price, and deploy the MVP

Once the blueprint is clear, use the prompt, cost model, and deployment options to start building.

Build prompt

Copy this into a builder

Use a TypeScript monolith with PostgreSQL; calculate forecasts and concentration deterministically from user-entered amounts, dates, probabilities, and capacity rather than using AI.

Build prompt

Your build prompt is ready

Open the prompt pack whenever you are ready to take this blueprint into your builder.

Based on the blueprintReady for your builderFollow-up steps included

Cost calculator

Model the MVP operating cost

A technical run-cost estimate for the first production version. Team, acquisition, payment fees, and business COGS are excluded.

Estimated monthly total$5-$35

$5-$35 per 500 pipeline updates

Pipeline updates / month500 pipeline updates
Selected pathEasiest
Pricing checkedAug 2, 2026

Usage assumptions

Use beta workload metrics when available.

Infrastructure approach
Railway hosts the application and PostgreSQL database.
Cost breakdown

$5-$35 per month

Low and high values allow for usage variance and plan headroom.

Managed app

Railway hosts the application and PostgreSQL database.

2K pipeline updates included, then $2-$8 per 2K pipeline updates
$5-$35

Included

  • Application and database compute
  • Forecast calculations
  • Basic backups within the chosen path

Not included

  • Payment processing
  • Accounting software
  • Customer support labor
  • Marketing
  • Custom analytics

Pricing basis

The estimate combines the selected infrastructure path, required operating modules, selected optional modules, and usage above included monthly allowances. Taxes and regional uplifts are excluded.

Railway pricing

Deployment options

Pick the operational tradeoff

Choose based on operating preference, not only the headline price.

EasiestRecommended

Railway

Deploy the private app and database with minimal setup.

$5-35/month

Good fit

  • Fast setup
  • Managed runtime
  • Simple backups

Limitation

Resource pricing exceeds a tiny VPS at stable low usage.

Open Railway
Cheapest

Vultr

Run the app, worker, and database on one small Vultr VPS with Docker Compose and explicit backups.

$7-20/month

Good fit

  • Low baseline
  • Portable
  • Predictable

Limitation

You own patching, backups, and monitoring.

Deploy on Vultr View the lean VPS guide
More control

DigitalOcean

Separate application, worker, data, storage, and backup responsibilities as the workload grows.

$25-90/month

Good fit

  • Isolation
  • Private network
  • Custom backups

Limitation

Overbuilt for the first solo-consultant pilot.

Explore DigitalOcean View the separated cloud guide

Start building

Prototype, automate, then deploy

Recommended route
01Vibe-coding builderPrototype the Monday planning view

Use Lovable to test opportunity entry, weekly forecast, capacity timeline, and concentration alerts with solo consultants.

Open Lovable 02AutomationAdd optional intake capture

Use Make later to turn a qualified website form into a draft opportunity; all amounts, stages, and probabilities remain consultant-controlled.

Open Make 03DeployDeploy the private planning tool

Host the app and PostgreSQL database together for a simple, low-maintenance solo workspace.

Open Railway

Keep exploring

Related ideas

Internal ToolReal Estate

Real Estate Lead Pipeline CRM

A focused CRM for agents to qualify property inquiries, schedule the next contact, move opportunities through deal stages, and see overdue follow-ups.

MVP time6-8 weeks
Cost$7-$165
DifficultyIntermediate
9.9k views 3.3k likes
Explore idea

Internal ToolEvents & Community

MissionBoard: Campaign Operations Hub

A shared operations hub for small nonprofits and ministry teams to coordinate campaigns, reconcile contributions and volunteer work, and report outcomes.

MVP time5-7 weeks
Cost$7-$105
DifficultyModerate
12k views 1.4k likes
Explore idea