Reads A:BM. IDs as text, dates as dates, amounts without decimals.
- Trim + Uppercase for text fields; blanks in A:AV converted to 0.
- Mobile number must be 10 digits or masked like XXXXXX1234; pincode must be 6 digits.
- Customer age must be 18 to 65.
- STRUCTURE INSURANCE (₹) and GPA INSURANCE (₹) must be greater than ₹1,00,000.
- Residential: Construction Rate × Carpet Area must match Structure Insurance.
- Commercial: Structure Insurance must match GPA Insurance.
- Final download creates separate sheets: Fireins Clean, Summary, Master Format and Error Report.
- Premium columns AX:BM are read from uploaded Excel values. Summary TOTAL PRIMIUM uses BJ / Total Property + GPA.
- Insured person and nominee name should not be same.
Records
0
Valid
0
Errors
0
Total Premium
₹0
Structure SI
₹0
GPA SI
₹0
Upload file and click Process. Report premium uses BJ / Total Property + GPA.