How to Create a 13-Week Cash Forecast in 5 Steps
September is here, which means Q4 is just around the corner. For many small businesses, the final quarter brings a mix of opportunity and pressure. Sales may increase, inventory may need replenishing, year-end expenses may appear, and tax payments may land at the same time.
That combination can make cash feel unpredictable.
A 13-week cash forecast gives you a clearer view of what is coming. It helps you spot a potential cash crunch before it hits, giving you time to collect outstanding invoices, adjust spending, or arrange financing.
Fear not, you do not need an MBA or a complicated software system to get started. A spreadsheet and a consistent weekly process can give you a practical financial life raft.
Here is how to build one in five steps.
What a 13-week cash forecast actually does
A 13-week cash forecast is a rolling, week-by-week view of the money expected to enter and leave your business over the next quarter.
Unlike a traditional profit and loss statement, a cash forecast focuses on timing. It asks when cash will actually reach your bank account and when payments will actually leave it.
That distinction matters. You may have a profitable business on paper and still struggle to cover payroll or vendor payments if customer payments arrive later than expected.
The basic formula is simple.
Opening cash balance + cash inflows − cash outflows = closing cash balance
The closing balance for one week becomes the opening balance for the next week.
Step 1, Choose your starting date and gather the facts
Start with the cash you actually have available today.
Pull the current balance from each operating bank account. If you have multiple accounts, list them separately and confirm that the balances are up to date. Reconcile them to your most recent bank statements so you are not building your forecast on outdated information.
Do not include money that is restricted or unavailable for normal business use. This might include customer deposits, escrow funds, or money reserved for a specific purpose.
Next, gather the information you will need for the next 13 weeks.
Current bank balances
Open customer invoices
Expected payment dates
Vendor bills and accounts payable
Payroll dates and amounts
Rent, utilities, and recurring subscriptions
Loan payments
Sales tax and payroll tax obligations
Planned owner draws
Expected inventory or equipment purchases
Known one-time expenses
Create a spreadsheet with one column for each week. Label the columns with actual date ranges rather than simply calling them Week 1, Week 2, and Week 3.
That makes the forecast much easier to use when you are reviewing upcoming payroll, taxes, or vendor deadlines.
Step 2, Map your expected cash inflows
Now, estimate when cash will come into the business.
The key is to forecast collections based on realistic payment behavior, not just invoice due dates. If a customer usually pays 10 days late, your forecast should reflect that pattern.
Review your accounts receivable and assign each expected payment to the week when you believe the cash will reach your account.
Include inflows such as
Customer payments
Deposits from new projects
Subscription receipts
Refunds
Grants
Loan proceeds
Owner contributions
Asset sales
Other committed sources of cash
Be cautious with sales that are still uncertain. A new proposal or promising conversation is not the same as a signed contract or an invoice with a dependable payment history.
You can include expected sales in a separate scenario, but your base forecast should rely primarily on cash that is committed or reasonably likely to arrive.
Step 3, Schedule every expected cash outflow
This is where your forecast becomes especially useful.
List every payment you expect to make and assign it to the week when the cash will leave your account. Do not rely only on your profit and loss statement. Some expenses are recorded before they are paid, while others may not appear clearly in your accounting records until later.
Your outflow section should include
Payroll and payroll taxes
Contractor payments
Rent and utilities
Vendor and supplier payments
Inventory purchases
Loan principal and interest
Sales tax payments
Insurance
Software and subscriptions
Marketing commitments
Professional fees
Equipment purchases
Owner draws or distributions
Bonuses and commissions
Q4 deserves special attention. If you run a retail or product-based business, inventory and freight costs may rise before sales revenue arrives. If you operate a service business, you may have year-end bonuses, project expenses, or tax payments to plan for.
Write down those items now, even if the exact amount is not final. A rough estimate is more useful than a surprise.
For payments that are flexible, note the latest reasonable payment date. This will help you identify which expenses could be delayed if a low-cash week appears.
Step 4, Calculate weekly cash and look for trouble spots
Once you have entered your inflows and outflows, calculate the forecast for each week.
For every column, determine
Total cash inflows
Total cash outflows
Net cash flow
Closing cash balance
Net cash flow equals total inflows minus total outflows.
Closing cash balance equals opening cash balance plus net cash flow.
Then carry each week’s closing balance into the following week as its opening balance.
Now look across the entire 13-week period. Do not focus only on the first few weeks. A cash problem in Week 8 may feel far away, but that distance is exactly what gives you time to respond.
Highlight any week where
The closing balance becomes negative
Cash falls below your minimum comfort level
Payroll or taxes may be difficult to cover
A large payment depends on an uncertain customer collection
Several large expenses occur close together
A forecast is not meant to predict the future perfectly. It is meant to show you where your assumptions need attention.
The forecast becomes more useful when you record actual results each week, review the differences, and improve your assumptions over time.
That is an important mindset shift. You are not trying to create a perfect spreadsheet. You are creating an early-warning system.
Step 5, Set a cash floor and decide what you will do
A cash floor is the minimum amount of money you want to keep available in the business.
There is no universal number that works for every company. Your floor should reflect your payroll, fixed expenses, seasonality, debt obligations, and risk level.
As a starting point, you might consider keeping enough cash to cover at least one month of essential operating expenses. A seasonal, inventory-heavy, or fast-growing business may need a larger buffer.
Once you choose your cash floor, mark every week that falls below it. Those are your action weeks.
Possible responses may include
Following up on overdue invoices
Asking for deposits or milestone payments
Offering an early-payment incentive
Delaying nonessential purchases
Rescheduling flexible projects
Negotiating vendor payment timing
Reducing discretionary spending
Pausing owner distributions temporarily
Arranging a line of credit before the need becomes urgent
The goal is not to panic or make every decision from a place of fear. The goal is to make thoughtful decisions while you still have options.
Make your forecast a weekly habit
A 13-week forecast only works if you keep it current.
Set aside 15 to 30 minutes each week for a simple review.
Update actuals
Replace the prior week’s estimates with what really happened. Record the actual cash received and the actual payments made.
Compare forecast to reality
Look for meaningful differences. Did a customer pay late? Did a vendor bill arrive earlier than expected? Was payroll higher than planned?
Adjust future weeks
Move delayed payments to the week you now expect them. Add new bills, contracts, tax obligations, or purchases.
Roll the forecast forward
Remove the completed week and add a new week at the end. You should always have 13 future weeks visible.
Keep the model simple enough that you will actually use it. Too much detail can make the process overwhelming and bury the decisions that matter.
Use the forecast before making big decisions
Your cash forecast should be part of your decision-making process, not a report you open only when something goes wrong.
Before hiring, buying equipment, increasing inventory, launching a major campaign, or taking a large owner draw, check how the decision affects your next 13 weeks.
It can also help you compare different paths.
What happens if a major customer pays 30 days late
What happens if sales are 20 percent lower than expected
What happens if you hire now instead of in January
What happens if a large purchase is delayed by six weeks
These scenarios can turn a stressful guess into a more informed choice.
If building and maintaining this forecast feels like one more responsibility on an already crowded list, you are not alone. JOLT Strategies can help you establish the model, organize the assumptions, and review the results with you regularly.
Our advisory services are designed to help you understand what your numbers are saying and turn that information into practical next steps. You can also explore our business forecasting resources for additional guidance.
Start Q4 with more visibility
A 13-week cash forecast will not eliminate every financial surprise. It will give you something much more useful, a clearer view of what may be ahead and more time to respond.
Start with your actual cash balance. Add realistic inflows. Schedule every expected outflow. Calculate your weekly closing balances. Set a cash floor. Then review and update the forecast every week.
You do not have to navigate the next quarter without a map. With a simple process and the right support, you can spot cash crunches earlier, make decisions with greater confidence, and move into Q4 feeling prepared.
You are not alone in this journey. JOLT Strategies is here to help you turn financial information into a plan you can use, week after week, as your business grows.
Further reading
Comments