Upload A:BL workbook. Export creates Fireins Clean, Summary, Master Format and Error Report. Premium uses BI = Total Property + GPA. AGE in BL is calculated from DOB to DISB DATE when missing.
Waiting for file...
Formula Fix AW:BL is now handled like your Excel. AY/AZ/AD/PTD cached rates are copied from upload; other calculation columns are exported as Excel formulas and summary uses calculated BI value.
BJ is Diff. Premium total is BI - Total Property + GPA. In your sample BI total is ₹846241 and BJ total is -₹702.
| Status | Message |
|---|---|
| Info | Upload and process file. |