MIS and Reporting for Indian Risk Managers: Building Dashboards That Drive Renewal Decisions

Insurance programmes at Indian enterprises are frequently managed in an information vacuum. The risk manager or CFO responsible for the company's insurance portfolio often has limited visibility into the most basic operational data: total premium spend across all policies, claims frequency and severity by policy class, loss ratios by location or business unit, broker performance metrics, and policy expiry dates and renewal timelines.

This data deficit is not a technology problem. The underlying data exists: every premium payment generates an invoice, every claim generates a file, every policy generates a schedule. The problem is that this data is scattered across multiple systems and stakeholders. Premiums are tracked by the finance department in the accounting system. Claims are managed by the broker and the insurer, with the policyholder often receiving only periodic status updates. Policy documents are filed (physically or digitally) without structured data extraction. Loss prevention recommendations from risk engineering surveys sit in PDF reports that are read once and archived.

The consequence is that renewal decisions, the single most consequential insurance decision a company makes each year, are based on incomplete information. The risk manager approaches renewal knowing only the current premium and, perhaps, a rough sense of the claims experience. They lack the data to answer fundamental questions: Is our loss ratio improving or deteriorating? Which locations are driving the most claims? Are we paying more for coverage than comparable companies in our industry? Is our broker delivering value beyond transaction processing?

In an Indian market context, this data deficit is particularly costly. Indian commercial insurance premiums are determined through negotiation between the insured (via the broker) and the insurer's underwriter. Unlike personal lines (motor, health) where rates are largely standardised, commercial rates for fire, marine, liability, and engineering lines are heavily influenced by the insured's loss history, risk quality, and negotiating strength. A risk manager who walks into a renewal negotiation armed with complete data, trending loss ratios, benchmarked premiums, documented risk improvements, and clear coverage requirements, achieves materially better outcomes than one who relies on the broker's summary and the insurer's renewal quote.

Building an insurance MIS is not a multi-year IT project. It is a structured approach to collecting, organising, and analysing the data that already exists within the organisation and its insurance partners. The tools can be as simple as a well-designed Excel workbook or as sophisticated as a cloud-based analytics platform, depending on the complexity of the insurance programme.

An effective insurance MIS tracks a defined set of metrics across four dimensions: cost, claims, coverage, and compliance. Each dimension provides distinct insights that, in combination, give the risk manager a complete picture of the insurance programme's performance.

Cost metrics centre on premium spend. Total annual premium, broken down by policy class (fire, marine, motor, liability, engineering, health, miscellaneous), by business unit or subsidiary, and by location, is the foundation. Track premium as a percentage of revenue (or turnover) to benchmark against industry averages. For Indian manufacturing companies, total insurance premium typically ranges from 0.15% to 0.40% of revenue, though this varies widely by industry (chemical and petrochemical companies tend toward the higher end, IT services companies toward the lower end). Year-on-year premium change, broken down into rate change and exposure change (change in sum insured or asset values), reveals whether premium increases are driven by insurer pricing decisions or by growth in the insured base.

Claims metrics track frequency (number of claims per year), severity (average and maximum claim amount), and loss ratio (claims paid plus reserves as a percentage of premium). Loss ratio is the single most important metric for renewal negotiations, because it directly indicates whether the insurer is making or losing money on the account. An incurred loss ratio below 40% gives the insured strong grounds to negotiate premium reductions. A loss ratio above 70% signals that the insurer will seek premium increases or coverage restrictions at renewal. Track loss ratio on an incurred basis (including outstanding reserves for open claims) rather than a paid basis (which can understate the true loss experience if large claims are still being settled).

Coverage metrics assess the adequacy and completeness of the insurance programme. Sum insured as a percentage of replacement value (for property insurance) or revenue (for BI insurance) indicates whether the programme is keeping pace with asset growth and inflation. Coverage gap analysis, comparing the risks identified in the company's risk register against the perils and scenarios covered by the insurance programme, identifies uninsured or underinsured exposures. Deductible analysis, tracking the amount of losses retained below deductible levels, reveals the true 'self-insured' portion of the risk.

Compliance metrics track operational aspects: policy expiry dates (ensuring no lapses), premium payment timelines (Section 64VB of the Insurance Act requires premium payment before or at the time of risk inception), outstanding risk improvement recommendations from surveyors (which, if not addressed, may provide the insurer with grounds to restrict coverage), and regulatory filing requirements (such as declarations under open policies for marine cargo).

Data without visualisation is a spreadsheet. A spreadsheet with 50 columns and 500 rows of insurance data is useful to the person who built it but inaccessible to the CFO, the board risk committee, or the plant manager who needs to understand the insurance implications of their operational decisions. Dashboards transform data into visual narratives that drive decisions.

