All resources

Applied Epic

Preparing Your Accounting Operations for an Applied Epic Conversion

Independence note NJTS provides independent consulting and administrative support. It is not an Applied Systems partner or reseller and is not affiliated with or certified by Applied Systems. The conversion itself is run by the agency with Applied or its implementation partner. This article covers the accounting preparation around it.

A move to Applied Epic, whether from another agency management system, from accounting software, or from another Epic database, is usually planned as a technology project. The accounting consequences arrive later: opening balances that don’t tie out, open items nobody can explain, and a first month-end that takes twice as long. Most of that can be prevented by treating accounting readiness as its own workstream, starting months before go-live.

Clean up before you convert

Conversion moves data. It does not fix it. Unreconciled balances, duplicate clients, old open items and unapplied cash in the old system become unreconciled balances in the new one, now harder to research. Consultant guidance commonly places preparation and data clean-up at the start of the conversion process. Before the final conversion data is extracted:

  • Reconcile bank accounts, including trust accounts, with every reconciling item supported.
  • Reconcile Agency Bill receivables and premium payables detail to the general ledger.
  • Work down unapplied cash, suspense and credit balances. Return premiums owed to insureds should be refunded or clearly identified.
  • Reconcile Direct Bill commission receivable or suspense balances, and producer payables.
  • Write off or resolve items that are known to be uncollectible or invalid, with approval.
  • Document what remains open, with amounts, so it can be tied out after conversion.

Decisions that shape the accounting

Several set-up decisions are hard to change later. Make them deliberately, with accounting involved:

  • Agency structure: how agencies, branches, departments and profit centers map to how the business is managed and reported.
  • Chart of accounts: mapping old accounts to the new structure; which accounts are control accounts fed by transactions.
  • Accounting basis and commission settings: how the agency recognizes income, and how producer commission expense, payables and payments are handled. Epic’s settings must reflect the agency’s actual policy, and some features depend on those settings.
  • Code alignment: carriers, lines, producers and other codes mapped from the old system, with the mapping retained for reference.
  • Reports: which reports the owners, accounting team and producers will rely on, defined before go-live rather than rebuilt afterwards.

Opening balances: prove them

After conversion, the agency should prove that opening balances in Epic equal the reconciled closing balances in the old system:

  • by balance-sheet account;
  • for receivables and payables detail;
  • for trust cash.

Applied’s guidance for an agency’s first month on Epic includes verifying that client beginning balances agree with the accounts receivable opening balance.

Illustrative Example | Fictional Data The agency, figures and events below are fictional and are included only to illustrate the method.

Harbor & Pine Insurance Agency (fictional) closes its old system with reconciled net client receivables of $512,300. After conversion, client beginning balances in the new system total $518,700. The $6,400 difference traces to two kinds of credit balance left out of the conversion file:

  • $4,100 of return premiums owed to insureds;
  • $2,300 of unapplied customer payments.

Because credits reduce a net receivable, dropping them made the converted total higher.

Opening receivables tie-out after conversion (fictional)
Amount
Converted client beginning balances$518,700
Old system reconciled net receivables$512,300
Difference$6,400
Return-premium credits not converted$4,100
Unapplied payments not converted$2,300
Unexplained$0

Without the tie-out, $6,400 of amounts owed to insureds and unapplied cash would have disappeared from the receivable detail. That carries a regulatory dimension for return premiums owed.

Cutover: what to freeze, and what not to lose

  • Agree a cutoff date and the activity that must be complete in the old system by then: receipts applied, statements reconciled, payables paid or listed.
  • Define what happens during any blackout period: how receipts and urgent transactions are recorded, and who enters them in Epic afterwards.
  • Keep read-only access to the old system and its reports for research. Many post-conversion questions are answered there.
  • Back up and archive old-system reports that support the opening balances.

The first closes after go-live

Plan for the first two or three month-ends to take longer:

  • Run a parallel tie-out: compare key balances and reports from Epic with expectations built from the old system’s trends.
  • Follow the new month-end sequence (locking, generating journal entries, closing, then reporting) and write it into the close calendar.
  • Expect new kinds of differences: download suspense queues, statement matching and producer payables behave differently in a new system. Assign owners early.
  • Review configuration after the first close. Structure, allocation and commission settings are easier to correct after one month than after twelve.

After conversion: documentation and ownership

Document the agency’s Epic accounting procedures: receipts, statements, payables, month-end and the reconciliations. Train more than one person on each. A conversion is the best opportunity an agency will have to make accounting work less dependent on one person’s memory.

How NJTS helps

NJTS supports the accounting side of system transitions:

  • readiness reviews and pre-conversion reconciliation clean-up;
  • structure and chart-of-accounts mapping input;
  • opening-balance tie-outs;
  • first-close support;
  • documentation, alongside Applied Epic administration and configuration support for accounting-related settings.

See Accounting Operations and Insurance Agency Accounting.

Planning a conversion? Describe your timeline and current system. No confidential records are needed to start.

Discuss conversion readiness