A Simple Cash Flow Forecast for a One-Person Service Business

If you run a one-person service business, you have probably had the same small panic more than once: it is mid-month, two invoices are sitting unpaid, a tax bill is on the calendar, and you cannot quite remember whether you are about to be flush or about to be tight. The bank balance tells you what happened, not what is coming. That gap — between what is in your account today and what it will look like in three weeks — is where most of the stress in a solo business actually lives.

A cash flow forecast does not solve the late client or the surprise expense. What it does is convert a fog of vague worry into a few specific dates, dollar amounts, and decisions. You stop asking, "Can I afford this?" and start asking, "In which week does this fit?" Once that shift happens, the forecast becomes the most reliable tool a one-person business can own — not because it is fancy, but because it is honest with you on a regular schedule.

This post walks through a forecast simple enough to build in a single afternoon and disciplined enough to keep working a year from now. We will cover what a forecast really is, the four columns you actually need, how to estimate income when half your clients pay late, how to handle taxes and irregular bills, the weekly rhythm that keeps the model honest, and the warning signs to watch for. By the end, you will have a template you can open every Friday and know, within reason, what the next thirteen weeks look like.

What a Cash Flow Forecast Actually Is (And Is Not)

A cash flow forecast is a week-by-week estimate of money coming in and money going out, anchored to your real bank balance. It is not a profit-and-loss report — that lives in accrual accounting and tells you whether your business is profitable on paper. A forecast is built in cash terms: an invoice counts on the day the money lands in your account, not the day you send it. That distinction matters for solo operators because most late-payment pain comes from the gap between when work is delivered and when cash arrives.

It is also not a budget, and not a prediction in the fortune-teller sense. A good forecast is a confidence-weighted plan: some rows are near-certain (a recurring retainer), others are guesses. The point is not to be right; it is to be specific enough that you notice when you are wrong, and then quickly recalibrate.

The Four Columns You Actually Need

There is an entire genre of finance content that wants to sell you a 47-tab spreadsheet. Resist it. The working forecast lives in four columns: the week, the cash you expect to receive, the cash you expect to pay out, and your projected ending balance. That is enough to answer every question that actually matters in solo operations.

Set up rows for the next thirteen weeks, dated by Friday. Thirteen weeks is long enough to see a quarterly tax bill coming and short enough that the numbers stay grounded in your real pipeline. Above the first week, write your current bank balance — the one showing right now, not the one from two days ago.

• Column A: Week ending date (every Friday for thirteen weeks).
• Column B: Expected cash in (invoices likely to clear that week, retainers, refunds).
• Column C: Expected cash out (rent, software, taxes set-aside, owner draw, contractor payments).
• Column D: Projected balance (previous balance + B − C).

That is the entire model. Every other column — confidence percentages, client names, category tags — is optional polish. Build the four core columns first, populate them with real numbers, and only add complexity later if the simple version genuinely fails to answer a real question.

How to Estimate Income When Half Your Clients Pay Late

The honest answer to "when will this invoice be paid?" is rarely the due date. According to a widely cited Intuit QuickBooks survey, more than half of U.S. small businesses regularly deal with unpaid invoices, with the average outstanding balance reaching about $17,500 per business (see the AOL summary at https://www.aol.com/news/client-wont-pay-practical-guide-133506766.html). The fix is not to be more optimistic; it is to be more specific about who pays when.

Open your last six months of paid invoices and group clients into three buckets. "Reliable" clients pay within five days of the due date — slot them in the week payment is expected. "Typical" clients pay 7 to 21 days late — slot them two weeks after the due date. "Slow" clients run 30 days late or more — slot them three to four weeks after. The buckets are imperfect on any single invoice but remarkably accurate over a quarter.

For new clients, default to "typical" and adjust after their first cycle. For pipeline you have proposed but not signed, leave it out of the cash-in column entirely; a signed contract with a deposit counts, a hopeful conversation does not. If the slow bucket has more than three clients in it, that is signal worth acting on. A predictable cadence of friendly nudges — a few days before due, the day after, then once a week — pulls most invoices back into the typical bucket without damaging the relationship.

Handling Taxes, Irregular Bills, and the Once-a-Year Surprises

Most solo cash crunches are not caused by ordinary expenses. They are caused by predictable-but-forgotten ones: a quarterly estimated tax payment, an annual software renewal, a professional license, the accountant's bill in February. None are surprises; they are things you knew about and did not write down. The forecast fixes that by giving them a specific week to live in.

Walk through the next twelve months and list every bill that fires less often than monthly. Drop each amount into the week it is due. Then, for taxes, add a recurring line that moves a fixed percentage of every deposit into a separate "Tax Set-Aside" sub-balance — 25 to 30 percent of net income is a common U.S. starting point, but use whatever your accountant suggests. The point is not the percentage; it is that the money is invisible to your spending balance the moment it arrives.

Treat your owner draw the same way. Pick a weekly or biweekly amount, transfer it on a fixed day, and let the forecast tell you when that day is coming. A scheduled draw turns "how much can I take this month?" into a calm, repeating answer.

The Friday Update Ritual That Keeps the Model Honest

A forecast that is not updated weekly is a museum exhibit. The discipline that makes the model worth keeping is short, repeatable, and on the same morning every week. Friday works well: most banking activity from the week has cleared, and you have a quiet hour before the weekend. Block thirty minutes. Open the spreadsheet.

• Update the current bank balance to today's actual number.
• Move any invoices that paid this week from the "expected" column to a "received" log.
• Reslot any invoices that did not pay — push them out by their bucket's typical delay.
• Add any new invoices you sent or contracts you signed this week.
• Re-read the next four weeks. If any week's projected balance dips below your minimum, take one action — send a reminder, defer a non-essential expense, or call a client — before closing the file.

That last step is the entire return on investment of the practice. The forecast surfaces one decision per week that quietly compounds into stability over a quarter.

The Three Numbers to Watch Every Week

Once the model is running, a small dashboard at the top keeps signal out of noise. Three numbers do most of the work.

First, your minimum projected balance over the next eight weeks — the lowest your account is expected to dip. If it is at or below your floor, action is needed and you can see it weeks before it arrives. Second, unbilled work in progress: hours or milestones already delivered but not yet invoiced. If that number is creeping up, cash is being trapped in your own admin — the cure is to send invoices on the day work is delivered, not at month end. Third, overdue receivables aged by bucket. If the slow-bucket total grows week over week, your follow-up rhythm is the lever, not your pricing.

For a deeper playbook on the follow-up side, our guide on writing a friendly first reminder pairs neatly with this forecast: https://duedropin.com/blog/how-to-write-first-payment-reminder-email-without-damaging-relationship/. And on why clients pay late despite good intentions: https://duedropin.com/blog/why-friendly-payment-reminders-outperform-firm-ones/.

When the Forecast Says "You Have a Problem in Three Weeks"

The most useful days of running a forecast are the ones where it warns you about a shortfall before it happens. The instinct in those moments is to close the sheet, but the forecast is doing exactly what it was built to do: giving you a runway long enough to make a calm, professional decision instead of a frantic one.

Three weeks of warning means you have time to send a polite check-in to two reliable clients about upcoming work, defer a software upgrade, ask a slow-bucket client whether a small partial payment is possible by Friday, or pause a discretionary expense. None of those moves require panic. All of them buy you the runway to keep your invoicing and follow-up tone steady — exactly the tone that protects long-term client relationships.

If the gap is structural rather than a single late invoice — four straight months where the model keeps warning you — that is data about pricing or client mix, not a forecasting problem. If a gentler, automated follow-up rhythm is part of how you take stress off your plate, DueDrop sends polite, on-time reminders for invoices already issued by your existing billing tool, which can pull a chunk of your slow bucket back into the typical bucket without you writing a single email.

Frequently Asked Questions

How often should a one-person business update its cash flow forecast?

Weekly is the right cadence for most solo service businesses. A monthly update is too slow to catch a single late invoice that throws a particular week off, and a daily update creates more anxiety than insight. A thirty-minute Friday block — same time every week — is the version most solo operators actually keep up with for more than a quarter.

Do I need accounting software to build a useful forecast?

No. A plain spreadsheet works perfectly well, and starting there often forces a clearer understanding of your numbers than a tool that auto-fills the cells for you. Graduate to an automated tool only after you have earned the intuition by hand for a quarter.

How far ahead should I forecast?

Thirteen weeks is the working sweet spot — long enough to see a quarterly tax bill or seasonal slowdown, short enough that the numbers stay anchored to clients you can name. A twelve-month version is useful for annual planning, but should be a separate, lower-resolution view.

What is the right minimum cash buffer?

A common rule of thumb is one month of fixed personal and business expenses, with three months as the more comfortable target. Write down your floor and treat any week that dips toward it as a prompt for one specific decision.

What if my income is wildly inconsistent month to month?

The forecast is even more valuable for inconsistent businesses, because it makes the lumps visible weeks ahead instead of as month-end shocks. Keep your owner draw at a steady, modest amount and let the business account absorb the variability.

The Calm Version of Knowing What Is Coming

A cash flow forecast does not change how much money your business makes. What it changes is how much of that money you are aware of, and how soon. The bank balance tells a story about last week; the forecast tells the story about next month. When you have both on the same page every Friday morning, running a one-person business stops being a series of surprises and starts being a sequence of decisions you have plenty of time to make well.

Take aways to keep close to the spreadsheet:

• Build four columns — week, in, out, balance — and resist the urge to add more until you have run the simple version for a full quarter.
• Bucket clients by how they actually pay, not by their due dates. Reliable, typical, and slow are enough.
• Move tax money into a separate sub-balance the day each deposit lands; treat it as already gone.
• Update on the same morning every week. Thirty minutes, one decision per session.
• Watch three numbers: minimum projected balance, unbilled work in progress, and the slow-bucket aging total.
• When the forecast warns, act early and quietly. The whole point of the model is to give you that runway.

You can build the first version this afternoon. The hard part is not the math — it is committing to the Friday ritual. Do that for one quarter and the forecast stops being a chore; it starts being the thing that lets you run the business on calm instead of caffeine.