Motor Policy Manager

Please ensure your Excel file has following columns in order:

1. Serial (optional, will be auto-generated if missing)
2. Date (format: DD/MM/YY) *
3. Policy No. *
4. Portal ID *
5. Agent Name *
6. Customer Name *
7. Vehicle No. *
8. Company
9. Product *
10. NCB (percentage value) *
11. Product Type *
12. Make
13. Model
14. Date of Registration (format: DD/MM/YY)
15. Policy Start Date (format: DD/MM/YY)
16. Policy Expire Date (format: DD/MM/YY)
17. Depreciation (Yes/No)
18. Discount (percentage value)
19. Business Book Date (format: DD/MM/YY)
20. OD Premium (numeric value) *
21. PREMIUM (Total) (numeric value) *
22. Payment Mode

* = Required field