13-Week Cash Flow Forecast: A Practical Guide for SMEs
Sales can look healthy while the bank balance remains tight. Customers may pay after salaries, supplier bills and other commitments fall due. For an SME owner, a 13-week cash flow forecast is a practical way to make those timing gaps visible before the payment date arrives.
This guide sets out a simple working format for a Chennai business, whether it sells services, trades goods or manufactures products. The figures in the example are illustrative, rather than a forecast for any actual company.
What belongs in a 13-week cash flow forecast?
Use one column for each week and separate money expected to arrive from money expected to leave. Start with the available opening bank balance. Record customer collections, other receipts, supplier payments, payroll, rent and other scheduled commitments. Keep uncertain receipts visibly separate so they do not create a false sense of available cash.
The basic calculation is: opening cash plus receipts minus payments equals closing cash. Carry each week's closing balance into the next week's opening balance. Explain unusual movements in a notes column so another person can understand the assumptions.
Build the first version in five steps
Choose a consistent week-end date and name one person responsible for maintaining the forecast.
Reconcile the opening balance to your banking records. Identify restricted amounts separately from money available for operations.
List outstanding customer invoices with expected collection dates. Use the customer's payment history and current correspondence, rather than assuming every invoice will arrive on its due date.
Enter known commitments by payment date. Ask purchasing, payroll and operations teams about items that have been committed but have not yet reached the accounts ledger.
Review the lowest projected closing balance and record the actions needed, with an owner and a follow-up date.
A simple weekly example
Suppose a business starts a week with ₹8 lakh, expects ₹5 lakh in customer collections and plans ₹10 lakh in payments. Its projected closing balance is ₹3 lakh. If ₹3 lakh of those collections moves into the following week, the projected closing balance becomes zero. The sales figure has not changed; the cash timing has.
Use that scenario to prompt a discussion: which collection dates need confirmation, which purchases are essential this week and which commitments need an agreed revised schedule? Any change to supplier payment timing should be agreed with the supplier and reflected in the forecast.
Turn the spreadsheet into a weekly management routine
At the end of each week, replace estimates with actual receipts and payments. Explain the largest differences, then add a new thirteenth week. Track whether an apparent shortfall is a one-off timing issue or a recurring feature of how the business operates.
Keep a short action list alongside the forecast. Examples include resolving a disputed invoice, confirming a purchase commitment or obtaining a missing billing document. A forecast becomes more useful when each uncertainty leads to a specific follow-up.
Common questions
Is a cash flow forecast the same as a profit report?
No. A profit report and a cash forecast answer different questions. The forecast focuses on when money is expected to move. Review both with the finance team so accounting results and payment capacity are understood together.
Can a small business start with a spreadsheet?
Yes. A clearly owned spreadsheet can be a useful starting point. Reliable source data, consistent updates and clear assumptions matter more than visual complexity.
Get support with forecasting and management reporting
Coreinfo's Virtual CFO offering includes cash flow management, budgeting and forecasting. Discuss your reporting needs and the appropriate review frequency with the team.
Comments