A cash flow forecast does not need fancy software or a finance degree to earn its keep. It needs a current starting balance, honest dates for money expected in and out, and a habit of being updated. This example shows how a small service business can use a four-week view to spot a pressure point early.
The business below is fictional. The method is not. The IRS explains that a sound recordkeeping system should clearly show income and expenses and include a summary of business transactions. Those records give a forecast something dependable to stand on. The IRS recordkeeping guidance is a helpful reference when the source records themselves need attention.
Meet the example business
Imagine a small design-and-installation business, Cedar Studio. It begins the month with $18,000 in its operating account after the latest bank reconciliation. The owner has two outstanding customer invoices, a recurring monthly client payment, payroll every other Friday, regular vendor bills, rent, software, insurance, and an estimated tax payment due this month.
The owner knows the work pipeline looks healthy. That is not quite the same as knowing there will be enough cash on the dates it is needed. One customer is expected to pay a $9,000 invoice in week three, while payroll and the tax payment are both due earlier. The forecast puts those facts in the same place.
Step 1: Start with the bank balance you can trust
Cedar Studio starts with $18,000, not the balance from a stale bank feed and not the total value of invoices sent. A forecast can be only as good as its opening number. If the books and bank do not match, reconcile first or mark the forecast as provisional until the difference is understood.
This is also why sales and cash should be kept separate in the owner’s mind. An invoice may represent completed work, but it is not available to pay a bill until the customer pays it. Likewise, a loan principal payment can reduce bank cash even though it is not an ordinary operating expense on the profit and loss statement.
Step 2: List receipts by the date they are likely to arrive