The executive summary dashboard should fit on a single screen (or a single printed page) and answer five questions: What did we spend on insurance this year? How does that compare to last year? What is our claims experience telling us? Where are our biggest coverage gaps? What actions are needed before the next renewal? Use large-format numbers for the headline metrics (total premium, total claims, overall loss ratio), trend charts for year-on-year comparisons, and a traffic-light system (green, amber, red) for metrics that require attention.

The claims analysis dashboard should provide drill-down capability: from total claims to claims by policy class, from policy class to claims by location, from location to individual claim details. Heat maps showing claims frequency and severity by location (on a map of India, if the company operates multiple sites) immediately identify problem locations that require risk improvement attention. Pareto charts showing the top 10 claims by value, and their cumulative contribution to total claims cost, highlight the large losses that dominate the insurance programme's performance.

The renewal preparation dashboard is the most operationally valuable. It should be populated 90 days before the principal renewal date and should contain: a five-year loss ratio trend (showing the insurer whether the account is improving), a summary of risk improvements completed since the last renewal (with before and after photographs and investment amounts), the current sum insured with inflation adjustment recommendations, a comparison of the expiring policy terms against the risk manager's desired terms (deductible levels, sub-limits, exclusions to be negotiated), and a competitive benchmarking section showing how the company's premium rates compare to available market data.

Design principles for insurance dashboards in the Indian context: use INR formatting consistently (INR crore for large amounts, INR lakh for smaller amounts, never mixing the two on the same chart). Use financial year (April to March) as the default time axis, not calendar year, since Indian insurance programmes, financial reporting, and tax calculations are aligned to the financial year. Label all charts with clear titles and source notes. Avoid cluttering dashboards with too many metrics; the goal is to surface the 5 to 8 metrics that matter most, not to display everything the MIS can calculate.

For tools, most Indian risk managers can build effective dashboards using Microsoft Excel or Google Sheets for companies with fewer than 50 policies and straightforward programmes. For larger programmes (100+ policies, multiple business units, international operations), consider dedicated insurance management platforms such as Origami Risk, Riskonnect, or India-specific solutions from providers like Riskcovry or Artivatic. These platforms offer pre-built insurance analytics templates, automated data ingestion from insurer portals, and collaboration features for multi-stakeholder workflows.

Claims data is not just an insurance metric. It is operational intelligence that identifies where the business is losing money due to preventable events. A risk manager who analyses claims patterns and translates them into risk improvement recommendations creates value far beyond insurance cost management.

Frequency analysis identifies recurring loss patterns. If a textile mill files seven motor burnout claims in three years, the pattern suggests a systemic electrical maintenance issue rather than random equipment failure. If a logistics company's marine cargo claims are concentrated in a specific transit route (say, the Nhava Sheva to Chennai coastal route), it suggests a packaging, stowage, or carrier selection problem specific to that route. If a food processing plant's machinery breakdown claims spike during the monsoon season, it may indicate humidity-related deterioration of control systems that could be prevented with environmental controls.

Severity analysis identifies the loss scenarios that drive the majority of insurance costs. In most Indian commercial insurance portfolios, the Pareto principle applies: 20% of claims account for 80% of claim costs. Identifying and addressing the root causes of the few large losses has a disproportionate impact on the overall loss ratio. A single INR 5 crore fire claim at one location can dominate a company's loss ratio for years, making investment in fire prevention at that location (automatic sprinklers, fire detection, housekeeping improvements) the highest-return risk improvement the company can make.

Root cause analysis goes beyond frequency and severity to ask why losses are occurring. Categorise claims by proximate cause: electrical fire, mechanical failure, human error, weather event, theft, third-party negligence. Then drill into each category. Are electrical fires caused by ageing wiring, overloaded circuits, or inadequate maintenance? Are machinery breakdowns occurring in equipment that has exceeded its design life? Are theft claims concentrated at locations with inadequate security measures?

Translating analysis into action requires the risk manager to prepare risk improvement recommendations with business case justification. For each recommended improvement, estimate the implementation cost, the expected reduction in claim frequency or severity, and the payback period. A fire suppression system costing INR 50 lakh that is expected to reduce fire loss severity by 60% at a location with an average annual fire loss of INR 30 lakh has a payback period of under two years, even before considering the premium reduction that the insurer may offer in response to the improved risk.

Present claims analysis and risk improvement recommendations to the insurer and broker at least 60 days before renewal. Insurers respond positively to policyholders who demonstrate data-driven risk management. A presentation showing a declining loss ratio trend, documented risk improvements, and a forward-looking risk improvement plan strengthens the case for premium reductions, broader coverage, and lower deductibles at renewal. It transforms the renewal from a price negotiation into a risk partnership discussion.

The insurance broker is the risk manager's most important external partner. Yet most Indian companies do not systematically measure their broker's performance, relying instead on subjective impressions and the annual renewal outcome. Building broker performance metrics into the MIS transforms this relationship from trust-based to evidence-based.

Service quality metrics track the broker's operational performance. Response time to queries (measured from the risk manager's request to the broker's substantive response), policy issuance turnaround (time from premium payment to receipt of the policy document), claim intimation support (time from the risk manager's loss notification to the broker's filing of the claim with the insurer), and endorsement processing speed (time from endorsement request to confirmed endorsement issuance) all measure whether the broker delivers timely, efficient service.

Market access metrics assess whether the broker is using its market relationships effectively. Number of insurer quotations obtained at renewal (a broker that presents only one quote is not providing competitive market access), range of premium rates obtained (the spread between the cheapest and most expensive quote indicates how actively the broker worked the market), and the quality of insurers presented (credit ratings, claim settlement track records) all indicate the depth and effectiveness of the broker's market reach.

Technical quality metrics evaluate the broker's advisory contribution. Quality of the renewal presentation (does it include loss analysis, market comparisons, coverage gap identification, and recommendations?), accuracy of sum insured advice (did the broker identify under-insurance risks before the renewal?), proactive risk management support (does the broker organise risk engineering surveys, facilitate loss prevention training, or share market intelligence?), and claims advocacy effectiveness (does the broker actively negotiate with the insurer on disputed claims, or merely transmit correspondence?) all measure the broker's value as a technical advisor, not just a transaction intermediary.

Compensation transparency metrics track what the broker earns from the relationship. Under IRDAI regulations, brokers must disclose their remuneration to the client. Track the broker's commission or brokerage as a percentage of premium for each policy class and compare it to the IRDAI-prescribed maximum rates (varying by class, typically 12.5% for fire, 15% for marine, 10% for motor). If the broker earns fees in addition to or instead of commission, track the total remuneration and assess whether it is commensurate with the services delivered.

Conduct a formal broker performance review annually, at least 60 days before the renewal cycle begins. Present the metrics to the broker, discuss areas for improvement, and set performance expectations for the coming year. This review serves two purposes: it motivates the broker to deliver better service (knowing their performance is being measured), and it provides the risk manager with objective data to support broker retention, renegotiation, or replacement decisions.

For large Indian companies running formal broker RFPs (request for proposals), historical broker performance data from the MIS provides an invaluable baseline for evaluating incumbent and prospective brokers against objective criteria rather than sales presentations.

One of the most valuable outputs of an insurance MIS is the ability to benchmark the company's premium rates against the broader Indian market, providing objective evidence of whether the company is paying a fair price for its insurance coverage.

Benchmarking in Indian commercial insurance is challenging because premium rate data is not publicly available. Unlike personal lines (where standardised tariffs and online comparison tools provide transparency), commercial rates are negotiated individually based on the insured's risk profile, loss history, sum insured, occupancy class, and the competitive dynamics of the particular insurer market at the time of renewal.

