Cash Flow Projection Example for Small Business

A cash flow projection turns the next few weeks into dates and decisions. It does not try to predict every sale perfectly. It asks a simpler question: after the money expected to arrive and the bills already due, how much cash should still be available at the end of each week?

That distinction matters because a business can be busy and profitable on paper while still facing a tight Friday. Payroll, inventory, rent and taxes do not wait for a customer invoice to clear. A projection helps an owner see the timing before it becomes an emergency.

Start with a realistic projection, not a perfect one

Use the actual cash available to operate, not a hopeful number. Exclude money already promised for another obligation or funds that are restricted. Then list cash receipts in the week they are likely to clear and payments in the week they are likely to leave the account.

For owners building the habit from scratch, the cash flow forecast template explains a simple weekly structure. A rolling 13-week cash flow forecast extends that view through a full quarter. This example stays short so the sequence is easy to see.

A four-week cash flow projection example

Business owner using a calendar and calculator to plan cash flow

Imagine a service business beginning the month with $15,000 in available cash. It has two customer payments that should arrive during the month, plus regular payroll, rent, supplier and operating costs. The owner lists the timing conservatively:

Week	Opening cash	Expected receipts	Expected payments	Projected ending cash
Week 1	$15,000	$3,000	$9,500	$8,500
Week 2	$8,500	$12,000	$7,000	$13,500
Week 3	$13,500	$2,500	$10,000	$6,000
Week 4	$6,000	$9,000	$8,000	$7,000

The month ends with $7,000, but that is not the main lesson. The lowest projected balance appears in Week 3. That is the week the owner needs to understand. A monthly total alone can hide that pressure point.

Build each line from a real business event

A projection is more dependable when every line has a reason behind it. For cash coming in, start with invoices already sent, card settlements that normally arrive on a known schedule, recurring customer payments and deposits that are already contracted. If a receipt depends on a proposal that has not been accepted, leave it out of the base projection. It can sit in a separate upside view until the business has enough certainty to count on the date.

For cash going out, use the calendar as well as the bookkeeping records. Payroll may happen every other Friday. Rent may leave on the first. A supplier may allow 30 days but expect payment sooner to keep an account in good standing. Taxes, insurance renewals, debt payments and annual software costs can all be easy to miss when an owner only looks at the prior month’s total. Put each obligation in the week the cash is most likely to leave, even when the expense belongs to a different accounting period.

It helps to give larger uncertain items a note beside them. A note such as “Customer confirmation pending” or “Supplier date to be discussed” makes the next action visible. The value is not in making the sheet look sophisticated. It is in knowing which assumption can change the answer, and who needs to provide the next piece of information.

Test the timing of the largest receipt

Small business owner checking invoices and customer payments

Now change one assumption. If the $12,000 payment expected in Week 2 slips to Week 4, the balance after Week 2 is only $1,500. With the same Week 3 costs, the projection falls below zero before the delayed cash reaches the account.

The work may still be profitable. The customer may still pay. But the timing has changed the decision. Instead of waiting to be surprised, the owner can check whether the customer can confirm a payment date, defer a discretionary purchase or speak with a supplier before the due date. The guide to small business cash flow problems helps separate a temporary timing issue from a deeper operating problem.

Keep a base view and a cautious view

The base view should reflect what is most likely to happen. A cautious view changes one or two assumptions that would hurt cash if they moved against the business. For example, an owner might shift the largest customer receipt out by two weeks, reduce an uncertain collection or add an urgent repair. This is not a prediction of failure. It is a way to see how much room the business has before a timing change would affect payroll, a critical supplier or another commitment.

Do not make the cautious view so pessimistic that it becomes useless. Choose the risks that are both plausible and material. If the business has a customer who often pays later than agreed, use that customer. If inventory is normally ordered before a seasonal rush, use that order. A realistic downside view is more useful than a generic stress test because it points to a decision the owner can actually make.

Use the projection to decide what matters first

Business owner organizing tax forms, a calculator and financial papers

Start with the expenses that protect the business: payroll, taxes, rent, insurance, debt commitments and the suppliers that keep work moving. Then add the variable costs, planned purchases and owner draws that meaningfully affect the balance. This is not a reason to avoid spending. It is a way to put each commitment in the correct week.

Keep the receipts honest as well. A signed contract is stronger than a new lead. An invoice from a customer who usually pays 20 days late should not be treated like cash arriving on its due date. The U.S. Small Business Administration’s finance guidance recommends monitoring business finances regularly, which is exactly what makes a projection more reliable over time.

Review the low point, then choose one action

Desk with a notebook, laptop and phone ready for planning

A helpful projection produces a specific action, not more paperwork. When the projected balance drops, ask what caused it and whether the cause is temporary. It may be a receivable that needs follow-up, a supplier payment that can be scheduled differently or a purchase that can wait until the next receipt clears.

Confirm the opening balance. Begin from the actual available cash.
Check the two largest receipts. Use realistic dates and update them when customers respond.
Find the lowest week. That is the date that needs attention, not just the final balance.
Name one response. Collect, reschedule, reduce or compare options based on a clearly defined need.

When the projection shows a short, defined gap backed by an expected receipt, it may be useful to understand invoice factoring for small businesses or a small business line of credit. Those options have different costs and repayment structures. The projection should clarify the reason for funding before an owner compares an offer.

Know when the sheet is pointing to a bigger problem

A projection can reveal a timing issue, but it can also reveal a pattern that needs more than a short-term response. If the balance keeps falling even after expected customer payments arrive, the business may be spending more than it collects over time. If the same customer is always late, the collection process or contract terms may need attention. If payroll, material costs or debt payments leave no operating buffer in ordinary weeks, the owner may need to review pricing, margins or the underlying cost structure.

That is why a projection should sit beside, not replace, regular financial review. A cash plan is best at answering when money is available. A profit and loss statement is better for judging whether the business is earning enough over time. Together, the two views help an owner avoid treating a recurring operating loss as a simple short-term gap.

Keep the projection alive each week

Replace estimates with actual deposits and payments, then add a new future week. Compare what you expected with what happened. Over time, the projection becomes more useful because it reflects the business’s real collection rhythm, expense schedule and seasonal patterns.

A short weekly review is enough for many owners: confirm the bank balance, review the next two weeks, update the largest receipts, look for the low point and decide what needs attention. For a broader plan that connects a defined need to the next step, visit the funding options overview or see how Prodigy 1 Capital works.

Frequently asked questions

What is a cash flow projection?

A cash flow projection estimates when cash is likely to enter and leave a business. It starts with available cash, adds realistic receipts, subtracts planned payments and shows the expected balance at the end of each period.

How far ahead should a small business project cash flow?

A four-week view is a practical place to begin. Many owners also keep a rolling 13-week view for a full quarter of visibility. The right horizon depends on how far ahead payroll, inventory, contracts and customer payments can be predicted with reasonable confidence.

Should projected sales go into a cash flow projection?

Only include sales when there is a realistic expectation of when the cash will clear. A quote, a hoped-for job or an invoice with an uncertain payment date should not be treated as available cash simply because it may become revenue later.

What should an owner do when a projection shows a shortfall?

First identify the specific week and cause. Confirm expected customer payments, review which costs can move without harming the business and speak with key suppliers early when timing is the issue. If the gap is short and tied to a clear repayment source, compare financing carefully after understanding the full cost and terms.

Photography sourced from Unsplash.