Reference no: EM132210078
Assignment - Preparation of Bank Reconciliation Statement and Control Accounts
ASSIGNMENT:
1. The submission is in the form of an individual numerical/written report.
2. This should be written in a concise, formal business style using single spacing and font size 12.
3. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system.
4. Provide working notes wherever required.
5. The document must be submitted to turnitin in word document.
6. Please provide a bibliography using Harvard referencing system if you referred any sources for theoretical parts or questions.
7. The numbers/numerical statements and calculations must be neatly/clearly shown so that the assessor assess the work of the learner appropriately.
8. The recommended word limit is 2,000 - 2,500 words, although you will not be penalised for exceeding the total word limit.
9. The file must be saved in the format: student ID-FA-Formative-A1, for formative submission and student ID-FA-Summative-A1, for summative assignment.
10. In case of extenuating situations, the relevant college policies apply
Learning Outcomes:
LO3: Perform bank reconciliations to ensure company and bank records are correct.
LO4: Reconcile control accounts and shift recorded transactions from the suspense accounts to the right accounts.
Assignment Brief and Guidance:
The Scenario
BRS and Control Accounts - Why Variations?
Given below are the sets of transactions supplied to you as a practicing accountant to prepare bank reconciliation statements and to reconcile control accounts. The report must be submitted to the Chief Financing Officer to take necessary actions upon the deviations found in the passbook and the cash book and the control accounts. The report that you submit with detailed calculation and working notes wherever necessary will have bearing on the operating efficiency of the firm and failing on might result misrepresentation in preparing and disclosing financial information to the interested parties. Hence you have a major role to oversee the entire set of calculations.
Extract 1: For preparing Bank Reconciliation Statement for RR Telecommunications for year ending 31st December 2017
1. Bank overdraft as per pass book OMR 30,000
2. Interest on overdraft OMR 3,000
3. Insurance premium paid by the bank OMR 300
4. Cheque issued to the suppliers but not presented for payment to bank OMR 9,750
5. Cheque deposited by the business but not yet collected by the bank OMR 9,000
6. A wrong debit given by the bank OMR 750
Extract 2: For preparing Bank Reconciliation Statement for RR Telecommunications for the year ending 31 December 2017
1. Overdraft as per cash book on 31st December OMR 10,540
2. Interest on overdraft for six months ending Dec. OMR 240
3. Interest on investments collected by bank OMR 300
4. Bank charges for the above period OMR 60
5. Cheques drawn but not cashed by the customers, prior to December OMR 2,500
6. Cheques paid into the bank, but not cleared before 31st December OMR 4,200
7. A Bill Receivable for OMR 1,000 discounted with the bank was dishonoured on December 31st.
8. Cheques issued for OMR 50, returned with remark Not Sufficient Fund (NSF).
Extract 3: Transactions for clearing suspense accounts for RR Telecommunications
1. One cash payment of OMR 1,000 remain un noticed. Later the amount found to be related to the payment of stationery charges.
2. A creditor (supplier) sends an invoice for OMR 9,000 for services, which is payable in 90 days. The accounting personnel is not aware to which department will be debited or charged with this invoice. The accounting department subsequently understands invoice is relating to the R&D department and it must be charged with the invoice.
Extract 4: Data on purchase book, purchase returns book and cash payments book for reconciliation accounts for RR Telecommunications
Purchase Returns Day Book
|
Invoice No.
|
Suppliers
|
Supplier code.
|
Gross
|
VAT
|
Net
|
AA1
|
DEF Ltd
|
10
|
4,224
|
704
|
3,520
|
BB2
|
LMN Ltd
|
11
|
21,120
|
3,520
|
17,600
|
Total
|
25,344
|
4,224
|
21,120
|
Purchase Day Book
|
Invoice No.
|
Suppliers
|
Supplier code.
|
Gross
|
VAT
|
Net
|
10
|
DEF Ltd
|
10
|
132,000
|
22,000
|
110,000
|
11
|
LMN Ltd
|
11
|
168,960
|
28,160
|
140,800
|
Total
|
300,960
|
50,160
|
250,800
|
Cash Payments and Credit Purchase Book
|
Ref
|
Details
|
Bank
|
Discount received
|
Cash Purchase
|
VAT
|
Trade Payables (Credit purchases)
|
10
|
DEF Ltd
|
125,114
|
|
|
|
125,114
|
11
|
LMN Ltd
|
137,522
|
6,160
|
|
|
137,522
|
|
Cash purchase
|
31,680
|
|
26,400
|
5,280
|
|
Total
|
294,316
|
6,160
|
26,400
|
5,280
|
262,636
|
You need to:
(a) Prepare accurate bank reconciliation that apply appropriate tools and techniques to generate accounts and balance sheet using extracts 1 and 2
AND
(b) Produce accurate accounts that have been reconciled applying appropriate methods using extracts 3 and 4
Attachment:- Assignment Brief.rar