Free Excel template · ASC 606 / ASC 340-40

Audit Program: Insurance Agency or Brokerage

An insurance agency holds client premiums as a fiduciary and earns commissions that arrive months after the sale. The main risks are misuse of fiduciary money, contingent commissions recognized too early and receivables and payables that do not reconcile to carrier statements.

Standard
ASC 606 / ASC 340-40
Format
Excel (.xlsx)
Cost
Free
Access
No sign-up

What it is

An insurance agency holds client premiums as a fiduciary and earns commissions that arrive months after the sale. The main risks are misuse of fiduciary money, contingent commissions recognized too early and receivables and payables that do not reconcile to carrier statements.

This program covers commission and fee revenue, fiduciary cash and liabilities, producer compensation and acquisitions, and licensing and claims. It is a five-tab workbook with sign-off columns and a completion summary.

When to use it

What’s inside

Standard cited

This template follows ASC 606 / ASC 340-40. It is written in our own words, except for phrases the standard requires the document to contain, with [bracketed placeholders] for client details, amounts in USD and dates as MM/DD/YYYY. Check it against the current standard and your firm’s methodology before use.

Download free Excel template (.xlsx)

Questions

How are contingent commissions recognized?

They are variable consideration under ASC 606. The entity recognizes an amount only to the extent a significant reversal is not probable. The program tests the estimate against carrier statements received later.

Are state fiduciary rules covered?

The program tells you to read the rules in each state of operation. They differ by state and the program does not restate them.

Does it tie to the fiduciary reconciliation workbook?

Yes. The related workbook in this library performs the year-end recomputation the program calls for.

Related templates

Last updated 11/05/2026. All free templates.