Question Completion:
Prepare a bank reconciliation statement as of July 31, 2017.
Answer:
<h3>Crane Company</h3>
Bank Reconciliation Statement as of July 31, 2017
Balance as per bank statement         $7,905.80
Add Uncredited deposits                      1,309.30
Less Checks outstanding                      1,979.10
Balance as per adjusted cash book  $7,236.00
Explanation:
a) Data and Analysis:
July 31, 2017:
Cash balance per books of $6,355.00
Bank statement balance = $7,905.80
Reconciling items:
1. Bank service charge$19.00
2. Direct EFT receipt $1,630.00  
3. Uncredited deposits $1,309.30
4. Understated check No. 2480 $45
5. Checks outstanding $1,979.10
6. NSF charge of $685.00 (W. Krueger)
Cash Book Adjustment as of July 31, 2017
Balance as per cash book        $6,355.00
add: Direct EFT receipt                1,630.00
less: Bank service charge                 19.00
Understated check No. 2480          45.00
NSF charge                                    685.00
Adjusted Cash Book balance  $7,236.00