Question

In: Accounting

The owner of Harry’s Garden Supplies has completed a bank reconciliation and cannot get the bank’s...

The owner of Harry’s Garden Supplies has completed a bank reconciliation and cannot get the bank’s records to agree with the cash records of his business. He concludes that internal control has somehow failed and cash is being misappropriated. He asks you to check the records and confirm or otherwise his suspicions. He supplies the reconciliation statement at the end of last month, his cash records, and the most recent bank statement.

Last month’s reconciliation statement is presented below.

Harry’s Garden Supplies

Bank Reconciliation

as at 31 May 2020

Balance as per bank statement

$ 42,328.90

Cr

Add: Outstanding deposits

1,224.50

5,553.40

Less: Unpresented cheques

   223.70

Balance as per Cash at Bank account

5,329.70

Dr

The total of the cash receipts journal for June is $64,776.30 and the total of the cash payments journal is $63,265.60. The current bank statement shows that cheques presented and paid amount to $59,725.10, and total deposits amount to $64,780.60. There are also additional debits on the statement for a dishonoured cheque for $210, and account fees for $20.

An examination of the records reveals that all reconciling items at 31 May 2020 appear in the bank statement for June, unpresented cheques at 30 June total $7,154.40, and the 30 June deposit of $1,950.40 has not been credited by the bank. Your check of the cash journals reveals that addition errors have been made by the clerks responsible. Receipts should total $65,766.30 and payments should total $63,185.60.

Required:

  1. Recalculate and present the general ledger Cash at Bank account balance as it should be at 30 June 2020.

  1. Prepare the bank reconciliation statement at 30 June 2020.

  1. Advise the owner of Harry’s Garden Supplies whether cash is being misappropriated, assuming that the records maintained by the bank are accurate. (150 words)

  1. ‘Although the process of bank reconciliation provides a measure of control over cash in a business entity, bank reconciliation is useless unless it operates within a framework that incorporates essential elements of a good internal control system.’ Discuss this statement.

Solutions

Expert Solution

a) Balacnce as on 31-May-2020(Cash at Bank Account) 5329.7
Add: Total Receipts during the month of June 65776.3
Less:Total Payments during the month of june (63,185.60)
Balacnce as on 30th-June-2020(Cash at Bank Account) 7920.4
Balance as per Bank statement as on 30th june 2020
Balance as on 31-05-2020 42328.9
Add:Total deposits for June 64780.6
Less:Cheque Presented and Paid (59,725)
Less: Bank Charges (20)
Less:Cheque dishonoured (210)
Balance as on 30 june 2020 47154.4
b) Bank Reconciliation Statement for the month of June 2020
Balacnce as per Bank statement 47154.4
Add: Outstanding Deposits 1950.4
Less:unpresented Cheques (7,154)
Less:Account fee (20)
Less:Dishonoured Cheque debited (210)
Balance as per Cash at Bank account should be 41720.4
Balacnce as on 30th-June-2020(Cash at Bank Account) 7920.4
Misappropriation of Cash 33800

c). Since the accounts maintained by the bank are correct while preparing the bank reconcilition statements its found that the Cash Account is misapropriated by $.33800 during the period.

The cash at Bank account is showing a difference of the same while comparing the statements.

d).Whether there established a strong internal control or not its better to prepare the bank reconciliation statements at a regular intervals to know the accuracy of the cash accounts maintained. The bank reconciliation statemeng is a tool which can be used by the entities to get a control over the cash and bank account.We cant say that its a useless tool when there is a strong internal control system, an entity reuires both the internal control as well as a system of preparing bank reconciliation to ensure the correctness of the cash at bank account.from the bank reconciliation statement we can identify the mistakes in our cash book entry.


Related Solutions

