Template

    Cash flow forecasting for a small business: a 13-week template

    Published 5 min readBy the flowwork.ai editorial teamReviewed by Akshay Kumar V, Finance, flowwork.ai,

    Short answer

    A 13-week cash flow forecast lists expected cash in and cash out by week, starting from today's bank balance. Include customer collections (by invoice due date, adjusted for how late each customer usually pays), salaries and statutory payments (TDS by the 7th, PF and ESI by the 15th, GST by the 20th), rent, loan EMIs and vendor payments. Update it every week; the weeks where the closing balance dips below a safe minimum tell you when to chase collections, delay spend or arrange funds.

    13-week cash flow template

    Week 1Week 2Week 3
    Opening balance20.016.511.0
    + Customer collections8.03.012.0
    − Salaries———
    − TDS / PF / ESI / GST2.5 (TDS by 7th)1.5 (PF, ESI by 15th)3.0 (GST by 20th)
    − Vendors and rent6.04.05.0
    − Loan EMI3.0——
    Closing balance16.511.015.0

    One column per week; first three weeks shown as an example (₹ lakh).

    Put salaries in the week you actually pay them (often the last or first week of the month). Set a minimum balance, for example one month's payroll, and flag any week below it.

    How do I make the forecast reliable?

    • Use each customer's real payment pattern, not the due date alone.
    • Include annual and quarterly items: advance tax, insurance, bonuses, audit fees.
    • Compare last week's forecast with what actually happened and correct the assumptions.
    • Keep it to cash, not profit: depreciation and accruals don't belong here.

    How flowwork.ai solves this

    1. FlowBooks shows what customers and vendors owe, and a cash flow statement from the books.
    2. Bank statements are imported and matched, so the opening balance is current.
    3. Payment reminders, customer statements and UPI QR on invoices help collections arrive sooner.
    4. Payroll and statutory dues from FlowPay sit in the same books.

    See FlowBooks, monthly bank reconciliation and getting overdue invoices paid.

    Frequently asked questions

    What is a 13-week cash flow forecast?

    A week-by-week plan of expected cash in and out for the next quarter, starting from today's bank balance, updated every week.

    What should a small business include in a cash flow forecast?

    Customer collections, salaries, TDS, PF, ESI and GST payments, rent, vendor payments, loan EMIs and any quarterly or annual payments.

    Sources

    Spotted something out of date? Tell us and we'll correct it.

    Try flowwork.ai free

    Start with one module and add the rest when you need them.