Question

In: Accounting

The bookkeeperat Hopkins Company has not reconciled the bank statement with the cash account, saying instead,...

The bookkeeperat Hopkins Company has not reconciled the bank statement with the cash account, saying instead, "I don't have time." You have been asked to prepare a reconciliation and review procedures with the bookkeeper.

The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (Summarized):

                                          Bank Statement

Cheques Deposits Balance
Balance, April 1,2018 $31,000
Deposits during April $36,100 67,100
Notes Collected for company (including $70 interest) 1,180 68,280
Cheques cleared during April $44,500 23,780
NSF cheque-A. B. Wright 160 23,620
Bank service charges 70 23,550
Balance, April 30, 2018 23,550

                                               Cash in Bank

Apr. 1 Balance   23,500 Apr.     Cheques written   41,000
Apr.     Deposits 41,500

                                              Cash on Hand

Apr. 30         Balance       100

A company of cheques written before and during April whththe cheques cleared through the bank showed that cheques of $4,100 are still outstanding at April 30. No seposits in transit were carried over from March, but a deposit was in transit at April 30.

Required:

1. Prepare a detailed bank reconciliation at April30, 2018.

2. Prepare any required journal entries as a result of the reconciliation. Why are they necessary?

3. What were the balances in the cash accounts in the ledger on May 1, 2018?

4. What total amount of cash should be reported on the statement of financial position at April 30. 2018.

Please answer all the questions, espicially, question 3 and 4 because I put this question before but the professor who answered it did not answer all of them.

Solutions

Expert Solution

1)
Hopkins Company
Bank Reconciliation
April 30, 2018
Company's Books Bank Statement
Cash balance per books ($23500 + 41500 - 41000 -100) $23,900.00 Cash balance per bank statement $23,550.00
Additions: Additions:
Interest Collected $1,180.00 Deposits in transit (41500 - 36100) $5,400.00
$25,080.00 $28,950.00
Deductions: Deductions:
NSF—A. B. Wright $160.00 Outstanding checks -$4,100.00
Bank charges $70.00 -$230.00
Adjusted cash balance per books $24,850.00 Adjusted cash balance per bank $24,850.00
2)
Accounts and Explanation Debit Credit
Bank Charges $70.00
Cash $70.00
Accounts Receivable—A. B Wright 160
Cash 160
Cash $1,180.00
Interest Revenue $1,180.00
3)
The balances in the cash accounts in the ledger on May 1, 2018 $24,850.00
4) Total amount of cash should be reported on the statement of financial position at April 30. 2018
Current Assets : Cash $24,850.00

Related Solutions

The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying instead, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (summarized): Bank Statement Cheques Deposits Balance   Balance, April 1, 2018 $ 34,000   Deposits during April $ 37,600 71,600   Notes collected for company      (including $85 interest) 1,330 72,930   Cheques...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying...
The bookkeeper at Hopkins Company has not reconciled the bank statement with the cash account, saying instead, “I don’t have time.” You have been asked to prepare a reconciliation and review the procedures with the bookkeeper. The April 30, 2018, bank statement and the April ledger accounts for cash showed the following (summarized): Bank Statement Cheques Deposits Balance   Balance, April 1, 2018 $ 34,000   Deposits during April $ 37,600 71,600   Notes collected for company      (including $85 interest) 1,330 72,930   Cheques...
When the bank reconciliation has differing amounts of the company cash account and the bank statement...
When the bank reconciliation has differing amounts of the company cash account and the bank statement what must you do
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,390 and #5893 for $1,528.00. The following information was available for the September 30, 2020, reconciliation: From the September 30, 2020, bank statement: Balance of previous statement on Aug. 31/20 10,979.00 6 deposits and other credits totalling 23,509.00 9 cheques and other debits totalling 27,498.00 Current balance as of Sept. 30/20 6,990.00 Chequing Account Transactions Date...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed...
Pelzer Company reconciled its bank and book statement balances of Cash on August 31 and showed two cheques outstanding at that time, #5888 for $6,040 and #5893 for $1,443.00. The following information was available for the September 30, 2017, reconciliation: From the September 30, 2017, bank statement   BALANCE OF PREVIOUS STATEMENT ON AUG. 31/17 10,368.00   6 DEPOSITS AND OTHER CREDITS TOTALLING 18,392.00   9 CHEQUES AND OTHER DEBITS TOTALLING 23,908.00   CURRENT BALANCE AS OF SEPT. 30/17 4,852.00 Chequing Account Transactions Date...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,096 and No. 5893 for $489. The following information is available for its September 30, 2017, reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 18,500 9,892 11,524 20,132 CHECKS AND DEBITS DEPOSITS AND CREDITS Date No. Amount Date Amount 09/03 5888 1,096 09/05 1,115...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,028 and No. 5893 for $494. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 16,800 9,617 11,270 18,453 CHECKS AND DEBITS DEPOSITS AND CREDITS Date...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,089 and No. 5893 for $509. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 20,000 9,724 11,564 21,840 CHECKS AND DEBITS DEPOSITS AND CREDITS Date...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,089 and No. 5893 for $509. Check No. 5893 was still outstanding as of September 30. The following information is available for its September 30 reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 20,000 9,724 11,564 21,840 CHECKS AND DEBITS DEPOSITS AND CREDITS Date...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31...
Chavez Company most recently reconciled its bank statement and book balances of cash on August 31 and it reported two checks outstanding, No. 5888 for $1,089 and No. 5893 for $517. The following information is available for its September 30, 2017, reconciliation. From the September 30 Bank Statement PREVIOUS BALANCE TOTAL CHECKS AND DEBITS TOTAL DEPOSITS AND CREDITS CURRENT BALANCE 18,500 9,922 11,574 20,152 CHECKS AND DEBITS DEPOSITS AND CREDITS Date No. Amount Date Amount 09/03 5888 1,089 09/05 1,144...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT