Bank reconciliation and entries

The cash account for Collegiate Sports Co$.$ on November $1,20$Y$9,$ indicated a balance of $$12,130.$ During November, the total cash deposited was $$66,480$ and checks written totaled $$61,730.$ The bank statement indicated a balance of $$22,540$ on Novernber $30,20$r$9.$ Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

a$.$ Checks outstanding totaled $$10,040.$

b$.$ A deposit of $$8,180,$ representing receipts of November $30,$ had been made too late to appear on the bank statement.

c$.$ A check for $$630$ had been incorrectly charged by the bank as $$360.$

d$.$ A check for $$850$ retumed with the statement had been recorded by Collegiate Sports Co$.$ as $$580.$ The check was for the payment of an obligation to Ramirez Co$.$ on account.

e$.$ The bank had collected for Collegiate Sports Co$.$ $$4,320$ on a note left for collection. The face of the note was $$3,990.$

f$.$ Bank service charges for November amounted to $$60.$

$9.$ A check for $$1,000$ from Hallen Academy was returned by the bank because of insufficient funds.

Instructions:

Prepare a bank reconciliation as of November $30,20Y9.$

Collegiate Sports Co$.$

Bank Reconciliation

November $30,20Y9$

Line Item Description Amount Amount

Cash balance according to bank statement

Total deductions

Adjusted balance

Cash balance according to company's records