Skip to main content

Financial Oversight

Role Required: SUPER_ADMIN / TNCHS_ADMIN
Navigation: Sidebar → Financial Reports
Last Updated: March 2026 | Portal Version: 1.0

Overview​

Financial Oversight provides comprehensive reporting across the entire platform. You can view financial summaries at three levels: State (all societies), Region (all societies in a region), and Society (individual society). Reports break down collections, refunds, and net position by online/offline channels.

Report Levels​

LevelScopeUse Case
StateAll regions and societiesPlatform-wide financial health
RegionAll societies in a regionRegional performance comparison
SocietySingle societyDetailed society financials

Financial Summary​

The financial summary report provides a complete picture of money flow:

Key Metrics​

MetricDescription
Gross CollectionsTotal payments received (online + offline)
Gross RefundsTotal refunds processed (online + offline)
Net CollectionsGross Collections − Gross Refunds
Membership FeesEntrance fees, share capital, GST collected
Booking PaymentsAdvance payments, EMI installments, final payments

Running a State-Level Summary​

  1. Navigate to Financial Reports → Summary
  2. Select scope: State (all societies)
  3. Set the date range (start and end dates)
  4. Click Generate
  5. The report shows:
    • Total gross collections across all societies
    • Total gross refunds
    • Net position
    • Breakdown by membership vs. booking payments
    • Online vs. offline channel split

Running a Regional Summary​

  1. Select scope: Region
  2. Choose the target Region from the dropdown
  3. Set the date range
  4. The report aggregates all societies within that region

Running a Society Summary​

  1. Select scope: Society
  2. Choose the specific Society
  3. Set the date range
  4. The report shows that society's complete financial picture

Collections Breakdown​

The collections report provides granular detail on all payments received:

Online Collections​

  • Payment gateway transactions (Razorpay)
  • Advance payments (typically 10% of plot cost)
  • EMI installments
  • Full settlement payments

Offline Collections​

  • Cash payments
  • Cheque / DD payments
  • NEFT / RTGS / IMPS bank transfers
  • UPI payments recorded manually

Filtering​

FilterDescription
Society IDView a specific society
Region IDView all societies in a region
NeitherState-wide view (all societies)
Date RangeStart and end date (inclusive)

Refunds Breakdown​

The refunds report shows all refunds processed:

Categories​

  • Online Refunds: Processed back through the payment gateway
  • Offline Refunds: Manual refunds (cash/cheque returns)
  • Full Refunds: Complete booking cancellation refunds
  • Partial Refunds: Plot downgrades or partial cancellations
  • Penalty Deductions: Amounts retained as cancellation fees

Understanding Net Impact​

Net Financial Position = Gross Collections − Gross Refunds

Example for a quarter:
  Gross Collections: ₹2,50,00,000
  − Gross Refunds:     ₹12,00,000
  ──────────────────────────────────
  Net Collections:   ₹2,38,00,000

Cross-Society Comparison​

To compare financial performance across societies:

  1. Run society-level summaries for each society you want to compare
  2. Compare key metrics:
    • Collection efficiency (collected vs. outstanding)
    • Refund rate (refunds as percentage of collections)
    • Membership fee collection
    • Online vs. offline payment mix

Periodic Reporting​

Daily​

  • Check for any unusual refund activity
  • Verify large offline payment recordings

Weekly​

  • Review regional financial summaries
  • Compare week-over-week collection trends

Monthly​

  • Generate state-level financial summary
  • Review net position trends
  • Audit offline payment verification compliance

Quarterly​

  • Comprehensive state-level review
  • Regional comparison analysis
  • Identify underperforming societies

Common Scenarios​

"I need a financial overview for a board meeting"​

  1. Run the State-level Financial Summary for the current quarter
  2. Note: Gross Collections, Gross Refunds, Net Position
  3. Export the data for your presentation

"Which region is collecting the most?"​

  1. Run Regional Summaries for each region for the same period
  2. Compare Gross Collections across regions
  3. Factor in the number of active societies per region for fair comparison

"A society's refund rate seems high"​

  1. Run the Refunds Breakdown for that society
  2. Check refund count and total amounts
  3. Look at refund reasons in the society's refund management section
  4. Compare with the society's audit logs for any irregularities

"I need an offline vs. online payment comparison"​

Both the collections and refunds reports include channel breakdowns:

  • Online Collections vs. Offline Collections
  • Online Refunds vs. Offline Refunds
  • This helps assess digital adoption across societies