Insights / Close & reporting
Bank reconciliation automation: matching rules that work
Bank reconciliation is often the single biggest manual task in the close. It doesn't need to be. With daily bank data and good matching rules, most transactions match themselves and the team only reviews exceptions.
Get the data in daily
Use your bank's direct connection or a daily file import into the ERP. Daily matching keeps problems small and moves most reconciliation work before month end.
Write matching rules in layers
- Exact match: same amount and same reference, like a check number or payment ID.
- Amount and date window: same amount within a few days, for items without references.
- One-to-many: one bank deposit matched to several customer payments, which is common with lockbox deposits.
- Recurring items: bank fees, interest and sweeps that can create their own entries automatically.
Fix the source of exceptions
Review unmatched items weekly and ask why each didn't match. Usually it's a missing reference on outgoing payments, cash posted to the wrong account, or deposits split differently than they were recorded. Fixing those upstream improves the match rate every month.
Want this done for you?
We build these processes inside your ERP, usually NetSuite. Start with a free 30-minute teardown.