The cash account for Collegiate Sports Co. on November 1, 2014, indicated a balance of $81,145. During November

The cash account for Collegiate Sports Co. on November 1, 2014, indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The bank statement indicated a balance of $112,675 on November 30, 2014. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

a. Checks outstanding totaled $41,840.
b. A deposit of $12,200, representing receipts of November 30, had been made too late to appear on the bank statement.
c. A check for $7,250 had been incorrectly charged by the bank as $2,750.
d. A check for $760 returned with the statement had been recorded by Collegiate Sports Co. as $7,600. The check was for the payment of an obligation to Ramirez Co. on account.
e. The bank had collected for Collegiate Sports Co. $7,385 on a note left for collection. The face of the note was $7,000.
f. Bank service charges for November amounted to $125.
g. A check for $2,500 from Hallen Academy was returned by the bank because of insufficient funds.

Instructions
1. Prepare a bank reconciliation as of November 30.
2. Journalize the necessary entries. The accounts have not been closed.
3. If a balance sheet were prepared for Collegiate Sports Co. on November 30, 2014, what amount should be reported as cash?


Answers:






























1.

COLLEGIATE SPORTS CO.
Bank Reconciliation
November 30, 2014
Cash balance according to bank statement $112,675
Add deposit of November 30, not recorded by bank 12,200
$124,875
Deduct: Outstanding checks $41,840
Bank error in charging check as $2,750 instead
of $7,250 4,500 46,340
Adjusted balance $ 78,535
Cash balance according to company’s records* $ 66,935
Add: Proceeds of note collected by bank, including
$385 interest $ 7,385
Error in recording check as $7,600 instead of $760 6,840 14,225
$ 81,160
Deduct: Check returned because of insufficient funds $ 2,500
Bank service charges 125 2,625
Adjusted balance $ 78,535
 Cash balance, November 1………………………………………… $ 81,145
Plus cash deposited in November……………………………… 293,150
Less checks written in November………………………………… (307,360)
Balance per company’s records, November 30………………… $ 66,935
2.

Cash 14,225
Notes Receivable 7,000
Interest Revenue 385
Accounts Payable—Ramirez Co. 6,840
Accounts Receivable—Hallen Academy 2,500
Miscellaneous Expense 125
Cash 2,625
3. $78,535; the adjusted balance from the bank reconciliation should be reported
as cash on the November 30, 2014, balance sheet for Collegiate Sports Co.