//
Industries

Insurance

NetSuite, built for insurance finance — from the policy admin export to the statutory filing.
//
NETSUITE CONSULTANTS

ERP for Insurance

Insurance runs on promises, data, and trust, yet many carriers, MGAs, MGUs, program administrators, and specialty insurers still close the books on legacy GL systems like Great Plains, spreadsheets, and manual journal entries keyed from policy admin and agency management system (AMS) exports. Premium, commission, claims, and reinsurance activity is high-volume and lives in proprietary sub-ledgers, while Finance is expected to deliver a faster close, statutory and GAAP/IFRS reporting, program-level profitability, and a clean audit trail.

MHI has built a path from fragmented, spreadsheet-driven finance to a modern, scalable, cloud-based insurance finance platform on NetSuite.

Combining NetSuite ERP, NetSuite Planning & Budgeting (NSPB), NetSuite Analytics Warehouse (NSAW), and MHI’s proprietary Accounting Class Engine (ACE), we give insurance finance teams sub-ledger-to-GL automation, full data lineage, and insurance-grade reporting, so they can scale programs, onboard new MGAs and acquisitions, and GROW.
//
BUSINESS IMPACT
Insurance finance teams are expected to deliver a faster close, statutory and GAAP/IFRS reporting, program-level profitability and a clean audit trail — from high-volume premium, commission, claims and reinsurance activity. NetSuite, extended with MHI’s insurance solutions, delivers all four on one platform.
Direct integration icon

Faster close, clean audit trail

Sub-ledger-to-GL automation, journal entry approval workflows and role-based segregation of duties (SOX-ready), and a full audit trail from GL balance back to policy, claim and transaction detail.

One transaction, every book

A single source transaction posts to the primary US GAAP book and every secondary book — statutory (SAP / NAIC), IFRS 17, IFRS 9, tax-basis or local regulatory — with no double entry and no off-system statutory spreadsheets.

Program-level profitability

Segments for line of business, program, geography, treaty and investment support program and divisional P&L, and loss ratio and combined ratio analysis by segment.
//
Solutions & Areas of Impact

Record to Report — the insurance finance foundation

Multi-Entity Structure & Consolidation
Secondary Book for Non-GAAP Reporting
Insurance-Ready Chart of Accounts & Segments
Close, Controls & Audit
Premium, Billing & Order to Cash
Claims, Commissions & Procure to Pay
Reporting & Analytics

Multi-Entity Structure & Consolidation

Holding company, carriers, MGAs, reinsurance and shared-services entities in one instance.
Holding company, operating carriers/MGAs, reinsurance entities, and shared-services entities in one instance (NetSuite OneWorld)
Elimination subsidiaries for intercompany and consolidated reporting
Shared-cost allocations from the holding company / shared services to operating entities
Multi-currency (e.g., USD/CAD) for cross-border groups

Secondary Book for Non-GAAP Reporting

One source transaction, every book: GAAP, statutory, IFRS and tax (Multi-Book Accounting).
Primary book on US GAAP, with one or more secondary books for statutory (SAP / NAIC Annual Statement), IFRS 17, IFRS 9, tax-basis, or local regulatory (e.g., OSFI) reporting
A single source transaction posts to every book, so there is no double entry and no off-system statutory spreadsheets
Book-specific adjustments only where accounting treatments differ (e.g., non-admitted assets, acquisition cost deferral/DAC, unearned premium and loss reserve treatment, discounting, risk adjustment)
Book-specific chart of accounts mapping, exchange rates, and period close
Book-specific financial statements and trial balances for statutory filings, regulators, rating agencies, and parent-company reporting
Reconciles GAAP to STAT and GAAP to IFRS differences in-system with a full audit trail
Built to scale for M&A, new program launches, and new MGA onboarding

Insurance-Ready Chart of Accounts & Segments

Reporting dimensions built for insurance, from line of business to treaty.
Segments for Line of Business (LOB), Program, Geography / Risk Location, Treaty, and Investment
Custom segments for NAIC Annual Statement Line (ASL), IFRS 17 groupings, regulator groupings (e.g., OSFI), IBC coverage codes, and actuarial groups
Program-level and divisional P&L, loss ratio and combined ratio analysis by segment
COA designed to support statutory (SAP), GAAP, and IFRS reporting

Close, Controls & Audit

A SOX-ready close with a full audit trail from the GL back to the policy.
Journal entry approval workflows and role-based segregation of duties (SOX-ready)
Accruals, reversals, and period close management
Bank connectivity (BAI2) and automated bank reconciliation by entity, including premium trust / fiduciary accounts
Full audit trail from GL balance back to policy, claim, and transaction detail

Premium, Billing & Order to Cash

Policy, billing and commission activity from policy admin systems and AMS, into the ledger.
Policy, billing, and commission activity integrated from policy admin systems and AMS
Summarized journal entries or customer-level invoicing, your choice
Broker and agent receivables, including direct bill and agency bill
Customer categories for domestic brokers, fronting brokers, and child broker relationships
Customer deposits and collateral tracking (e.g., fronting collateral)
Earned/unearned premium and revenue recognition
Cash application and credit card / payment processor settlement

Claims, Commissions & Procure to Pay

Claims, commissions and reinsurance payables tied to the policy and the premium collected — plus faster claim payments and a real-time cash position.
Vendor categories for claimants, brokers, reinsurers, and regular vendors
Claim payouts and claim vendor invoices with claim-level detail
Broker and agent commission payables
Reinsurance bills, ceded premium, and recoverables tracking by treaty, facultative reinsurer, and fronting company
Transaction-level insurance attributes: policy/bond number, risk location, transaction type, commission rate, treaty
PO and vendor bill approvals, Electronic Bank Payments, employee expenses, fixed assets
The value goes beyond claim-level visibility: Finance gets a more timely and accurate picture of cash position, including claim reserves, payables due, and collections in flight
Provider and claim vendor invoices are managed in NetSuite and tied directly to the policy, claim, and premium collected, so verifying collections takes far less time
Verified collections let Finance cut payments to providers, claimants, and vendors faster (everyone wants their check faster)
Fewer payment exceptions and manual look-ups between claims systems, bank activity, and the GL
Electronic Bank Payments for batch ACH/wire disbursements, with approval workflows and controls
Better provider relationships, lower claims leakage, and stronger cash forecasting and liquidity management

Reporting & Analytics

One source of truth, from the executive dashboard to the policy-level detail.
Real-time dashboards and KPIs for executives, Finance, and program leaders
Summary-to-detail (drill-through) reporting on premium, revenue, billing, claims, and settlements
Policy metrics and claims reporting via NetSuite Analytics Warehouse (NSAW)
Bordereaux-ready data for program and reinsurance reporting
Retire custom reports and spreadsheets; NetSuite becomes the single source of truth
// NetSuite Planning & Budgeting (NSPB) for Insurance

Driver-Based Insurance Planning

Insurance FP&A is still largely done in Excel: an annual budget, a manual monthly budget-vs-actual, and forecasts at the consolidated level only. Insurers need to plan the way they report, by LOB, program, geography, and regulatory groupings, and NSPB lets them do that natively on top of NetSuite actuals.

10-20%

Typical share of the ERP effort

8-12 weeks

Typical deployment

Use case

Plan by segment

LOB, Program, Geography, Treaty and Investment, on the same dimensions as the GL.

Insurance dimensions

Program ID, IFRS 17 groupings, NAIC ASL, OSFI groupings, IBC coverage, actuarial group, intra-group.

Premium and revenue

Gross written, ceded, net and earned premium planning.

Ratio forecasting

Loss ratio, expense ratio and combined ratio.

OPEX, CAPEX and workforce

Headcount, comp and benefits by department.

Rolling forecasts

Actuals load nightly from NetSuite; closed periods actualize after month-end close.

Scenarios and versions

Budget v1, Final Review, Board Approved, plus quarterly forecast archives.

Excel-native reporting

Income statement, balance sheet and cash flow through Smart View.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.Outcome: Remove manual budget-vs-actual work, give Finance and program leaders a shared view of plan vs. actual by segment, and speed up board and finance committee reporting.

// MHI Proprietary

ACE – Accounting Class Engine

MHI’s Accounting Class Engine (ACE) is a proprietary transaction classification and summarization engine for NetSuite. It turns high volumes of accounting events from policy admin, billing, claims, and payment systems into summarized, auto-reconciled transactions in NetSuite, with full data lineage back to the source sub-ledger.

MHI reports a 100% win rate against Workday Accounting Center.

How it works

01.

Sub-ledger ODS

Built on NSAW, holds transaction-level detail

02.

Business-defined rules

Owned by Finance or data stewards, not IT

03.

Summarized posting

Journals, invoices or any NetSuite transaction type

04.

Balance and control

Every posting validated and reconciled automatically

05.

Drill-through reporting

From GL summary to policy- and claim-level detail

06.

SOX-compliant framework

Automated controls and IT general computing controls

What it does for insurers

  • Consolidated billing transactions and invoices

  • Claim vendor invoices and payouts

  • Cash and credit card settlement and reconciliation via journal entry

  • Cost accruals

  • Premium revenue recognition

  • Summary-to-detail revenue and billing reporting

  • Claims reporting and policy metrics

  • Reconciliation algorithms (transactional, balance, and non-financial) with exception management and reconciling entries

// Summary-to-Detail Reconciliation

ACE + NetSuite Account Reconciliation (NSAR)

ACE summarizes high-volume policy, billing, claims, and payment events into lean GL postings. NetSuite Account Reconciliation (NSAR) completes the loop by matching those summarized postings back to their underlying detail and to external sources, so Finance can trust the summary without rebuilding the detail.

// What NSAR matches and reconciles

01

Transaction matching

ACE lineage IDs auto-match summarized journals to detailed sub-ledger records in the ACE ODS.

02

Many-to-one and one-to-many

Thousands of policy or claim events against one summarized entry, or one bank deposit against many premium receipts.

03

Three-way reconciliation

Across sub-ledger, GL, and bank / payment processor statements.

04

Cash and card settlement

Processor batches, fees, and chargebacks against premium collected.

05

Claims disbursement

Claim payments against cleared bank activity, with exceptions surfaced automatically.

06

Balance-sheet reconciliations

Premium receivable, unearned premium, claims and commissions payable, reinsurance recoverables, suspense accounts.

07

Rules-based auto-match

Tolerance thresholds, exception queues, and reconciling-entry creation.

08

Reconciliation compliance

Preparer/reviewer workflow, sign-offs, aging, and audit-ready evidence for SOX controls.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Suspendisse varius enim in eros elementum tristique. Duis cursus, mi quis viverra ornare, eros dolor interdum nulla, ut commodo diam libero vitae erat. Aenean faucibus nibh et justo cursus id rutrum lorem imperdiet. Nunc ut sem vitae risus tristique posuere.Outcome: A faster close, fewer manual reconciliations in spreadsheets, and a defensible summary-to-detail audit trail.

Source systems supported

01.

Policy management / policy administration systems

02.

Claims management systems

03.

Billing systems and agency management systems

04.

Credit card and payment processors

Outcome: Keep the GL lean and the detail auditable. Process millions of policy and claim events without bloating NetSuite, shorten the close, and replace manual sub-ledger-to-GL reconciliations.

//
Functionality

What’s in the solution set

A core set of insurance finance capabilities, extended with add-ons for the way your programs run.
Included · Added to fit your operation

Our functionality list

Core

Multi-entity OneWorld setup with eliminations and intercompany

Multi-book support for GAAP and non-GAAP (STAT/IFRS) reporting

Insurance COA and segments (LOB, Program, Geography, Treaty, NAIC ASL, IFRS 17)

Insurance vendor and customer categories (claimant, broker, reinsurer, fronting broker)

Insurance transaction fields (policy/bond #, risk location, commission rate, treaty, facultative reinsurer)

Summarized JE import from policy admin and AMS

JE approvals, bank connectivity, and automated bank reconciliation

Add-Ons

ACE – Accounting Class Engine (sub-ledger summarization and auto-reconciliation)

NetSuite Analytics Warehouse (NSAW) – policy, claims, and premium analytics

NetSuite Planning & Budgeting (NSPB) – LOB and program planning

Policy admin, claims, and billing integrations

Payment processor and credit card settlement automation

NetSuite Account Reconciliation (NSAR) – summary-to-detail transaction matching with ACE

Multi-Book Accounting – secondary books for STAT, IFRS 17, and tax

Premium trust / fiduciary account reconciliation

// Client stories
Kaitlyn image

Working with Myers-Holum as an integrated part of our team enabled us to quickly implement NetSuite and unlock the system’s power and benefits in just four months. This enabled us to eliminate many of our prior pain points in the organization. Our team benefits from the efficiency and power of NetSuite on a daily basis and we continue to work with Myers-Holum to streamline, enhance, automate, and optimize our procedures through the NetSuite system.

Michael Sothen
CFO, Balavant Insurance Group
Gates logo
Colleagues reviewing a project together on a laptopColleagues reviewing a project together on a laptop
// How we implement

Four decades of successful implementations

MHI has successfully completed over 1,000 projects for companies ranging in size from the Fortune 500 to mid-market, and is recognized as a leading NetSuite Alliance Partner.

Our CPG practice spans specialty food and condiments, supplements and functional beverage, hydration and sports nutrition, beverage distribution, personal care and car care, home goods and furniture, apparel and travel goods, and wine import and distribution — including a number of the fastest-growing brands in supplements and functional beverage.

Our NetSuite practice

Let’s discuss your next project