The cash account of Alpine Sports Co. on April 1, 2020, indicated a balance of $16,911.95. During April, the total cash deposited was $65,500.40, and checks are written totaled $68,127.47. The Bank Statement indicated a cash balance of $18,880.45 on April 30, 2020. Comparing the bank statement, the cancelled checks, and the company cash account, indicated the following reconciling items:

Checks Outstanding totaled $5,180.27.

A deposit of $3,481.70 was recorded in the checkbook but had not cleared the bank.

A check for $620.00 had been incorrectly recorded by the bank for $260.00

A check for the amount of $479.30 was incorrectly recorded by Alpine Sports Co. in the checkbook for $497.30.

The bank collected $3,424.00 on a note receivable payable to Alpine, Co. The principal amount of the note was $3,200.00

The bank service charge for April was $25.00.

A check received for $880.00 was returned by the bank because of insufficient funds. (NSF)

Prepare a Bank Reconciliation for Alpine Sports, Co. as of April 30.

Thank you