Business Growth Series, Book 02, Follow-Up Guide
Cash flow visibility can support stability, stronger decisions, and the practical work of transforming a business plan into sustainable operations. A business may show profit on its income statement while available cash remains limited because customer payments, payroll, taxes, vendor bills, and other obligations occur at different times.
This follow-up to TLC’s earlier cash-flow management guide for small businesses focuses on one practical mechanism: the 13-week rolling cash flow forecast.
A 13-week cash flow forecast is a weekly planning schedule that estimates your opening cash, expected inflows, expected outflows, and closing cash for the next 13 weeks. It is not a promise about future results. It is a decision-support tool that can help you identify timing issues early enough to consider appropriate actions.
TLC Business Solutions is Ukiah-based and serves US-based businesses whose owners or responsible parties may be located outside the United States. Services are strictly limited to US GAAP and US tax law.
This blog is published by TLC Business Solutions and promotes our own services.
Part 1: Build the Forecast
I. Understand the Four Core Components
A useful forecast can be simple. The value comes from consistent inputs and regular review rather than from unnecessary complexity.
1. Opening cash
Opening cash is the cash available at the beginning of each forecast week. For Week 1, use a current, reconciled bank balance that reflects cleared transactions as closely as possible.
The closing cash from Week 1 becomes the opening cash for Week 2. This connection continues through the full forecast.
2. Expected inflows
Inflows represent cash you reasonably expect to receive during a specific week. Potential categories include:
- Customer invoice collections
- Credit card or payment processor deposits
- Recurring service payments
- Deposits or milestone payments
- Loan proceeds or other financing
- Refunds or other identified receipts
Record inflows in the week when you expect the cash to arrive, not necessarily when the sale occurs or the invoice is issued.
3. Expected outflows
Outflows represent cash payments expected during a specific week. Potential categories include:
- Payroll and payroll-related obligations
- Required tax payments
- Vendor and supplier payments
- Rent, utilities, insurance, and subscriptions
- Loan payments
- Inventory, materials, or shipping
- Planned equipment or technology purchases
- Discretionary operating expenses
Payment timing matters. An invoice received this week may not be paid until a later week. The forecast should reflect the expected payment date.
4. Closing cash
Closing cash shows the estimated cash remaining at the end of each week.
The basic calculation is:
Opening cash + total inflows − total outflows = closing cash
The closing balance is then carried into the next week as opening cash.
II. Set Up a 13-Week Grid
Use a spreadsheet or accounting system with:
- 13 columns for the upcoming weeks
- Week-ending dates across the top
- Inflow categories grouped together
- Outflow categories grouped together
- Rows for total inflows, total outflows, net cash flow, and closing cash
- A notes area for risks, owners, and next actions
You may also include a minimum cash threshold. This is the lowest cash balance your business believes it needs to support core obligations. The threshold should reflect your operating structure, payment schedules, and risk tolerance rather than a generic benchmark.
The forecast can also distinguish between:
- Committed inflows: receipts supported by contracts, payment history, or customer confirmation
- Possible inflows: receipts that depend on an uncertain sale, approval, or delayed customer action
- Committed outflows: scheduled payroll, taxes, rent, debt payments, and known vendor obligations
- Flexible outflows: spending that may be delayed, reduced, or reconsidered
This distinction helps you apply conservative assumptions without treating every estimate as equally reliable.
III. Use Conservative Assumptions
Forecasting does not require perfect prediction. It requires assumptions that are documented and reviewed.
For inflows, consider:
- Whether the customer has paid on time historically
- Whether the invoice is approved and undisputed
- Whether the payment method creates processing delays
- Whether the expected receipt depends on a future milestone
- Whether seasonal patterns affect collection timing
For outflows, consider:
- Whether the amount is contractually required
- Whether the due date is fixed
- Whether the payment may be larger than usual
- Whether a recurring charge or annual obligation is approaching
- Whether a planned purchase has received approval
Illustrative teaching example, not a benchmark: Suppose a business enters a week with $10,000 in opening cash, expects $6,000 in customer receipts, and anticipates $7,500 in payments. The estimated closing cash would be $8,500. These figures are provided only to demonstrate the calculation and do not represent a target, average, or expected result for any business.
If a customer payment is uncertain, you may choose to place it in a later week or mark it separately. If an expense is likely to occur but the amount is unclear, a conservative estimate may provide a more useful planning signal than omitting the expense.
IV. Prepare Before Your First Forecast
Before building the first version, gather:
- Current bank balances and recent bank activity
- Accounts receivable aging
- Open invoices and customer payment terms
- Accounts payable aging
- Payroll calendar and payroll tax schedule
- Recurring bills and subscription dates
- Loan and credit payment schedules
- Upcoming tax obligations
- Known inventory or purchasing commitments
- Planned equipment, hiring, or capital spending
- A list of people responsible for collections, payments, payroll, and approvals
Your forecast is more useful when the underlying books and bank accounts are reasonably current. When reviewing accounting entries, the DEAL mnemonic can also provide a basic reference: Debits increase Expenses and Losses; Credits increase Equity and Revenue. The forecast itself focuses on cash timing, but accurate accounting records can help you identify the transactions that inform it.
Part 2: Review, Respond, and Maintain
V. Establish the “Same Day, Same Questions” Rhythm
Choose a consistent day each week for the review. The exact day may depend on your payroll, banking, and reporting cycles. The important factor is creating a repeatable operating rhythm.
Start with three questions:
1. What changed?
Compare the completed week’s forecast with actual activity.
- Which receipts arrived earlier or later?
- Which payments differed from the estimate?
- Did a new bill or customer delay appear?
- Did the actual closing cash match the bank balance?
- Which assumptions need to be revised?
Replace prior estimates with actuals where appropriate. This process turns the forecast into a learning tool rather than a static worksheet.
2. What is due?
Review the upcoming weeks for scheduled obligations.
- Payroll
- Required taxes
- Rent and utilities
- Vendor invoices
- Debt payments
- Insurance
- Contract renewals
- Planned purchases
Confirm both the amount and the expected payment date. A payment that is due at the end of a week may affect the available cash needed for the following week.
3. What is at risk?
Look for weeks where projected closing cash approaches or falls below your internal minimum threshold.
A risk may involve:
- A delayed customer receipt
- A concentrated payroll or tax obligation
- A large vendor payment
- A seasonal reduction in collections
- An unplanned repair or purchase
- A mismatch between customer payment terms and vendor terms
For every material risk, assign:
- An owner
- A next action
- A due date
- A revised assumption, if necessary
For example, the owner of receivables may confirm a customer payment date, while the operations manager reviews whether a discretionary purchase can be rescheduled.
VI. Roll the Forecast Forward
A rolling forecast keeps the planning horizon current.
After reviewing the completed week:
- Replace forecast figures with actual inflows and outflows.
- Confirm the actual ending cash against the bank balance.
- Move the remaining weeks forward.
- Add a new Week 13.
- Update assumptions using recent payment behavior and known obligations.
- Recheck the minimum cash threshold.
- Record risks and assigned actions.
The first four weeks may use detailed invoice and payment information. Later weeks may rely more heavily on historical patterns, contracts, recurring schedules, and management assumptions. As each week approaches, replace broader estimates with more specific information.
VII. Respond When the Forecast Shows a Squeeze
A projected squeeze is a variable to manage through flexibility and proactive strategies. Consider reviewing actions in this order:
1. Protect payroll and required taxes
Payroll supports employees and business continuity. Required tax obligations also need careful attention under applicable US tax law. Review dates and amounts with the appropriate professional before changing payment arrangements.
2. Review vendor timing
Where agreements permit, discuss payment timing with vendors before a payment becomes overdue. Options may include aligning payment dates with customer receipts, using agreed terms more deliberately, or arranging an installment schedule.
3. Reconsider discretionary spending
Review planned purchases, optional subscriptions, nonessential upgrades, and other expenses that may be delayed or reduced without impairing critical operations.
4. Address collections
Confirm invoice accuracy, follow up on overdue balances, make payment instructions easy to use, and clarify disputed items. Earlier visibility may provide more room for a professional customer conversation.
5. Evaluate financing carefully
A line of credit or other financing may be relevant for some businesses, but terms, repayment capacity, interest, fees, and tax considerations should be evaluated before commitment.
TLC’s business management and financial reporting services can support businesses that need more structured reporting, cash-flow visibility, or operational review. Past work has helped clients identify financial errors and lost assets, but individual circumstances vary and no particular result is promised.
[Video placeholder: How to update a 13-week cash flow forecast in a weekly review]
FAQ: Cash Flow Forecasting for Small Businesses
Is a 13-week forecast only for businesses in financial difficulty?
No. A forecast can be used during stable periods as a planning and monitoring tool. It may help you evaluate hiring, purchasing, expansion, tax preparation, and other decisions before they affect available cash.
Should the forecast use revenue from the income statement?
Use expected cash receipts, not only recorded revenue. Accrual-basis revenue may be recognized before a customer payment reaches your bank account.
How often should the forecast be updated?
A weekly update is generally appropriate for a rolling 13-week forecast. Replace completed estimates with actuals, review variances, and add a new future week.
What if the forecast is inaccurate?
Treat differences as information. A delayed receipt, unexpected bill, or timing change can show where assumptions need refinement. The objective is not perfect prediction; it is earlier awareness and better decisions.
Can software create the forecast automatically?
Software may help organize data, but the forecast still depends on appropriate categories, payment timing, reconciled accounts, and management judgment. A spreadsheet may be sufficient for a smaller operation.
Conclusion: Make Cash Visibility a Weekly Operating Habit
Cash flow management for small business becomes more actionable when the next several weeks are visible. A 13-week forecast organizes opening cash, expected inflows, expected outflows, and closing cash into a repeatable decision tool.
The weekly habit is equally important:
- Ask what changed
- Confirm what is due
- Identify what is at risk
- Assign an owner and next action
- Update the forecast with actuals
- Extend the view by one week
This approach can support cash flow management for small businesses, more disciplined cash flow forecasting, and informed conversations with advisors, lenders, vendors, and team members. For business owners seeking financial advisory for small business, the forecast can also provide a practical starting point for broader reporting and planning.
External Resources
- U.S. Bank: How to Manage Cash Flow
- JPMorgan: Cash Flow Management and Reporting Guide
- Bank of America: Cash Flow Management Basics for Small Business
- TLC Business Solutions Services
- TLC Business Solutions Educational Resources
Disclaimer
This information is for educational purposes and is not individualized accounting, tax, legal, or financial advice. The information does not constitute professional tax, accounting, legal, or financial advice. TLC Business Solutions serves US-based businesses under US GAAP and US tax law and does not provide international accounting services. Consult an appropriately qualified professional regarding your specific circumstances.