please help understand the steps to follow to solve this question 11/2/21, 4:34 PM Studocu is not
Fantastic news! We've Found the answer you've been seeking!
Question:
please help understand the steps to follow to solve this question
Transcribed Image Text:
11/2/21, 4:34 PM Studocu is not sponsored or endorsed by any college or university Downloaded by Gurleen Sharma (gurleen sharma09@gmail.com) Lab 7.3 (Question 1)-Lyryx Learning Inc lyryx Lab 7.3 (Question 1) Name Mike Sawicki Sawicki Date 2021-10-18 12:17 Spreadsheet Print Preferences Help Question 1 [35 points] Consider the following information and prepare a bank reconciliation, along with any resulting journal entries, for X-cell Inc. for the month ended August 31, 2015. Please enter journal entries for each of the following, If required. Enter the corresponding number as the description for each entry. Also, the dates must be entered in the format dd/mmm (le 15/Jan). 1. Outstanding deposit 2. Interest earned 3 NSF cheque 4. Bank service charge 5. Error 6. Notes receivable collected 7. Outstanding cheque Bank statement balance. Add: Outstanding deposit X-cell Inc. Bank Reconcllation July 31, 2015 24,400 Book balance, 950 Add: Interest eamed Deduct Outstanding cheques Adjusted bank balance, #413 25,350 Deduct 950 Bank service charge, 24.400 Adjusted book balance 24.414 24,420 20 24,400 Bank Statement www.Cash Account No. 101 To: X-cell Inc. Cheques/Charges/Debits August 31, 2015 Deposits/Credits Date Desc. PR Debit Credit Balance Balance 31/Jul Balance 24,400 31/Aug CR13 3:050 27,450 24,400 #418 03/Aug 900 03/Aug 950 24,450 31/Aug CD15 10,850 16,600 #415 07/Aug 1,150 07/Aug 050 24.350 #413 09/Aug 950 09/Aug 800 24,200 #416 11/Aug 950 23,250 #419 11/Aug 950 22,300 #420 15/Aug 1:300 21,000 #417 23/Aug 750 20,250 NSF 24/Aug 450 19.800 #414 30/Aug 1000 8,800 Bank service 31/Aug 20 Interest 8,787 The NSF cheque for $450 was that of a customer Deposits Made August 7 Cheques Written 050 ,000 1,150 1200 950 Total August Cash 3.050 750 900 950 1,300 421 422 423 1,350 1,200 1,300 This document is available free of charge on studocu https://fa1.lyryx.com/student-servlets/LabServletlab-70038singleQuestion-0&commands1&cod-7845 11/2/21, 4:34 PM Downoaded by Gurleen Sharma (gurleen.sharma09@gmail.com) Lab 7.3 (Question 1)-Lyryx Learning Inc Total August Cash Disbursements- X-ce 2 of 3 Bank Reconciliation August 31, 2015 10.850 11/2/21, 4:34 PM Studocu is not sponsored or endorsed by any college or university Downloaded by Gurleen Sharma (gurleen sharma09@gmail.com) Lab 7.3 (Question 1)-Lyryx Learning Inc lyryx Lab 7.3 (Question 1) Name Mike Sawicki Sawicki Date 2021-10-18 12:17 Spreadsheet Print Preferences Help Question 1 [35 points] Consider the following information and prepare a bank reconciliation, along with any resulting journal entries, for X-cell Inc. for the month ended August 31, 2015. Please enter journal entries for each of the following, If required. Enter the corresponding number as the description for each entry. Also, the dates must be entered in the format dd/mmm (le 15/Jan). 1. Outstanding deposit 2. Interest earned 3 NSF cheque 4. Bank service charge 5. Error 6. Notes receivable collected 7. Outstanding cheque Bank statement balance. Add: Outstanding deposit X-cell Inc. Bank Reconcllation July 31, 2015 24,400 Book balance, 950 Add: Interest eamed Deduct Outstanding cheques Adjusted bank balance, #413 25,350 Deduct 950 Bank service charge, 24.400 Adjusted book balance 24.414 24,420 20 24,400 Bank Statement www.Cash Account No. 101 To: X-cell Inc. Cheques/Charges/Debits August 31, 2015 Deposits/Credits Date Desc. PR Debit Credit Balance Balance 31/Jul Balance 24,400 31/Aug CR13 3:050 27,450 24,400 #418 03/Aug 900 03/Aug 950 24,450 31/Aug CD15 10,850 16,600 #415 07/Aug 1,150 07/Aug 050 24.350 #413 09/Aug 950 09/Aug 800 24,200 #416 11/Aug 950 23,250 #419 11/Aug 950 22,300 #420 15/Aug 1:300 21,000 #417 23/Aug 750 20,250 NSF 24/Aug 450 19.800 #414 30/Aug 1000 8,800 Bank service 31/Aug 20 Interest 8,787 The NSF cheque for $450 was that of a customer Deposits Made August 7 Cheques Written 050 ,000 1,150 1200 950 Total August Cash 3.050 750 900 950 1,300 421 422 423 1,350 1,200 1,300 This document is available free of charge on studocu https://fa1.lyryx.com/student-servlets/LabServletlab-70038singleQuestion-0&commands1&cod-7845 11/2/21, 4:34 PM Downoaded by Gurleen Sharma (gurleen.sharma09@gmail.com) Lab 7.3 (Question 1)-Lyryx Learning Inc Total August Cash Disbursements- X-ce 2 of 3 Bank Reconciliation August 31, 2015 10.850
Expert Answer:
Answer rating: 100% (QA)
Here are the stepbystep workings for this bank reconciliation question Bank Reconciliation Statement ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
CHANGING OUR LIVES Introduction Thesis I have now chosen to go to college to have a better job, a better financial income, and personal reasons. how it impacted: I. First Main Point Employment...
-
In a two-player, one-shot simultaneous-move game each player can choose strategy A or strategy B. If both players choose strategy A, each earns a payoff of $500. If both players choose strategy B,...
-
What are implicit costs? How are they different from explicit costs?
-
The Internal Revenue Service reported the average refund in 2017 was $2,878 with a standard deviation of $520. Assume the amount refunded is normally distributed. a. What percent of the refunds are...
-
According to the Supreme Court decision in Quill Corp. v. North Dakota, a state may not require a retailer with no physical presence in the state to collect and remit sales tax on sales made in the...
-
Okabe Company ended its fiscal year on July 31, 2017. The companys adjusted trial balance as of the end of its fiscal year is shown below. Instructions (a) Prepare the closing entries using page J15....
-
Based on the Lease Obligations by Year visualization, do the results make sense? Select answer from the options below No. There is a decreasing trend in finance lease and operating lease obligations,...
-
A survey by the Arthur Andersen Enterprise Group/ National Small Business United attempted to determine what the leading challenges are for the growth and survival of small businesses. Although the...
-
Assume Sports Shirtz sells 2 shirts: polos for $60 and t-shirts for $30. Fixed costs are $80,000 and the VCs are $20 and $10 for polos and Tees respectively. The sales ratio is 60% polos and 40%...
-
B-Tran Ltd has been carrying on business in Hong Kong for many years. It prepares its accounts to 31 March each year. On 1 December 2019, it purchased a motor car (AA:30%) under hire purchase terms...
-
To what impact does long working hours causes a decline in the performance of the Jamaica Constabulary Force members in the area 2 division. You are required to write the problem statement for the...
-
A market system allows entrepreneurs and workers to further their own self-interests, subject to the rewards and penalties that the system imposes. Which virtues of the market system does this...
-
What was the purpose for the creation of Republic Act 7277, sometimes known as the Magna Carta for Persons with Disabilities, as amended by Republic Acts 9442 and 10754?
-
Texas and how to use it What would be a response to the statement "Tax Revenue is the people's money, and the people should decide how to spend it
-
Zakah is the best way to alleviate the poverty from society- judge this statement summarizing the Nisab of Zakat in different goods properly.
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
John Fuji (age 37) moved from California to Washington in December 2011. He lives at 468 Cameo Street, Yakima, WA 98901. John's Social Security number is 571-78-5974 and he is single. His earnings...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Sophie is a single taxpayer. For the first payroll period in October 2012, she is paid wages of $3,250 monthly. Sophie claims three allowances on her Form W-4. a. Use the percentage method to...
-
Figure P2.4 shows a graph of position versus frame number from a video clip of a moving object. Describe this motion from beginning to end, and state any assumptions you make. Data from Figure P2.4...
-
What minimum information must be extracted from a video clip of a moving object in order to quantify the object's motion?
-
The sequence in Figure P2.3 represents a ball that is initially held above the ground. In the first frame the ball is released. In subsequent frames the ball falls, bounces on the ground, rises, and...
Study smarter with the SolutionInn App