Applied Epic accounting for Canadian brokerages

Applied Epic is a broker management system first

Applied Epic, made by Applied Systems, is the broker management system (BMS) that a large share of Canadian insurance brokerages run on. It manages clients, policies, carriers, activities, and documents, and it also includes an accounting module that maintains a general ledger and ties financial records to the policy and billing data already in the system.

That’s the whole reason Epic accounting matters. In a brokerage, the accounting is the billing: premiums collected, premiums payable to insurers, commissions earned, and producer compensation all flow from policy transactions. When the accounting lives in the same system as the policies, those numbers reconcile from one source. When it doesn’t, they don’t.

What the Applied Epic accounting module actually does

Configured and used properly, the accounting module handles:

• The general ledger: chart of accounts, journal entries, and financial statements.
• Direct bill and agency bill: two different billing flows that Epic models differently (detail below).
• Premium trust: tracking money held on behalf of clients and insurers separately from operating funds.
• Carrier reconciliation: matching insurer statements to what Epic recorded on the policies.
• Commission accounting: recognizing commission income and tracking what producers and sub-brokers are owed.
• Month-end close: bringing all of the above together into a closed, reportable period.

For the module’s screens, permissions, and a monthly review checklist you can run against your own setup, see what is the Applied Epic accounting module? The rest of this guide goes deeper on how these pieces connect to each other and to the rest of Epic, rather than repeating that checklist.

From policy transaction to the general ledger

When a policy is bound, that transaction is the seed of everything downstream. On agency-bill business, Epic generates an invoice to the client and records the amount payable to the carrier. When the client pays, the receipt is entered against that invoice, and the cash lands in trust. When the brokerage remits to the carrier, a disbursement clears part of the trust liability and pays down what’s owed.

On direct-bill business, no invoice or receipt runs through the brokerage’s books, because the carrier bills and collects the client itself. Instead, the carrier’s commission statement, sometimes loaded as a commission download, sometimes entered manually, is what tells Epic what to record: commission income and the commission receivable.

Each of these events, agency-bill receipts and disbursements, direct-bill statement entries, adjustments, generates a journal entry that posts to the general ledger. That’s the mechanism that makes Epic’s accounting more than a policy log: every dollar that moves through billing has a corresponding GL entry, and the trial balance is a byproduct of running the policies correctly rather than a separate exercise.

A bookkeeper working inside Epic each month spends time in a small number of areas: the receipts and payments queue (matching incoming cash to invoices), disbursements and vouchers (paying carriers, producers, and government remittances), the general ledger itself (reviewing and correcting journal entries), and a set of standard accounting reports, billing registers, commission verification, and status of accounts, that show whether the postings line up with what the policies say should have happened. None of that replaces judgment. Epic will post what it’s told; whether the coding, the rate, and the trust math are right is still a bookkeeping decision.

Chart of accounts and structure decisions

Epic’s billing and trust data only means something if the chart of accounts behind it is built for a brokerage, not a generic small business. At minimum that means a trust bank account kept entirely separate from the operating bank account, a trust liability account (premiums payable to insurers, and often a separate return-premium-payable account) that mirrors what the trust bank should hold, a commission receivable for direct-bill business, and a producer or sub-broker payable for commission splits.

GST/HST, and QST for Quebec-based or Quebec-registered brokerages, needs its own accounts too. Premium is generally exempt and commission is generally taxable, so the two need to be tracked separately rather than blended into one revenue line; see GST/HST on insurance brokerage commission for the specifics, and confirm registration and treatment with your tax advisor.

If the brokerage runs multiple branches or more than one corporate entity, decide up front whether trust and operating cash are held and reported per branch or pooled centrally, and make sure that decision is mirrored in both the Epic setup and the corporate ledger. A mismatch there is one of the more time-consuming things to unwind later.

This guide won’t repeat the full structure. See our insurance brokerage chart of accounts guide for the complete list of accounts and how they map to Epic.

Agency bill in Epic

