small business cash flow projection template

Operational Liquidity Forecasting Standard Operating Procedure

Document Control

• Document ID: SOP-FIN-042
• Version: 1.0.0
• Effective Date: [Date]
• Review Cycle: Quarterly

1. Purpose & Scope

This procedure establishes the standardized method for projecting [Company Name]'s future cash inflows and outflows. It is designed to ensure solvency, identify potential liquidity gaps, and inform strategic capital allocation decisions. This scope covers a rolling [6/12]-month horizon.

2. Prerequisites

• Access to [Accounting Software Name] or historical bank statements.
• Current [Accounts Receivable/Payable] aging reports.
• Current month’s finalized Profit & Loss statement.
• Spreadsheet software capable of handling recurring logic (e.g., [Excel/Google Sheets]).

3. Roles & Responsibilities

4. Step-by-Step Procedure

Phase 1: Baseline Establishment

• Export actual cash balances from [Bank Name] as of [Date].
• Input fixed monthly overhead costs (rent, insurance, software licenses).
• Document all known recurring debt service payments.

Phase 2: Revenue Forecasting

• Estimate inflows based on [Sales Pipeline/Historical Average].
• Apply a [__________]% "conservatism haircut" to all projected sales to account for volatility.
• Account for [__________] day average collection period (Days Sales Outstanding).

Phase 3: Expense & Variable Outflow Modeling

• Map out variable costs (COGS, marketing spend, commissions).
• Include one-time capital expenditures scheduled for [Month/Year].
• Factor in tax obligations based on [Quarterly/Annual] filing requirements.

Phase 4: Reconciliation and Sensitivity Analysis

• Calculate the "Net Burn" or "Net Inflow" for each month.
• Stress test the model: What happens if revenue drops by [__________]%?
• Review the ending cash balance to ensure it never dips below [Minimum Operating Reserve Amount].

5. Quality Assurance & Pro-Tips

• QA Check: Ensure total cash out in the model matches the sum of [Accounts Payable] and [Payroll] records for the current period.
• Pro-Tip: Use a "Buffer Column" to track unexpected expenses like equipment repairs or legal fees.
• Common Pitfall: Overestimating the speed of customer payments. Always assume payments arrive at the end of your standard credit term, not the beginning.

6. FAQs

Q: How often should I update this forecast? A: Update the model every [__________] days to ensure it reflects actual performance against your projections.

Q: What should I do if the model shows a negative balance? A: Immediately evaluate options for accelerating receivables, delaying non-essential capital expenditures, or securing a [Line of Credit/Bridge Loan].