Cash Flow Forecasting for Small Businesses: How to See a Shortfall Before It Happens

A profitable business can still run short of cash.

That may sound contradictory, but it happens all the time. You complete work, send invoices, and see revenue on your Profit & Loss statement. Meanwhile, payroll, supplier bills, loan payments, and other obligations are leaving your bank account before customers pay.

The result is a stressful question: “How can the business be doing well if there is not enough cash?”

Cash flow forecasting helps answer that question before it becomes an emergency. Instead of looking only at today’s bank balance, you create a reasonable picture of the money expected to come in and go out over the next several weeks.

For many growing businesses, a 13-week cash flow forecast is a practical place to start.

If you need a broader overview, visit SociaTax’s cash-flow resource hub. You can also review our guide to understanding your business numbers.

What is cash flow forecasting?

Cash flow forecasting is the process of estimating when money will enter and leave your business in the future.

A forecast focuses on cash timing: not just sales, revenue, or profit.

For example, a plumbing company may complete a large commercial repair this week but not receive payment for 30 days. The revenue may appear in the accounting records before the cash reaches the bank. A cash flow forecast shows that timing gap.

A forecast usually includes:

• Opening cash: The cash available at the beginning of the period
• Expected money in: Customer payments and other expected receipts
• Expected money out: Payroll, vendors, rent, insurance, taxes, loan payments, and other obligations
• Net cash movement: Expected money in minus expected money out
• Closing cash: Opening cash plus net cash movement

The basic formula is:

Opening cash + expected money in − expected money out = closing cash

Your closing cash for one week becomes the opening cash for the next week.

A forecast is different from a historical cash flow statement. A cash flow statement explains what already happened. A forecast helps you plan for what may happen next.

How to build a 13-week cash flow forecast

You can build a basic cash flow projection in a spreadsheet. The goal is not to create a complicated financial model. The goal is to make upcoming cash needs visible.

Step 1: Start with verified opening cash

Begin with the actual cleared balance in your business bank accounts.

Do not rely only on an unreconciled QuickBooks balance or an estimate from memory. Include the cash that is genuinely available, while being careful not to count funds that are restricted, already committed, or held for another purpose.

If you have multiple business bank accounts, decide whether your forecast will include all of them or only the account used for regular operating expenses. Be consistent.

Step 2: List expected money in

For each of the next 13 weeks, list the cash you reasonably expect to receive.

Possible sources include:

• Customer invoice payments
• Credit card or payment processor deposits
• Recurring service payments
• Retainer payments
• Loan proceeds
• Owner contributions
• Refunds or other expected receipts

Use the expected payment date, not simply the invoice date.

If a customer invoice is due on the 15th but that customer regularly pays several days late, your forecast should reflect the payment timing you actually expect. A conservative forecast is usually more useful than one based on best-case assumptions.

You can separate expected receipts into categories such as “committed,” “likely,” and “uncertain.” That makes it easier to see which parts of the forecast deserve caution.

Step 3: List expected money out

Next, record when cash is expected to leave the business.

Include both regular and occasional payments:

• Payroll and payroll-related payments
• Subcontractor payments
• Materials and inventory
• Rent and utilities
• Insurance
• Vehicle and equipment costs
• Software subscriptions
• Loan payments
• Taxes and other required payments
• Planned equipment purchases
• Owner draws or distributions

For a field-service business, also consider timing around busy seasons, materials for scheduled jobs, vehicle repairs, and subcontractor commitments.

Put each payment in the week when it is expected to leave the bank account. A bill received this week may not be paid until next week. That distinction matters.

Step 4: Calculate net cash movement

For each week, subtract expected money out from expected money in:

Expected money in − expected money out = net cash movement

A negative number does not automatically mean the business is failing. It may reflect a planned equipment purchase, a seasonal slowdown, or a large annual insurance payment.

The important question is whether you know about the negative movement early enough to plan for it.

Step 5: Calculate the closing balance

Add the net cash movement to the opening cash:

Opening cash + net cash movement = closing cash

Then carry that closing balance into the following week as the new opening cash balance.

Here is a simplified example. The figures below are illustrative only and do not represent an actual business.

Week	Opening cash	Expected money in	Expected money out	Net cash movement	Closing cash
Week 1	$24,000	$18,000	$21,500	$(3,500)	$20,500
Week 2	$20,500	$12,000	$19,000	$(7,000)	$13,500
Week 3	$13,500	$27,000	$16,000	$11,000	$24,500
Week 4	$24,500	$15,000	$29,000	$(14,000)	$10,500

In this example, the plumbing company is not necessarily unprofitable. The business may simply have a large payroll, supplier payment, or other obligation arriving before the next group of customer payments.

The forecast gives the owner time to investigate the timing and decide what action is appropriate.

Step 6: Update it every week

A 13-week forecast is most useful when it becomes a rolling tool.

At the beginning of each week:

1. Replace last week’s estimates with actual results.
2. Update expected customer payment dates.
3. Add new bills, payroll changes, or planned purchases.
4. Add one more future week to keep the forecast at 13 weeks.
5. Compare the forecast with the actual bank balance.

