top stories
Reconciliations
| by Ronnie Patton 01 May 1999 |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
We carry out a reconciliation to verify the completeness and accuracy of a particular part of the accounting records by comparing it with another record, as noted in the table below. As can be seen, two reconciliations (debtors’ control and creditors’ control) deal entirely with the firm’s own records, while two (bank and creditors’ account) also deal with records maintained outside the firm. This article outlines a structured approach to debtors’ control and creditors’ control reconciliations.
Control accountsFirst you must ensure that you know exactly how the control accounts are constructed.
Debtors’ controlDebtors represent money owed to the firm by customers. This is recorded as an asset, which is shown as a debit balance.Debtors increase when sales are made to customers on credit. Therefore, sales are shown as a debit entry in the debtors’ control account (with the double entry being completed by a credit entry in the sales account). Debtors decrease when payments are received from customers. Cash received is shown as a credit entry in the debtors’ control account (with the double entry being completed by a debit entry in the cash account). Debtors also decrease if discount is allowed to customers. Discount allowed is shown as a credit entry in the debtors’ control account (with the double entry being completed by a debit entry in the discount allowed account). The result of these entries will be the closing balance of debtors, which will appear on the credit side of the account before being brought down on the debit side. Thus, the debtors’ control account is constructed as in Figure 1.
Creditors’ controlCreditors represent money owed by the firm to suppliers. This is recorded as a liability, which is shown as a credit balance.Creditors increase when purchases are made from suppliers on credit. Purchases are shown as a credit entry in the creditors’ control account (with the double entry being completed by a debit entry in the purchases account). Creditors decrease when payments are made to suppliers. Payments are shown as a debit entry in the creditors’ control account (with the double entry being completed by a credit entry in the bank account). Creditors also decrease if discount is received from suppliers. Discount received is shown as a debit entry in the creditors’ control account (with the double entry being completed by a credit entry in the discount received account). The result of these entries will be the closing balance of creditors, which will appear on the debit side of the account before being brought down on the credit side. Thus, the creditors’ control account is constructed as in Figure 2.
ApproachDebtors control and creditors’ control reconciliations involve four main steps:
2 decide if the difference affects the nominal ledger or the personal ledger; 3 update the nominal ledger; 4 prepare a reconciliation statement.
Step 1: Identify the differences between the two records.
Step 2: Decide if the difference affects the nominal ledger or the personal ledger.
Step 3: Update the nominal ledger. If an entry has been omitted or understated, the adjustment will be on the same side of the control account as the original entry. If an entry has been overstated, the adjusting entry will be on the opposite side of the account.
Step 4: Prepare a reconciliation statement.
Example 1 — Debtors’ control reconciliationThe balance on the debtors’ control account is £78,547, while the listing of balances from the debtors’ ledger is £78,747.The following differences have been identified:
(ii) the cash book had been incorrectly added, with the total being overstated by £99; (iii) an invoice for £670 had been posted to the customer’s account as £760; (iv) a credit balance of £388 on a customer’s account had been listed as a debit balance. Step 1: Has already been completed. Step 2:
(ii) affects the nominal ledger; (iii) affects the personal ledger; (iv) affects the listing of balances from the personal ledger.
Step 3:
(i) this entry should have been made on the credit side of the account, so a credit entry of £765 is needed;
Step 4:
(iv) £388 has been added to the listing, but should have been deducted. An adjustment of £776 (£338 x 2) is needed, reducing the total balances: The listing of balances can now be revised :
Example 2 — Creditors control reconciliationThe balance on the creditors control account is £35,684, and the listing of balances from the creditors ledger is £34,704.The following differences have been identified (Step 1):
(ii) the total value of cheques paid was entered in the nominal ledger as £22,450. The correct total was £24,250; (iii) a balance of £758 on a customer’s account has been included in the list of balances as £578. Step 2:
(ii) affects the nominal ledger; (iii) affects the listing of balances. Step 3:
(ii) a debit entry has been understated, so a debit entry is required (£1,800):
Step 4:
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unable to open a PDF document? To open a PDF you need Adobe Acrobat Reader, which can be downloaded for free from the Adobe website.
