Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Cash Record and Bank Statement for Dickson Insurance are shown below. Using these two documents, complete the Bank Reconciliation on the following page. NOTES:
The Cash Record and Bank Statement for Dickson Insurance are shown below. | |||||
Using these two documents, complete the Bank Reconciliation on the following page. | |||||
NOTES: | |||||
Outstanding checks should be listed separately on the reconciliation | |||||
The correct amount for Check # 1419 is $1,960. The error was made on the company's side. | |||||
DICKSON INSURANCE - CASH RECORD | |||||
MAY 2024 | |||||
Date | Item | Check No. | Deposit Amt | Payment Amt | Balance |
1-May | $ 14,000 | ||||
4-May | Deposit | $ 4,150 | $ 18,150 | ||
6-May | Check | 1416 | $ 850 | $ 17,300 | |
9-May | Deposit | $ 540 | $ 17,840 | ||
14-May | Deposit | $ 560 | $ 18,400 | ||
16-May | Check | 1417 | $ 160 | $ 18,240 | |
17-May | Deposit | $ 2,190 | $ 20,430 | ||
19-May | Check | 1418 | $ 670 | $ 19,760 | |
23-May | Check | 1419 | $ 1,690 | $ 18,070 | |
31-May | Deposit | $ 1,870 | $ 19,940 | ||
Check | 1420 | $ 1,450 | $ 18,490 | ||
Check | 1421 | $ 1,200 | $ 17,290 | ||
Check | 1422 | $ 640 | $ 16,650 | ||
DICKSON INSURNANCE COMPANY | |||||
BANK STATEMENT | |||||
MAY 31, 2024 | |||||
Beginning Balance | $ 14,000 | ||||
Deposits and Other Credits | |||||
May 1 | EFT Collection (rent) | $ 200 | |||
May 5 | $ 4,150 | ||||
May 10 | $ 540 | ||||
May 15 | $ 560 | ||||
May 18 | $ 2,190 | ||||
May 22 | Bank collection (A/R) | $ 1,700 | $ 9,340 | ||
Checks and Other Debits | |||||
Check # | |||||
May 8 | NSF - customer check | $ 700 | |||
May 11 | 1416 | $ 850 | |||
May 19 | EFT payment (power bill) | $ 400 | |||
May 22 | 1417 | $ 160 | |||
May 29 | 1418 | $ 670 | |||
May 31 | 1419 | $ 1,960 | |||
May 31 | Service Charge | $ 10 | $ (4,750) | ||
Ending Balance | $ 18,590 | ||||
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