πŸ’° Finance Dashboard
P&L Β· Revenue Β· Receivables Β· Payouts Β· Reconciliation
Gross Revenue
β‚Ή82.4L
↑ 22% MoM
Net Revenue
β‚Ή69.8L
After refunds
GST Collected
β‚Ή10.7L
18% on taxable
Refunds Issued
β‚Ή2.6L
12 this month
B2B Payouts Due
β‚Ή8.4L
5 partners
Net Profit
β‚Ή42.1L
Margin: 51%
πŸ“ˆ Daily Revenue β€” March 2026
🍩 Revenue Mix
πŸ“¦ Revenue by Product
πŸ“… Monthly Comparison
πŸ’³ Payment Gateway Split
⚑ Today's Snapshot
${[ ['Transactions',247,''],['Gross Revenue','β‚Ή2,48,320',''],['Refunds Issued','β‚Ή4,200',''], ['Net Revenue','β‚Ή2,44,120',''],['GST Collected','β‚Ή37,036',''],['Avg Ticket Value','β‚Ή1,004',''], ].map(([l,v,_])=>`
${l}${v}
`).join('')}
🏦 Bank Balances
${[ {bank:'HDFC Current A/C',num:'XXXX 4231',bal:'β‚Ή28,42,000',status:'Active'}, {bank:'ICICI Escrow A/C',num:'XXXX 8812',bal:'β‚Ή8,40,000',status:'Escrow'}, {bank:'Axis Refund Pool',num:'XXXX 3310',bal:'β‚Ή1,20,000',status:'Refunds'}, {bank:'SBI GST Account',num:'XXXX 9910',bal:'β‚Ή10,72,000',status:'Tax'}, ].map(b=>`
${b.bank}
${b.num} Β· ${b.status}
${b.bal}
`).join('')}
πŸ“‹ P&L Statement β€” March 2026
REVENUE
Online Ticket Salesβ‚Ή48,32,000
B2B / Group Salesβ‚Ή18,64,000
Walk-in Counterβ‚Ή9,12,000
Annual Passportsβ‚Ή4,99,000
F&B Revenueβ‚Ή3,84,000
Gross Revenueβ‚Ή84,91,000
Less: Refunds & Cancellationsβˆ’β‚Ή2,56,000
Less: Platform Discountsβˆ’β‚Ή1,84,000
Net Revenueβ‚Ή80,51,000
GST
GST Collected (18%)β‚Ή10,72,000
Less: GST Refundedβˆ’β‚Ή38,400
Net GST Liabilityβ‚Ή10,33,600
OPERATING EXPENSES
Staff & Payrollβˆ’β‚Ή12,40,000
Maintenance & Utilitiesβˆ’β‚Ή8,20,000
Marketing & Adsβˆ’β‚Ή4,80,000
B2B Commissions Paidβˆ’β‚Ή6,84,000
Payment Gateway Feesβˆ’β‚Ή1,48,000
F&B Cost of Goodsβˆ’β‚Ή1,92,000
Insurance & Legalβˆ’β‚Ή0,60,000
Total Expensesβˆ’β‚Ή36,24,000
Net Profit (EBITDA) β‚Ή44,27,000
Profit Margin55.0%
Revenue vs Expenses
Expense Breakdown
πŸ“Š YoY Comparison
${[ ['Revenue Mar 2026','β‚Ή84.9L','β‚Ή68.2L','↑24.5%',true], ['Expenses Mar 2026','β‚Ή36.2L','β‚Ή31.8L','↑13.8%',false], ['Net Profit','β‚Ή44.3L','β‚Ή32.1L','↑37.9%',true], ['Margin','55.0%','47.1%','↑7.9pp',true], ].map(([l,cy,ly,chg,good])=>`
${l}
${cy}
LY: ${ly} ${chg}
`).join('')}
Total Outstanding
β‚Ή14.2L
12 invoices
Due Within 7 Days
β‚Ή6.8L
5 invoices
Overdue
β‚Ή2.4L
3 invoices Β· >30 days
Collected MTD
β‚Ή28.6L
↑ 18% MoM
Outstanding Receivables
Invoice IDPartner / ClientTypeInvoice DateDue DateAmountOutstandingStatusActions
Total Payouts Due
β‚Ή8.4L
5 partners
TDS to Deduct
β‚Ή84,000
@10% on TA commissions
Paid This Month
β‚Ή12.8L
9 transactions
Next Payout Date
5 Apr
Scheduled batch
Partner Payout Queue
🏦 Payout History
DatePartnerTypeGrossTDSNet PaidMethodReferenceStatus
βœ…
Last Reconciliation: Today at 09:00 AM
28 Mar 2026 Β· 247 transactions Β· 3 discrepancies found Β· 2 auto-resolved
Payment Gateway Reconciliation
Matching POS / Razorpay settlements vs. booking records
DateGatewayBookings CountExpectedSettledDifferenceStatusAction
⚠️ Discrepancies
Settlement Timeline
πŸ’§ Monthly Cash Flow β€” FY 2025-26
πŸ“₯ Cash Inflows (This Month)
${[['Ticket Sales (Online)','β‚Ή48,32,000'],['B2B Collections','β‚Ή18,64,000'],['Walk-in Cash','β‚Ή9,12,000'],['Passport Sales','β‚Ή4,99,000'],['F&B Revenue','β‚Ή3,84,000'],['Total Inflows','β‚Ή84,91,000']].map(([l,v],i)=>`
${l}${v}
`).join('')}
πŸ“€ Cash Outflows (This Month)
${[['Staff Salaries','β‚Ή12,40,000'],['Maintenance','β‚Ή8,20,000'],['Marketing','β‚Ή4,80,000'],['B2B Commissions','β‚Ή6,84,000'],['GST Filing','β‚Ή10,33,600'],['Misc Expenses','β‚Ή2,60,000'],['Total Outflows','β‚Ή45,17,600']].map(([l,v],i)=>`
${l}${v}
`).join('')}