Reconciling Control Accounts with Ledger

This assignment provides a detailed example of reconciling control accounts with ledger entries, including a statement of profit or loss, statement of retained earnings, and statement of financial position. It also explores the concept of suspense accounts and their use in correcting errors in accounts.

FINANCIAL ACCOUNTING
Contents
1

Part A – From the information of bank transactions given below you are required to prepare bank reconciliation statement
and adjusting entries for Lighter Company..........................................................................................................................................3
Part B – The balance extracted from the records of Sky at 31 August 2018 were as follows:..........................................................7
Reference.................................................................................................................................................................................................20
Part A – From the information of bank transactions given below you are required to prepare bank
reconciliation statement and adjusting entries for Lighter Company.
2

Bank Reconciliation Statement
Lighter Company ended December 31, 2018
£ £
Original Balance per Bank Statement
5,7
18.28
Add: Outstanding lodgement
8
96.50
6,6
14.78
Less: Unpresented cheques
Check
No. Date
661 01/12/2018
(108
.15)
667 14/12/2018
(15
.50)
669 16/12/2018
(19
.00)
671 17/12/2018
(121
.50)
674 18/12/2018
(168
.75)
(4
32.90)
Corrected Balance
6,1
81.88
£ £
Original Balance per LB
5,4
77.52
Add: Credit Memoranda (CM)
Date Explanation
22/12/2018 Collection a receivable from
customer BRG.
768
.00
3

25/12/2018 Dividends received from MSN
Plc.
305
.38
31/12/2018 Interest earned on average
account balance during
December.
45
.98
1,1
19.36
6,5
96.88
Less: Debit Memoranda (DM)
Date Explanation
22/12/2018 Fee charged by bank for
handing collection of receivable
(99
.00)
30/12/2018 A cheque for 250 from
customer (was paid into bank on
27 Dec, but has bee dishoured
on 31 Dec)
(250
.00)
31/12/2018 Service charge by bank for
month of December
(30
.00)
(3
79.00)
Less: Check No. 673
(
36.00)
Corrected Balance
6,1
81.88
4

No. Date Narrative Affected Account Debit (£) Credit (£)
Cash 768.00
Receivable Control Account 768.00
Cash 305.38
Dividend Received 305.38
Cash 45.98
Interest Income 45.98
Bank Service Expense 99.00
Cash 99.00
Receivable Control Account 250.00
Cash 250.00
Bank Service Expense 30.00
Cash 30.00
Telecom Expense 36.00
Cash 36.00
Addition Adjusting Entries
Lighter Company ended December 31, 2018
1 22/12/2018 Collection a receivable from customer BRG
Service charge by bank for the month of
December
Error of Check No.673 (amount of £61 but
recorded in cash book payments as £26)
5 30/12/2018
6 31/12/2018
7 22/12/2018
Dividends received from MSN Plc
Interest earned on average account balance
during December
Fee charged by bank for handing collection
of receivable
A cheque for £250 from customer, which
was paid into the bank on 27 Dec, has been
dishonoured on 31 Dec
2 25/12/2018
3 31/12/2018
4 22/12/2018
General Ledger: Cash
Date Description Dr (£) Cr (£) Balance (£)
31/12/2018 Balance 5,477.52
22/12/2018 Collection a receivable from customer BRG 768.00 6,245.52
25/12/2018 Dividends received from MSN Plc 305.38 6,550.90
5

31/12/2018 Interest earned on average account balance during
December 45.98 6,596.88
22/12/2018 Fee charged by bank for handing collection of receivable 99.00 6,497.88
30/12/2018 A cheque for £250 from customer, which was paid into the
bank on 27 Dec, has been dishonoured on 31 Dec 250.00 6,247.88
31/12/2018 Service charge by bank for the month of December 30.00 6,217.88
22/12/2018 Error of Check No.673 (amount of £61 but recorded in
cash book payments as £26) 36.00 6,181.88
Part B – The balance extracted from the records of Sky at 31 August 2018 were as follows:
I – Explain the purposes of using control account and suspense account? Explain the process taken to reconcile control
account and clear suspense accounts as well as how and why they are reconciled, using the given account example.
Control Account is an account in the main ledger (general ledger) which aggregates and combines the ledger of the ledger of the
subsidiaries into it. This also helps subsidiaries keep track of account transactions in a particular way and in more detail. (YouTube,
2017).
According to (Cameron, 2017), suspense account is an account in the general ledger, hold on to funds, unclassified transactions
during the company (i.e. it will hold off items to wait for classification and it also contains information different in the date collection
process).
6

According to (Gikonyo, 2015), process to reconcile the control account:
 Step 1: Identify the errors.
For Receivables Control Account:
o No entry had been made in the control account in respect of the debts written off as bad
o No entry has been made in the control account for a cheque paid by debtor £235.
o Sales on credit of £189 to Jack had been correctly entered in his account but nothing had been entered in the
control account.
o No corresponding entry had appeared in the control account about discount allowed from Marry (£195).
o Cash receipts £200 from receivables treatment as a cash sale.
For Payables Control Account:
o No entry had been made in Harper’s account (for £105 and is only recorded on ledger, not TB).
o A purchase invoice for £625 had been entered incorrectly in control account £652 (but correctly in purchase
account).
o Two credit balances of £58 and £68 had been omitted from the list extracted from payable ledger.
7