Agency bill is the flow where the brokerage stands in the middle of the money. The brokerage invoices the client for the premium, the client pays, and the payment is receipted into the trust account against that invoice. What the brokerage owes the carrier, the premium net of the brokerage’s commission, sits on the books as a payable until it’s remitted.

When the brokerage pays the carrier, that remittance is a disbursement out of trust, and it should clear the specific payable it was meant to settle, not just reduce a lump-sum trust balance. The trust liability schedule, the record of what the brokerage owes out of trust at any point, is built from these agency-bill payables plus any return premiums owed back to clients. That schedule is what the monthly trust reconciliation compares against the trust bank balance (more below).

Where agency-bill accounting breaks down in Epic is almost always at the edges: an invoice raised for the wrong amount after an endorsement, a receipt applied to the wrong policy or client, or a remittance sent for a different amount than the payable it was supposed to clear. Any of those leaves a balance in the trust liability schedule that doesn’t correspond to real cash, which is exactly the gap a monthly carrier statement reconciliation is built to catch.

Direct bill in Epic

Direct bill is simpler in principle and just as easy to get wrong in practice. The carrier bills and collects the premium directly from the client, so nothing runs through the brokerage’s trust account. What lands in Epic is the carrier’s commission statement, and that statement is what tells Epic what commission was earned and paid.

The reconciliation job is comparing that statement to what Epic expected to earn on the same policies, based on the rates and splits recorded there. Differences show up constantly: a policy the carrier processed but Epic doesn’t have on file, a cancellation or endorsement that changed the commission, a rate that doesn’t match what’s set up in Epic, or a statement that lumps several policies into one line. Each of those is an unmatched item, and unmatched items should be investigated and cleared, not booked as-is and left. Booking whatever the carrier paid without matching it hides both carrier errors and the brokerage’s own data problems, and it’s the fastest way to lose track of what commission income should actually be.

For the line-by-line process, matching statement to policy and working through each type of difference, see how to reconcile direct bill in Applied Epic.

Premium trust in Epic

A premium trust account only does its job if two things exist in the general ledger at the same time: the trust bank account itself, and a trust liability that represents everything the brokerage owes out of that account, agency-bill premiums payable to carriers, return premiums payable to clients, and anything else held on someone else’s behalf. Epic can maintain both sides, but it doesn’t reconcile them for you.

The monthly trust position is derived by comparing the trust bank balance, after a normal bank reconciliation, to the trust liability schedule built from Epic’s agency-bill and payable records. The difference is either a surplus or a shortfall, and a shortfall is a problem the moment it’s found, not something to carry forward and hope corrects itself.

Every Canadian jurisdiction expects brokers to keep client and insurer premium segregated from operating funds and to reconcile it on a defined basis: RIBO in Ontario, the Insurance Council of British Columbia, the Alberta Insurance Council, and the Quebec AMF each set their own specific rules and filing expectations. This guide keeps that part general on purpose; confirm the current requirement with your provincial regulator or your CPA. What doesn’t vary by province is the accounting mechanics: the trust bank and the trust liability both have to exist in the GL, and someone has to reconcile them every month.

For the full mechanics of trust assets versus trust liabilities and how surplus and shortfall work, see our premium trust accounting guide. If you want that reconciliation done for you every month with a dated report your principal broker can file, see premium trust reconciliation.

Month-end in Epic: controls and review points

The sequence of an Epic close, bank and trust reconciliation, carrier statement matching, direct-bill commission reconciliation, accruals, then closing the GL period, is covered step by step in how to run month-end close in Applied Epic. This section covers what to actually check at each stage, rather than the order to run them in.

Before closing, confirm every reconciling item has a documented reason, not just a dollar amount sitting in a suspense account. Review whether adjustments were approved by someone other than the person who posted them, so a coding error and a cover-up look different on paper. Check that the period you’re closing matches the cutoff used on every supporting schedule, trust, carrier, and bank, since a mismatched cutoff is one of the more common reasons a “closed” period gets reopened. And before the GL period locks, confirm direct-bill commission reconciliation is actually finished, not just started, because that reconciliation routinely produces adjustments to commission income and receivables that belong in the period being closed.

