Cash Is a Discipline — 13-Week Forecasting & Working Capital Wins

Executive Summary

Growing Caribbean businesses don’t run out of profit; they run out of cash visibility. Sales rise, but stock sits too long, customers pay late, suppliers tighten terms, and month-end reports arrive after the moment to act. The solution is not a bigger overdraft; it’s a disciplined cash operating system anchored by a rolling 13-week cash forecast (13WCF) and working-capital levers built into daily AP/AR processes.

Dawgen FinanceGrid™ operationalises cash discipline with hybrid delivery (In-Client + Dawgen Hub), IFRS-sound cut-offs, and an SLA-backed cadence. This article explains the 13WCF, shows how to connect it to AP/AR/Inventory routines, sets pragmatic DSO/DPO/CCC targets, and gives you templates, KPIs, risk controls, and a 30-60-90 plan to move from guesswork to governance—island by island.

1) Cash Discipline: What It Really Means

Cash discipline is repeatable behaviour tied to a calendar:

• Every Friday the 13WCF is refreshed and reconciled to bank balances and sales/collection reality.

• Every Monday leaders review the next 2–3 weeks of inflows/outflows and adjust actions (collections, buys, payment runs).

• Daily, AP/AR routines enforce small behaviours—invoice on time, code on time, approve on time—that compound into predictable liquidity.

Outcome: Liquidity surprises shrink; supplier trust grows; leadership decides earlier and with confidence.

2) The 13-Week Cash Forecast (13WCF): Definition & Design

Definition: A forward-looking, weekly view of cash in and out for the next 13 weeks, reconciled to opening bank balances and linked to AR, AP, payroll, taxes, inventory buys, capex, and debt service.

Why 13 weeks?

• Long enough to see quarter-scale patterns (VAT/GCT remittances, rent, loan instalments).

• Short enough to keep assumptions credible and behaviour-driving.

Core Design Principles

1. Direct method first. Start with actual cash events (collections, payments), not just P&L.

2. One sheet; many links. Single master per entity with links to AR ageing, AP due, payroll calendar, tax calendar, and capex plans.

3. Granularity where it matters. Customers and suppliers above a threshold (e.g., top 20 by exposure) are listed explicitly; the rest bucketed.

4. Governance by cut-off. Each Friday, the sheet closes; deltas to prior view are explained in notes.

5. Confidence scoring. Each inflow/outflow carries a High/Medium/Low certainty tag to focus management energy.

3) Inputs & Assumptions (What Feeds the 13WCF)

• Opening Cash: Reconciled bank balances by currency and entity.

• AR Collections: From ageing + promise-to-pay (PTP) log + credit-note expectations.

• AP Payments: From AP due list + committed payment runs + supplier agreements/negotiations.

• Payroll & Statutory: Monthly payroll calendar; NIS/NHT/PAYE; GCT/VAT; withholding; corporate tax instalments.

• Operating Opex: Rent, utilities, logistics, insurance, subscriptions.

• Inventory & COGS Timing: Purchase orders (POs), lead times, landed-cost schedules.

• Capex & Projects: Approved projects with draw schedules.

• Financing: Loan service, interest, availability of lines, covenant dates.

• FX Considerations: Expected conversions, hedges, and cross-border remittances.

4) From Forecast to Actions (Closing the Loop)

A forecast that doesn’t change behaviour is just a spreadsheet. FinanceGrid™ ties 13WCF to action owners:

• Collections Playbook (AR): Top 20 customers with contact steps and dates; dispute resolution SLAs; proactive “remind before due” cadence.

• Supplier Strategy (AP): Segment suppliers (strategic vs. spot), set payment terms by segment, and pre-agree instalment plans if needed.

• Inventory Rhythm: PO release windows governed by cash runway and lead times; dead-stock plan with discounting windows.

• Payment Run Governance: Fixed weekly or twice-weekly runs; exceptions approved by CFO; visibility to upcoming cash dips.

• Leadership Monday: 20-minute huddle to prioritise collections, payment negotiations, and purchase release.

5) Working-Capital Levers that Actually Move the Number

A. Accounts Receivable (DSO)

1. Right-first-time invoicing. Same day as delivery/service; e-invoice if possible.

2. Promise-to-Pay log. Track commitments; escalate misses within 24 hours.

3. Dispute clock. Aged disputes have owners and deadlines; credit notes issued promptly with adequate approval.

