Question
1)Directions Using the data shown below and the accompanying July 2020 bank statement from Death Star Credit Union (DSCU), prepare the July 2020 bank reconciliation
1)Directions | ||
Using the data shown below and the accompanying July 2020 bank statement from | ||
Death Star Credit Union (DSCU), prepare the July 2020 bank reconciliation for Acme, Inc. | ||
2)General ledger Cash account | ||
The controller spilled grease on the detail report that shows the cash balance per general ledger. | ||
The exact amount is not known, but looks to be approximately $479,000. | ||
3)Items on the June 2020 bank reconciliation | ||
Deposits in transit: | ||
Amount | ||
51,419.75 | recorded in books on 6/28/20 | |
3,068.80 | recorded in books on 6/29/20 | |
Outstanding checks: | ||
Check # | Amount | |
51753 | 2,112.03 | written 5/31/20 |
52108 | 857.35 | written 6/29/20 |
52109 | 6,069.88 | written 6/29/20 |
52110 | 19,446.05 | written 6/29/20 |
4)Transactions recorded in the general ledger during the month of July 2020 | ||
Deposits: | ||
Date | Amount | |
7/9/2020 | 40,513.66 | ACH |
7/10/2020 | 53,877.55 | |
7/13/2020 | 3,540.23 | |
7/13/2020 | 49,400.01 | |
7/14/2020 | 5,424.10 | |
7/15/2020 | 37,032.82 | |
7/16/2020 | 29,243.25 | |
7/16/2020 | 53,596.22 | |
7/17/2020 | 50,425.80 | ACH |
7/18/2020 | 46,803.88 | |
7/20/2020 | 24,796.74 | |
7/20/2020 | 39,038.93 | |
7/24/2020 | 24,212.49 | |
7/27/2020 | 28,962.06 | |
7/29/2020 | 43,924.10 | |
7/30/2020 | 12,194.81 | |
7/31/2020 | 32,895.27 | |
7/31/2020 | 62,185.15 | |
Checks: | ||
Check # | Date | Amount |
52111 | 7/2/2020 | 6,436.26 |
52112 | 7/2/2020 | 23,383.59 |
52113 | 7/2/2020 | 15,329.22 |
52114 | 7/2/2020 | 6,098.67 |
52115 | 7/2/2020 | 6,526.03 |
52116 | 7/2/2020 | 7,828.48 |
52117 | 7/2/2020 | 7,268.70 |
52118 | 7/2/2020 | 7,750.37 |
52119 | 7/2/2020 | 21,682.39 |
52120 | 7/2/2020 | 5,878.70 |
52121 | 7/2/2020 | 15,891.71 |
52122 | 7/9/2020 | 8,713.20 |
5)Additional info |
a)DSCU debited Acme's account on 7/24/20 for an installment loan payment. |
The interest portion of the payment was $3,150.87. |
b)Acme's bookkeeper tripped over a spare anvil laying in the office. After regaining consciousness, but still woozy, he |
mistakenly recorded check #52163 for $1,500 higher than he should have. The item cleared the bank for the correct amount. |
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