How to Build a 13-Week Cash Flow Forecast for a Small Business
Build a rolling 13-week cash forecast with weekly receipts, payments and a cash floor. Use the free planner to test a late payment and find the tightest week.


A florist has two winter weddings on the calendar, a corporate arrangement due for delivery and a payroll debit due Friday. A busy order book says the next month looks promising. It does not tell her whether the checking account can cover Friday's payroll after Thursday's flower shipment clears. A rolling 13-week cash flow forecast puts those events in the weeks when the money is expected to move.
Start with available cash, add expected receipts and subtract payments for each week. Carry the result forward thirteen times. The number to watch is the lowest weekly closing balance and how far it sits above or below your chosen operating floor. The free 13-week cash flow planner lets you edit every week and see a late customer's effect immediately.
Choose the starting balance and your cash floor
Pick a fixed cutoff, such as the close of business on Sunday. Use a reconciled balance for the accounts whose money is available for the forecast. Check deposits in transit and outstanding payments. If a check has already reduced your starting balance, do not subtract it again when it clears. If you begin with a bank balance that still includes the money, put the withdrawal in the week it is expected to clear.
Set an operating floor separately. It is the balance at which you want an earlier decision, even if the bank would still have money. A florist might choose $2,000 as an illustrative minimum because a large refrigeration repair or a replacement shipment can arrive without much notice. Choose an amount that fits your own obligations. Keeping that floor visible makes it easier to notice a squeeze before the balance reaches zero.
Put receipts in the week cash will arrive
Use a customer promise, recent payment history, a settlement schedule or another concrete reason to choose a week. A wedding invoice issued in week one with payment expected in week four belongs in week four. If the deposit has already cleared and is part of opening cash, include only the remaining installment. Keep tentative new orders in a separate scenario until you can support a collection date.
Seasonal businesses often collect through several channels. A retail card sale can settle on a different day from the transaction, and a corporate client may approve an invoice on a monthly cycle. Check what actually happened to the last few comparable receipts. For a big collection, note who will confirm the date and when it is worth checking again.
Put payments in the week cash will leave
Start with the items that have the least flexibility, such as dated payroll debits, rent, loan payments and firm supplier commitments. Add expected purchases, delivery costs and other cash outgoings. Check the actual payment schedule for payroll-related debits and supplier installments. A flower order placed this week may require a deposit now and a balance at pickup next week.
Write out the big items before grouping them into weekly totals. A single “expenses” figure can hide two payments for the same purchase, especially if you model the original card charge and then the credit card statement. For a cash forecast of your bank accounts, follow the date the bank money leaves. Keep the detailed schedule behind the compact totals you enter in the planner.
A florist's first three weeks, with the arithmetic visible
Suppose the shop opens week one with $8,000, expects $3,000 of receipts and has $6,000 of payments. It closes with $5,000. Week two starts with that $5,000, takes in $2,000 and pays $5,500, leaving $1,500. Week three brings $7,000 in and sends $3,000 out, taking the balance back to $5,500. Assume the remaining ten weeks have no net cash change in this illustration.
The business stays above zero in this base case. It still falls $500 below its $2,000 floor in week two. The owner can now identify the specific week and the amount she wants to address. If the $2,000 expected in week two arrives one week late, move it out of week two and into week three. Week two now closes at negative $500, and week three still closes at $5,500. The final total stayed the same while the intervening week became impossible to fund from the modeled cash alone.
Look inside the lowest week
A weekly total can hide a Monday cash shortage followed by a large Friday deposit. When a week is close to the floor, list receipts and payments by day. Check settlement dates, weekends and holidays against your own bank and customers. A month-end statement can look completely ordinary even when the business was short for two days in the middle.
Once you know the timing, identify which decisions are real. Confirm an installment date with a customer, review when an optional purchase must be ordered or ask a supplier whether an alternative delivery schedule is possible. Enter a new date only after you have a reason to rely on it. Keep the original case as a reference so the team can see which change fixed the shortfall.
For a second worked example, open the calculator in this guide and replace the prefilled figures with your own.
Convert receivables into a collection calendar
An accounts receivable aging report tells you who owes money and how long the invoices have been outstanding. Add an expected collection date based on evidence. A signed customer promise, an approved invoice on the customer’s payment run, an invoice awaiting inspection and an invoice under dispute should not all be scheduled for next Friday. Give material amounts an owner who can verify the date.
In QuickBooks Online, start with the accounts receivable aging summary or detail for the relevant cutoff. Tie the report to the balances you are using and check for payments already received or unapplied credits. An invoice that has already been paid cannot also fund next week. When comparing a historical balance, check the report’s aging method and date. Intuit’s guide to matching aging reports.
Estimate card settlements using the days you expect funds to reach the bank. For a florist, a weekend of counter sales and a single wedding invoice behave differently. Record card receipts net of processing fees if that is how you forecast deposits, then leave the same fees out of the payments column. Alternatively, forecast gross collections and show the fees as separate outflows. Choose one treatment and apply it consistently.
Free 13-week cash flow forecast planner
The planner begins with illustrative figures. Set your first week, opening cash and minimum floor. Enter weekly customer receipts, other inflows, operating payments and other outflows in U.S. dollars. The balance rolls from one week to the next. The planner shows the first closing balance below the floor, the lowest closing balance and the amount of the deepest gap. Download the weekly results as a CSV if you want to keep a dated copy.
The florist in our example starts with $18,000 and a $10,000 floor. In week one, $7,000 arrives and $11,000 leaves. Closing cash is $14,000. In week two, $5,000 arrives and $12,000 leaves. Closing cash falls to $7,000. The business is $3,000 under its floor at the end of week two. The balance is still positive, so the issue is the shrinking cushion and the dates of the next payments.
In week three, $15,000 of expected receipts and $8,000 of payments return the balance to $14,000. Week four brings $9,500 in and $8,500 out, ending at $15,000. On a four-week summary the shop starts at $18,000 and ends at $15,000. That tidy summary conceals the week-two low point. For a week with payroll on Tuesday and a customer deposit on Friday, go one level deeper and schedule cash by day. Even a weekly closing balance can hide an overdraft midweek.
Stress-test one late payment without losing track of it
Suppose $6,000 of the week-three receipts is the corporate invoice. Use the planner’s delay option to move it from week three to week four. The revised week-three closing balance is $8,000. Week four still closes at $15,000 because the same money arrives one week later. The tool removes the receipt from its original week and adds it once in the destination week. If payment moves beyond week 13, it stays outside this forecast window.
Ask what changes operationally in those two low weeks. Could the florist secure a deposit before buying custom stems for the next event? Could the owner verify whether an approved invoice is on this week’s payment run? Is a discretionary purchase scheduled early enough to move by agreement? Put a person, deadline and estimated cash effect on each action. Keep payroll, taxes and contractual obligations on their actual schedules unless the responsible parties confirm a change.
A second stress test can be even more revealing. Take the confirmed order back to its original date, then change a supplier payment from week four to week two because imported stems must be reserved earlier. The customer’s invoice has not changed, yet the risk has moved nearer. Save the result of the first scenario before testing another. Distinguishing timing changes from permanent changes helps the owner act on the correct problem.
Roll the forecast every week
Use the same review time each week. Replace last week's forecast with actual receipts and payments, reconcile the new opening balance, remove the closed week and add a thirteenth future week. Mark differences as timing, amount or unexpected items. A delayed customer payment may shift a week. A lost order changes the amount you can expect. The next version should reflect the actual cause.
Share the work with the people closest to the dates. The bookkeeper can reconcile the starting cash. The person overseeing collections can confirm customer promises. The buyer or operations lead knows when the next material commitment becomes firm. Give every substantial uncertain figure a source, a date and an owner. That prevents a guess from turning into an assumed fact just because it has appeared on the sheet for several weeks.
Common questions from owners
Why thirteen weeks? It is approximately one quarter, long enough to see several payrolls, supplier cycles and customer collections together. You can see the effect of a decision next month while keeping the near-term timing in weekly detail. Use a separate longer-range plan for decisions that reach beyond this window.
What if I have no reliable sales forecast? Start with the cash you can verify, firm obligations and receipts with a named payer and a reasonable date. Model additional work as a second case. Rerun the forecast when an estimate becomes an order or a customer confirms payment. A few well-documented inputs give you a better starting point than thirteen weeks of guesses.
Can a profitable company still show a cash shortfall? Yes. Inventory can be paid for before the customer pays, and loan principal and other cash movements follow their own schedule. Review the lowest week first and the ending cash second. For help preparing the inputs, open the 13-week planner, browse the free bookkeeping tools, or book a consultation with LiveFixPro Bookkeeping.

Mailing address: 701 Tillery Street Unit 12-1904, Austin, Texas 78702, United States
Get in touch
LiveFixPro Bookkeeping & Accounting Services LLC is an independent firm. Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. used with permission under the QuickBooks ProAdvisor Agreement.