This process helps the forecast become more realistic over time.

Three common cash flow forecasting mistakes

1. Treating invoices as cash

An invoice is not the same as a deposit.

A marketing agency may send $20,000 in invoices at the beginning of the month. If clients pay on different schedules, the full $20,000 should not automatically be placed in the first week of the forecast.

Forecast the money when you expect to receive it. If a payment date is uncertain, consider using a more conservative assumption.

This is one reason it is important to understand profit versus cash flow. Profit may reflect work completed or revenue earned, while cash flow reflects when money actually moves.

2. Forgetting irregular or annual payments

Many cash shortfalls are caused by expenses that do not occur every week.

Examples include:

• Annual insurance premiums
• Equipment purchases
• Vehicle repairs
• Loan principal payments
• Tax payments
• Licensing or renewal fees
• Seasonal inventory purchases

Review your prior year’s bank activity and payment calendar for expenses that may not appear in a normal monthly budget.

3. Using an unreliable opening balance

A forecast cannot be more accurate than its starting point.

If your bank accounts are not reconciled, customer payments are missing, or bills have not been entered, the forecast may show more available cash than the business actually has.

Before relying on the projection, make sure your bookkeeping is current enough to support the decision. Reviewing your Balance Sheet can also help you identify unpaid invoices, credit card balances, loans, and other obligations that affect cash.

Suzy’s perspective: “One of the biggest mistakes I see is waiting until the bank balance feels uncomfortable before looking ahead. A simple forecast gives owners more time to make thoughtful decisions.”

What to do when the forecast shows a shortfall

Seeing a projected low point is useful information. It gives you an opportunity to investigate before the shortfall arrives.

Start with these steps:

1. Confirm the numbers. Check the opening balance, expected customer payments, payroll, vendor bills, and upcoming obligations.
2. Review customer collections. Identify overdue invoices and confirm realistic payment dates.
3. Separate essential from discretionary spending. Review planned purchases, subscriptions, marketing expenses, and other costs that may be delayed or adjusted.
4. Talk with key vendors early. Payment terms may need to be discussed before a payment is missed.
5. Review planned hiring, equipment, or expansion decisions. A forecasted shortfall may change the timing of a purchase.
6. Ask your CPA, bookkeeper, lender, or financial adviser about appropriate options. The right response depends on your business and circumstances.

Do not wait until the projected cash balance reaches zero to begin planning. The earlier you understand the timing problem, the more choices you may have.

Forecasts are planning tools: not guarantees

A cash flow forecast is an estimate based on the information available today. Customers may pay late. Expenses may change. A repair may be more expensive than expected. Sales may be higher or lower than planned.

That does not make forecasting pointless. The value is in creating a working plan, updating it regularly, and watching how assumptions change.

You can also create different versions:

• Expected case: Your most reasonable projection
• Conservative case: Customer payments arrive later or expenses run higher
• Growth case: Sales or hiring increase faster than expected

Scenario planning can help you understand how a decision — such as adding a technician, purchasing a vehicle, or accepting a large job — could affect available cash.

For a broader review process, use The 3 Financial Reports Every Business Owner Should Know. A forecast looks forward, while your P&L, Balance Sheet, and Cash Flow Statement help you understand what has already happened and where the business stands today.

Frequently asked questions

How far ahead should a small business forecast cash flow?

A 13-week cash flow forecast is a practical short-term view for many growing businesses. It is long enough to show upcoming payroll cycles, vendor payments, loan obligations, and major purchases while remaining close enough to current operations to update regularly.

How often should I update a cash flow forecast?

Update it at least weekly if cash is tight, the business is growing quickly, or payment timing changes frequently. A monthly update may be sufficient for some businesses with more predictable cash activity.

Is a cash flow forecast the same as a budget?

No. A budget typically estimates revenue and expenses over a longer period. A cash flow forecast focuses on the timing of actual money coming in and going out of the bank.

Why can my business be profitable but still show a cash shortfall?

Profit and cash are different measurements. Customers may not have paid invoices yet, or the business may have used cash for equipment, inventory, loan principal, or owner distributions.

Do I need special software to create a forecast?

No. A spreadsheet can be enough to begin. The most important factors are accurate starting cash, realistic payment timing, complete upcoming obligations, and consistent updates.

The bottom line

Cash flow forecasting gives you a clearer view of what may happen next: not just what happened last month.

Start with:

• Your verified opening cash
• Expected customer payments
• Payroll, vendor, and other upcoming payments
• Weekly net cash movement
• Closing cash for each of the next 13 weeks

Then update the forecast as reality changes.

If your reports are difficult to trust, your customer payments are not being tracked consistently, or your cash position is unclear, SociaTax can help you build a more structured financial reporting process. Contact SociaTax to discuss how accurate bookkeeping and timely reporting can give you better information for business decisions.

This article is general educational information, not individualized tax, legal, payroll, or financial advice. A forecast is a planning tool and cannot guarantee future cash results.