KRISHNA HYUNDAI
| Bodyshop ERP
User
Total Invoice Value
₹ 0
0 Claims
Insurance Settled
₹ 0
Settlement Ratio: 0%
Insurance Pending (Open)
₹ 0
0 claims awaiting payment
Short Deductions & Cust. Dues
₹ 0
Ins Short: ₹0 | Cust: ₹0
Branch-wise Invoice vs Collected
Top Insurance Companies (by Pending)
Insurance Company Performance Matrix
| # | Insurance Company | Claims | Invoiced | DO Amount | Received | Sett. % | Pending Qty | Pending Amt | Short | Priority |
|---|
| Branch | R.O. No | Customer | Regn / Model | Insurance Co. | Policy No | Claim No | Invoice Amt | DO Amount | DO Date | Cust. Liab. (Auto) | Cust. Paid | MR No | Payment Mode | Pay 1 (Base) | Pay 1 Date | Pay 1 UTR | Bank Statement 1 | Pay 2 (GST) | Pay 2 Date | Pay 2 UTR | Bank Statement 2 | Pay 3 | Pay 3 Date | Pay 3 UTR | TDS | Total Rec. | Ins. Balance | Ins. Status | Del |
|---|
Customer Liability = Invoice Amt - DO Amt (auto-calculated). All changes save instantly to AWS Database.
Delete / Clean Uploaded Data
Remove test or trial imports instantly from the server database.
1. Daily Import – GDMS RO Billing Report
Upload daily RO Billing report. Automatically saved to AWS database.
Drag & drop Excel file here or click to browse
Open Pending Claims
Insurance Short Payment (>₹10)
Excess Received
User & Branch Access Management
Existing Users
AWS Database Storage Status
All records are safely stored on your permanent AWS server instance (`erp_database.sqlite`).