Question

On July 31, 2017, Crane Company had a cash balance per books of $6,355.00. The statement from Dakota State Bank on that date showed a balance of $7,905.80. A comparison of the bank statement with the Cash account revealed the following facts.
1. The bank service charge for July was $19.00.
2. The bank collected $1,630.00 for Crane Company through electronic funds transfer.
3. The July 31 receipts of $1,309.30 were not included in the bank deposits for July. These receipts were deposited by the company in a night deposit vault on July 31.
4. Company check No. 2480 issued to L. Taylor, a creditor, for $394.00 that cleared the bank in July was incorrectly entered in the cash payments journal on July 10 for $349.00.
5. Checks outstanding on July 31 totaled $1,979.10.
6. On July 31, the bank statement showed an NSF charge of $685.00 for a check received by the company from W. Krueger, a customer, on account.

Answer 1

Question Completion:

Prepare a bank reconciliation statement as of July 31, 2017.

Answer:

Crane Company

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