Your bank manager has requested an explanation regarding your bank account. He has advised you are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Your bank manager has requested an explanation regarding your bank account. He has advised you are overdraft by $120,000 as of today - January 31, 2023 and wants the negative balance covered immediately. You respond that your general ledger shows a cash balance of $320,000. Knowing that the only way to solve the problem is to prepare a bank account reconciliation as at January 31, 2023 you have your staff find and present the following information for analysis: Customer lockbox cash received by bank January 30 not in company records - $88,000 Cheques processed by bank and company during month - $437,000 Cheques issued by company not yet cleared bank - $398,000 Bank loan interest processed January 28 by bank not in company records - $19,000 Company cash transfer January 30 processed by bank on February 1 - $265,000 Company cash deposit made on last day after banking hours - $315,000 Deposits processed by company and bank - $545,000 Loan payment processed by bank January 27 - $383,000 New loan payment starting March 2023 - $200,000 January 31 EFT supplier payments not processed by bank until February 1 - $56,000 Prepare the detailed bank reconciliation to advise the bank as to what the "actual" balance will be. Your bank manager has requested an explanation regarding your bank account. He has advised you are overdraft by $120,000 as of today - January 31, 2023 and wants the negative balance covered immediately. You respond that your general ledger shows a cash balance of $320,000. Knowing that the only way to solve the problem is to prepare a bank account reconciliation as at January 31, 2023 you have your staff find and present the following information for analysis: Customer lockbox cash received by bank January 30 not in company records - $88,000 Cheques processed by bank and company during month - $437,000 Cheques issued by company not yet cleared bank - $398,000 Bank loan interest processed January 28 by bank not in company records - $19,000 Company cash transfer January 30 processed by bank on February 1 - $265,000 Company cash deposit made on last day after banking hours - $315,000 Deposits processed by company and bank - $545,000 Loan payment processed by bank January 27 - $383,000 New loan payment starting March 2023 - $200,000 January 31 EFT supplier payments not processed by bank until February 1 - $56,000 Prepare the detailed bank reconciliation to advise the bank as to what the "actual" balance will be.
Expert Answer:
Answer rating: 100% (QA)
Bank Account Reconciliation as of January 31 2023 Balance per bank statement 120000 Add Customer loc... View the full answer
Related Book For
Financial Accounting and Reporting
ISBN: 978-0273744443
14th Edition
Authors: Barry Elliott, Jamie Elliott
Posted Date:
Students also viewed these accounting questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
The following financial statements were provided by Sumsong Electronics Company. The owner, Gillian Sumsong, is applying for a second loan from the bank to buy some new equipment. The bank manager...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Mick Stone disposed of the following assets during tax year 2020-21: (1) On 19 May 2020, Mick sold a freehold warehouse for 522,000. This warehouse was purchased on 6 August 2008 for 258,000, and was...
-
Acridine is a heterocyclic aromatic compound obtained from coal tar that is used in the synthesis of dyes. The molecular formula of Acridine is C13H9N, and its ring system is analogous to that of...
-
Happy Camper Park, Inc. was organized on April 1, 2019, by Barbara Evans. Barbara is a good manager but a poor accountant. From the trial balance prepared by a part-time bookkeeper, Barbara prepared...
-
Suggest criteria that could be used to classify systems of financial reporting employed in different countries. What difficulties are there in performing an exercise of this nature?
-
Refer to Exercise 6-4. Using the same figures, assume that the merchandise mentioned was included in Pearces inventory, having been purchased from Searl. Required: Calculate the controlling interest...
-
Find the point W that is on the directed segment UV that is the distance from U to V. given (4,3) and point (-2,-3). 2 " V (-1.1) (0,-1) U (2,1) (3,2) e
-
On January 1, 2023, Pulaski, Incorporated, acquired a 60 percent interest in the common stock of Sheridan, Incorporated, for $392,400. Sheridan's book value on that date consisted of common stock of...
-
What is the purpose of a cash flow statement, and how is it prepared?
-
Construct a Moore state diagram to convert NRZI codes to NRZ codes. For your reference, the waveforms of various types of codes are given below. You may assume that the initial condition of the NRZI...
-
How do advanced electrochemical techniques, such as electrochemical impedance spectroscopy (EIS) and scanning electrochemical microscopy (SECM), contribute to the understanding of corrosion...
-
How can I figure out... wire from the end at x = 1 4 . 4 m . At time t = 1 2 . 7 m s , pulse 2 is sent along the wire from the end at x = 0 . At what position x do the pulses begin to meet? Number...
-
Can you elaborate on the role of environmental factors, such as pH, temperature, and aggressive chemical species, in influencing corrosion rates and corrosion product formation, and how these factors...
-
Premier Products, Inc. manufactures tennis rackets. Premier Products has grown extensively over the past two years. While the company has been very profitable, President Mark Harrison is concerned...
-
Derek decides that he needs $188,358.00 per year in retirement to cover his living expenses. Therefore, he wants to withdraw $188358.0 on each birthday from his 66th to his 85.00th. How much will he...
-
Consider the setup in Problem 16. Show that the relative speed of the ball and the point of contact on the stick is the same before and immediately after the collision. (This result is analogous to...
-
Donna Inc Donna Inc operates a defined benefit pension scheme for staff. The pension scheme has been operating for a number of years but not following IAS 19. The finance director is unsure of which...
-
The Mission Company Ltd, whose year-end is 31 December, has acquired two items of machinery on leases, the conditions of which are as follows: Item Y: Ten annual instalments of 20,000 each, the first...
-
Basalt plc is a wholesaler. The following is its trial balance as at 31 December 20X0. The following additional information is supplied: (i) Depreciate plant and machinery 20% on straight-line basis....
-
Explain the trade-offs that inventory managers face when they reorder products or supplies. How is the reorder point computed?
-
Supply-chain management involves long-term partnerships among channel members that are working together to reduce inefficiencies, costs, and redundancies and develop innovative approaches to satisfy...
-
Assume that you are responsible for the physical distribution of computers at a web-based company. What would you do to ensure product availability, timely delivery, and quality service for your...
Study smarter with the SolutionInn App