Question
Kamala owner of Gems Unique hired you to help her a bank reconciliation for march 20 using the following information. All receipts from sales are
Kamala owner of Gems Unique hired you to help her a bank reconciliation for march 20 using the following information. All receipts from sales are immediately deposited.
General Ledger Gems Unique
Cash at bank
Date | Ref | Debit | Credit | Balance | |
2020 | |||||
March 1 | Balance | 2657 | |||
1 | 750 | 3407 | |||
3 | Cheque #100 | 625 | 2782 | ||
3 | Cheque # 101 | 95 | 2687 | ||
8 | Cheque # 102 | 56 | 2631 | ||
9 | 1050 | 3681 | |||
13 | Cheque # 103 | 425 | 3256 | ||
20 | 155 | 3411 | |||
28 | Cheque # 104 | 247 | 3164 | ||
31 | 110 | 3274 |
Republic Bank
Bank Statement-Gems Unique
March 31, 2020
Date | Withdrawals | Deposits | Balance | |
1 | Balance | 3256 | ||
2 | Deposit | 750 | 4006 | |
6 | Cheque # 100 | 625 | 3381 | |
6 | Cheque # 101 | 95 | 3286 | |
8 | Cheque # 102 | 56 | 3230 | |
10 | Deposit | 1050 | 4280 | |
10 | NSF Cheque | 100 | 4180 | |
10 | NSF Fee | 35 | 4145 | |
14 | Cheque # 103 | 452 | 3693 | |
21 | Deposit | 125 | 3818 | |
23 | EFT-Digicel | 85 | 3733 | |
28 | Cheque # 99 | 361 | 3372 | |
30 | Bank charges | 13 | 3359 |
Additional Information:
i. On February reconciliation statement, there were two outstanding cheques: #95 for $238 and #99 for $361
ii. All cheques were correctly posted by Kamala for the month. The sales revenue deposit made on March 20th was for $125. Kamala made an error in recording these transactions in the books
iii. The electronic funds transfer (EFT) was for Kamala business cell phone use.
You are required to prepare the Bank Reconciliation for March 2020
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started