IW

Core P&L & Construction Runway

ISKCON Whitefield • Forensic Decoupled Accounting Baseline

Cloudflare D1: core-pnl-runway-db

Audited Core Baseline (April 2026 – September 2026)

Non-Ad Stable Donors across 3 Independent Channels • Zero Gateway Double-Counting • 100% Profitable Every Month • Core Operations Cover 97.3% of Construction Bills Internally

100% Internally Self-Funded
Grand Stable Revenue 3 Channels
₹3.79 Cr
Avg: ₹63.16 L / mo • Committed Baseline
Stable Cost (OpEx) 6 Heads
₹1.81 Cr
Avg: ₹30.15 L / mo • Kitchens, 14 Branches, Admin
Net Operating Surplus 100% Profitable
+₹1.98 Cr
Avg: +₹33.01 L / mo • 52.3% Operating Margin
Temple Land Construction CapEx Bills
₹2.04 Cr
Avg: ₹33.93 L / mo • Slabs, Steel & Contractors
Core Construction Coverage Internal Runway
97.3%
Core Surplus covers 97.3% • Zero External Debt

Monthly Core Financial Trajectory

Stable Revenue vs Operating Cost vs Construction Spend vs Operational Surplus (All figures in ₹ Lakhs)

Stable Revenue Operating Cost Construction Spend Operating Surplus

Master Month-by-Month Reconciled Waterfall Table

Click on any blue Revenue, red Cost, or amber Construction figure to inspect the exact sources and itemized bills.

👆 Interactive Cells: Click for Forensic Decomposition
Month Grand Stable Revenue (3 Channels) Core Operating Cost (OpEx) Net Operating Surplus Op. Margin Temple Construction Spend Net Free Cashflow (Surplus - CapEx) Operational Status
🏛️ Core Operations 97.3% Self-Fund Construction:

Committed regular donors, WhatsApp congregations, and physical temple footfall generated ₹1.98 Crore in net operational cash surplus, paying 97.3% of the ₹2.04 Crore construction bills internally without needing external loans.

🛡️ Complete Liquidity Safety with Festival Surpluses:

Combined with Janmashtami Net Surplus (+₹74.52L) and Social Media Net Profit (+₹67.12L), total organizational surplus was ₹3.40 Crore, creating a +₹1.36 Crore liquid bank buffer after paying all construction bills in full.

Automation Engine: Copy-Paste Prompt for October, November, December

Whenever new accounts are closed in Google Sheets, copy the prompt below and paste it in chat. It runs the dedicated updater, synchronizes the Cloudflare D1 database, and refreshes this dashboard automatically. 

Please update the Core Stable Revenue & Operating P&L Dashboard for October 2026 in project `core_pnl_runway_project`.

Execute the following automated workflow:
1. Run `python3 core_pnl_runway_project/scripts/update_month.py --month 2026-10`
2. Extract Channel 1 (Shopify Stable Donors) from 'Agency Payout & Profitability' (GID: 25738016 in 1c9Ng3YGc54J37Bq9hVVbZpempBKzitOuZKONm20_xRU) - deduct WhatsApp congregation, Ekadashi pledges, and caller field sales from Shopify store orders.
3. Extract Channel 2 (Easebuzz & Gateways Core) from EB_QRs and AutoDebit in 1VQTLyXnJEk3Uc3fX4TcXB6s3ISB6Cq2dg4s8NKMJSDY.
4. Extract Channel 3 (Direct Bank Inflows) from 'Bank Categories' (GID: 67386803 in 1VQTLyXnJEk3Uc3fX4TcXB6s3ISB6Cq2dg4s8NKMJSDY) - strictly exclude gateway settlement payouts (Easebuzz/Razorpay) to prevent double counting.
5. Extract Core Operating Cost (OpEx across 6 heads) and Temple Land Construction Spend from Volopay MIS (1vPEODBdDdrEjfbTk7lGQqwgVHB7ILf39nlPw_QvBl9o) - keep Yatra, Janmashtami festival spend, and Ad spend separate.
6. Synchronize the Cloudflare D1 database `core-pnl-runway-db`, redeploy to `core-pnl-runway.pages.dev`, and report the updated reconciliation.