A cash flow forecast shows when money is expected to enter and leave your business account. A 13-week view is useful because a profitable month can still contain a week when payroll and supplier bills arrive before customer payments. The purpose is to identify that timing gap before choosing a funding amount.
Start with cash you can actually use
Use the available opening bank balance, then identify pending payments, restricted funds, and amounts already committed. Do not count an invoice as cash simply because you have issued it. Place each expected customer payment in the week you realistically expect to collect it. Separate confirmed receipts from estimates so you can see how much of the forecast depends on assumptions.
Create one column for each week. Under receipts, separate customer collections from owner contributions and financing proceeds. Under payments, include inventory, payroll, rent, taxes, insurance, subscriptions, and existing financing obligations. A financing deposit may increase cash, but it is not operating sales.
Carry each closing balance into the next week
The basic calculation is opening cash plus receipts minus payments equals closing cash. For an illustrative week, $12,000 opening cash plus $18,000 collections minus $25,000 payments leaves $5,000. If your chosen minimum operating buffer is $8,000, that week has a $3,000 buffer shortfall. The buffer is your planning assumption, not a universal requirement.
Repeat the calculation across all 13 weeks. Look for the lowest projected balance, not just the final one. A forecast that ends with plenty of cash can still hide an earlier shortfall. Record the dates behind large payments so moving a bill between weeks does not accidentally make it disappear.
Test a slower-collection scenario
Duplicate the forecast and move an uncertain customer payment two weeks later. Leave fixed bills on their actual due dates. Then consider a reasonable sales reduction or an unexpected repair. These scenarios are planning exercises, not predictions. Their value is showing which obligations become difficult when collections arrive late.
If you add a potential funding offer, enter its net deposit and every expected payment or remittance on the relevant dates. A cash injection can solve the first gap while creating a later one. Do not judge affordability from the deposit alone.
Turn the forecast into a weekly routine
Choose a consistent review day. Replace the completed week's estimates with actual receipts and payments, explain material differences, and add a new thirteenth week. Assign someone to confirm overdue invoices and upcoming large bills. Keep an unchanged prior version so you can learn whether your assumptions are consistently optimistic.
Before applying, use the forecast to describe the amount needed, the date it is needed, and the operating cash expected to support the obligation. If the downside case never recovers, review costs, collections, and the business plan before relying on additional financing. An accountant can help reconcile the forecast with your bookkeeping.
Read the Lowest Week First: That Is Where Funding Decisions Live
When owners open a finished forecast, they look at the final week. Read it backwards. The number that decides whether you need funding, how much, and by when is the lowest projected balance across all 13 weeks, because a forecast can end comfortably and still hide a week in the middle where payroll, rent, and a tax payment land together. This page's example: $12,000 opening cash plus $18,000 of collections minus $25,000 of payments closes at $5,000. Against an $8,000 operating buffer, that week is $3,000 short, and that shortfall, with its date, is your funding requirement stated precisely.
Then stress the low week before you act on it. Duplicate the forecast, move the most uncertain customer payment two weeks later, and leave every fixed bill on its real due date. If the low week survives that test, your plan is sturdier than it looked. If it collapses, you have learned the most valuable thing a forecast can teach, while there is still time to accelerate a collection, move a discretionary purchase, or size funding to the exact week that needs it.
If you model funding inside the forecast, model all of it: the net deposit arriving on the realistic date, and every expected payment or remittance leaving on its dates. A deposit can repair the first gap and quietly manufacture a second one six weeks later. Judging an offer by the deposit alone repeats, inside the spreadsheet, the same mistake owners make at the sales table.
Kept weekly, this stops being a document and becomes a habit: replace estimates with actuals, explain the differences, add a new thirteenth week. The 2 a.m. question of whether the business makes it to spring becomes a date on a calendar with a plan attached. That is what the forecast is for.
Give Every Week a Job: Watch, Act, or Fund
Once the forecast is built, give every week one of three jobs: weeks closing comfortably above your buffer are watch weeks, weeks closing near it are act weeks, where you accelerate a collection or move a discretionary purchase, and weeks closing below it are fund weeks, sized to the shortfall and the date, not to a round number.
The labels turn a spreadsheet into decisions while there is still time to make them. This page's example closes one week at $5,000 against an $8,000 buffer, a $3,000 shortfall. Labelled as a fund week, that shortfall comes with a deadline weeks away: enough time to request a review calmly, compare offers against the exact amount and date, and enter the net deposit and every payment into the same forecast to confirm no later week drops below the buffer in exchange. Act weeks earn their keep the same way. Moving one uncertain customer payment two weeks later in a downside copy shows whether an act week quietly becomes a fund week, and a collection call made six weeks early is a conversation, while the same call made six days early is a crisis.
Most owners build their first forecast after a bank said no slowly, or a broker sold them an amount with no date attached to it. A forecast with a job for every week reverses that experience. The question stops being whether the business survives the quarter and becomes which week needs what, by when. That is the moment the numbers start working for you.
Mark the Week You Would Act Differently
The most useful line in a thirteen-week forecast is the first week you would act differently: this page's example closes one week at $5,000 against an $8,000 operating buffer, a $3,000 shortfall with a date on it, and naming that week while it is still weeks away turns funding into a planned decision instead of a payday emergency.
Give that week a written trigger. Beside it, record the action it calls for: chase the overdue invoice, move a discretionary purchase with permission, or size funding to the shortfall and the date, and note which lever you used and whether it worked. Keep the habits that make the trigger honest. Receipts sit at realistic collection dates based on each customer's actual payment history, not invoice dates. A habitual late payer moved two weeks later in a downside copy shows whether the marked week spreads. Funding you have not been approved for lives only in a separate scenario, never in the base forecast, and funding proceeds are shown separately from customer collections with their payments entered in full. Update weekly, replacing estimates with actuals and adding a new thirteenth week, so that week is always visible while acting is still cheap and calm.
Most owners build their first forecast after a bank said no slowly, or a broker sold them an amount with no date attached to it. A forecast with one clearly marked week reverses that experience. The 2 a.m. question of whether the business makes it to spring becomes a date on a calendar with a plan attached. The numbers start working for you, and the quiet thought arrives: I found them... finally.
Read the Forecast the Same Way Every Monday
A thirteen-week forecast only earns its keep when the review ritual never changes. Pick a fixed time each week, open the same view, and ask the same first question: which week closes lowest, and is it still above the buffer the business needs? This page's example shows the moment that matters: a week closing at $5,000 against an $8,000 buffer is a $3,000 shortfall with weeks left to act. Caught on a Monday ritual, that is a phone call and a moved payment. Caught the week it lands, it is a crisis.
Keep the ritual short and mechanical. Replace last week's estimates with what actually happened, note any variance worth explaining in one line, roll a fresh week onto the end, and re-check the lowest closing week. Tax weeks, holiday weeks, and the weeks a funding collection starts or ends all belong in the sheet at their real dates, not smoothed into averages. Twenty honest minutes a week beats a perfect model nobody opens.
Owners who build this habit stop living payday to payday in their heads. The bank's slow no and the broker's pressure lose their power when your own sheet already shows the tight week, its size, and your planned move. That is the calm this guide is really selling: the numbers stop ambushing you, and finally you are the one who sees it coming.
Share the ritual with whoever touches the money: the bookkeeper who sees receipts first, the manager who schedules supplier payments. A forecast one person keeps in a drawer helps that person; a forecast the whole small team reads on Monday changes which bills get paid early and which calls get made on time.
Let the Forecast Cross the Year-End Without Blinking
A thirteen-week forecast started in early November ends in late January, so the window already contains the hardest stretch of the year: the holiday weeks, the year-end bills, and the slow first weeks of the new year, all in one view. That is the window working as designed. Build it the way this page teaches, from cash you can actually use, with receipts placed at realistic collection dates and each week's closing balance carried into the next. The example week shows what the window is hunting: $12,000 of opening cash plus $18,000 of collections minus $25,000 of payments closes at $5,000, and against an $8,000 operating buffer that is a $3,000 shortfall with a date on it, found while acting is still cheap.
Enter the year-end obligations at their real dates rather than smoothing them away: taxes, insurance, and the annual renewals a thirteen-week view exists to catch, beside payroll and rent. Keep the downside copy honest by moving the most uncertain customer payment two weeks later and leaving every fixed bill where it belongs, and keep unapproved funding in a separate scenario, never in the base forecast. Then hold the Monday ritual across the turn of the year without skipping a week for the holidays: replace the completed week's estimates with actuals, explain the material differences in a line, and confirm overdue invoices before they surprise the window. Logic Advance reads a funding request best when it arrives with this forecast behind it, sized to a dated week. If a bank answered your busiest season with silence, or a broker sold you an amount with no date attached, that ends here. You found the numbers working for you, finally.
Frequently asked questions
Is a cash flow forecast the same as a profit-and-loss statement?
No. A cash forecast follows expected cash dates. A profit-and-loss statement measures revenue and expenses under your accounting method, which may recognize items before cash changes hands.
Should funding proceeds appear as sales?
No. Show financing proceeds separately from customer collections, and include the related future payments or remittances.
How often should I update the forecast?
A weekly update keeps the rolling 13-week view useful. Review sooner when a major receipt, expense, or funding assumption changes.
Why is 13 weeks the right window for a cash forecast?
Thirteen weeks is one full quarter: long enough to catch a quarterly tax payment, a seasonal slowdown, or a customer who pays in 60 days, and short enough that weekly estimates stay credible. Far beyond a quarter, the numbers become guesses. Inside it, the dates are close enough to act on.
What is an operating buffer, and how do I set one?
It is the minimum cash cushion you decide the business should not fall below, based on your fixed obligations, revenue volatility, and how fast you could react to a surprise. There is no universal figure. In this page's example, an $8,000 buffer turns a $5,000 closing week into a clear $3,000 shortfall to plan around.
Should I count funding I have not been approved for as cash in the forecast?
No. Keep unapproved funding in a separate scenario, never in the base forecast. Count only cleared cash, confirmed receipts placed at realistic collection dates, and facilities already approved and available. A base forecast built on hoped-for money hides exactly the weeks the forecast exists to reveal.
What should I do when the forecast shows a week below my buffer?
Act while the week is still ahead of you: chase the overdue invoice, ask about moving a discretionary purchase, or size funding to the shortfall and the date. Note which lever you used and whether it worked. A shortfall found six weeks early is a planning task; the same shortfall found on payday is a crisis.
How do I handle a customer who always pays late in the forecast?
Place their payments at the week you realistically expect collection, based on their actual payment history, not the invoice due date. Separate confirmed receipts from estimates so you can see how much of any week depends on hopeful timing, and stress-test by moving the least certain payment two weeks later.
Can I build the first forecast in a simple spreadsheet?
Yes. One column per week, rows for receipts and payments, and each week's closing balance carried into the next week as its opening balance. Start with your real cleared bank balance today. A rough forecast you update every week beats a precise model built once and never opened again.
How do I decide which week needs action first?
Start with the earliest week that closes below your operating buffer, not the week with the largest shortfall. An earlier shortfall has the least time to fix, and correcting it often improves every week that follows it in the forecast.
Should I place receipts in the week of the invoice date or the payment date?
Place each expected customer payment in the week you realistically expect to collect it. An invoice is not cash. If a customer habitually pays two weeks after terms, forecast the payment at that later date so the forecast reflects your real calendar.
What is the difference between a buffer shortfall and a negative balance?
A buffer shortfall means the week closes above zero but below the minimum operating cushion you chose, like this page's week closing at $5,000 against an $8,000 buffer. A negative balance means the week closes below zero. The shortfall is the earlier warning, and it arrives with more time to act.
How do I add a quarterly tax payment to a weekly forecast?
Enter it as a payment in the week it is actually due, at its expected amount, even if you set cash aside for it gradually. Large dated obligations, taxes, insurance, and annual renewals, are exactly what a 13-week view is built to catch before they share a week with payroll.
What should I do when two difficult weeks sit next to each other?
Treat them as one problem with two dates. A single funding decision, a moved purchase, or an accelerated collection may need to carry both weeks, so size any response against the combined dip and check that solving the first week does not push the second one lower.
How long should I keep earlier versions of the forecast?
Keep each prior version unchanged. Comparing what you expected with what actually happened shows whether your assumptions are consistently optimistic, and that record is what makes each new forecast more honest than the last.
How do I mark the first week I would act differently in the forecast?
Flag the earliest week that closes below your operating buffer and write the planned action beside it: the lever, the amount, and the date it must happen by. One marked week with a named action is worth more than a spreadsheet of unmarked shortfalls nobody owns.
What should I write beside a week that depends on one large receipt?
Note the customer, the amount, and how much of that week's closing balance depends on that single payment, then stress-test the week by moving the receipt two weeks later. A week that only works if one customer pays on time is a risk to manage early, not a balance to trust.
How do I show a funding payment that starts in the middle of the forecast?
Enter the net proceeds as a separate line from customer collections in the week the cash clears, and enter every scheduled payment from its real start date onward. Then recheck the later weeks, because a payment that fixes one week can quietly create the next shortfall.
When should a watch week become an act week?
When new information moves it closer to the buffer: a receipt slips, a supplier brings a payment forward, or a new commitment lands in it. The labels are a weekly discipline, not a one-time sort, and a week earns promotion to action as soon as its margin for surprise is gone.
What do I do with a receipt that arrives earlier than forecast?
Record the actual date, update the closing balances that follow, and resist spending the improvement twice. An early receipt can retire the action planned for a later shortfall week, or rebuild the buffer, but the forecast should show which choice you made and why.
How should I note a supplier payment I moved with permission?
Record the original due week, the agreed new week, and who confirmed the change, in the forecast itself. A moved payment improves one week by spending another, and the note keeps that trade visible when the later week is reviewed, instead of arriving as a surprise.
What is the first number to check in the weekly review?
The lowest projected closing balance in the thirteen weeks, compared with the buffer your business needs to operate. If the lowest week still clears the buffer, the forecast needs no action that week. If it falls below, as in this page's example of $5,000 against an $8,000 buffer, that week becomes the week's work.
How do I show a tax payment week in the forecast?
Enter the tax payment in the actual week it leaves the account, at its full amount, as its own line. Tax weeks are the classic hidden dip: they are large, fixed, and easy to forget because they do not arrive monthly. Seeing the dip thirteen weeks out lets you build toward it instead of borrowing around it.
Should seasonal weeks use last year's actual figures?
Last year's same weeks are the best starting estimate for a seasonal business, adjusted for anything you know has changed: a lost customer, a new contract, higher prices. Mark those weeks as estimates and replace them with actuals as they pass. A forecast that learns from its own history gets more trustworthy every quarter.
How do I forecast a week that contains a holiday?
Shorten that week's expected receipts and collections to the business days that actually occur, and move receipts that would land on the holiday to the next business day. Holiday weeks also change your own payments: payroll may run early and suppliers may close. Enter the week as it will really happen, not as a normal week with a note.
What size of variance is worth investigating?
Investigate any week where actuals differ from the forecast by enough to change a decision: a receipt that moved weeks, a payment that grew, a deposit pattern that slipped twice running. Small rounding differences are noise. A variance that moves your lowest closing week is signal, and it belongs in next week's sheet as a correction.
Can the forecast help decide when to apply for funding?
Yes. The forecast shows the tight week, its size, and how long the tightness lasts, which is exactly the information a funding decision needs. Applying while the gap is still weeks away means choosing from a position of calm, with statements and a plan that show the gap is dated and temporary rather than a surprise.
What lands inside a thirteen-week window that starts in November?
The holiday weeks with their shortened collection patterns, the year-end bills at their real dates, taxes, insurance, and annual renewals among them, and the slow first weeks of January, all inside one quarter's view. That density is the point of the window: obligations that are large, fixed, and easy to forget are exactly what thirteen weeks is built to catch before they share a week with payroll.
How do I enter a once-a-year payment that falls inside the window?
As its own line, in the week it actually leaves the account, at its full expected amount, even if you set cash aside for it gradually. Do not spread it across the weeks to make the chart smoother; the dip is the information. Large dated obligations are what the forecast exists to surface early, while there is still time to build toward them.
Why keep last year's final forecast beside the new year's first one?
Because the comparison is how the forecast learns. Keep each prior version unchanged, and set what you expected for the holiday weeks beside what actually happened: which receipts moved, which payments grew, where the lowest week landed. A business that records its own forecasting habits stops repeating its most optimistic one, and each new window starts more honest than the last.
How do I treat the cluster of holiday weeks in the middle of the window?
Enter each one as it will really happen, not as a normal week with a note: receipts shortened to the business days that occur, payments that shift around closures moved to their real dates, and payroll entered when it will actually run. Several unusual weeks in a row are where an averaged forecast hides its lowest balance, so the cluster gets more care, not less.
What changes in the forecast when the calendar year turns?
The ritual does not change, and that is the discipline: replace the completed week's estimates with actuals, explain material differences in a line, and add a new thirteenth week, the same as any other Monday. What changes is the content rolling in, January's slower receipts and the new year's first bills, which is why skipping the review for the holidays is the one mistake the window cannot afford.
How do I compare this year's holiday weeks with the same weeks last year once they close?
Set the closed weeks beside last year's same weeks on the same definitions, adjusted for anything you know has changed: a lost customer, a new contract, higher prices. Mark the seasonal weeks as estimates when they enter the window and replace them with actuals as they pass. Like compared with like is what turns the comparison into a measurement instead of an argument.
Further reading
SBA: Managing business finances provides additional background. Examples on this page are illustrative planning exercises, not offers or forecasts of business results.
Discuss your funding plan
Bring your use of funds, timeline, and current business information to the conversation. Availability, pricing, approval, and funding timing depend on the program and underwriting.