I just need help completing the worksheet everything is here I just have fill in the yellow boxes with the numbers already there in the white boxes

Byte of Accounting maegan grace 8742 Transaction Description of transaction June 1: Hudson Bloom invested $161,336.00 cash and computer equipment with a fair market value of 01 $41,440.00 in his new business, Byte of Accounting Check # 5000 was used to purchased computer equipment costing S16,240.00 from maegan June 1: 02 grace. The invoice number was 20117 June 1: Check# 5001 was used to purchased office equipment costing S896.00 from Office Express 03 The invoice number was 87417. June 2: Check # 5002 was used to make a down payment of L32,000.00 on additional computer 04. equipment that was purchased from Royce Computers, invoice number 76542. The fiull price of the $160,000.00. A five-year note was executed by Byte for the balance computer was June 4: Additional office equipment costing $500.00 was 05 credit from Discount Computer purchased on Corporation. The invoice number was 98432. June 8: Unsatisfactory office equipment costing $100.00 from invoice number 98432 was returned to 06 Discount Computer for credit to be applied against the outstanding balance owed by Byte. June 10: Check # 5003 was used to make a $24,500.00 payment reducing the prinicpal owed on the 07. June 2 purchase of computer equipment from Royce Computers. 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 Worksheet For Period Ending September 28, 2019 Unadjusted Trial Balance Credit Balance Sheet Account Adjusting Entries Debit 0.00 Adjusted Trial Balance Debit Income Statement Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance Debit Credit Credit Debit Credit Debit Credit 68.691.00 2.300.00 68,691.00 68,691.00 0.00 0.00 68,691.00 0.00 2,300.00 0.00 5,750.00 5,304.00 0.00 0.00 0.00 221.00 5,304.00 7,200.00 0.00 3,600.00 7,200.00 1140 Prepaid Rent 38 0.00 20.00 0.00 249,680.00 es - 1211 Office Eoauip 1212 Accum. Depr-Office Equip 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip 1411 Building Cost 1412 Accum. Depr.-Building o 00 0.00 0.00 2,121.00 2.121.00 0.00 20.00 0.00 249,680.00 0.00 0.00 0.00 0.00 0.00 3,628.00 80,000.00 0.00 0.00 0,00 80,000.00 193.00 0.00 0.00 0.00 0.00 0.00 1510 Land 15,000.00 0.0C 0.00 15,000.00 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2,600.00 2.600.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,316.00 0.00 0.00 85 500 135 500 00 202.776.00 0.00 621.00 85,000.00 135 500 00 2202 Not Payable 3100 Hudson Bloom, Capital 3300 Hudson Bloom, With drawals 0 00 0.00 0 00 0.00 P 0 00 202.776.00 0.00 1,800.00 0.00 0.00 1.800.00 0.00 0.00 0.00 5,750.00 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 0.00 0.00 0 0C ,600.00 0.00 3,600.00 2,070.00 OC 621.00 0.00 2,070.00 2,070.00 0,00 6.325.00 6.325.00 0.00 0.00 6,325.00 1.165.00 940.00 381.00 1,165.00 1,165.00 0.00 0.00 0 00 381.00 0.00 940.00 0.00 0.00 940.00 0.00 0.00 0.00 0.00 0.00 0.00 1,316.00 1.316.00 0.00 0.00 221.00 0.00 221.00 3.841.00 0.00 0.00 0.00 3,841.00 Total INET INCOME Balance 15,730.00 436,901.00 436,901.00 432,701.00 15,730.00 432,701.00 1. Copy the account balances from the Adjusted Trial Balance into the either the Income Statement or the Balance Sheet columns, (debits remain debits and credits remain credits). 2. Calculate the Net Income or Net Loss by finding the difference between the revenues and expenses. 3. Calculate the Net Income or Net Loss by finding the difference between the total of the debit balances and the total of the credit balances of the accounts in the Balance Sheet columns of the worksheet 4. Compare the two Net Incomes. If they are the same the financial statements will be displayed, otherwise there is an error in the completion of the worksheet 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 Byte of Accounting maegan grace 8742 Transaction Description of transaction June 1: Hudson Bloom invested $161,336.00 cash and computer equipment with a fair market value of 01 $41,440.00 in his new business, Byte of Accounting Check # 5000 was used to purchased computer equipment costing S16,240.00 from maegan June 1: 02 grace. The invoice number was 20117 June 1: Check# 5001 was used to purchased office equipment costing S896.00 from Office Express 03 The invoice number was 87417. June 2: Check # 5002 was used to make a down payment of L32,000.00 on additional computer 04. equipment that was purchased from Royce Computers, invoice number 76542. The fiull price of the $160,000.00. A five-year note was executed by Byte for the balance computer was June 4: Additional office equipment costing $500.00 was 05 credit from Discount Computer purchased on Corporation. The invoice number was 98432. June 8: Unsatisfactory office equipment costing $100.00 from invoice number 98432 was returned to 06 Discount Computer for credit to be applied against the outstanding balance owed by Byte. June 10: Check # 5003 was used to make a $24,500.00 payment reducing the prinicpal owed on the 07. June 2 purchase of computer equipment from Royce Computers. 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 Worksheet For Period Ending September 28, 2019 Unadjusted Trial Balance Credit Balance Sheet Account Adjusting Entries Debit 0.00 Adjusted Trial Balance Debit Income Statement Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance Debit Credit Credit Debit Credit Debit Credit 68.691.00 2.300.00 68,691.00 68,691.00 0.00 0.00 68,691.00 0.00 2,300.00 0.00 5,750.00 5,304.00 0.00 0.00 0.00 221.00 5,304.00 7,200.00 0.00 3,600.00 7,200.00 1140 Prepaid Rent 38 0.00 20.00 0.00 249,680.00 es - 1211 Office Eoauip 1212 Accum. Depr-Office Equip 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip 1411 Building Cost 1412 Accum. Depr.-Building o 00 0.00 0.00 2,121.00 2.121.00 0.00 20.00 0.00 249,680.00 0.00 0.00 0.00 0.00 0.00 3,628.00 80,000.00 0.00 0.00 0,00 80,000.00 193.00 0.00 0.00 0.00 0.00 0.00 1510 Land 15,000.00 0.0C 0.00 15,000.00 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2,600.00 2.600.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,316.00 0.00 0.00 85 500 135 500 00 202.776.00 0.00 621.00 85,000.00 135 500 00 2202 Not Payable 3100 Hudson Bloom, Capital 3300 Hudson Bloom, With drawals 0 00 0.00 0 00 0.00 P 0 00 202.776.00 0.00 1,800.00 0.00 0.00 1.800.00 0.00 0.00 0.00 5,750.00 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 0.00 0.00 0 0C ,600.00 0.00 3,600.00 2,070.00 OC 621.00 0.00 2,070.00 2,070.00 0,00 6.325.00 6.325.00 0.00 0.00 6,325.00 1.165.00 940.00 381.00 1,165.00 1,165.00 0.00 0.00 0 00 381.00 0.00 940.00 0.00 0.00 940.00 0.00 0.00 0.00 0.00 0.00 0.00 1,316.00 1.316.00 0.00 0.00 221.00 0.00 221.00 3.841.00 0.00 0.00 0.00 3,841.00 Total INET INCOME Balance 15,730.00 436,901.00 436,901.00 432,701.00 15,730.00 432,701.00 1. Copy the account balances from the Adjusted Trial Balance into the either the Income Statement or the Balance Sheet columns, (debits remain debits and credits remain credits). 2. Calculate the Net Income or Net Loss by finding the difference between the revenues and expenses. 3. Calculate the Net Income or Net Loss by finding the difference between the total of the debit balances and the total of the credit balances of the accounts in the Balance Sheet columns of the worksheet 4. Compare the two Net Incomes. If they are the same the financial statements will be displayed, otherwise there is an error in the completion of the worksheet 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