What is invoice reconciliation: three jobs sharing one name

Updated

Invoice reconciliation names three genuinely different jobs performed at different frequencies by different people. Conversations about it go wrong because two people mean different ones. Naming which you mean converts a vague complaint about reconciliation into a specific problem, and it usually turns out that only one of the three is actually causing trouble.

Transaction level

Matching an invoice against the purchase order and the goods receipt. Continuous, performed as invoices arrive, and the one automation genuinely addresses. It fails mostly through absence rather than disagreement, so when this is the one hurting, the fix is upstream discipline and better exception routing rather than any reconciliation tool.

Relationship level

Agreeing a supplier statement against your own record for that supplier. Periodic, tedious, frequently skipped, and the most reliable way to find invoices they raised that you never received. It also finds credits not applied and payments allocated to the wrong item, both of which distort the relationship quietly until somebody looks.

Period level

Tying the payables balance to the creditors figure in the accounts. Differences are usually timing: goods received not invoiced, invoices received not posted, payments in transit. Categorising them into those three groups first leaves a much shorter list of genuine unknowns to investigate properly.

Which one to prioritise

The transaction level, because it is continuous and it prevents the errors the other two later discover. Statement reconciliation for your highest-volume suppliers is a close second, because it finds the leaks. The period-end tie is a check on both rather than a source of improvement in itself.

Questions people ask about what is invoice reconciliation

Can any of it be automated?

The transaction level largely. Statement reconciliation can be assisted since it is a list comparison, but a person usually adjudicates the differences.

Who decides the accounting treatment?

Your accountant. Payables produces accurate detail and dates; the treatment is decided elsewhere.

How often should each happen?

Transaction level continuously, statements monthly for major suppliers, and the ledger tie at each period end.

What does statement reconciliation usually find?

Invoices the supplier raised that you never received, credit notes never applied, and payments allocated against the wrong invoice. All three are cheaper to find monthly than to discover during a dispute about a large balance a year later.

Why do period-end differences persist?

Usually because nobody categorises them, so a timing difference and a genuine error look the same and both get carried forward. Sorting them into the three known groups first leaves a short list worth investigating properly.

Sources

Related answers

Start Threewayly ProKeep the match, not the spreadsheet