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:
BCminus−bank collection of note receivable from customer,EFTminus−electronic funds transfer,USminus−unauthorized signature,SCminus−service charge |
Get Answers For Free
Most questions answered within 1 hours.