how do I complete the worksheet using these transactions???? please help !!! I tried to enter the right numbers but my computer keeps saying I'm wrong plz help.
Fomat Palmter dmaing ae Edting clipboard Aignmem Styles Cells Eom Number Ideas A C G H K N A Byte of Accounting, Inc. Worksheet For Period Ending September 28, 2019 sting Entries Credi Stafement Unadjusted Trial Balance Account Number Name 1110 Cash 1120 Accounts Receivable Adiusted Trial Balanc Ince Balance Sheet Credd Cred Debit 68,691.00 2.300 00 Doba Credit obi Debit Debit Credit 0.00 0.00 0.00 68,691.00 68.691.00 0 00 0 00 0 00 2300 00 rance 1140 7 200 00 renaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr-Office Equip. 0,00 0.00 0.00 0.00 0.00 0,00 630.00 2.121.00 0.00 0.00 0.00 0.00 249.8 0 00 1312 Accum Depr-Computer Equip 1411 Building Cost 1412 Accum. Depr-Building O 0ol 0 00 0.00 0.0 0 00 80,000.00 000 0.00 0.00 0.00 0.00 15.000.00 Aggounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 0 00 0,00 0.00 0,00 0.00 0.00 0.00 0.00 0 00 0.00 0 00 0 00 85 5 2202 Notes Pavable 3100 Hudson Bloom, Capital 3300 Hudson Bloom, Withdrawals 135 500 00 0.00l 0 00 0.00 0.00 0.00 0,00 0.00 202,776.00 0.00 1.800.00 4100 Computer & Consuting Revenue 5010 Rent Expense 5020 Salary Expense 0.00 0.00 0 00 0.00 0,00 000 0.00 0.00 000 0.00 2.070.00 0,00 4100 Compuler & Consulling Revenue 0.00 0.00 0.00 0.00 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 2.070.00 0.00 0.00 0.00 0 00 325 00 000 .165.00 0 0 0.00 94 FORD Sunplies Exper 0.00 0 00 5090 Interest Expense 5100 Insurance Expense 5110 Deprociation Expens0 0 0.00 0.00 000 0 00 0.00 0.00 Q.00 0.00 438.901.00 432,701.00 Total NET INCOME Balance . Welcome General Journal Changes in Owner Chart of Accounts Transactions Worksheet Income Statement 8888888888 888838 June 14: Check # 5004 was used to purchase 08. equipment for $5,304.00 from Seth's Insurance. The effective date of the policy was June 16 and the a one-year insurance policy covering its computer invoice number was 2387. 09. June 16: A check in the amount of $6,750.00 was received for services performed for Pitman Pictures June 16: Byte purchased building and the land it is on for $95,000.00 to house its repair facilities and a to store computer equipment. The lot on which the building is located is valued at $15,000.00. The 10. balance of the cost is to be allocated to the building. Check # 5005 was used to make the down payment of $9,500.00. A thirty year mortgage with balance inital payement due on August 1st, was established for the an paid for rent of the office space for June, July and August 11. June 17: Check # 5006 for $7,200.00 was June 17: Received invoice number 26354 in the amount of $425.00 from the local newspaper for 12 advertising paid with Check # 5007 13. June 21: Accounts payable in the amount of $400.00 were June 21: Check # 5008 was used to purchase a fax machine for the office from Office Machines Express 14 for $825.00. The invoice number was 975-328 15. June 21: Billed various miscellaneous local customers $4,200.00 for consulting services performed. 15. June 21: Billed various miscellaneous local customers $4,200.00 for consulting services performed. June 22: Check # 5009 was used to pay salaries of $1,035.00 to equipment operators for the week 16 ending June 18. Ignore payroll taxes. June 22: Received a bill for $1,165.00 from Computer Parts and Repair Co. for repairs to the computer 17. equipment. The invoice number was 43254 18. June 22: Check # 5010 was used to pay the advertising bill that was received on June 17 June 23: Purchased office supplies for $630.00 from Staples on account. The invoice number was 19. O 65498 20. June 23: Cash in the amount of $3,365.00 was received billings on 21. June 28: Billed $5,700.00 to miscellaneous customers for services performed to June 25. 22. June 29: Paid the bill received on June 22, from Computer Parts and Repairs Co with Check # 5011 23. June 29: Cash in the amount of $5,400.00 was received for billings June 29: Check # 5012 was used to pay salaries of $1,035.00 to equipment operators for the week 24 ending June 25. Ignore payroll taxes June 30: Received a bill for the amount of $940.00 from O & G Oil and Gas Co. The invoice number 25 was 784537 June 30: Check # 5013 was used to pay for airline tickets of $1,900.00 to send the kids to Grandma 26 Ellen for the July 4th holiday Adjusting Entries - Round to two decimal places The rent payment made on June 17 was for June, July and August. Expense the amount associated with 27 one month's rent 28. A physical inventory showed that only $259.00 worth of office supplies remained on hand as of June 30 The annual interest rate on the mortgage payable 29. was 8.00 percent. Interest expense for one-half month should be computed because the building and land were purchased and the liability incurred on June 16. 30. Record a journal entry to reflect that one half month's insurance has expired A review of Byte's job worksheets show that there are unbilled revenues in the amount of $5,750.00 for 31 the period of June 28-30. The fixed assets have estimated useful lives as follows: Building 31.5 years Computer Equipment - 5.0 years 32. Office Equipment - 7.0 years Use the straight-line method of depreciation. Management has decided that assets purchased during a month are treated as if purchased on the first day of the month. The building's scrap value is $7,000.00 The office equipment has a scrap value of $400.00. The computer equipment has no Calculate the depreciation for one month S scrap value A review of the payroll records show that unpaid salaries in the amount of $621.00 are owed by Byte 33. for three days, June 28 - 30. Ignore payroll taxes The note payable to Royce Computers (transactions 04 and 07) is a five-year note, with interest at the 34. 360 day year rate of 12 percent annually. Imterest expense should be computed based on a Closing Entries 35. Close the revenue accounts 36. Close the expense accounts. 37. Close the income summary account. 38. Close the withdrawals account
