Question

In: Accounting

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

  1. The cash account for Collegiate Sports Co. on November 1, 20Y9, 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, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items:

    1. Checks outstanding totaled $41,840.
    2. A deposit of $12,200, representing receipts of November 30, had been made too late to appear on the bank statement.
    3. A check for $7,250 had been incorrectly charged by the bank as $2,750.
    4. 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.
    5. The bank had collected for Collegiate Sports Co. $7,385 on a note left for collection. The face of the note was $7,000.
    6. Bank service charges for November amounted to $125.
    7. A check for $2,500 from Hallen Academy was returned by the bank because of insufficient funds.

    Required:

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

    Collegiate Sports Co.
    Bank Reconciliation
    November 30, 20Y9
    Cash balance according to bank statement $
    $
    Total deductions
    Adjusted balance $
    Cash balance according to company's records $
    $
    Total additions
    $
    Total deductions
    Adjusted balance $

    2. Journalize the necessary entries (a.) that increase cash and (b.) that decrease cash. The accounts have not been closed. If an amount box does not require an entry, leave it blank.

    20Y9 Nov. 30
    Nov. 30

    3. If a balance sheet were prepared for Collegiate Sports Co. on November 30, 20Y9, what amount should be reported as cash?
    $

Solutions

Expert Solution

Bank Reconciliation
1) Cash balance according to bank statement 112,675
Deposit in transit 12,200
Checks oustanding 41,840
Error in recording check 4500
Total deductions 46,340
Adjusted balance 78,535
Cash balance according to company's records 66,935
Note collection 7,385
Error in recording payment 6840
Total addittions 14,225
Bank service charge 125
NSF 2,500
Total deductions 2,625
Adjusted balance 78,535
2) 2009
30-Nov Cash 14,225
Accounts payable-Ramirez 6840
Note receivable 7000
interest income 385
30-Nov Bank service charge 125
Accounts receivable 2,500
cash 2,625
3) 78,535

Related Solutions

The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated a balance of $12,980....
The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated a balance of $12,980. During November, the total cash deposited was $71,170 and checks written totaled $66,080. The bank statement indicated a balance of $24,130 on November 30, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $10,750. A deposit of $8,750, representing receipts of November 30, had been made too late to appear...
Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated...
Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated a balance of $13,700. During November, the total cash deposited was $75,870 and checks written totaled $70,450. The bank statement indicated a balance of $25,720 on November 30, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $11,460. A deposit of $9,330, representing receipts of November 30, had been made...
Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 20Y9, indicated...
Bank Reconciliation and Entries The cash account for Collegiate Sports Co. on November 1, 20Y9, 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, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $41,840. A deposit of $12,200, representing receipts of November 30, had been made...
The cash account for Collegiate Sports Co. on November 1, 2016, indicated a balance of $81,145....
The cash account for Collegiate Sports Co. on November 1, 2016, 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, 2016. 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...
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,527....
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,527. During October, the total cash deposited was $139,121, and checks written totaled $135,890. The bank statement indicated a balance of $43,660 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $6,625. b. A deposit of $1,888 representing receipts of October 31, had been made too late...
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $33,857....
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $33,857. During October, the total cash deposited was $139,616, and checks written totaled $138,547. The bank statement indicated a balance of $43,270 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: a. Checks outstanding totaled $6,340. b. A deposit of $1,858 representing receipts of October 31, had been made too late...
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $5,140....
The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $5,140. During October, the total cash deposited was $39,175, and checks written totaled $40,520. The bank statement indicated a balance of $8,980 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: A. Checks outstanding totaled $5,560. B. A deposit of $1,050 representing receipts of October 31, had been made too late...
journal..v he cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of...
journal..v he cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $32,788. During October, the total cash deposited was $139,699, and checks written totaled $138,679. The bank statement indicated a balance of $42,830 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: A. Checks outstanding totaled $6,659. B. A deposit of $1,875 representing receipts of October 31, had been made too...
The cash account for Capstone Medical Co. at November 30, 2016, indicated a balance of $89,620....
The cash account for Capstone Medical Co. at November 30, 2016, indicated a balance of $89,620. The bank statement indicated a balance of $128,660 on November 30, 2016. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: A. Checks outstanding totaled $32,700. B. A deposit of $18,550, representing receipts of November 30, had been made too late to appear on the bank statement. C. The bank collected $26,750 on a...
Bank Reconciliation and Entries The cash account for Coastal Bike Co. at October 1, 20Y9, indicated...
Bank Reconciliation and Entries The cash account for Coastal Bike Co. at October 1, 20Y9, indicated a balance of $13,100. During October, the total cash deposited was $65,150 and checks written totaled $60,490. The bank statement indicated a balance of $22,090 on October 31, 20Y9. Comparing the bank statement, the canceled checks, and the accompanying memos with the records revealed the following reconciling items: Checks outstanding totaled $9,840. A deposit of $8,010, representing receipts of October 31 had been made...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT