Apr – Jun 2026 · PhonePe / Razorpay / Google Play · GST 18% inclusive · successful transactions only · generated
🔍 Every dotted-underlined number is clickable — it opens the exact underlying rows (unique transaction IDs + amounts) that sum to that number, with a one-click CSV download. Derived cells (÷1.18 splits, differences, ratios, totals-of-linked-cells) reference the same files as the cells they are computed from.
Read the bases carefully — three different April PhonePe numbers are all correct:
Transactions are by transaction date (₹2.56 Cr for Apr) — this is the revenue figure;
Settlements are by settlement date for PhonePe (₹2.63 Cr for Apr — includes ₹15.5L of March txns settled Apr 1–2, excludes ₹8.3L of Apr 29–30 txns settled in May; see the lag matrix in section 1) and transaction-month for Razorpay / Google Play;
the net credited to bank (₹2.37 Cr for Apr = settled − refunds − fees) appears in section 2.
Each is split Gross / Taxable / GST. Google's service fee carries no separate GST in the earnings report (Google invoices GST separately), so its commission GST shows 0. CSV: outputs/reconciliation_summary.csv.
Successful transactions matched against gateway settlement reports, with refunds shown so the net ties to your workings. "Unsettled" = collected but not yet in a settlement report (month-end timing or genuine gap).
Settlement-lag matrix — when each month's transactions actually settled. Settled cells use the settlement-report amounts; only the "unsettled" column uses transaction amounts (no settlement row exists yet). July 31 transactions settle Aug 1–2, hence the "unsettled" tail pending the August report.
Taxable (ex-GST) collections of ₹249+ plans spread daily over each plan's configured service period (per-amount setting in automation/deferral_config.json — currently all plans 91 days / quarterly; set any plan to 30 for monthly deferment and re-run). Amounts below ₹249 recognize in full on collection. Deferred balance carries forward and is released in later months.
Commission = transaction amount − settlement amount, validated against gateway-reported fees (incl. GST on fees).
Revenue by place of supply, with refunds netted (Taxable and GST computed on the net). "Unmapped" = transactions with no state in the GST location files.
Automation: automation/pipeline.py → outputs/results.json → this dashboard (build_dashboard.py). CSVs alongside: state-wise revenue, txn-vs-settlement gaps, bank credit register, deferral schedule. Verification workbooks: outputs/Row_Count_Verification.xlsx, outputs/Daily_Verification.xlsx.