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

Step-by-step 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