Operational Cash Forecast

13-Week Rolling Engine

Deterministic cash flow projection for Little Butterflies Daycare modeling BC ChildCareBC funding, bi-weekly payroll, and liquidity stress tests.

12-Month Projections Add-On is currently INACTIVE.You are viewing standard baseline projections ($0 cost).

Enable in Owner Settings

BC Subsidy Float & Working Capital Analyzer

15th & Month-End Payroll (24/yr)1st vs 15th Float Dynamics

1st of Month: Parent-Paid Tuition

+$0

Parent cash only; parent + ACCB fee receipts $0

1st–7th: Early Outflows

-$0

Rent only ($0.0k) — 1st payroll delayed to 15th

15th of Month: Ministry Deposits

+$13,726

Operating grants $13,726 + ACCB $0 + ECE-WE $0

ECE-WE monthly: wage top-up $0 + benefits $0

Semi-Monthly Schedule (15th & Month-End): By paying staff on the 15th and month-end, your 1st monthly payroll of $37,375 coincides directly with the arrival of Provincial CCFRI and Ministry grants. Intra-month float deficit is minimized with 0 triple-payroll months across the entire year.

Staff Roster Payroll Synchronization

Auto-Synced with 17 Staff

Deterministic payroll outflows and ECE-WE grant inflows derived directly from registered staff compensation rates and schedule models.

Manage Staff

Forecaster Payroll Source

Select whether cash projections flow from published operational shifts (including 4×10 Friday emergency OT and Director floor hours) or the standard static roster.

Operational Lookahead Active: Grounded in Published Master Schedule (Sep 8 – Sep 19).• Director: 0h floor / 40h admin.

Adjust Shifts in Schedule →

Active Educators

17 Staff Scheduled

1216 total hrs/2wk

Gross Bi-Weekly Payroll

$32,944

Net Outflow: $31,553

Semi-Monthly (15th & End)

$35,689

24 pay cycles/yr (Director model)

ECE-WE Direct Wage Top-Up

+$4,320

720 eligible hrs/2wk @ $6.00/hr

Monthly wage top-up:$9,360

+ 19.90% benefits:+$1,863

Total monthly ECE-WE:+$11,223

💡

What this page helps withFunding, Wages & Records

Simulate classroom enrollment, parent fee revenue, Child Care Fee Reduction Initiative (CCFRI) discounts, and educator staffing costs.

Healthy Liquidity Profile: Cash reserves remain above the $20,000 threshold across all 13 projected weeks (Lowest: $75,000 in Week 1).

Starting Cash

$75,000

As of Sep 14, 2026

Ending Balance

$116,178

Week 13 Projected

Lowest Balance

$75,000

Week 1

Total Inflows

$41,178

Tuition + CCFRI + Grants

Total Outflows

Payroll + Rent + Food

Net 13-Wk Cash Flow

+$41,178

Payroll largest cost

13-Week Closing Cash Balance Trajectory

Safe Reserve

Below Reserve Buffer (< $20,000)

Cash Deficit (< $0)

Week 1 (Oct 8 – Oct 14): $75,000

Week 2 (Oct 15 – Oct 21): $76,924

Week 3 (Oct 22 – Oct 28): $76,924

Week 4 (Oct 29 – Nov 4): $88,726

Week 5 (Nov 5 – Nov 11): $88,726

Week 6 (Nov 12 – Nov 18): $90,650

Week 7 (Nov 19 – Nov 25): $90,650

Week 8 (Nov 26 – Dec 2): $102,452

Week 9 (Dec 3 – Dec 9): $102,452

Week 10 (Dec 10 – Dec 16): $104,376

W10

Week 11 (Dec 17 – Dec 23): $104,376

W11

Week 12 (Dec 24 – Dec 30): $104,376

W12

Week 13 (Dec 31 – Jan 6): $116,178

W13

13-Week Rolling Cash Flow Ledger

Click any row to inspect inflow & outflow breakdown

Week	Date Range	Opening ($)	Inflows ($)	Outflows ($)	Net Flow ($)	Closing ($)	Status
Week 1	2026-10-08 to 2026-10-14	$75,000	+$0	-$0	+$0	$75,000	Healthy
Week 2	2026-10-15 to 2026-10-21	$75,000	+$1,924	-$0	+$1,924	$76,924	Healthy
Week 3	2026-10-22 to 2026-10-28	$76,924	+$0	-$0	+$0	$76,924	Healthy
Week 4	2026-10-29 to 2026-11-04	$76,924	+$11,802	-$0	+$11,802	$88,726	Healthy
Week 5	2026-11-05 to 2026-11-11	$88,726	+$0	-$0	+$0	$88,726	Healthy
Week 6	2026-11-12 to 2026-11-18	$88,726	+$1,924	-$0	+$1,924	$90,650	Healthy
Week 7	2026-11-19 to 2026-11-25	$90,650	+$0	-$0	+$0	$90,650	Healthy
Week 8	2026-11-26 to 2026-12-02	$90,650	+$11,802	-$0	+$11,802	$102,452	Healthy
Week 9	2026-12-03 to 2026-12-09	$102,452	+$0	-$0	+$0	$102,452	Healthy
Week 10	2026-12-10 to 2026-12-16	$102,452	+$1,924	-$0	+$1,924	$104,376	Healthy
Week 11	2026-12-17 to 2026-12-23	$104,376	+$0	-$0	+$0	$104,376	Healthy
Week 12	2026-12-24 to 2026-12-30	$104,376	+$0	-$0	+$0	$104,376	Healthy
Week 13	2026-12-31 to 2027-01-06	$104,376	+$11,802	-$0	+$11,802	$116,178	Healthy

BC Child Care Cash Flow Operations Guide

1. CCFRI Claim Timing

Submit monthly attendance claims on the last business day of the month. Fraser Health / Ministry processing takes 10–14 days. Delays beyond 3 weeks require activating the reserve buffer.

2. Bi-Weekly Payroll Sync

Because payroll occurs 26 times per year (2 months have 3 paydays), maintain at least 1 full payroll cycle ($16,200) in reserve to prevent 3-payday month deficits.

3. ECE-WE +$6.00/hr Pass-Through

The Province reimburses certified educator hours at 100%. Reconcile approved sick and statutory leave hours monthly to ensure full ECE-WE grant claims.