Cash Flow Forecast Template for Small Businesses

A cash flow forecast is a short, forward-looking view of the money you expect to receive and the money you expect to pay. It is not a prediction that needs to be perfect. It is a working plan that helps you see a tight week before payroll, rent, supplier bills, taxes, or a large purchase makes the decision for you.

For a small business, the most useful forecast is usually simple enough to update every week. You do not need a complicated dashboard or a finance degree. You need the actual bank balance, realistic customer payment dates, known commitments, and an honest view of the lowest point ahead. That turns a vague feeling of pressure into a specific date and a decision you can make while options are still open.

Use the template below as a starting point. It works in a spreadsheet, a notebook, or alongside the weekly process in our cash flow management guide. Adjust the rows to fit how your business earns, spends, and gets paid.

What a cash flow forecast tells you

A forecast answers a timing question: will the cash available and the cash likely to arrive cover what is due before the next money comes in? That is different from asking whether the business was profitable last month. A business can make a sale, record revenue, and still be short of available cash if payroll or inventory must be paid before the customer’s payment clears.

The FDIC and SBA’s Money Smart guide on managing cash flow makes the same practical point: a projection is an estimate that can be revised, and the habit of thinking ahead is what matters. Start with the dates and amounts you know. Then update the forecast as payments clear, costs change, or an invoice moves.

Start with a four-week weekly template

Four weeks gives you a manageable first view. It is long enough to show a pressure point around payroll, inventory, or a tax deadline, and short enough that the information can stay grounded in real commitments. Once the habit is working, many owners expand the same format to six, eight, or thirteen weeks.

Copy these rows into a spreadsheet. Put the week-ending dates across the top. Begin each new week with the previous week’s projected ending cash. The numbers below are only labels, not sample financial results. Your forecast should contain your own expected timing and amounts.

Keep the layout plain. A clean template makes it easier to see the one number that deserves attention: the projected ending cash for each week. If it falls lower than your comfortable operating floor, you have time to examine the assumptions and choose a response.

Use notes beside the forecast when a number depends on a condition: a payment that needs customer approval, a supplier delivery that is not confirmed, or a purchase that only happens if sales reach a target. Those short notes make the sheet easier to revisit and keep the next weekly review focused on the assumptions most likely to change.

1. Enter the starting cash balance

Use the amount that is actually available to run the business, not a total that includes money reserved for taxes, a restricted account, or a customer payment that has not cleared. If several accounts support operations, decide what belongs in the forecast and use the same rule every week.

Starting with a real number is important because every later line depends on it. The ending cash from one week becomes the starting cash for the next. That simple chain lets you see whether an ordinary commitment in week three is safe, tight, or likely to require attention before it is due.

2. List incoming cash by realistic arrival date

Separate customer payments from cash sales and other income when that distinction helps you see the business clearly. For open invoices, use the date you expect the payment to clear based on the customer’s usual pattern, the agreed terms, and any follow-up already planned. Do not count one large invoice in full if only part of it is likely to arrive in the forecast window.

Give each meaningful open invoice a next action and date. Confirm receipt, answer a question, send a reminder, or make a call. This is not about being aggressive with good customers. It is about replacing uncertainty with a respectful, consistent collection process. Our guide to cash flow management strategies explains how payment follow-up and purchasing decisions work alongside the forecast.

3. Add every known outflow, including the easy-to-miss ones

Payroll, rent, key suppliers, insurance, debt payments, and recurring software are common rows, but the template should reflect your actual operation. A contractor may need separate rows for materials and subcontractors. A retailer may want inventory broken out by purchase order. A service business may want a line for deposits or project delivery costs.

Do not hide irregular payments in a generic “other” row. Taxes, annual insurance, equipment repairs, license renewals, owner draws, and planned purchases can be exactly what turns a comfortable month into a tight week. The IRS publishes its current tax calendar for businesses and self-employed taxpayers, which is a useful place to confirm applicable federal due dates. For business-specific tax questions, use a qualified tax professional rather than a general template.

4. Calculate the projected ending cash

For each week, add starting cash and total cash in, then subtract total cash out. The result is your projected ending cash. Carry that number into the next week as its starting cash. A spreadsheet can handle the math, but the value is in the review: what assumptions produced the low point, and how dependable are they?

Set a practical floor for your business. It may be enough to protect payroll, keep critical suppliers current, or retain a modest operating reserve. The target will differ by business, so avoid copying another company’s number. The useful question is whether the forecast stays above the amount that lets you make normal decisions without rushing.

5. Test the week that looks tight

When a week falls below the floor, do not assume the forecast is bad news. It is useful information. First, check the timing. Is a customer payment truly expected that week? Is the supplier payment fixed, or can it be scheduled differently? Is a planned purchase essential now, or can it wait? Are there sales, deposits, or costs missing from the sheet?

Then compare a few realistic responses. You may follow up on an invoice, split an inventory order, reduce a discretionary expense, use a reserve, request a deposit on new work, or change the timing of a flexible payment. A Small Business Administration guide to financial projections also notes that a funding request should clearly explain the amount needed and what it will be used for. That same discipline helps make a better operating decision, even when you are not seeking financing.

Turn the forecast into a weekly habit

Set a recurring time to update the template, ideally after you can see what cleared during the prior week. Reconcile the starting balance, move payments that did not arrive, add new obligations, and look for the lowest projected balance. Write down the reason whenever reality differs from the plan. Over several weeks, you will learn which customers pay later than expected, which expenses tend to surprise you, and where the business needs more breathing room.

A forecast should evolve with the business. Add a row when a new kind of cost matters. Remove rows that are no longer useful. The goal is not an elaborate report. It is a reliable decision tool you will use when business is busy.

• Confirm the actual cash balance and payments that cleared.
• Move each customer payment to the date it is most likely to arrive.
• Add every known payroll, supplier, tax, debt, and operating commitment.
• Check the lowest projected ending balance in the next four weeks.
• Choose one action before the low week arrives.

When funding may fit a cash forecast

Funding can be useful when the forecast reveals a specific, temporary bridge with a realistic path to repayment. For example, a business may need inventory before an established seasonal rush, materials before a contracted project pays, or working capital during a short gap between delivery and collection. The plan should make the purpose, timing, cost, and repayment source clear.

It is less useful to use financing as a blurred answer to a shortfall that repeats every month. If the same gap comes from slow collections, thin margins, unplanned spending, or a payment schedule that does not fit the business, those causes deserve attention alongside any funding conversation. KerrFundingGroup helps U.S. owners begin with the job the capital needs to do, then explore the funding options that may fit the business. For a defined operating need, review the questions on our working capital page before deciding whether to apply.

Keep reading

Related posts

Managing Cash Flow for a Small Business: A Weekly System

Use a weekly routine to track cash, follow up on payments, and prepare for upcoming business expenses.

Read the guide →

7 Cash Flow Management Strategies for Small Businesses

Practical habits for collections, spending, reserves, and planned growth.

Read the strategies →