Payables account reconciliations: formula sheet

Key formulas

Basic reconciliation idea

Balance per supplier statement ± reconciling items = Balance per payables ledger account ± adjustments

Both sides should end at the same figure once all differences are explained.

Items that change the supplier's figure

Cash in transit (payment you sent, not yet on the statement) → deduct from statement balance; goods returned not yet credited by the supplier → deduct from statement balance

These are timing items. They need no entry in your ledger because you have already recorded them.

Items that change your ledger

Error or omission in your ledger → correct your payables ledger by journal or ledger entry; a valid invoice missing from your ledger → add to the ledger balance once verified; query disputed or unreceived items with the supplier

Examples: invoice omitted (once verified as valid and yours), credit note omitted, invoice posted twice, transposition error. Update your ledger, then the control account.

Direction of payables balance

Payables ledger balance = credit balance (amount owed to supplier)

Increase with invoices; decrease with payments, credit notes and discounts received.

Control account layout

Opening payables + Credit purchases − Purchase returns − Payments to suppliers − Discounts received − Contra entries = Closing payables

Debit side: payments, returns, discounts received, contras, and any closing debit balances. Credit side: opening balance, purchases, and any refunds received from suppliers.

Reconciliation rule

Control account balance (after corrections) = Total of payables ledger list (after corrections)

Correct each figure only for the errors that affected it.

Contra entry

Dr Payables ledger control; Cr Receivables ledger control

Used when a customer is also a supplier and you set off the amounts. It reduces both control accounts and the individual ledger accounts.

Errors that need no control account correction

Error in an individual supplier account or in the list only → adjust the list

Error in a daybook total or in the control account posting → adjust the control account.

Control account balance

Opening credit balance + credit purchases − purchase returns − payments − discounts received − contras = closing credit balance

Use the same layout every time. Credits (increases in payables) are added, debits are deducted.

Reconciliation rule

Corrected control account balance = corrected sum of payables ledger balances

If these still differ after all corrections, an error remains or you have put an item on the wrong side.

Contra entry

Dr Payables control account, Cr Receivables control account

Both control accounts fall. Individual supplier and customer accounts are also adjusted.

Debit balance in list

Total list = sum of credit balances − sum of debit balances

Debit balances reduce the list total. Do not add them.

Which account to change

Total error → control account. Individual account error → list of balances.

Some errors, such as an omitted invoice, affect both.

Quick revision

• A supplier statement is the supplier's record of what you owe; your ledger account is your record.
• Your payable is the supplier's receivable, so the views are mirror images.
• Reconcile by comparing the statement balance with the ledger balance, then explaining each difference.
• Goods or payments in transit are timing differences and need no correction in your ledger.
• Errors in your own ledger need correcting; errors by the supplier need to be queried with them.
• The control account total should equal the sum of the individual supplier balances.
• Purchases increase what you owe; payments to suppliers, purchase returns, discounts received and contras decrease it.
• Credit balances on the control account are the normal position for payables.
• Errors in totals posted to the general ledger are corrected in the control account; errors in individual supplier accounts are corrected in the list of balances; some errors affect both.
• When the trial balance does not balance, the difference is first posted to a suspense account, and the suspense account is cleared when the error is found and corrected.
• Always check whether the question asks for the corrected balance or the adjustment.
• Check the direction of each adjustment before you enter your number.

Common mistakes

• Adjusting your ledger for timing differences such as cash in transit. Fix: If you have already recorded the item, leave your ledger alone. Only adjust the statement side in the reconciliation.
• Adding a credit note instead of deducting it. Fix: Ask whether you owe more or less after the item. Credit notes and payments mean you owe less.
• Putting purchases on the debit side of the control account. Fix: Remember that the payables account holds what you owe. An increase in a liability is a credit. Purchases on credit go on the credit side.
• Including cash purchases or cash sales in the control account. Fix: Only credit transactions with suppliers belong. Cash purchases are paid at once and never create a payable.
• Adjusting both the control account and the list for every error. Fix: Ask where the error occurred. A wrong supplier posting changes the list only. A wrongly added day book changes the control account only.
• Adding a debit balance to the list total. Fix: Remember the list is mainly credit balances. A debit balance is subtracted from the list total.

Exam tips

• Read which balance the question wants: the corrected ledger figure or the figure per the supplier. Many marks are lost here.
• Only adjust your ledger for your own errors and omissions. Timing items like cash in transit go on the statement side.
• In multiple response questions, select exactly the number of items stated and test each against 'does this need a ledger entry?'
• For number entry, work out the direction first: payables are credit balances, so credit notes and payments reduce them.
• Always check that your two adjusted figures agree. If they do not, recheck the signs before moving on.
• Objective test questions often ask for one figure only, such as the closing balance or the corrected list total. Read the final line before you start working.
• In number entry questions, give the figure in the format asked and do not add a currency sign unless it is requested.
• In multiple response questions, check each statement separately against the rule: which record does this error affect?