The businesses that run out of cash rarely see it coming. The income statement shows a profit. Revenue is growing. Clients are paying. And then a payroll date arrives, and the checking account doesn’t have enough in it to cover the run. The owner scrambles to collect on outstanding invoices, delays a vendor payment, or pulls from a personal account to bridge the gap. The crisis passed, but it didn’t need to happen. A cash flow forecast would have shown the shortfall weeks or months in advance, with enough lead time to prevent it rather than react to it. At Legend Bookkeeping, cash flow forecasting is the service that clients tell us changed how they run their business, because it replaced the anxiety of not knowing with a clear, forward-looking picture of where cash will be and when it will get tight.
The mechanics aren’t complicated. The discipline of maintaining the forecast is what separates businesses that manage cash from businesses that are managed by it.
Why Profitable Businesses Run Out of Cash
Profit and cash are not the same thing. A business records revenue when a sale is made, not when payment arrives. It records expenses when they’re incurred, not when the check clears. This accrual basis of accounting is the right way to measure profitability, but it creates a gap between what the income statement reports and what the bank account holds.
A business that invoices $80,000 in March on net-30 terms records $80,000 in revenue in March. The income statement looks strong. But that cash doesn’t arrive until April, and some of it won’t arrive until May or June because not every customer pays on time. Meanwhile, March’s obligations are due in March: payroll on the 15th and 30th, rent on the 1st, vendor invoices on their own terms, and quarterly estimated tax payments on the 15th of April. The business is profitable in March on paper but may not have the cash in March to meet its obligations.
This timing mismatch is the single most common cause of cash flow problems in small businesses that are otherwise healthy. The business isn’t failing. It’s growing. And growth often makes the problem worse, because growth requires spending (inventory, hiring, equipment, marketing) before the revenue from that spending materializes. A business that lands a large contract may need to hire staff and purchase materials immediately, while the contract payments don’t begin for 60 or 90 days. The income statement will eventually reflect the profit. The bank account needs to survive the gap.
The 13-Week Rolling Cash Flow Forecast
The most practical cash flow forecasting tool for a small business is the 13-week rolling forecast. Thirteen weeks covers roughly one quarter, which is long enough to see problems forming and short enough that the projections remain reasonably accurate.
The structure is straightforward. Each week gets a column. The rows capture three categories: starting cash balance, expected inflows, and expected outflows. Starting cash for week one is the current bank balance. Each subsequent week’s starting cash is the prior week’s ending balance, which is starting cash plus inflows minus outflows.
Expected inflows come from identifiable sources. Accounts receivable aging tells you which invoices are due in which weeks, adjusted for each customer’s actual payment behavior. A customer whose invoices are net-30 but who historically pays at day 45 should be forecasted at day 45, not day 30. Recurring revenue from subscriptions or retainers gets placed in the week it’s expected to process. Any other expected cash receipts, loan proceeds, tax refunds, owner contributions, are placed in their respective weeks.
Expected outflows come from known obligations. Payroll is the largest and most predictable: it hits on the same dates every period at a known amount. Rent, loan payments, and insurance premiums are fixed and predictable. Vendor payments can be projected from accounts payable aging and known purchase orders. Estimated tax payments fall on known quarterly dates. Variable expenses like marketing spend, professional services, and discretionary purchases are estimated based on planned activity.
The resulting row, ending cash balance for each week, is the number that matters. When that number approaches zero or goes negative in a future week, you’re looking at a cash crunch with enough lead time to do something about it.
How Legend Bookkeeping Clients Use the Forecast to Make Better Decisions
The forecast’s value isn’t in predicting the future with precision. It’s in making the future visible enough to act on. A business owner who sees a projected cash shortfall in week nine has eight weeks of options. A business owner who discovers the shortfall in week nine has none.
The actions available with advance warning fall into a few categories, and which ones make sense depends on the specific situation.
Accelerating collections is the first lever. If the forecast shows that a cash shortfall coincides with a cluster of outstanding receivables, the business can intensify collection efforts on aging invoices, offer early payment discounts to customers with large balances, or move upcoming invoices to shorter payment terms. The receivables are already on the books. Getting them collected faster changes the timing of the inflow without requiring any new revenue.
Adjusting the timing of outflows is the second lever. A vendor payment that’s due in the week of the projected shortfall might be negotiable. Many vendors will accommodate a conversation about timing if it happens in advance rather than after the payment is missed. A planned equipment purchase or discretionary expense can be shifted to a later week when cash is stronger. The key is that these conversations happen from a position of planning rather than a position of crisis, which changes how vendors and creditors perceive the business.
Arranging a line of credit is the third lever, and it’s the one that requires the most lead time. A business that approaches a bank for a credit line with a 13-week forecast showing a temporary shortfall and a clear recovery path is a different conversation than a business that calls the bank because payroll is due tomorrow. Banks extend credit to businesses that demonstrate financial awareness and planning capability. The forecast itself is evidence of both.
Adjusting growth spending is the fourth lever. If the forecast shows that a planned hire, marketing campaign, or inventory build will create a cash shortfall that the business can’t bridge, the timing of that investment can be adjusted. Delaying a hire by four weeks, staging an inventory purchase across two months instead of one, or phasing a marketing spend differently may eliminate the shortfall entirely without abandoning the growth initiative.
Maintaining the Forecast
A 13-week forecast is only useful if it’s updated weekly. Each week, the actual cash results replace the projections for the completed week, and a new week is added at the end to maintain the 13-week window. Inflow projections are updated based on new invoices, collection results, and any changes in expected receipts. Outflow projections are updated based on new commitments, changed payment terms, and any expenses that shifted.
This weekly update takes 30 to 45 minutes when the underlying bookkeeping is current. Accounts receivable aging, accounts payable aging, and the bank balance provide the inputs. The forecast provides the output: a rolling 90-day visibility window into the business’s cash position.
The update cadence is what makes the forecast a management tool rather than a snapshot. A forecast built once and reviewed quarterly is a planning exercise. A forecast updated weekly and reviewed before major spending decisions is an operating tool that changes behavior in real time.
The Forecast Depends on Clean Books
Every number in the cash flow forecast originates from the accounting records. The accounts receivable aging that drives inflow projections depends on invoices being recorded accurately and promptly. The accounts payable aging that drives outflow projections depends on bills being entered as they’re received. The bank balance that anchors the starting cash position depends on reconciliations being current.
A business with a two-month backlog in bookkeeping can’t produce a reliable cash flow forecast because the inputs are two months stale. The receivables don’t reflect recent invoicing. The payables don’t reflect recent purchases. The bank balance might be reconciled but the categorization of recent transactions is incomplete. The forecast inherits every gap in the underlying records.
This is why cash flow forecasting works best when it’s integrated with ongoing bookkeeping rather than treated as a separate exercise. The bookkeeper who maintains the records weekly also has the data to update the forecast weekly, and the forecast gives the bookkeeper’s work a forward-looking purpose that makes the monthly reports more meaningful to the business owner.
Stop Reacting to Cash Problems. Start Seeing Them Coming.
A cash flow forecast doesn’t eliminate the timing mismatches that create cash pressure in a growing business. It makes those mismatches visible 60 to 90 days in advance, which is the difference between managing cash and being managed by it. If you want a rolling cash flow forecast built on accurate, current financial data and maintained as part of your ongoing bookkeeping relationship, contact Legend Bookkeeping. Our forecasting services are built directly on the bookkeeping and financial reporting we maintain for clients nationwide. Legend Bookkeeping gives you the numbers you need to see what’s coming, not just what already happened.
