Question

In: Accounting

Bank Reconciliation and Entries The Coins, currency (paper money), checks, money orders, and money on deposit...

  1. Bank Reconciliation and Entries

    The Coins, currency (paper money), checks, money orders, and money on deposit that is available for unrestricted withdrawal from banks and other financial institutions.cash account for Collegiate Sports Co. on November 1 indicated a balance of $81,145. During November, the total cash deposited was $293,150, and checks written totaled $307,360. The A summary of all transactions mailed to the depositor or made available online by the bank each month.bank statement indicated a balance of $112,675 on November 30. 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.

    Collegiate Sports Co.
    Bank Reconciliation
    November 30
    Cash balance according to bank statement $
    • Add bank error in charging check as $2,750 instead of $7,250
    • Add bank service charges
    • Add deposit of November 30, not recorded by bank
    • Add outstanding checks
    • Add note and interest collected by bank
    $
    • Deduct bank service charges
    • Deduct check returned because of insufficient funds
    • Deduct deposit of November 30, not recorded by bank
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    $
    • Deduct bank error in charging check as $2,750 instead of $7,250
    • Deduct bank service charges
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct proceeds of note collected by bank, including $100 interest
    Adjusted balance $
    Cash balance according to company's records $
    • Add bank error in charging check as $2,750 instead of $7,250
    • Add bank service charges
    • Add check returned because of insufficient funds
    • Add deposit of November 30, not recorded by bank
    • Add note and interest collected by bank
    $
    • Add bank service charges
    • Add cash balance according to company's records
    • Add deposit of November 30, not recorded by bank
    • Add error in recording check as $7,600 instead of $760
    • Add outstanding checks
    $
    • Deduct check returned because of insufficient funds
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    $
    • Deduct bank service charges
    • Deduct deposit of November 30, not recorded by bank
    • Deduct error in recording check by Collegiate Sports Co.
    • Deduct outstanding checks
    • Deduct note and interest collected by bank
    Adjusted balance $

    Feedback

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

    a. Nov. 30
    • Accounts Payable-Ramirez Co.
    • Accounts Receivable-Ramirez Co.
    • Cash
    • Interest Revenue
    • Notes Receivable
    • Cash
    • Cash Short and Over
    • Interest Receivable
    • Miscellaneous Administrative Expense
    • Notes Receivable
    • Accounts Receivable-Hallen Academy
    • Interest Revenue
    • Petty Cash
    • Sales
    • Unearned Interest
    • Accounts Payable-Ramirez Co.
    • Accounts Receivable-Ramirez Co.
    • Cash
    • Cash Short and Over
    • Sales
    b. Nov. 30
    • Accounts Payable-Hallen Academy
    • Accounts Receivable-Hallen Academy
    • Cash Short and Over
    • Interest Expense
    • Interest Revenue
    • Cash Short and Over
    • Miscellaneous Expense
    • Miscellaneous Revenue
    • Notes Receivable
    • Petty Cash
    • Accounts Payable-Hallen Academy
    • Accounts Receivable-Hallen Academy
    • Cash
    • Miscellaneous Revenue
    • Petty Cash

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

Solutions

Expert Solution

Solution 1:

Solution 2:

Solution 3:

Amount to be reported as cash = $78,535


Related Solutions

