4. The following information is available for the Avisa Company for the month of November:

a. On November 30, after all transactions have been recorded, the balance in the companys Cash account has a balance of $27,202.

b. The companys bank statement shows a balance on November 30 of $29,279.

c. Outstanding checks at November 30 include check #3030 in the amount of $1,525 and check #3556 in the amount of $1,459.

d. A memo included with the bank statement shows a $67 NSF check from a customer, J. Brown.

e. A deposit placed in the banks night depository on November 30 totaled $1,675, and did not appear on the bank statement.

f. Included with the bank statement was a fee of $55 for bank service charges. It has not been recorded on the companys books.

g. Bank collected $890 on our behalf.

Based on the above information, prepare the November bank reconciliation for the Avisa Company.