Monthly reconciliation worked until it didn't — here's when to switch

We reconciled monthly for seven years. Then we hired someone whose previous agency reconciled weekly, and she looked at our process like we were still using carbon paper.

She was half right. Monthly reconciliation works fine until you cross about $4M in written premium. After that, the month-end close starts to feel like an archaeological dig. You're reconciling 40 carrier statements at once, chasing down discrepancies that happened three weeks ago, and discovering that someone moved a policy between carriers on the 8th but nobody told accounting.

Weekly reconciliation fixes some of that. It also creates new problems. Here's what actually changes when you move from monthly to weekly, and the revenue threshold where it starts to make sense.

The staff time math doesn't work the way you think

Most operators assume weekly reconciliation takes four times as long as monthly. You're doing the work four times, right?

Wrong. Monthly reconciliation at a $6M agency takes our accounting person about 12 hours. That's not 12 hours of data entry. That's 3 hours of matching payments, 6 hours of investigating variances, 2 hours of correcting AMS entries, and 1 hour of wondering why Travelers sent us a check for a policy we moved to Progressive in February.

Weekly reconciliation takes about 90 minutes per week. That's 6 hours a month. Half the time.

The reason is simple. When you reconcile weekly, variances are small and recent. You're comparing 8 transactions instead of 35. When something doesn't match, you remember why. The policy that moved carriers? You reconciled it three days after it moved, when the email thread was still in your inbox.

Monthly reconciliation batches all your mistakes into one terrible afternoon. Weekly reconciliation spreads them across four normal mornings.

But this only works if you have weekly statements. Most carriers still send statements monthly. If you're reconciling weekly but waiting for monthly statements, you're just doing data entry four times for no reason.

Cash flow visibility is the real reason to switch

The staff time argument is interesting. The cash flow argument is why we actually switched.

At $4M in premium, our monthly commission revenue averaged about $65K. Some months were $45K, some were $90K. We didn't know which until the 5th of the following month, after we'd closed the books and reconciled everything.

That's fine if your cash position is comfortable. It's not fine if you're trying to decide whether to hire, or whether you can cover payroll and a $15K software payment in the same week.

Weekly reconciliation gives you a rolling 7-day view of commission income. You know by Wednesday what hit your bank account on Monday. You know by the 8th of the month whether you're trending toward a $45K month or a $90K month.

This matters more as you grow. At $2M in premium, a $20K variance is annoying. At $8M, a $20K variance might mean you're not paying bonuses this quarter.

The carrier statement problem is worse than the software problem

Every AMS can handle weekly reconciliation. Most agency operators think the blocker is software. The blocker is carriers.

Progressive, Travelers, and Nationwide will send you weekly statements if you ask. Hartford will not. Safeco will send you something they call a weekly statement, but it's actually just last week's transactions appended to a month-to-date summary, and good luck parsing that.

Smaller regional carriers are worse. I have one carrier that sends statements on the 10th of the following month, every month, no exceptions, no early access via portal. If I reconcile weekly, I'm reconciling that carrier monthly anyway.

This means most agencies that reconcile weekly are actually running a hybrid system. They reconcile 60% of their book weekly and 40% monthly. That's still better than reconciling everything monthly, but it's not the clean process the AMS demo promised you.

The threshold is $4M in written premium, maybe $3M if you're growing fast

Below $3M, monthly reconciliation is fine. Your accounting person spends one afternoon a month on it, variances are small enough to absorb, and you probably don't have the staff depth to handle weekly reconciliation if your accounting person is out sick.

Between $3M and $5M, it depends on your growth rate and your cash management style. If you're growing at 20% a year, weekly reconciliation gives you better visibility into whether that growth is profitable. If you're stable at $4M and have six months of operating cash, monthly is fine.

Above $5M, you should reconcile weekly. Not because monthly is impossible, but because the cost of a surprise is too high. A $30K variance in a $100K commission month is a planning problem. You'll make different decisions in week two if you know it's coming.

We switched at $6M. I wish we'd switched at $4M.

What to do next

Call your top five carriers and ask whether they can send weekly statements. If three of them say yes, try weekly reconciliation for 90 days and measure the actual time spent.