Commission and trust accounting: Business Central for insurance agencies

Where Business Central for insurance agencies begins and ends

An agency management system centers on the policy. It tracks the client, the carrier and the cover. It produces client invoices and tracks what is owed to carriers. Yet it rarely has strong reports, group totals, fixed assets or budgets.

However, Business Central supplies those. The agency system remains the record for policies and client balances. Instead, finance receives totals by carrier, line of business and office. They arrive each day or each month. We write down that line. So nobody maintains the same balance in two places.

Commission income and producer pay

Agency revenue in Business Central for insurance agencies arrives two ways. On agency-billed policies, the agency keeps its commission from the premium collected. On direct-billed policies, the carrier pays a commission statement. Then both post to commission income. Tags for carrier, line, office and producer make later study easy.

Producer pay depends on new or renewed deals, the split for each account and sometimes a draw. The figures usually come from the agency system or a commission tool. Business Central records the expense and the payable. It pays producers through payroll or as vendors.

Premium trust accounting in Business Central for insurance agencies

Agencies hold premiums they collect for carriers in trust. For this reason, many states expect them in a separate trust bank account. Business Central keeps trust and operating bank accounts apart. You reconcile each against its own statement. You record transfers of earned commission as they happen.

Also, a report compares the trust bank balance with net premiums owed to carriers. So a shortfall is visible at once. However, the rules differ by state, and we do not give legal advice on them. We build the accounts and reports to the needs your own adviser confirms.

Multiple offices and acquisitions with Business Central for insurance agencies

Agencies grow by buying books of business and other agencies. Each new firm can run as its own company at first. Later it can merge into the main one. A shared chart of accounts from the start lets you compare firms before that merger.

You record a bought book of business as an asset. Fixed Assets then writes it off over time. Earn-out payments to sellers are liabilities with a payment schedule. Then group totals join the firms. Office and region tags show which sites do well.

Reporting agency principals rely on

Principals using Business Central for insurance agencies watch revenue by carrier and line. They watch bonus income and pay as a share of revenue. They also watch earnings per office. With commission income coded by dimension, those reports come straight from the ledger. Meanwhile, policy counts and written premium come from the agency system into Power BI.

In addition, budgets by office and producer set expectations for the coming period. Then you compare actuals each month. Bonus pay arrives at odd times. So you can spread it across the period with repeat journals. Then one big payment does not skew monthly results.

Business Central for insurance agencies: what buyers ask

Does Business Central replace an agency management system?

No. It has no policy, coverage or renewal records. It replaces the accounts part of the agency system with a full finance tool. Agencies keep their existing system for client service. They connect it to Business Central for finance. So staff keep the tools they know, and the owners gain far better reporting.

How does data move from the agency system to Business Central?

Most agency systems send out ledger files or offer an API. We map their transaction codes to your accounts and dimensions. Then we import them as journals on a schedule. A check report shows that both systems match after each import. So you catch differences while they are fresh. You do not wait for year end.

Can producers see their own numbers?

Yes. You can give a producer a Power BI report filtered to their own book. It shows income and compensation for the period. Each person sees only their own data. Producers do not need to log in to the ledger. So they get clear answers, and your finance team fields fewer calls.

Is it suitable for carriers or managing general agents?

This page is about retail and wholesale agencies. Carriers need systems for policies, claims and legal reports, with a ledger behind them. Business Central can be that ledger for a smaller carrier or a managing general agent. However, the scope is different. So it needs its own check before you plan.

Can we keep separate books for each office?

You can use a tag per office inside one company. You can also use one company per legal entity when different owners hold the offices. Tags are simpler and suit most agencies. We help you choose by looking at ownership, tax filings and how producers are paid. So the setup fits how your agency works and grows.

Related topics for agency finance leaders

Agencies that buy other agencies should read the multi-company pages first. The other pages listed cover commission calculation and the wider financial services sector. Start with the topic that your principals ask about most. Then ask us how Business Central for insurance agencies can fit your offices. For the product detail, see Business Central documentation on Microsoft Learn.