Why Brokerage Books Drift Into Spreadsheets — and How to Keep Applied Epic Clean

There is a pattern we see across Canadian brokerages, and it almost always starts the same way: the accounting quietly leaves the broker management system and moves into spreadsheets.

It is rarely a decision anyone makes on purpose. The accounting module in Applied Epic was never fully configured, or the staff member who understood it left, and the people who remain need an answer today. So they build a spreadsheet to track commissions, or the trust position, or what is owed to carriers. The spreadsheet works — for a while. Then there are two sources of truth, and they stop agreeing.

How the drift happens

The drift is gradual and reasonable at every step:

• A reconciliation falls behind, so someone tracks it manually “just this once.”
• A report Epic could produce feels easier to rebuild in Excel.
• Configuration gaps in the general ledger or reconciliation settings make the in-system numbers look wrong, so they get worked around instead of fixed.
• The workaround becomes the routine, and Epic slowly falls out of sync.

None of these moments looks like a problem on its own. The problem is cumulative.

What it costs

In a brokerage, the accounting is the billing — premiums collected, premiums payable to insurers, commissions earned, producer compensation. When those numbers live in spreadsheets disconnected from the policy data in Epic, three things tend to follow. Trust reconciliation gets harder, because the trust position is no longer falling out of the system. Carrier and commission numbers stop tying out, because nothing is forcing them to reconcile. And year-end turns into a forensic exercise, because the “real” books have to be reverse-engineered from spreadsheets nobody fully documented.

Keeping Epic clean

The fix is not to abandon Epic — it is to use it the way it was designed. That means three things, repeated every month:

1. Configure the accounting module properly — the chart of accounts and the reconciliation settings — so the in-system numbers are trustworthy.
2. Run the agency- and direct-bill workflows consistently, so commissions and premiums payable reconcile from one source.
3. Close every month inside the system, on a calendar, including trust and carrier reconciliation.

When the close happens in Epic every month, the spreadsheets become unnecessary, the trust position is always current, and year-end is just another close. For the full mechanics, see our guide to Applied Epic accounting for Canadian brokerages, and the question many owners start with: does Applied Epic do accounting?