Fire Insurance Lot Auto Process

Upload & Details

Sheet name expected: Fireins. Upload data A:AV; formula block AW:BL is created; final premium is from BI - Total Property + GPA.

Upload Excel

Lot NoDate of Payment / MISUTRNIL Branch LocationSM ID

Attached Section

Upload supporting files if required. File names will be added in the downloaded report.

File processed successfully. Download final report.

Total Rows84

Total Premium BI₹5,00,591

Error Rows19

Diff Total BJ₹-10,920

Validation Conditions

A:AV uploaded data is trimmed and converted to uppercase.
Blank cells in A:AV are converted to 0.
Mobile number should be 10 digits or valid masked 10 characters.
Pincode should be 6 digits.
Customer age should be between 18 and 65 only when GPA tenure is not 0.
Structure Insurance must be greater than ₹1 lakh. GPA Insurance validation applies only when GPA tenure is not 0.
Residential: Construction Rate × Carpet Area must match Structure Insurance.
Commercial: Structure Insurance must match GPA Insurance.
Insured person and nominee should not be the same.

Preview / Error Report

84 rows processed

Status	Application ID	Case No	Property Type	Age	Premium BI	Error
ERROR	1730692	744061	GPA+BGR+RESI	75	₹885	Customer age should be between 18-65
OK	1767166	755146	GPA+BGR+COMM	47	₹18,451
OK	1739493	746349	GPA+BGR+RESI	54	₹4,342
ERROR	1753788	750641	GPA+BGR+RESI	69	₹2,514	Customer age should be between 18-65
OK	1719510	741134	GPA+BGR+RESI	36	₹6,781
OK	1729578	745377	GPA+BGR+COMM	35	₹21,087
OK	1776759	755840	GPA+BGR+COMM	64	₹13,179
ERROR	1702938	738208	GPA+BGR+RESI	68	₹929	Customer age should be between 18-65
OK	1742726	748364	GPA+BGR+RESI	62	₹2,084
OK	1732392	750316	GPA+BGR+RESI	24	₹1,115
OK	1715117	740521	GPA+BGR+COMM	47	₹52,718
OK	1748305	750469	GPA+BGR+COMM	45	₹18,451
OK	1711351	741029	GPA+BGR+RESI	50	₹10,747
OK	1717418	748986	GPA+BGR+RESI	22	₹3,143
ERROR	1640469	726005	GPA+BGR+RESI	75	₹1,712	Customer age should be between 18-65
OK	1739798	749777	GPA+BGR+RESI	44	₹4,000
OK	1738143	747410	GPA+BGR+RESI	54	₹1,931
OK	1739798	749777	GPA+BGR+RESI	44	₹4,000
ERROR	1752204	749730	GPA+BGR+RESI	68	₹6,552	Customer age should be between 18-65
OK	1718513	741214	GPA+BGR+RESI	53	₹3,290
OK	1628266	736760	GPA+BGR+RESI	43	₹2,512
ERROR	1705751	738803	GPA+BGR+RESI	69	₹1,109	Customer age should be between 18-65
ERROR	1717933	746414	GPA+BGR+RESI	75	₹877	Customer age should be between 18-65
OK	1752628	749900	GPA+BGR+RESI	56	₹4,572
OK	1737052	745800	GPA+BGR+RESI	40	₹5,407
OK	1731358	746476	GPA+BGR+RESI	40	₹1,487
OK	1764652	753481	GPA+BGR+RESI	36	₹1,392
OK	1749271	750503	GPA+BGR+RESI	38	₹679
OK	1700816	738833	GPA+BGR+RESI	38	₹12,573
OK	1747180	750928	GPA+BGR+RESI	34	₹2,407
OK	1715706	740579	GPA+BGR+RESI	40	₹3,892
OK	1747632	750804	GPA+BGR+RESI	57	₹5,149
OK	1751536	750007	GPA+BGR+RESI	52	₹978
OK	1758259	751909	GPA+BGR+RESI	59	₹3,362
OK	1735118	747619	GPA+BGR+RESI	25	₹8,453
OK	1755194	751997	GPA+BGR+RESI	38	₹2,055
ERROR	1701981	738280	GPA+BGR+RESI	73	₹1,092	Customer age should be between 18-65
OK	1745557	747806	GPA+BGR+RESI	29	₹1,142
ERROR	1736286	744504	GPA+BGR+RESI	81	₹6,295	Customer age should be between 18-65
OK	1747834	750733	GPA+BGR+RESI	52	₹8,071
OK	1749935	748947	GPA+BGR+RESI	47	₹1,671
OK	1731241	747141	GPA+BGR+RESI	44	₹2,180
OK	1754439	750200	GPA+BGR+RESI	37	₹4,307
OK	1734197	753247	GPA+BGR+RESI	20	₹1,759
OK	1736760	748550	GPA+BGR+RESI	36	₹4,984
OK	1701555	739359	GPA+BGR+RESI	29	₹3,230
OK	1750047	750190	GPA+BGR+RESI	43	₹4,893
OK	1766267	754193	GPA+BGR+RESI	63	₹2,053
ERROR	1731589	749716	GPA+BGR+RESI	68	₹5,244	Customer age should be between 18-65
OK	1733674	748091	GPA+BGR+RESI	32	₹3,420
OK	1720521	748683	GPA+BGR+RESI	46	₹3,743
OK	1733058	746509	GPA+BGR+RESI	40	₹4,772
OK	1750700	750723	GPA+BGR+RESI	33	₹17,281
OK	1739982	751737	GPA+BGR+RESI	45	₹2,304
OK	1733709	744499	GPA+BGR+RESI	43	₹3,972
ERROR	1713618	737916	GPA+BGR+RESI	69	₹5,962	Customer age should be between 18-65
OK	1710720	740265	GPA+BGR+RESI	35	₹3,905
OK	1763187	752740	GPA+BGR+RESI	34	₹934
OK	1760052	751775	GPA+BGR+RESI	44	₹31,030
OK	1752226	749271	GPA+BGR+RESI	51	₹4,101
OK	1743253	750771	GPA+BGR+RESI	44	₹5,978
ERROR	1730456	748137	GPA+BGR+RESI	68	₹3,746	Customer age should be between 18-65
OK	1710152	741839	GPA+BGR+RESI	55	₹6,832
OK	1764610	753998	GPA+BGR+RESI	31	₹6,613
OK	1706644	739394	GPA+BGR+RESI	51	₹2,070
OK	1746813	749964	GPA+BGR+RESI	60	₹7,415
ERROR	1742113	746050	GPA+BGR+RESI	84	₹677	Customer age should be between 18-65
OK	1748131	751525	GPA+BGR+RESI	39	₹6,759
ERROR	1701507	738379	GPA+BGR+RESI	66	₹5,099	Customer age should be between 18-65
OK	1723605	750501	GPA+BGR+RESI	50	₹8,427
OK	1733177	746762	GPA+BGR+RESI	49	₹5,559
ERROR	1763138	752768	GPA+BGR+RESI	73	₹4,431	Customer age should be between 18-65
OK	1743715	750248	GPA+BGR+RESI	39	₹2,575
ERROR	1720615	744138	GPA+BGR+COMM	67	₹3,374	Customer age should be between 18-65
OK	1738252	749558	GPA+BGR+RESI	51	₹2,739
ERROR	1753513	749377	GPA+BGR+RESI	68	₹13,553	Customer age should be between 18-65
ERROR	1697926	736611	GPA+BGR+RESI	68	₹6,643	Customer age should be between 18-65
ERROR	1758362	750209	GPA+BGR+RESI	66	₹5,610	Customer age should be between 18-65
OK	1729381	746504	GPA+BGR+RESI	55	₹5,371
OK	1729224	751514	GPA+BGR+RESI	31	₹1,918
OK	1746114	748940	GPA+BGR+RESI	27	₹5,645
OK	1710519	744029	GPA+BGR+RESI	51	₹6,007
OK	1724939	744163	GPA+BGR+RESI	53	₹10,670
OK	1572616	716616	GPA+BGR+COMM	35	₹9,720