Reconciliation doesn't take 2 hours. Fixing the mistakes that make reconciliation hard takes 2 hours.
Had a realization this month that kind of changed how I think about our whole close process and wanted to share it.
We track time across all our clients and reconciliation consistently shows up as about 2 hours per client per month. That's pretty standard from what I hear. Everyone says recs take about 2 hours. It's one of those numbers that just gets accepted as normal.
But this month I asked my team to break their rec time down by subtask. Not just log 2 hours to reconciliation but actually track what they were doing during those 2 hours. The results were kind of surprising.
Actually matching transactions between the bank feed and QBO took about 25 minutes on average. That's the thing most people think of when they say reconciliation. It's the core task. And it wasn't even close to being the biggest time block.
Investigating and resolving exceptions took about 20 minutes. These are the transactions where something doesn't line up and you have to dig into it.
But here's the big one. Fixing miscategorized transactions so the reconciliation would even work correctly took 48 minutes on average. That's almost half the total reconciliation time. These are transactions that got auto categorized wrong by QBO's bank rules or that a client went in and changed to the wrong account or that landed in Uncategorized because nothing matched. Before you can reconcile anything you have to clean all of this up first.
The rest was downloading and organizing statements at about 12 minutes, creating adjusting entries at 15 minutes, and documenting the completed rec at about 10 minutes.
So what we call a reconciliation problem is actually almost 40% a categorization problem. The reconciliation itself isn't slow. The data going into it is messy. And messy data means you spend almost half your rec time on cleanup before you can even start the actual matching.
Once we saw this we started thinking about it completely differently. The fix for slow reconciliation isn't getting better at reconciling. It's getting the categorization right in the first place so that when you sit down to reconcile everything is already clean and you're just confirming matches instead of hunting down errors.
I don't know if this is obvious to everyone else or if it's just something we missed at our firm. But it was a genuine shift in how we approach the close and I'm curious if other firms see a similar breakdown when they actually track where their rec time goes