⚠ Could not load data

Ensure the Google Sheet is published: File → Share → Publish to web → CSV.

MTPL Payment Dashboard

Loading…
Live
View
Total Entries
—
All payment records
Total Final Amount
—
Sum of Total Amount
Total Paid
—
Amount Paid collected
Total Remaining
—
Remaining Amt pending
Pending Payments
—
Not fully collected
Collection Rate
—
Paid ÷ Total Amount
class="error-banner" style="margin:0 0 16px 0;">
Payment Status Breakdown
Collected vs Pending vs Partial
Collection by Month
Based on Collection Date
Paid
Remaining
Top SPOCs by Collection
Amount Paid collected per SPOC
Top Products Sold
By number of orders
SPOC Performance
Ranked by collection
#SPOCTopline (₹) Collected (₹)Outstanding (₹) EntriesShareColl.%
Month-by-Month Breakdown
Detailed view
Month Topline (₹) Collected (₹) Outstanding (₹) Entries Paid Pending Refund Cancelled Coll.%
Refund Count
—
—
Refund Amount
—
Total refunded
Cancelled Count
—
—
Cancelled Value
—
Total cancelled value
📋 All Payments — Full Detail
Loading records…
Paid Pending Partial Refund Cancelled
— records
Sr No Name of SPOC Collection SPOC Month Date Name Qty Model Product MRP (₹) Discount (₹) Amt/SQ (₹) Total Amt (₹) GST % GST Amt (₹) Final Amt (₹) Amt Paid (₹) Remaining (₹) Location Delivery Status Date of Delivery Payment Status
—
Filtered Total Amt
—
Filtered Paid
—
Filtered Remaining
—
Filtered Final Amt
—
Filtered Rows
—
Top Products Sold
By number of orders