FA – L1 – Q52 – Control accounts and account reconciliations

Kofi Enterprises maintains accounts on a fully integrated computerised accounting system which produces control accounts as an integral part of the DOUBLE ENTRY system. At the end of each month individual sales and PURCHASE ledger balances are reconciled automatically to the respective control accounts as a pre-programmed control check.

Unfortunately Kofi was taken ill in the middle of August and his assistant input a number of entries without the correct integration codes. Consequently the system has been unable to reconcile the control accounts at the end of that month. The assistant has manually extracted the individual ledger balances, and the net totals at 31 August are as follows.

Purchase ledger Sales ledger
GH¢3,556 GH¢8,946

The assistant has also manually produced draft accounts for the six months to 31 August and provides you with the following abridged trial balance.

GH¢ GH¢
Sales ledger control account 8,979
Purchase ledger control account 7,496
Net profit per draft accounts 4,322
Sundry balances (net) 2,839
11,818 11,818

You have checked through the accounting records and discovered the following discrepancies.
(1) The total for the PURCHASES day book input total for August has been incorrectly shown as GH¢6,241 following a manual override. The total should have been GH¢2,641.
(2) An old debit balance of GH¢28 in the PURCHASE ledger had been written off during August as bad. You discover that no ENTRY had been input other than in the individual supplier’s ledger account.
(3) A payment of GH¢260 on 14 August relating to the payment of a July PURCHASES invoice had been wrongly input in the cash account as wages.
(4) During the month of August there had been a mix-up over goods supplied to a CUSTOMER, Kwame. The goods were invoiced for GH¢62, despatched to Kwame and correctly entered in the system on 5 August. Several items turned out to be defective and were returned by Kwame on 28 August. These goods, originally costing GH¢14, were included in the original invoice of GH¢62 at an amount of GH¢17. No ENTRY was made in the books as a result of the return of the goods but they were manually input into the INVENTORY account at GH¢17. Owing to their damaged state their net realisable value is estimated to be GH¢5.
(5) Kofi has received discounts during the month amounting to GH¢280. However, these have only been manually input to the individual suppliers’ accounts.
(6) Certain discrepancies in the print-out of balances at 31 August have come to light, suggesting a software error might also have occurred. You discover that
(i) debit balances on the sales ledger of GH¢54 and GH¢69 respectively had been completely omitted from the listing
(ii) a CREDIT balance on the PURCHASE ledger of GH¢71 had been listed as a debit balance of GH¢17
(iii) the total of debit entries on Adwoa’s account in the sales ledger had been overcast by GH¢90.

Required
(a) Adjust the sales and PURCHASE ledger control accounts and show the reconciliation of the closing balances with the aggregate of the individual balances extracted from the PURCHASE and sales ledgers.

(b) Compute a revised net profit for the six month period to 31 August.

KOFI

(a)

Sales ledger control a/c

GH¢ GH¢
Balance per trial balance 8,979 (4) Credit note outstanding 17
Corrected balance c/d 8,962
8,979 8,979

Purchase ledger control a/c

GH¢ GH¢
(1) Overstatement of purchases day book input total 3,600 Balances per trial balance 7,496
(3) Payment mis-input 260 (2) Debit balance written off 28
(5) Discounts received 280
Corrected balance c/d 3,384
7,524 7,524

List out of individual ledger balances

Sales ledger Purchase ledger
GH¢ – GH¢ + GH¢ – GH¢ +
8,946 3,556
(3) Payment mis-classified 260
(4) Credit note outstanding 17
(6i) Balance omitted 54
(6i) Balance omitted 69
(6ii) Balance omitted 88
(6iii) Balance wrongly extracted
(6iii) Overcast on Adwoa’s a/c 90
9,069 3,644
(107) 260 (260)
Totals as amended (agreeing with control accounts) 8,962 3,384

(b) Amendments to net profit for the six months to 31 August

GH¢
Net profit (per manual draft accounts) 4,322
(1) Overstatement of PDB total (3,600)
(2) Debit balance written off (28)
(3) Payment mis-classified 260
(4) Credit note due (17)
(4) Write-down of inventory (12)
(5) Discount received 280
Net profit as revised 1,205