small business cashflow template

Financial Liquidity Monitoring and Projection Protocol

Document ID: FIN-OPS-001
Version: 1.0.0
Effective Date: [__________]
Review Cycle: Quarterly

1. Purpose & Scope

This procedure establishes the systemic approach to tracking incoming and outgoing capital for [Company Name]. The scope covers the collection of historical transaction data, the projection of future liabilities, and the maintenance of a rolling liquidity forecast to ensure operational solvency.

2. Prerequisites

• Software: Spreadsheet application (Excel/Google Sheets) or dedicated accounting suite.
• Data Access: Read-only access to [Primary Bank Account Name] and [Secondary Bank Account Name].
• Documentation: Previous 90 days of bank statements and [Current Fiscal Year] budget projections.
• System: A dedicated folder path at [Server/Cloud Location] for secure file storage.

3. Roles & Responsibilities

4. Step-by-Step Procedure

Phase 1: Data Aggregation

• Export transaction history from [Accounting Software Name] for the period [Start Date] to [End Date].
• Categorize all outflows into "Fixed Costs" (Rent, Salaries, Insurance) and "Variable Costs" (Inventory, Marketing, Travel).
• Reconcile total inflows against [Sales CRM Name] records to ensure no missed receipts.

Phase 2: Liquidity Modeling

• Input opening balance for [Current Month] into the [Template Name] master sheet.
• Populate "Fixed Outflows" based on standing recurring payments.
• Estimate "Variable Outflows" using a 3-month moving average of historical spending.
• Apply a [__________]% buffer to all projections to account for unforeseen contingencies.

Phase 3: Analysis and Variance Reporting

• Compare projected closing balance against actual ending balance from the previous cycle.
• Identify variances exceeding [__________]% and document the root cause in the [Variance Log].
• Determine if the current liquidity runway covers the minimum requirement of [Number] months of expenses.

5. Quality Assurance, Pro-tips, and Common Pitfalls

• QA Check: Ensure that the sum of all inflows minus the sum of all outflows equals the net change in the bank balance.
• Pro-Tip: Perform this update every Friday morning to ensure the data is fresh before weekend operational decisions.
• Common Pitfall: Failing to account for annual or quarterly tax installments. Always amortize these large payments into monthly "sinking funds" within your model.

6. FAQs

Q: How often should I update the projections?
A: Ideally, perform a minor update weekly and a comprehensive audit at the close of every month.

Q: What should I do if the model shows a negative balance?
A: Immediately categorize expenses into "Essential" and "Discretionary." Pause all discretionary spending and contact your [Financial Institution] to discuss available credit facilities or short-term financing options.