Brokerages that run this discipline every month, with the same reviewer checking the same things on the same schedule, get a close that holds up. The ones that skip review steps under deadline pressure are the ones redoing prior periods later. For the close calendar and turnaround itself, see month-end close.

Where Epic accounting goes wrong

Symptom	Likely cause	Fix
Trust bank balance and trust liability schedule never match	Remittances or receipts posted to the wrong policy or payable, or the bank reconciliation itself isn’t current	Reconcile the bank account first, then rebuild the trust liability schedule from agency-bill payables and match line by line
Commission income swings for no clear reason	Direct-bill statements are booked as received without matching to expected commission	Match every statement line to the policy before posting; investigate the gap instead of booking the carrier’s number blind
The “real” numbers live in a spreadsheet, not in Epic	The module was never fully configured, or the person who understood it left	Reconfigure the GL and reconciliation settings, then move the actual close back into Epic
Premiums payable balance keeps growing	Remittances to carriers are irregular or not tied to specific invoices	Remit on a schedule and clear each payable against the remittance that settled it
Producer payable doesn’t match compensation agreements	Splits were set up once and never updated when agreements changed	Review producer payable against current agreements at least annually, and whenever a split changes
Year-end becomes a multi-week reconstruction	Reconciliations only happen occasionally, so differences compound across months	Close every month on a calendar, so year-end is a roll-up instead of a rebuild
GL and Epic show different balances for the same account	Manual journal entries posted to the corporate ledger without a mirrored entry in Epic, or the reverse	Pick one system of record for each balance and document how the other one receives it

Migrating onto Epic accounting or cleaning up a neglected module

Two situations come up constantly: a brokerage migrating onto Epic from another broker management system, and a brokerage that’s been on Epic for years but let the accounting module drift. Both need roughly the same discipline before anything new gets posted.

Start with a mapped opening trial balance: every GL account in the old system, or the neglected Epic setup, needs a home in the corrected structure, including the trust liability, premiums payable, and commission receivable, not just the obvious operating accounts. Before you accept those opening balances, reconcile trust and carrier statements up to the cutover date; carrying forward an unreconciled trust position just moves the problem into the new system with a clean-looking start date.

For a cleanup rather than a migration, pick a cutover date instead of trying to reconstruct every month back to when things went wrong. Reconcile trust, bank, and the largest carrier balances as of that date, correct what’s material, and note what wasn’t fully resolved so it isn’t mistaken for a clean number later.

Either way, the order to reconcile first is the same: bank, then trust, then carrier and commission balances, because trust and commission numbers only mean something once the bank position underneath them is clean.

Who does what: brokerage, BrokerLedger, and Applied Systems

Three parties touch Epic accounting, and it helps to be clear about where each one’s job starts and stops.

The brokerage holds the licence, and the principal broker carries the regulatory responsibility for trust money and financial filings. That doesn’t transfer to anyone else, regardless of who does the bookkeeping. Applied Systems owns the product: hosting, uptime, feature support, and fixing bugs in Epic itself are handled through their own support channels, not through a bookkeeper.

What sits in between is the accounting work: configuring the general ledger and reconciliation settings correctly, running agency- and direct-bill workflows consistently, reconciling trust and carrier statements every month, and closing the period. That’s the part BrokerLedger does, either training your staff to run it or running it directly.

Knowing which of the three you’re dealing with saves time when something goes wrong: a login problem or a system outage goes to Applied Systems support, a trust shortfall or a reconciliation that won’t tie out is an accounting problem, and a filing deadline or licence question stays with the brokerage.

Getting your Epic accounting fixed

This guide covers how Epic accounting is supposed to work. If yours doesn’t, the gap is usually one of three things: the module was never configured properly, the close has drifted into spreadsheets, or a migration left opening balances that don’t reconcile.

BrokerLedger’s Applied Epic accounting service covers all three: module setup and cleanup, trust and carrier reconciliation, and month-end close run inside the system, with a written assessment before anything changes. See how we work inside Applied Epic for the broader picture, or book a discovery call to find out what it would take to get your Epic accounting back on track.