Problem - Bank Reconciliation

High Tech Company of New York has provided you with the following cash account information for the month. The company's cash book had a cash balance of $5,815.30 while the company's bank account at fleet Bank showed the balance of $7,075.80. A comparison of the cash book and the bank statement revealed the following details.

1. Bank service charge for July was $25

2. The bank collected a note receivable of $1,200 for R & J company on July 15, plus $48 of interest. The bank made a $10 charge for the collection.

3. The July receipts of $1,819.60 were not included in the July deposits.

4. Company check No. 2480 issued to G. Subway a creditor for $492 that cleared the bank in july was incorrectly entered in the cash payment journal in July for $429.

5. Checks outstanding in July totaled $2,480.10

6. On July 31, the bank statement showed an NSF check of $550 for a check received by company from B.N Diet a customer on account.

(a) Create the bank reconciliation for July 2011.

(b) Create the necessary adjusting entries at July 31, 2011.