o A payable ledger contra of £175 had been entered in Cloud’s account in the receivable ledger but no other entry had
been made.
o The purchase day book had ben undercast by £1,460.
 Step 2: Revise the total balance quoted from memorandum ledger.
Receivable Control a/c Receivable Ledger
Original Balance 1,873 Original Balance 1,619
Add:
Dishonoured Account 235
Sales on credit 189
424
Less:
Discount Allowed (195)
Cash Received (200)
Bad Debts Expense (108)
Contra with payables
ledger (175)
(678)
Corrected Balance 1,619 Corrected Balance 1,619
Payable Control Account Payable Ledger
Original Balance 2,03
0 Original Balance 1,807
Add:
8

Credit Blances 58
Less: 68
Purchase Invoice (27) 126
Contra with receivable ledger (175) Less:
Goods returned to Harper (105)
(202)
Corrected Balance 1,82
8 Corrected Balance 1,828
 Step 3: Bring down the balance on the control account and adjust accounts to the correcting entries.
Receivable Control Account
Orginal balnance 1,873 Cash Received 200
Dishonoured
Account 235 Discounts Allowed 195
Sales on credit 189 Bad Debts Expense 108
Contra with
payable ledger 175
Corrected Balance 1,619
2,297 2,297
Payable Control Account
Purchase Invoice 27 Original Balance 2,030
Contra with receivable 175
9

ledger
Corrected Balance 1,828
2,030 2,030
According to (Acccountingandfinance.blogspot.com, 2015), process to clear the suspense account:
 Step 1: Open a suspense account with the amount of the imbalance.
o Debts written off as bad.
DR Irrevocable Debts Expense: (£)108.
CR Suspense Account: (£)108.
o Cheque dishonored by bank (for (£)235).
DR Suspense Account: (£)235.
CR Cash at bank: (£)235.
o Sales on credit of (£)189 to Jack.
DR Suspense Account: (£)189.
CR : (£)189.
o Marry had been allowed a cash discount of (£)195.
10

DR Discount Allowed: (£)195.
CR Suspense Account: (£)195.
o A purchase invoice of (£)625 had been entered incorrectly in control account as (£)652.
CR Payables Control Account: (£)652
DR Purchase Account: (£)625.
DR Suspense Account: (£)27
o Discount received had been debited to the discount allowed account.
DR Payables Control Account: (£)200.
DR Discount Allowed: (£)200.
CR Suspense Account: (£)400.
 Step 2: Using journal entries to clear suspense account and correct the error.
SKY
Adjusting Entries at 31 August 2018
No. Narrative Affected A/C Debit (£) Credit (£)
1
a) No entry had been made in the control account in
respect of the decbts written off as bad
Suspense Account 108
Receivable Control A/c 108
b) Dishournor cheque for 235 from customers
Receivable Control A/c 235
Suspense Account 235
c) Sales on credit to 189 to Jack had been correctly Receivable Control A/c
11

entered in his account but nothing had been entered in the
control account.
189
Suspense Account 189
d) Marry had been allowed a cash discount of 195, but no
corresponding entry had appeared in the control account.
Suspense Account 195
Receivable Control A/c 195
e) Cash recepts 200 from receivables treated as a cash
sale.
Sales 200
Receivable Control A/c 200
2 a) Goods returned to Harper costing 105 had been
entered correctly in the control account, but no entry had
been made in Harper's account.
Payable Control a/c 105
Purchase a/c 105
b) A purchase invoice for 625 had been incorrectly
entered in the control account as 652, but correctly in the
purchase account.
Payable Control a/c 27
Suspense Account 27
c) Two credit balances of 58 and 68 had been omitted
from the list extracted from the payable ledger
Suspense Account 126
Payble Ledger A/c 126
d) A payable ledger contra of 175 has been entered in
Cloud's account in the receivables ledger but no entry had
been made.
Payable Control a/c 175
Receivable Control A/c 175
e) Discount received 200 had been debited to the discount
allowed account.
Suspense Account 400
Discount Allowed 200
Discount Received 200
f) The purchase day book had been undercast by 1,460. Purchase a/c
1,460
12

Payable Ledger a/c 1,460
3
Some office equipment which had cost 280 had been
debited to the purchase account (depreciation for this
equipment is charged full year)
Office Equipment 280
Purchase a/c 280
4
The wages expense included 450 of personal drawings
by the owner of the busisness.
Drawings Account 450
Wage Expense 450
5
The depreciation for equipment should have been
charged at 15% on cost, but no entries for depreciation
for the period
Depreciation Expense 267
A/c Depreciation - equipment 267
6
The account for stationary included 70 of personal
notepaper for the owner.
Drawings Account 70
Stationary 70
Suspense Account
No. Description Dr (£) Cr (£) Balance (£)
1 Balance (252)
2 a) No entry had been made in the control account in respect of the
decbts written off as bad 108 (144)
3 b) Dishournor cheque for 235 from customers 235 (379)
4 c) Sales on credit to 189 to Jack had been correctly entered in his
account but nothing had been entered in the control account. 189 (568)
13

5 d) Marry had been allowed a cash discount of 195, but no
corresponding entry had appeared in the control account. 195 (373)
6 b) A purchase invoice for 625 had been incorrectly entered in the
control account as 652, but correctly in the purchase account. 27 (400)
7 e) Discount received 200 had been debited to the discount
allowed account. 400 0.00
Payable Control Account
No. Description Dr (£) Cr (£) Balance (£)
1 Balance (2,030)
2
b) A purchase invoice for 625 had been incorrectly entered
in the control account as 652, but correctly in the purchase
account.
27 (2,003)
3
d) A payable ledger contra of 175 has been entered in
Cloud's account in the receivables ledger but no entry had
been made.
175 (1,828)
Receivable Control Account
No. Description Dr (£) Cr (£)
Balance
(£)
1 Balance 1,873
2 a) No entry had been made in the control account in respect of the
decbts written off as bad 108 1,765
3 b) Dishournor cheque for 235 from customers 235 2,000
4 c) Sales on credit to 189 to Jack had been correctly entered in his
account but nothing had been entered in the control account. 189 2,189
14

5 d) Marry had been allowed a cash discount of 195, but no
corresponding entry had appeared in the control account. 195 1,994
6 e) Cash recepts 200 from receivables treated as a cash sale. 200 1,794
7 d) A payable ledger contra of 175 has been entered in Cloud's account
in the receivables ledger but no entry had been made. 175 1,619
Unadjusted TB Adjustment Adjusted TB Income Statement Balance Sheet
Debit
(£)
Credit
(£)
Debit
(£)
Credit
(£)
Debit
(£)
Credit
(£)
Debit
(£)
Credit
(£)
Debit
(£)
Credit
(£)
Premises 7,500 7,500 7,500
Capital 8,750 8,750 8,750
Drawings 1,200 520 1,720 1,720
Accumulated depreciation of
office equipment at 1 Sep 2017 400 267 667 667
Receivables control account 1,873 424 678 1,619 1,619
Payables control account 2,030 202 1,828 1,828
Inventory at 1 Sep 2017 1,200 1,200 1,200
Purchases 9,540 280 9,260 9,260
Sales 14,945 200 14,745 14,745
Return Inwards 250 250 250
Office equipment 1,500 280 1,780 1,780
Wages Expense 1,300 450 850 850
Commission Expense 200 200 200
15

Discount Allowed 230 200 30 30
Discount Received 100 200 300 300
Cash at bank 750 750 750
Cash in hand 208 208 208
Heating and lighting expense 368 368 368
Postage and stationary expense 250 70 180 180
Bad debts expense 108 108 108
Depreciation expense 267 267 267
Suspense Account 252 703 451 703 703
Inventory at 31 August 2018 989 989 989 989 989 989
26,477 26,477 3,585 3,585 27,982 27,982 12,713 16,034 14,566 11,245
Profit per Period 3,321 3,321
16,034
16
,034
1
4,566
14
,566
Sky
Statement of Profit or Loss at 31 August 2018
£ £
Sales 14,745
Less: Cost of good sold
Opening Stock 1,200
Purchase 9,260
16

Closing Stock (989)
9,471
Gross profit 5,274
Less: Expense
Wages Expense 850
Commission Expense 200
Heating and lighting expense 368
Postage and stationary expense 180
Bad debts expense 108
Discount Allowed 30
Depreciation expense 267
2,003
Add: Revenue
Discount Received 300
Less: Income
Return Inwards 250
Net Profit 3,321
Sky
Statement of Retained Earning at 31 August 2018
Net profit 3,321
Drawings (1,720)
Retained Earning (*) 1,601
17

Sky
Statement of Financial Position at 31 August 2018
£ £
Non-current Assets
Office equipment Cost 1,780
Acc Depreciation (667)
1,1
13
Premises
7,5
00
8,6
13
Current Assets
Trade Receivable 1,619
Cash at bank 750
Cash in hand 208
Inventory 989
3,5
66
Total Assets
12,1
79
Current Liabilities
Trade Payable 1,8
18

28
Equity
Capital
8,7
50
Retained Earning (*)
1,6
01
12,1
79
Reference
YouTube. (2017). What Is A Control Account In Financial Accounting?. [online] Available at: https://www.youtube.com/watch?
v=br7sCjfLsUk [Accessed 1 Jan. 2019].
Cameron, A. (2017). What Is a Suspense Account? | Examples and How to Use. [online] Accounting Tips, Training, and News.
Available at: https://www.patriotsoftware.com/accounting/training/blog/what-is-suspense-account-journal-entry-example/
[Accessed 1 Jan. 2019].
Gikonyo, S. (2015). Reconciling control accounts with ledgers (an illustration). [online] Acccountingandfinance.blogspot.com.
Available at: http://acccountingandfinance.blogspot.com/2015/03/reconciling-control-accounts-with.html [Accessed 2 Jan. 2019].
19