13-Week Cash Flow Forecast: Operational Quick-Start
Purpose: Provide Indonesian corporate finance teams and founders with an actionable template to forecast rolling liquidity, survive 60-day customer payment cycles, and avoid cash shortfalls on statutory deadlines.
1. The Core 13-Week Cash Flow Formula
$$\text{Closing Cash}{w} = \text{Opening Cash}{w} + \text{Verified Collections}{w} - \text{Committed Disbursements}{w}$$
A 13-week forecast models one complete quarterly operating cycle, revealing liquidity bottlenecks 4 to 8 weeks before they materialize.
2. Prioritizing Outflows: The 4-Tier Disbursement Matrix
When liquidity tightens, prioritize cash disbursements strictly by statutory risk:
| Priority Tier | Payment Category | Operational Risk If Delayed |
|---|---|---|
| Tier 1 (Non-Negotiable) | Employee Payroll & Statutory Taxes (PPh 21, 23, PPN) | Labor disputes, criminal tax penalties, bank freezes |
| Tier 2 (Critical Operations) | Core suppliers, cloud infrastructure, facility rent | Immediate operational shutdown or eviction |
| Tier 3 (Discretionary) | Growth marketing, non-essential software, travel | Slower expansion, zero existential risk |
| Tier 4 (Capital) | Dividend distributions, founder draws, major capex | Permitted strictly when cash runway > 90 days |
3. Weekly Maintenance Checklist (The Monday/Friday Routine)
- Monday Inflow Recalibration: Review AR aging. Update expected collection dates based on actual client communication, not initial contract due dates.
- Tax Calendar Reservation: Block cash reserves for mandatory Indonesian tax remittance deadlines: 10th (PPh Withholding), 15th (PPh 25 installment), and month-end (PPN 11%).
- THR & Annual Bonus Accrual: In Indonesia, Tunjangan Hari Raya (THR) requires paying a full month's salary before religious holidays. Accrue 1/12th of this liability every month.
- Verify Minimum Operating Cash Buffer: Maintain a minimum cash balance equal to 60 days of fixed operating expenses (payroll + rent + utilities).
- Friday Payment Run Authorization: Execute supplier disbursements strictly against approved purchase orders and validated tax invoices (Faktur Pajak).
- Variance Analysis: Compare actual weekly closing cash against the forecast. Identify systematic forecasting biases immediately.
4. Common Cash Flow Pitfalls in Indonesia
- Counting Gross Revenue as Cash: Forgetting that B2B clients in Indonesia frequently deduct 2% PPh 23 before remitting payment to your bank account.
- Ignoring Extended Terms (TOP 60/90): Enterprise buyers and government contractors routinely exceed agreed payment terms by 15–30 days.
- National Holiday Banking Halts: DJP tax deadlines that fall on Indonesian public holidays or cuti bersama must be funded and scheduled ahead of time.
Official Operational Standards
- Bank Indonesia Regulation on Real-Time Electronic Settlements
- Indonesian Directorate General of Taxes (DJP) Statutory Tax Calendar