Despite this opacity, risk managers can construct useful benchmarks from several sources. Industry associations, such as CII, FICCI, and sector-specific bodies (the Indian Drug Manufacturers' Association, the Federation of Indian Chambers of Commerce and Industry), occasionally publish survey data on insurance costs as a percentage of revenue or turnover. Insurance brokers with large commercial portfolios can provide anonymised benchmarking data showing the range of rates for comparable risks (same industry, same sum insured range, similar loss histories). Reinsurance market reports from Swiss Re, Munich Re, and Guy Carpenter publish broad pricing trends for the Indian market by class of business.

To build an internal benchmark, track your own premium rates over five years: rate per mille (premium per INR 1,000 of sum insured) for fire and property classes, rate per unit of revenue for BI, and rate per vehicle or per employee for motor and workers' compensation respectively. Plot these rates as a trend and overlay them with any available market data to assess whether your rates are converging toward, above, or below the market average.

The burning cost method provides a company-specific benchmark. Calculate the average annual claims cost (net of deductibles and recoveries) over the past five years and express it as a rate per INR 1,000 of sum insured. This 'burning cost' represents the minimum rate that would be actuarially justified by your own loss experience, before adding the insurer's expense loading and profit margin. If your current premium rate is significantly higher than the burning cost (a common situation for companies with improving loss ratios), you have strong evidence to negotiate a reduction at renewal.

Present benchmarking data at renewal as part of the negotiation package. Frame the data constructively: 'Our five-year incurred loss ratio is 28%, our burning cost rate is INR 0.35 per mille, and the current premium rate of INR 0.65 per mille represents a loading of 86% above the burning cost. We are seeking a rate of INR 0.50 per mille, which provides the insurer with a 43% loading over the burning cost and is consistent with the market range for our risk profile.' This data-driven approach is far more effective than simply asking the insurer for a 10% discount.

Building an insurance MIS requires collecting data from multiple sources, and the practical challenges of data collection in the Indian insurance ecosystem should not be underestimated.

Policy data comes from the policy documents themselves. For each policy, extract and store: policy number, insurer name, policy class, inception and expiry dates, sum insured (by section and sub-section), premium (gross, net, and GST), deductible levels, key terms and conditions, and endorsement details. In India, policy documents are typically issued as physical documents or scanned PDFs, not as structured digital data. Extracting structured data from these documents requires manual entry (for smaller portfolios) or OCR and document processing tools (for larger portfolios).

Claims data comes from the insurer and broker. Request a quarterly claims bordereau (a structured listing of all claims) from each insurer, showing claim number, date of loss, date of intimation, cause of loss, claimed amount, paid amount, outstanding reserve, and status (open, settled, rejected, withdrawn). Most Indian insurers can provide this data in Excel format upon request. Some larger insurers offer online claim tracking portals that provide real-time access to claim status.

Premium payment data comes from the finance department's accounting system. Cross-reference premium payments against policy invoices to ensure all premiums are paid (Section 64VB compliance), GST input credits are correctly claimed, and the total premium spend reconciles with the policy records.

Risk engineering data comes from survey reports prepared by the insurer's risk engineer or an independent surveyor. Extract key data from these reports: risk grade or score, fire protection system adequacy, electrical installation condition, housekeeping assessment, and specific risk improvement recommendations with their implementation status.

The most common data quality challenges in Indian insurance MIS are inconsistent policy numbering across insurers, multiple policies with different expiry dates creating a fragmented data collection timeline, claims data that is updated with varying frequency by different insurers (some provide monthly updates, others only upon request), and the absence of a unique risk identifier across policies (the same factory may be referred to by different names in the fire policy, marine policy, and liability policy).

To address these challenges, create a master location register that assigns a unique internal identifier to each insured location, linked to the various policy references used by different insurers. Establish a standard data collection calendar (for example, claims data quarterly, policy data at each renewal, risk survey data annually) and assign responsibility for each data stream. Use data validation rules in your MIS to catch common errors: premium amounts that do not match policy schedules, claim dates that fall outside the policy period, and sum insured figures that have not been updated for inflation.

The ultimate purpose of an insurance MIS is not to produce reports. It is to produce better renewal outcomes: lower premiums, broader coverage, higher policy limits, and fewer coverage gaps. Converting MIS data into renewal strategy requires a structured approach that begins 90 to 120 days before the renewal date.

At T-minus 120 days, generate the pre-renewal analytics package. This includes the five-year loss ratio trend by policy class, the current sum insured adequacy assessment (comparing declared values against replacement values adjusted for inflation), the claims cause analysis identifying the top loss drivers, the broker performance review, and the premium benchmarking analysis. Share this package with the broker and schedule a pre-renewal strategy meeting.

At T-minus 90 days, conduct the pre-renewal strategy meeting with the broker. Using the MIS data, agree on the renewal objectives: target premium range (supported by burning cost and benchmarking data), coverage changes to pursue (based on gap analysis), deductible modifications (higher deductibles to trade for premium reductions where the company's balance sheet can absorb the retention), and insurer strategy (whether to renew with the existing insurer, invite competitive quotes, or restructure the programme across multiple insurers).

At T-minus 60 days, share the renewal submission with the market. The submission should include the risk manager's data pack: current schedules of insured values, five-year claims history, risk improvement investment summary (with photographs), and a clear statement of the coverage and terms sought. This data pack, drawn directly from the MIS, distinguishes the risk manager as a sophisticated buyer and sets the expectation that the renewal will be data-driven.

At T-minus 30 days, evaluate the quotes received against the MIS benchmarks. Compare each insurer's proposed rate against the company's burning cost and market benchmarks. Compare proposed deductibles against the company's actual below-deductible loss experience (the MIS tracks losses below the deductible that were not claimed, providing insight into the true retention cost). Compare coverage terms against the gap analysis, ensuring that the most critical gaps identified in the MIS are addressed in the new policy.

At renewal, update the MIS with the new policy data and reset the tracking cycle for the coming year. Capture the negotiation outcomes (premium change, coverage changes, deductible changes) as part of the renewal record, so that year-on-year performance can be tracked and the cumulative impact of the MIS-driven approach can be measured.

Companies that have adopted this data-driven renewal process consistently report premium savings of 10% to 25% over a three-year period, not through aggressive market-switching (which can be counterproductive in the relationship-driven Indian insurance market) but through better-informed negotiations with existing insurers and brokers. The investment in building and maintaining an insurance MIS, typically requiring one to two days per month of a risk manager's time once established, generates returns that are orders of magnitude larger.