4. Collections cadence. “Remind-before-due” + Day 1/7/14 sequence; call scripts; senior escalation at Day 21/30.

5. Incentives. Early-pay discounts for targeted customers; align sales commission with cash collected, not billed.

Target: Reduce DSO 10–20% over 90 days.

B. Accounts Payable (DPO)

1. Supplier segmentation. Strategic suppliers get reliability and negotiated terms; non-strategic follow standard cycles.

2. Batch payment runs. Twice-weekly runs create a predictable rhythm.

3. 3-way match discipline. Avoid over-payment and rebilling cycles.

4. Term alignment. Push toward 30/45 days where feasible; negotiate settlement discounts in exchange for predictability.

5. Supplier scorecard. On-time payment %, dispute frequency, delivery reliability—bring data to negotiations.

Target: Extend DPO 5–10 days without harming supply.

C. Inventory (Days Inventory Outstanding – DIO) & Buying

1. Demand-linked POs. POs are released against rolling demand signals, not hope.

2. ABC & XYZ analysis. Prioritise A and high-volatility items for frequent review; long-tail stock is limited or on consignment.

3. Aging actions. Markdowns and bundles for inventory > 90 days; calendarised to cash dips.

4. Supplier collaboration. Vendor-managed inventory (VMI) or flexible MOQs where possible.

5. Logistics cadence. Consolidate shipments to reduce landed-cost surprises.

Target: Reduce DIO 10–15% in two quarters.

Combined Outcome: CCC (Cash Conversion Cycle) improves, freeing cash without new debt.

6) The Weekly Cadence (Who Meets, What’s Decided)

• Friday (Finance): Lock 13WCF, reconcile to bank, update certainty tags; publish notes (new risks/opportunities).

• Monday (Leadership 20 mins): Confirm top 5 collections actions, supplier negotiations, and PO releases; agree cash buffer policy for the week.

• Daily (Ops Huddles): AR calls, AP exceptions, PO confirmations; escalate blockers same day.

• Monthly SteerCo (T+7): Review working-capital KPIs (DSO/DPO/CCC), variance to forecast, and structural fixes (terms, credit policy).

• Quarterly Value Review: Step down hours and price if automation reduces effort; re-baseline targets.

7) A Simple 13WCF Structure (Tab Layout)

1. Summary Dashboard: Opening cash, net in/out by week, minimum cash, red-flag weeks, DSO/DPO/CCC.

2. Inflows (AR): Customer-level lines for top accounts; bucket for “rest”; PTP dates; confidence tags.

3. Outflows (AP): Supplier-level for top accounts; standard buckets; scheduled runs (Tue/Fri).

4. Payroll & Statutory: Calendar by entity; FX flag if cross-border.

5. Inventory/COGS: PO schedule with expected receipts and payment timing.

6. Capex/Debt: Major projects and loan service.

7. Assumptions & Notes: FX rates, seasonality factors, one-off items.

Evidence: Each figure links to AR ageing, AP due list, payroll/tax calendars, PO reports, loan schedules.

8) KPIs & Targets

• Forecast Accuracy (2-week window): ±5% variance to actual.

• DSO: Improve 10–20% within 90 days (sector-dependent).

• DPO: Extend +5–10 days with stable supplier scorecards.

• CCC: Net improvement 10–20% over two quarters.

• Collections SLA: 95% of top-20 PTPs met on time.

• AP On-Time %: ≥ 92% on agreed terms (predictability beats random early/late).

• Cash Buffer Policy: Minimum days-of-cash defined (e.g., 15–25 days) and met ≥ 90% of weeks.

• Forecast Hygiene: 100% of red-flag weeks have documented actions/owners.

All roll into the Ledger Health Score components: Working Capital, AP Cycle, Close Timeliness.

9) Controls: Speed with Safety

• Maker–Checker: Payment runs require two approvals; payroll and taxes retain client sign-off.

• Cut-Off Rules: IFRS-aligned revenue/expense recognition reduces post-close surprises.

• Evidence Files: Store each week’s locked forecast, variance notes, and action list.

• FX Policy: Thresholds for conversions and hedges; segregation between requestor and approver.

• Credit Policy: Credit limits and auto-holds; exceptions documented with expiry dates.

10) Sector Notes (Caribbean Context)

• Hospitality/Tourism: Seasonality drives large swings—model occupancy-linked inflows, pre-bookings, and tour operator terms; negotiate supplier terms around low-season.