Sunshine Interiors deposits all Coins, currency (paper money), checks, money orders, and money on deposit that...
Sunshine Interiors deposits all Coins, currency (paper money), checks, money orders, and money on deposit that is available for unrestricted withdrawal from banks and other financial institutions.cash receipts each Wednesday and Friday in a night depository, after banking hours. The data required to reconcile the A summary of all transactions mailed to the depositor or made available online by the bank each month.bank statement as of July 31 have been taken from various documents and records and are reproduced as...
Using the information below, answer the following questions on money: Currency outside banks Coins and Paper...
Using the information below, answer the following questions on money: Currency outside banks Coins and Paper money 110 Traveler’s cheques 4,340 Charter Banks Chequable deposits 140 TMLs & CUCPs Chequable deposits 50 Money market mutual funds 7,760 TMLs & CUCPs Total Deposit 1,600 Savings & Time Deposit 6,700 Part 1: The value of 'M1+' is:   Part 2: The value of 'M2' is: Part 3: The value of 'M2+' is:
1. A bank reconciliation revealed bank charges of $11, outstanding checks of $221, and NSF checks...
1. A bank reconciliation revealed bank charges of $11, outstanding checks of $221, and NSF checks of $90. The journal entry to cause the company records to match the correct adjusted ending cash balance includes: a credit to cash for a total of $322. None of these. a credit to cash for a total of $11. a credit to cash for a total of $101. a credit to cash for a total of $90. 2. Hastings Company replenished a $500...
Listed below are various items: Coins & Currency on hand $6,200 Cashiers’ Checks $3,900 Postdated Checks...
Listed below are various items: Coins & Currency on hand $6,200 Cashiers’ Checks $3,900 Postdated Checks $495 Commercial Paper with a 60-day maturity $3,300 Certificates of Deposit with a 120-day maturity $13,500 Overdraft in checking account at different bank from regular bank ($303) Compensating Balance-Restricted Cash $18,000 Bond Sinking Fund $25,000 U.S. Treasury Bills with 30-day maturity $12,910 Postage Stamps $279 Petty Cash $551 Compute the cash and cash equivalents balance for this company.
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris...
Prepare bank reconciliation and related entries. AP The bank portion of the bank reconciliation for Katsaris Company at August 31, 2017, was as follows: KATSARIS COMPANYBank Reconciliation August 31, 2017 Cash balance per bank $13,229 Add: Deposits in transit 2,350 15,579 Less: Outstanding cheques #4451 $1,740 #4460 549 #4461 723 #4462 1,840 #4464 620 5,472 Adjusted cash balance per bank $10,107 The unadjusted cash balance per books on September 30, 2017, was $10,228. The September bank statement showed the following:...
Question 11 The asset demand (Da) for money Group of answer choices includes coins, paper currency...
Question 11 The asset demand (Da) for money Group of answer choices includes coins, paper currency and government bonds is typically high if interest rates are relatively high is the demand for money as a medium of exchange is the demand for money in case of an emergency is the demand of money as a store of wealth Question 12 The asset demand for money Group of answer choices is unrelated to both the rate of interest and real income...
Which money market is not created by a bank? Commercial paper Certificate of deposit Bankers acceptance...
Which money market is not created by a bank? Commercial paper Certificate of deposit Bankers acceptance Federal funds
Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal Final Question X...
Bank reconciliation and entries Instructions Chart of Accounts Amount Descriptions Bank Reconciliation Journal Final Question X Instructions The cash account for American Medical Co. at April 30 indicated a balance of $97,456. The bank statement indicated a balance of $127,960 on April 30. Comparing the bank statement and the accompanying canceled checks and memos with the records revealed the following reconciling items: A. Checks outstanding totaled $30,050. B. A deposit of $19,720, representing receipts of April 30, had been made...
QUESTION 1 On a bank reconciliation, customers' checks that are returned for lack of funds would...
QUESTION 1 On a bank reconciliation, customers' checks that are returned for lack of funds would be deducted from the balance per company records deducted from the balance per bank statement added to the balance per bank statement added to the balance per company records QUESTION 2 After the company completes the bank reconciliation, it makes journal entries for adjustments it made to the bank statement balance it made to its records it made to both the bank statement and...
Author Anna Schwartz writes this about money: “The U.S. money supply comprises currency—dollar bills and coins...
Author Anna Schwartz writes this about money: “The U.S. money supply comprises currency—dollar bills and coins issued by the Federal Reserve System and the Treasury—and various kinds of deposits held by the public at commercial banks and other depository institutions such as savings and loans and credit unions.” (Schwartz, n.d) In this threaded discussion, complete the following: 1) Discuss the concept of money. First, define the functions of money and explain how currency meets these functions. 2) Historically, a number...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT