Five Reconciliation Rules Every Controller Should Automate

Rules Two and Three: Payouts

Payment processors deposit net amounts, which never match the invoices behind them. A good rule should split each payout into gross revenue and fees.

Use the processor's settlement report to do that split automatically, posting revenue, refunds and fees to their own accounts. The same approach works for bank charges and interest, which can be matched by description pattern and sent straight to the right expense or income account without review.

Anything outside the expected range should be flagged for review rather than auto-matched. A rule that is confident about the normal case and cautious about the unusual one is a rule the team can trust.

Rule Four: Match Customer Receipts to Invoices

Match incoming payments to open invoices by amount and reference first, then by customer and a short date window. This two-step approach catches most receipts even when customers forget to quote the invoice number.

Partial payments should create a remaining balance on the invoice instead of an unmatched item. That keeps receivables accurate and gives the collections team a clean list of exactly what is still outstanding.

Rule Five: Turn Everything Else into New Rules

Whatever the first four rules miss becomes a short exception list for a person to review. On a typical day that list should take minutes to clear, not the hours reconciliation used to consume.

The key is to treat every manual decision as a potential new rule. When someone matches an unusual transaction, the system should offer to remember that pattern for next time. Over a few months the exception list keeps shrinking, the rules become more precise and reconciliation turns into a short daily check rather than a stressful task that piles up at the end of every month.