For this example, the owner does not count every quoted project as cash. The forecast includes only a $4,000 recurring-client payment expected in week one, a $6,500 invoice expected in week two, a $9,000 invoice expected in week three, and a $3,500 deposit expected in week four. Each amount has a realistic date beside it.
That conservative choice matters. A customer who usually pays 30 days after invoicing should not be forecast as if they will pay tomorrow. For larger or uncertain receipts, the owner can make a second, lower-confidence scenario rather than quietly treating hope as cash. The Small Business Administration’s cash-flow projection training similarly calls out fixed and variable costs, inventory, capital spending, and owner draws as items that belong in a practical projection.
Step 3: Put every known payment in the week it leaves the bank
Cedar Studio lists payments in the same weekly columns. Week one has rent of $2,400, supplier bills of $2,800, and software and utilities of $600. Week two has payroll of $7,200 and supplier bills of $1,500. Week three has an estimated tax payment of $4,500, insurance of $900, and supplier bills of $2,000. Week four has payroll of $7,200, supplier bills of $1,800, and software and utilities of $600.
The owner also checks for less frequent costs that are easy to miss: annual subscriptions, loan payments, sales-tax or payroll-tax deposits, equipment repairs, owner draws, and card-payment due dates. The tax side deserves special care. The IRS notes that federal income tax is generally pay-as-you-go and that many businesses have deposit obligations before filing, so a forecast should reflect the business’s real filing and payment calendar, not a guess.
Step 4: Run the four-week example
Here is the working view. Every figure is illustrative, and the point is the timing.
| Week | Opening cash | Cash in | Cash out | Closing cash |
|---|---|---|---|---|
| Week 1 | $18,000 | $4,000 | $5,800 | $16,200 |
| Week 2 | $16,200 | $6,500 | $8,700 | $14,000 |
| Week 3 | $14,000 | $9,000 | $7,400 | $15,600 |
| Week 4 | $15,600 | $3,500 | $9,600 | $9,500 |
At first glance, the business appears to have a positive month. Total receipts are $23,000 and total payments are $31,500, so cash declines from $18,000 to $9,500. More important, the owner can see exactly when the balance changes and whether $9,500 is enough of a reserve for the next payroll, vendor cycle, or unexpected repair.
Notice that the closing cash is not a recommendation about how much Cedar Studio should keep. Every business has a different floor. An owner with a small, predictable payroll and low fixed costs may be comfortable with one reserve; a business with seasonal sales, inventory commitments, or a larger team may need more room. The useful question is not whether the balance is positive. It is whether it leaves enough capacity for the commitments already on the calendar and the ordinary surprises that come with operating a business.
What the example reveals that a total cannot
A single monthly total could hide the pressure in weeks two and four. In week two, payroll lands before the larger week-three invoice. In week four, payroll, supplier bills, and recurring costs arrive together while only a deposit is expected. Neither is automatically a crisis. Both are worth seeing early.
That early view creates choices. The owner might follow up on the week-three invoice before it becomes late, confirm a vendor due date, delay a discretionary purchase, move a planned owner draw, or speak with a lender well before a shortage develops. A forecast is a conversation starter with the numbers, not an instruction to stop spending or collecting.
Write down the reason for every material change. If a receipt moved because a customer requested more time, note that. If supplier costs rose because an order was larger than expected, note that too. Over a few weeks, those notes turn the forecast into a practical operating record. They show whether a tight cash pattern comes from timing, collection habits, pricing, seasonal work, or a one-time event that should not drive a permanent decision.
Test one realistic change
Now suppose the $9,000 customer payment slips from week three to week four. Week three closes at $6,600 instead of $15,600. Week four still closes at $9,500 if the payment arrives then, but the business would have to carry a much thinner cushion through the third week.
This is where a forecast earns its value. The owner does not need to predict the future perfectly. They need to know which assumptions deserve attention. A simple “on time” and “late” version can reveal whether the business has enough room for ordinary payment delays.
Use the same thinking for a larger decision. Before adding a staff member, ordering inventory, replacing equipment, or taking an owner distribution, add the proposed date and amount to the forecast. Then look at the closing balance in that week and the weeks that follow. If the decision creates an uncomfortable low point, it is not necessarily wrong. It may simply need different timing, a customer deposit, a financing plan, or a clear conversation with the people affected.
Use the example to build your own view
Begin with a four-week format. Use the weekly cash flow forecast template as a blank layout, then bring in the real dates from your bank balance, open invoices, payroll calendar, vendor bills, and tax calendar. Keep an accounts receivable aging report nearby, because old invoices should not be treated as equally likely cash.
- Update actual results: Replace last week’s forecast with what actually cleared the bank.
- Revise receipt dates: Move a customer payment when the facts change, rather than leaving the original hopeful date.
- Add a new week: Keep the view rolling forward so the next pressure point remains visible.
- Compare to a reserve: Decide what minimum cash balance makes sense for your payroll, obligations, and risk level.
- Investigate surprises: A repeated miss can point to invoicing, collection, pricing, purchasing, or recordkeeping work that needs attention.
When a bookkeeping conversation can help

If a forecast is hard to build because the bank balance is unclear, invoices are not current, bills are scattered, or the numbers cannot be explained, start with the records. Integra’s small business bookkeeping support can help create a steadier monthly rhythm, and bookkeeping cleanup can help when older activity needs to be organized first.
The goal is not to make every week predictable. It is to make the business more prepared for the weeks that are not. When the records are current and a simple forecast is reviewed regularly, owners can make decisions with more context and less last-minute scrambling.
Cash flow forecast example FAQs
What should a cash flow forecast include?
Include the reconciled opening cash balance, expected receipts by date, expected payments by date, net movement, and the projected closing balance. The useful detail is timing, not a long list of vague totals.
Is a cash flow forecast the same as a budget?
No. A budget sets a plan for income and spending. A cash flow forecast focuses on when money is expected to reach or leave the bank. A business can be on budget and still face a tight week if receipts arrive after payroll or other bills are due.
How often should a small business update a cash flow forecast?
A short forecast is most useful when it is updated weekly. Replace estimates with actual cash movement, revise expected receipt dates, add a new week, and look ahead again.




