Question
Requirement 1. Prepare the DunlapDunlap Automotive bank reconciliation at JulyJuly 3131, 20182018. Prepare the Bank side of the bank reconciliation, then prepare the Book side
Requirement 1. Prepare the
DunlapDunlap
Automotive bank reconciliation at
JulyJuly
3131,
20182018.
Prepare the Bank side of the bank reconciliation, then prepare the Book side of the bank reconciliation. (Include the balances at
JulyJuly
3131
in each of the addition subtotal calculations. If a box is not used in the table, leave the box empty; do not select a label or enter a zero.)
Dunlap Automotive | |||||
Bank Reconciliation | |||||
July 31, 2018 | |||||
Bank: |
|
| |||
|
|
|
| ||
| Add: |
|
|
| |
Subtotal |
| ||||
| Less: |
|
|
| |
|
| Check No. |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |||
|
|
|
|
Books: |
|
| |||
|
|
|
| ||
Add: |
|
|
| ||
|
|
| |||
|
|
| |||
Subtotal |
|
| |||
Less: |
|
|
| ||
|
|
|
| ||
|
|
| |||
|
|
|
| ||
|
|
|
|
Cash | Account No. 101 | ||||||
Date | Item | Jrnl. Ref. | Debit | Credit | Balance | ||
July 1 | Balance |
|
|
| 7,850 | ||
31 |
| CR 6 | 9,881 |
| 17,731 | ||
31 |
| CP 11 |
| 9,778 | 7,953 |
Cash Receipts (CR) |
| Cash Payments (CP) | ||
Date | Cash Debit |
| Check No. | Cash Credit |
July 2 | $2,852 | 3113 | $1,452 | |
8 | 555 | 3114 | 1,499 | |
10 | 1,662 | 3115 | 1,830 | |
16 | 859 | 3116 | 93 | |
22 | 405 | 3117 | 775 | |
29 | 897 | 3118 | 171 | |
30 | 2,651 | 3119 | 432 | |
Total | $9,881 | 3120 | 1,001 | |
3121 | 222 | |||
3122 | 2,303 | |||
|
|
| Total | $9,778 |
Bank Statement for July 2018 | ||||||
Beginning balance | $7,850 | |||||
Deposits and other additions: | ||||||
July | 1 |
| $800 | EFT | ||
4 |
| 2,852 | ||||
9 |
| 555 | ||||
12 |
| 1,662 | ||||
17 |
| 859 | ||||
22 |
| 405 | ||||
23 |
| 1,225 | BC | 8,358 | ||
Checks and other deductions: | ||||||
July | 7 |
| $1,452 | |||
13 |
| 1,380 | ||||
14 |
| 446 | US | |||
15 |
| 1,499 | ||||
18 |
| 93 | ||||
21 |
| 389 | EFT | |||
26 |
| 775 | ||||
30 |
| 171 | ||||
30 |
| 30 | SC | (6,235) | ||
Ending balance | $9,973 |
Explanation: BCminusbank collection of note receivable from customer,EFTminuselectronic funds transfer,USminusunauthorized signature,SCminusservice charge |
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