How to reconcile accounts payable so it ties, and what to do when it will not

Knowing how to reconcile accounts payable matters because it is the check that most often finds a real error. You are proving that the list of what you owe supplier by supplier agrees with the single balance the ledger carries for payables. The two are built differently, which is precisely why the comparison is worth doing: the subsidiary ledger is assembled invoice by invoice and the control account is the sum of what was posted, so anything posted directly, entered twice or allocated wrongly shows up as a difference. This page is the five steps, the four differences that cause most breaks, and how to work back efficiently when it will not tie.

Take both sides at the same cut-off

The aging at the period end and the control account balance at the same period end. Reconciliations that will not tie are very often comparing two different moments, and establishing that first saves an afternoon of looking for an error that does not exist.

List the differences and explain each one

Do not net them. A reconciliation that reaches zero by offsetting two unexplained items has proved nothing. Each difference gets a reason and, where needed, a correcting entry. A difference with a reason attached is evidence; a difference that cancels another is a coincidence you have chosen to trust.

Work back from the largest

Sort by amount rather than reading every line. In small teams the four usual causes are a duplicated invoice, a payment allocated to the wrong supplier, a manual journal posted straight to the control account, and a credit note recorded one side only. Sorting by size finds all four quickly.

Questions people ask about how to reconcile accounts payable

How often should we reconcile payables?

At every period end, without exception, because the balance appears on the statements being signed off. Monthly is the minimum and there is no good reason to do it less often.

What if the difference is small?

Explain it anyway. Small unexplained differences are how genuine errors hide, and a recurring small difference is usually a systematic problem worth finding once.

Should the reconciliation be reviewed?

By someone other than the preparer where possible. Where the team is too small for that, the compensating control is that an owner or director sees it, which is also what an auditor will ask about.

Sources

Related answers

Start Monthendly ProGet Monthendly Pro, $43 a month