


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

LOB, Program, Geography, Treaty and Investment, on the same dimensions as the GL.
Program ID, IFRS 17 groupings, NAIC ASL, OSFI groupings, IBC coverage, actuarial group, intra-group.
Gross written, ceded, net and earned premium planning.
Loss ratio, expense ratio and combined ratio.
Headcount, comp and benefits by department.
Actuals load nightly from NetSuite; closed periods actualize after month-end close.
Budget v1, Final Review, Board Approved, plus quarterly forecast archives.
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’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.
01.
Built on NSAW, holds transaction-level detail
02.
Owned by Finance or data stewards, not IT
03.
Journals, invoices or any NetSuite transaction type
04.
Every posting validated and reconciled automatically
05.
From GL summary to policy- and claim-level detail
06.
Automated controls and IT general computing controls


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
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.
01
ACE lineage IDs auto-match summarized journals to detailed sub-ledger records in the ACE ODS.
02
Thousands of policy or claim events against one summarized entry, or one bank deposit against many premium receipts.
03
Across sub-ledger, GL, and bank / payment processor statements.
04
Processor batches, fees, and chargebacks against premium collected.
05
Claim payments against cleared bank activity, with exceptions surfaced automatically.
06
Premium receivable, unearned premium, claims and commissions payable, reinsurance recoverables, suspense accounts.
07
Tolerance thresholds, exception queues, and reconciling-entry creation.
08
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.
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.
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
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


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