• Distribution/Retail: Inventory turns are king—weekly SKU reviews and promo calendars feed the 13WCF.

• Construction/Projects: Milestone billings and retention releases; ensure WIP and claims timing appear explicitly.

• Public Sector/NGOs: Grant drawdowns and compliance timing; map donor disbursement calendars.

11) Case Vignette (Illustrative)

Context: Multi-island distributor. Close at T+14, AR >90 days at 18%, supplier pressure, frequent FX cash crunch.

FinanceGrid™ actions (90 days):

• Deployed 13WCF with top-20 customer PTP logs; twice-weekly payment runs; supplier segmentation.

• Introduced AR “remind-before-due” cadence and dispute clocks; aligned sales incentives to cash collected.

• Added PO release gates tied to cash runway; consolidated shipments to reduce landed-cost volatility.

Outcomes:

• Forecast accuracy ±4% in 2-week window by week 6; AR >90 down to 9%; DPO extended +7 days; CCC improved 16%.

• Minimum cash buffer met 11/13 weeks; supplier disputes down 40%; bank overdraft fees reduced materially.

12) 30-60-90 Plan to Institutionalise Cash Discipline

Days 0–30 — Stabilise

• Ledger Health Check with working-capital focus; baseline DSO/DPO/CCC and minimum cash policy.

• Stand up 13WCF v1.0 for the main entity; link to AR/AP/Payroll/Tax calendars.

• Launch top-20 Collections Playbook and PTP log; set twice-weekly payment runs.

• First Leadership Monday huddle; agree red-flag response rules.

Days 31–60 — Optimise

• Expand 13WCF to all entities; add confidence tags and variance notes.

• Install dispute clocks, credit-note SLAs, and supplier negotiation lanes.

• Introduce PO release gates based on cash runway; pilot markdown plans for >90-day stock.

• Hit forecast accuracy ±5% in 2-week window; DSO/DPO trends improving.

Days 61–90 — Transform

• Publish dashboards (DSO/DPO/CCC, forecast accuracy, red-flag weeks with actions).

• Negotiate structural term changes with strategic suppliers; align sales comp to cash.

• Bake the cadence: Friday lock, Monday huddle, SteerCo T+7.

• Re-baseline hours and SLAs; discuss efficiency rebates where automation reduces effort.

13) Templates You’ll Receive with FinanceGrid™

• 13WCF Workbook (entity tabs, roll-up, notes, confidence tags).

• Collections Playbook & PTP Log (with reminder sequences).

• Supplier Segmentation & AP Run Calendar (with priority codes).

• Inventory Aging & Action Matrix (markdown/bundle/return).

• Cash Buffer Policy template (thresholds, governance).

• KPI Dashboard for DSO/DPO/CCC and forecast accuracy.

14) FAQs

Q: Our business is too volatile—will a 13WCF be wrong every week?
A: Volatility is exactly why you need a short-horizon, frequently refreshed forecast. We tag confidence levels and track variance to learn quickly.

Q: We don’t have time—month-end already consumes us.
A: The cadence is light: Friday lock (Finance), Monday 20-minute huddle (Leadership). Time saved from fewer surprises more than pays for the routine.

Q: Can we run this on QuickBooks/Sage?
A: Yes. We meet you on your ERP, extract AR/AP/PO calendars, and standardise a workbook. Automation (OCR/bank feeds) reduces manual steps.

Q: Will suppliers resist term extensions?
A: Data wins. On-time % and dispute rates support your ask. We aim for predictability over blanket delays.

Q: How does this tie to audit and IFRS?
A: Clean cut-offs and reconciliations reduce adjustments; evidence files support auditors; 13WCF notes explain subsequent-events variances.

Conclusion — Liquidity as a Managed Outcome

Cash is not a mystery—it’s a managed outcome of everyday behaviours governed by a simple, relentless rhythm. With a 13-week cash forecast, a weekly leadership huddle, and embedded AP/AR routines, your organisation trades overdraft anxiety for strategic options.

Control. Clarity. Caribbean-wide. That’s the promise of cash discipline inside Dawgen FinanceGrid™.

Next Step!

Ready to see your cash before it moves?
Email [email protected] or WhatsApp +1 555 795 9071 to book a free Ledger Health Check. We’ll build your 13WCF, tune your working-capital levers, and deliver measurable cash gains in 90 days.