Recurring reconciliation discipline post-Fusion-go-live. Row, period, account, Schedule F, Schedule P, NAIC Pages 14/15 reconciled at five cadences. Signed evidence packs for controller, chief actuary, chief reinsurance officer, head of statutory reporting and external audit.
Statutory accounting, SOX, NAIC examination and reinsurance audit all require ongoing reconciliation evidence. Reconciliation runs every cycle — not just before go-live.
P&C insurance carriers operate under a stack of overlapping audit and reporting regimes that all expect ongoing reconciliation evidence: SOX for publicly traded carriers, statutory accounting (SAP) audited annually by state insurance regulators, GAAP for SEC filings, reinsurance treaty audits typically every 2–3 years per major treaty, state-DOI financial condition examinations every 3–5 years per state of domicile, NAIC IRIS ratio surveillance, and the carrier's own internal audit cycle. Every one of these expects the carrier to be able to produce reconciliation evidence on demand showing that its general ledger ties to its policy and claim systems-of-record.
A one-shot pre-go-live data validation check does not satisfy any of those regimes. What they require is ongoing reconciliation that runs every cycle — and produces signed evidence packs each cycle that auditors and examiners can pull on demand. Carriers that go-live without this discipline find themselves doing emergency reconciliation reconstruction the first time external audit or state-DOI examination asks for evidence — and the reconstruction work invariably surfaces issues that would have been caught earlier with a proper recurring reconciliation discipline.
Syntra ETL's duck creek migration reconciliation framework is designed as recurring operating discipline. Five cadences — real-time, daily, monthly, quarterly, annually — operate together. Each produces signed timestamped evidence packs structured to match the audit work papers external auditors and DOI examiners already use. Variances at each cycle are surfaced immediately with row-level diagnostics and named owners for resolution. The carrier enters every audit and examination with reconciliation evidence already prepared and signed — no emergency reconstruction, no scope creep, no findings that derail filings.
The specific insurance-finance dimensions on which Duck Creek and Fusion have to tie out cycle after cycle.
Per policy. Earning curve per policy term, recomputed from Duck Creek source vs posted to Fusion GL. Cancellation and endorsement reshape correctly. Per-LOB per-state reconciliation.
UPR roll-forward: BOP UPR + new written - earned - cancellations = EOP UPR. Per LOB per state per period. Tied out to the cent against Duck Creek-originated UPR.
Case + IBNR: BOP + new claims + adverse development - paid - favorable = EOP. Per claim feature per accident period per transaction period. NAIC Schedule P-ready.
Ceded premium and recoverables per treaty per bordereau period. Recoverable aging per cedant per credit rating. NAIC reserve-credit-for-reinsurance compliance.
Per claim per feature per accident period. Reversal posted to original loss account. Net paid loss after recovery reconciled per LOB per accident year for Schedule P.
Base + override + contingent + bonus. Per producer per period. 1099 totals reconcile across Duck Creek source and Fusion AP.
Five cadences that operate together. Each produces signed evidence used by named audiences.
Every Duck Creek financial event flowing into Fusion hash-validated on arrival. Mean time to detection under 30 seconds. Hash mismatches alerted to integration ops, replayed before next event.
Row-level hash + value reconciliation plus aggregate period-to-date reconciliation per LOB per state. Pack delivered to controller and head of statutory reporting first thing in the morning. Daily variance threshold zero.
Full statutory reconciliation. Schedule F per treaty per bordereau. Reserve roll-forward per claim feature. UPR roll-forward per policy. NAIC Pages 14/15 reconstitution. Delivered to steering within 5 BD of close.
Full evidence pack archived for SOC 1 retention. Signed by controller, chief actuary, chief reinsurance officer, head of statutory reporting, head of internal audit. Immutable timestamped archive.
Annual Statement reconstituted from Fusion and tied out cell-by-cell against Duck Creek-originated version. Schedule F, Schedule P, Schedule T all reconstituted. Statutory accountants sign before filing.
Auditors and examiners pull evidence packs directly from the archive. No reconstruction work required. Variances and resolutions documented in real time over the prior reporting period — every question has an answered audit trail.
Same underlying engine, output tailored for each consumer.
Ledger-level reconciliation: Fusion GL trial balance vs Duck Creek source-of-truth per account per period. Monthly close certification evidence.
Reserve roll-forward per claim feature per accident period. Schedule P loss-development triangles reconstituted. IBNR alignment with actuarial model.
Schedule F per treaty per bordereau. Recoverable aging per cedant per credit rating. Treaty true-ups and profit commission settlements reconciled.
NAIC Annual Statement Pages 14/15 cell-by-cell. State DOI premium tax (PT-1) reconstituted. Surplus lines filings tied out.
SOX evidence: every GL posting traceable to originating Duck Creek source event with full transformation lineage and signed manifest.
Structured to match external audit work papers. Pulled on demand during annual audit. Completeness, accuracy and cutoff evidence per statutory accounting principles.
Duck creek migration reconciliation is the structured proof discipline that demonstrates the Duck Creek-to-Fusion integration produced the right financial result at the row, period, account and statutory-filing levels. It is distinct from data validation in that reconciliation is a recurring operating discipline rather than a one-shot pre-go-live check — reconciliation runs every cycle (real-time, daily, monthly, quarterly, annually) post-go-live and produces signed evidence packs that statutory accountants and external auditors rely on for SOX, statutory accounting and NAIC examination support. The reconciliation framework knows insurance-finance — written vs earned premium, unearned-premium reserve roll-forward, case-reserve and IBNR roll-forward, reinsurance cession per treaty per bordereau, Schedule F and Schedule P reconstitution — and produces results expressed in the same language that the carrier's actuarial team, statutory accountants and external auditors already speak.
Generic ETL reconciliation compares row counts and sum totals between source and target — useful but inadequate for P&C insurance finance. The reasons: (1) the source Duck Creek policy transaction and the target Fusion AR invoice are not one-for-one — one policy transaction may produce multiple Fusion postings spread across the earning curve over the policy term; (2) Schedule F treaty cession requires reconciliation per treaty per bordereau period, not per transaction; (3) loss-reserve roll-forward requires beginning + new claims + adverse - paid - favorable = ending, not just sum comparison; (4) NAIC Pages 14 and 15 require reconciliation cell-by-cell per state per LOB per period; (5) statutory accounting (SAP) and GAAP differ on certain treatments (deferred acquisition cost, for example) and both bases need separate reconciliation. Generic reconciliation tools cannot do any of this. Syntra ETL's duck creek migration reconciliation framework does all of it natively.
Six audiences. Controller — for monthly close certification that the Fusion ledger matches Duck Creek source. Chief actuary — for confirmation that reserve roll-forward and Schedule P loss triangles reconcile per-claim per-period. Chief reinsurance officer — for Schedule F cession reconciliation per treaty per bordereau. Head of statutory reporting — for NAIC Annual Statement Pages 14/15 reconstitution and state DOI filing reconciliation. Head of internal audit — for SOX evidence that the integration produces correct GL postings traceable to source. External auditor — for the annual statutory audit, drawing on the same evidence pack. The framework produces output tailored for each audience — the controller sees ledger-level reconciliation, the chief actuary sees reserve roll-forward, the chief reinsurance officer sees treaty cession, all from one underlying reconciliation engine.
Five cadences operate together. Real-time / per-event — every Duck Creek financial event flowing into Fusion is hash-reconciled at the moment of arrival, mean time to detection under 30 seconds. Daily — full row and aggregate reconciliation as part of overnight close, results to controller and head of statutory reporting first thing in the morning. Monthly — full statutory reconciliation including Schedule F per treaty per bordereau, reserve roll-forward per claim feature, NAIC Pages 14/15 reconstitution, delivered to steering within 5 BD of close. Quarterly — full evidence pack archived for SOC 1 retention, signed by full steering. Annually — Annual Statement reconstituted cell-by-cell against Duck Creek-originated version, statutory accountants sign before filing. The cadence keeps statutory and audit obligations satisfied at all times, no surprises at filing season.
Multi-period adjustments are a recurring P&C insurance reality — adverse development on prior-year claims, favorable development releases, late-reported losses, reinsurance treaty true-ups, premium audit adjustments on commercial policies, retrospective rating adjustments. The duck creek migration reconciliation framework explicitly handles them through a period-allocation discipline: every Duck Creek financial event carries an accident period (or policy period for premium) plus a transaction period; reconciliation tracks reserve roll-forward on the accident-period axis while ledger postings track on the transaction-period axis; multi-period adjustments are reconciled per accident period per transaction period for full transparency. NAIC Schedule P loss-development triangles reconstitute correctly off this. Generic ETL reconciliation gets multi-period adjustments wrong every time.
Reinsurance reconciliation is its own subdiscipline. The framework reconciles per treaty per bordereau period: ceded premium calculated from Duck Creek source vs ceded premium posted as Fusion AP credit memos, loss-ceded calculated from source vs loss-ceded posted as Fusion AP credit memos, recoverables calculated from source vs Fusion AR invoices, treaty true-ups and profit commission settlements per treaty agreement. Schedule F reconstitutes cell-by-cell against the Duck Creek-originated Schedule F. Per-cedant reconciliation tracks recoverable aging by cedant credit rating per NAIC reserve-credit-for-reinsurance rules. The chief reinsurance officer and chief actuary review the reinsurance reconciliation each month and sign off before Schedule F is finalized for any statutory filing.
Salvage (sale of damaged property after the carrier paid the loss) and subrogation (recovery from a responsible third party after the carrier paid the loss) reduce net loss but require careful reconciliation because they post to the same claim feature as the original loss with a reversing sign. The duck creek migration reconciliation framework explicitly tracks salvage and subrogation per claim per feature per accident period — the source event from Duck Creek (typically through a salvage transaction or subrogation transaction in the claim ledger) is reconciled against the Fusion posting (typically an AR receipt offsetting the original AP indemnity entry, with the offset hitting the same loss account). Net paid loss after salvage and subrogation reconciles per LOB per accident year for Schedule P loss-development triangle preparation.
External auditors performing the annual statutory audit need to confirm three things about the Duck Creek-to-Fusion integration: (1) completeness — every Duck Creek financial event that should have reached Fusion did reach Fusion; (2) accuracy — every Fusion posting reflects the correct insurance-finance translation of the source event; (3) cutoff — events are posted in the correct accounting period per statutory accounting principles. The duck creek migration reconciliation evidence pack delivers all three: extraction manifest with counts and hashes confirms completeness; row-level reconciliation with value comparison confirms accuracy; period-allocation reconciliation confirms cutoff. The pack is structured to match the audit work papers external auditors already use — they pull evidence directly without reconstruction. State DOI examiners use the same pack for periodic financial condition examinations.
30-minute call with our P&C insurance-finance integration team. We'll walk through your Duck Creek deployment, your reinsurance program, your statutory and audit calendar — and scope a duck creek migration reconciliation framework before the call ends.