What transactions might get recorded as a result of a bank reconciliation
What transactions might get recorded as a result of a bank reconciliation
Lush Garden supplies uses a perpetual inventory system. Lush Garden supplies has these account balaces at...
Lush Garden supplies uses a perpetual inventory system. Lush Garden supplies has these account balaces at July 31, 20X6, prior to making the year end adjustments: Inventory (Beg bal: 11,500, End bal: 18,000), COGS (bal: 76,000), Sales Revenue (161,000). A year ago, the NRV (net realizable value) cost of ending inventory was 12,000 which exceeded cost of 11,500. Lush Garden Supplies has determined that the NRV cost of the July 31, 20X6, ending inventory is 14,800. Prepare the company's 20X6...
Suppose that the bank sells $5 million in securities to get new cash. Show the bank’s...
Suppose that the bank sells $5 million in securities to get new cash. Show the bank’s balance sheet after this transaction. What are the bank’s excess reserves?
This is the HW question I cannot get the correct answer for. I've completed the first...
This is the HW question I cannot get the correct answer for. I've completed the first step but I cannot seem to get the correct numbers for EFN for 20, 25 and 30%!?!? See below for given financial statements and my table with the pro forma of 20, 25 and 30% numbers The most recent financial statements for Scott, Inc., appear below. Interest expense will remain constant; the tax rate and the dividend payout rate also will remain constant. Costs,...
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement,...
Bank reconciliation The company’s accounting intern has prepared the end-of-January bank reconciliation from the bank statement, and is worried because the Adjusted Balance amounts do not agree. After reviewing the bank reconciliation, scroll down for the next steps in helping the intern. Murdstone Co. Bank Reconciliation January 31, 20Y5 1 Cash balance according to bank statement $23,557.98 2 Deduct deposit of May 31, not recorded by bank 12,125.25 3 $11,432.73 4 Add outstanding checks: 5 No. 124 $62.00 6 No....
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
Question 2 Bank Reconciliation The Duluth Manufacturing Company has a business chequing account at the Bank...
Question 2 Bank Reconciliation The Duluth Manufacturing Company has a business chequing account at the Bank of Ontario. The bank provides a bank statement and cancelled cheques once a month. The cut-off date is the last day of the month. The bank statement for the month of May is summarized as follows: Balance, May 1, 2016                                          $32,120        Deposits                                               82,140        Cheques processed                                       (78,433)        Service charges                                       (80)        NSF cheque from customer                                              (2,187)        Note...
James Thomas is responsible for preparing bank reconciliation statements for Ajax Inc. Ajax has many bank...
James Thomas is responsible for preparing bank reconciliation statements for Ajax Inc. Ajax has many bank accounts, including separate accounts for each major branch, accounts for payments of salaries and dividends, and accounts kept in foreign currency for overseas divisions. James maintains records including bank statements and weekly bank reconciliations for each account. In addition, there are files containing correspondence with banks about disputed transactions, dishonored checks from Ajax's customers, and other bank-initiated transactions such as fees and interest. a....
Beleaguered Bank has the balance sheet shown below. Assume that the bank’s desired reserve ratio is...
Beleaguered Bank has the balance sheet shown below. Assume that the bank’s desired reserve ratio is 10% of total deposits and that it ad just received this demand deposit. Assets: Liabilities: Reserves $50 000 Loans $50,000 Demand Dep. $100,000 a. (2) Does this bank carry any excess reserves? If yes, how much? b. (2) What is the maximum amount of loans this bank could have on its books? c. (2) Assume that Beleaguered Bank converts all of its excess reserves...
Scenario: Kim Weathers, CEO of Southwest Idaho Bank and Trust, has decided to retain the bank’s...
Scenario: Kim Weathers, CEO of Southwest Idaho Bank and Trust, has decided to retain the bank’s corporate jet at a time most of the bank’s competitors have sold theirs. The bank has built a reputation for being an expert in taking care of the needs of a diverse, specialized segment of customers such as cattle ranchers in Montana and western Texas as well as almond growers in California. Ms. Weathers has determined that the bank’s executives, including her, need to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT