Small Business Cash Flow Forecast: A 30 Day Worksheet

A small business cash flow forecast is useful when it connects accounting records to the next operating decisions. The goal is not to predict every surprise. It is to make expected cash in, expected cash out, and the timing gap visible before the checking balance becomes the only warning signal.

The U.S. Small Business Administration guidance used here supports six practical building blocks. It does not guarantee future cash availability or identify every cost variance as waste. The worksheet below keeps that boundary clear and turns the official guidance into a repeatable review.

Start with the balance sheet

SBA guidance explains that a balance sheet can help a business track capital and build a cash flow projection for future years. In a working forecast, use the current balance as a starting point, then separate confirmed obligations from estimates that still depend on customer payment or a management decision.

This source position does not establish that a balance sheet alone predicts liquidity. PATech editorial analysis: the practical failure usually begins when a team copies one accounting total into a forecast without checking when the related cash will actually move.

Worksheet line	Question to answer
Opening cash	What balance is available at the start of the review window?
Expected receipts	Which customer payments have a documented date?
Expected payments	Which obligations fall inside the same window?
Decision reserve	What amount must remain available for a slow period?

Separate sales channels before comparison

SBA guidance also notes that separating and analyzing business segments, such as online and face to face sales, can provide financial insights. The useful move is to preserve the channel distinction in the forecast instead of combining every sale into one monthly total.

PATech editorial analysis: compare each segment with the timing of its receipts, refunds, delivery costs, and operating demands. This does not prove which channel is more profitable. It creates a cleaner basis for asking why two channels with similar sales may create different cash pressure.

• Keep each sales channel on its own line.
• Record the expected receipt date, not only the sale date.
• Mark estimates that still depend on customer action.
• Review the largest timing assumptions first.

Use a thirty day warning window

An SBA cash flow example describes a thirty day forecast that combines the checking balance with expected receivables and payments to warn of an upcoming shortage. That horizon is an operating review window, not a promise that all listed cash will arrive.

The failure point is often an untested date. A receivable listed inside the window can look like available cash even when the customer has not confirmed payment. Label the assumption, assign an owner, and update it when the underlying evidence changes.

A positive forecast can guide decisions about when to order inventory and how much cash to save for slow periods. It does not automatically authorize either action. Treat the forecast as decision support and keep the final choice with the business owner.

Classify expenses and timing

SBA guidance groups expenses into development, operations, recurring, and nonrecurring categories. Using those categories helps the owner see whether money in and money out form a sustainable profit and loss view rather than a pile of unrelated transactions.

Cash and accrual accounting also record the same sale at different times. Accrual accounting records the sale when it is completed, while cash accounting records it after payment is received. The forecast should state which timing basis each line uses.

1. Update opening cash.
2. Confirm receipts and payment dates.
3. Review expenses by category.
4. Flag the earliest possible shortage.
5. Record the owner and next review date.

Turn the worksheet into a control

PATech editorial analysis: a forecast becomes operational when the same person updates it on a defined cadence, exceptions have owners, and each decision points back to a visible assumption. A spreadsheet with no review ritual is only a snapshot.

PATech offers an Automation Audit to map this workflow before any automation is proposed. That is a service description, not a guarantee of savings, accuracy, or financial performance. The immediate objective is simpler: create one evidence based view of cash timing that the owner can inspect and revise.