Using the information and Excel, provided for Jacks Maintenance Services to: 1. Record the journal entries...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the information and Excel, provided for Jacks Maintenance Services to: 1. Record the journal entries for June transactions. Include narrations. 2. Record adjusting entries for the end of June. Include narrations. 3. Construct the "T" formatted ledger accounts. 4. Prepare the profit and loss statement for the year ended 30 June 2020. 5. Prepare the classified narrative formatted balance sheet as at 30 June 2020. You must use excel formula to construct the leger accounts, profit and loss statement, and balance sheet. Use excel to answer the assignment requirements. The excel sheets must be linked to each other. You CANNOT just enter the data into the financial statements. You MUST enter the data once and link the excel sheets to produce the financial reports. Cash at bank Accounts receivable GST receivable Prepaid rent Prepaid insurance Office supplies Office equipment Account Accumulated depreciation - Office equipment Accounts payable Unearned fees Capital (H. Jacks) Drawings (H. Jacks) Fees revenue Jacks Maintenance Services Unadjusted Trial Balance as at 31st May 2020 Loan payable - due 31 December 2020 GST payable Electricity expense Fuel expense Rent expense Salaries expense Telephone expense Totals 65,100 56,300 3,600 12,000 9,000 6,660 121,500 21,600 4,500 8,600 22,000 73,000 6,100 409,960 Dr Cr 53,700 29,300 17,600 22,000 3,860 115,000 168,500 409,960 June transactions: Date 1/06/2020 2/06/2020 5/06/2020 Purchased office supplies on credit, due 15 July 2020 9/06/2020 Received a cash deposit upfront from a customer for maintenance work to be completed by the end of July 2020 12/06/2020 Cash receipts from customers for moneys owed 15/06/2020 Paid all outstanding accounts payable from previous month 22/06/2020 Received electricity bill 24/06/2020 Paid June salaries up to this date 26/06/2020 Received and paid telephone bill for month of June 28/06/2020 Settled previous month GST with ATO 29/06/2020 Cash receipts from customers for moneys owed 30/06/2020 Record all June Sales made on credit 30/06/2020 Received bank interest Additional Information: ● ● ● ● ● ● Transaction Cash receipts from customers for moneys owed Purchased a truck paying a 40% cash deposit and taking out a 3- year 7% loan to cover the balance. ● ● ● Amount $22,000 $88,000 $1,045 $1,540 $13,800 $682 $5,260 $363 $11,400 $79,200 $423 All sales are credit sales (21 days). Unless stated all amounts are GST inclusive or GST exempt. A physical count of office supplies on 30th June shows $2940 of unused supplies on hand. Depreciation of the office equipment for the year is estimated to be $16,200. Depreciation of the truck will be determined using the straight line method. Jacks maintenance estimates the useful life of the truck to be 5 years, and the residual value to be $7,000. Prepaid Rent was paid on the 1st of May and covered a period of four months. This account was not adjusted at the end of May. 25% of prepaid insurance expired during June. A fuel bill for June of $1,100 has not been recorded or paid. Salaries expense accrued for the last week in June amounts to $2,150. Interest expense of $275 has accrued in June on the loans payable. Of the unearned fees recorded in May, 20% were refunded to a customer as Jack's Maintenance Services was unable to complete the work prior to 30 June as previously agreed. The remainder of the unearned fees were earned during June. Using the information and Excel, provided for Jacks Maintenance Services to: 1. Record the journal entries for June transactions. Include narrations. 2. Record adjusting entries for the end of June. Include narrations. 3. Construct the "T" formatted ledger accounts. 4. Prepare the profit and loss statement for the year ended 30 June 2020. 5. Prepare the classified narrative formatted balance sheet as at 30 June 2020. You must use excel formula to construct the leger accounts, profit and loss statement, and balance sheet. Use excel to answer the assignment requirements. The excel sheets must be linked to each other. You CANNOT just enter the data into the financial statements. You MUST enter the data once and link the excel sheets to produce the financial reports. Cash at bank Accounts receivable GST receivable Prepaid rent Prepaid insurance Office supplies Office equipment Account Accumulated depreciation - Office equipment Accounts payable Unearned fees Capital (H. Jacks) Drawings (H. Jacks) Fees revenue Jacks Maintenance Services Unadjusted Trial Balance as at 31st May 2020 Loan payable - due 31 December 2020 GST payable Electricity expense Fuel expense Rent expense Salaries expense Telephone expense Totals 65,100 56,300 3,600 12,000 9,000 6,660 121,500 21,600 4,500 8,600 22,000 73,000 6,100 409,960 Dr Cr 53,700 29,300 17,600 22,000 3,860 115,000 168,500 409,960 June transactions: Date 1/06/2020 2/06/2020 5/06/2020 Purchased office supplies on credit, due 15 July 2020 9/06/2020 Received a cash deposit upfront from a customer for maintenance work to be completed by the end of July 2020 12/06/2020 Cash receipts from customers for moneys owed 15/06/2020 Paid all outstanding accounts payable from previous month 22/06/2020 Received electricity bill 24/06/2020 Paid June salaries up to this date 26/06/2020 Received and paid telephone bill for month of June 28/06/2020 Settled previous month GST with ATO 29/06/2020 Cash receipts from customers for moneys owed 30/06/2020 Record all June Sales made on credit 30/06/2020 Received bank interest Additional Information: ● ● ● ● ● ● Transaction Cash receipts from customers for moneys owed Purchased a truck paying a 40% cash deposit and taking out a 3- year 7% loan to cover the balance. ● ● ● Amount $22,000 $88,000 $1,045 $1,540 $13,800 $682 $5,260 $363 $11,400 $79,200 $423 All sales are credit sales (21 days). Unless stated all amounts are GST inclusive or GST exempt. A physical count of office supplies on 30th June shows $2940 of unused supplies on hand. Depreciation of the office equipment for the year is estimated to be $16,200. Depreciation of the truck will be determined using the straight line method. Jacks maintenance estimates the useful life of the truck to be 5 years, and the residual value to be $7,000. Prepaid Rent was paid on the 1st of May and covered a period of four months. This account was not adjusted at the end of May. 25% of prepaid insurance expired during June. A fuel bill for June of $1,100 has not been recorded or paid. Salaries expense accrued for the last week in June amounts to $2,150. Interest expense of $275 has accrued in June on the loans payable. Of the unearned fees recorded in May, 20% were refunded to a customer as Jack's Maintenance Services was unable to complete the work prior to 30 June as previously agreed. The remainder of the unearned fees were earned during June.
Expert Answer:
Answer rating: 100% (QA)
Journal Entries Date Particulars Amt Dr Cr 01062020 Cash Ac Dr 22000 To Accounts receivable Ac 22000 ... View the full answer
Related Book For
Fundamental Accounting Principles Volume 1
ISBN: 9781259259807
15th Canadian edition
Authors: Kermit Larson, Tilly Jensen, Heidi Dieckmann
Posted Date:
Students also viewed these accounting questions
-
Using the information and analysis prepared in QS 2-6, prepare the journal entries for the month of August. Use the following template. Ensure to include the date, the account descriptions, the debit...
-
Your company is considering funding two projects. Project A will cost the company $720,000, and Project B will cost $600,000. For Project A, they expect an estimated cash flow of $125,000 per year....
-
A. Prepare an income statement for the year ended 30 June 2017 using accrual accounting. B. Prepare an income statement for the year ended 30 June 2017 using cash accounting. C. Lana was not sure...
-
A problem in Statistics is given to three students A, B, and C whose chances of solving it are 1/4 and 1/5 respectively. Find the probability that the problem will be solved if they all try...
-
Stan rented an office building to Clay for $3,000 per month. On December 29, 2014, Stan received a deposit of $4,000 in addition to the first and last months rent. Occupancy began on January 2, 2015....
-
Maximize f = 3x + 5y subject to the constraints determined by the shaded region shown in the figure. y 24 (8, 18) 16 8- + 8. 16 24
-
5. What can you do to protect your privacy online? Draw up a concrete list of steps that you might reasonably consider. Are there some actions that you would not be willing to take, either because...
-
Sherpers Boards sells a snowboard, Xpert that is popular with snowboard enthusiasts. Information relating to Sherpers purchases of Xpert snowboards during September is shown below. During the same...
-
A jeep and BMW enter a highway running east-west at the sameexit heading in opposite directions. The jeep entered the highway30 minutes before the BMW did, and traveled 9 mph slower than theBMW. Af 2...
-
For the circuit in Fig. 2.95, determine i1 to i5. Figure 2.95 For Prob. 2.31 3 ( 2 --> i 13 12 40 V
-
Let :XY be a function. Let Z be a subset of Y. Prove that (Y-Z)=X-/-(2).
-
Process tracing software can be used with test data to investigate an application for fraud because process tracing software can a. Be used to trace a transaction from its origination through to the...
-
Which of the following statements are correct regarding the potential audit use of embedded audit modules? Embedded audit techniques: I. Are designed by internal auditors, therefore they are of...
-
Using an AS/AD diagram, show how a rise in AD could lead to a rise in national income but with no change in the price level.
-
Auditors have various EDP audit techniques available to aid in testing computer-based systems. Included in these audit techniques are (1) test data, (2) integrated test facility (ITF), (3) tagging...
-
Detailed testing of controls in a computer system through the use of test data or an TF a. Can be performed using either real or simulated transactions. b. Is not convincing because many of the...
-
French Corp French Corporation wishes to hire Leslie as a consultant to design a comprehensive staff training program. The project is expected to take one year, and the parties have agreed to a...
-
Explain briefly what is meant by electronic data interchange (EDI). How does EDI affect a companys audit trail?
-
ORiley Companys payroll costs and fringe benefit expenses include the normal CPP and EI contributions, retirement fund contributions of 10% of total earnings, and health insurance premiums of $120...
-
Tim Roadster began Roadster Servicing on April 1, 2017, and showed the following items after the first month of operations. Match each of these items with the financial statement or statements on...
-
The payroll records of Brownlee Company provided the following information for the weekly pay period ended March 23, 2015: Required 1. Enter the relevant information in the proper columns of a...
-
On1 May 19X8 Jenny Barnes, who is a retailer, had the following balances in her books: Premises 70,000; Equipment 8,200; Vehicles 5,100; Stock 9,500; Trade debtors 150. Jenny does not keep proper...
-
From the following draw up a bank reconciliation statement from details as on 31 December 19X6: Cash at bank as per bank column of the cash book Unpresented cheques Cheques received and paid into the...
-
The following are extracts from the cash book and the bank statement of J Roche. You are required to: (a) Write the cash book up to date, and state the new balance as on 31 December 19X9, and (b)...
Study smarter with the SolutionInn App