Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

byte of accounting worksheet income balanaces are off all items 1-34 are correct not sure why balances are off on worksheet ... please help :)

byte of accounting worksheet income balanaces are off
all items 1-34 are correct not sure why balances are off on worksheet ... please help :)
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Byte of Accounting Jaclyn Nelson 3444 Transaction Description of transaction June-1:-Hudson Bloom invested $125,718.00 cash and computer equipment with a fair market value of 01 $35,650.00 in his new business, Byte of Accounting. Check # 5000 was used to purchased office equipment costing $598.00 from Office Express. June 1: 02 The invoice number was 87417. Check # 5001 was used to purchased computer equipment costing $10,120.00 fsom Jaclyn June 1: 03. Nelson. The invoice number was 20117. June 2: Check # 5002 was used to make a down payment of $32,000.00 on additional computer 04. equipment that was purchased from Rovce Computers, invoice number 76542. The full price of the computer was $160,000.00 A five-year note was executed by Byte for the balance. June 4: Additional office equipment costing $500.00 was purchased on credit from Discount Computer 05. 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 June 07. 2 purchase of computer equipment from Royce Computers. June 14: Check # 5004 was used to purchase a one-year insurance policy covering its computer 08. equipment for $5,640.00 from Seth's Insurance. The effective date of the policy was June 16 and the invoice number was 2387. 09. June 16: A check in the amount of $6,000.00 was received for services performed for Pitman Pictures June 16: Byte purchased a building and the land it is on for $95,000.00 to house its repair facilities and 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 an inital payement due on August 1st, was established for the balance. 11, June 17: Check # 5006 for $4,800.00 was paid for rent of the office space for June, July and August. June 17: Received invoice number 26354 in the amount of $275.00 from the local newspaper for 12 advertising. 13. June 21: Billed various miscellaneous local customers $4,400.00 for consulting services performed June 21: Check # 5008 was used to purchase a fax machine for the office from Office Machines Express 14. for $800.00, The invoice number was 975-328. 15. June 21: Accounts payable in the amount of $400.00 were paid with Check # 5007. 16. June 22: Check # 5010 was used to pay the advertising bill that was received on June 17. June 22: Received a bill for $1.215.00 from Computer Parts and Repair Co. for repairs to the computer 17, equipment. The invoice number was 43254. June 22: Check # 5009 was used to pay salaries of $835.00 to equipment operators for the week ending 18. June 18.) Ignore payroll taxes. 19. June 23: Cash in the amount of $3.525.00 was received on billings. June 23: Purchased office supplies for $505.00 from Staples on account. The invoice number was 20. 65498 21. June 28:(Billed $5,385,.00 to miscellaneous customers for services performed to June 25. 22. June 29: Cash in the amount of $5.101.00 was received for billings. 23. June 29: Paid the bill received on June 22, from Computer Parts and Repairs Co with Check # 5011. June 29: Check # 5012 was used to pay salaries of $835.00 to equipment operators for the week ending 24 June 25. Ignore payroll taxes. June 30: Received a bill for the amount of $915,00 from O & G Oil and Gas Co. The invoice number was 784537 June 30: Check # 5013 was used to pay for airline tickets of $1,600.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 $202.00 worth of office supplies remained on hand as of June 30. The annual interest rate on the mortgage payable 29. should be computed because the building and land were purchased and the liability incurred on June 16, was 7.25 percent. Interest expense for one-half month 30. Record a iournal entry to reflect that one half month's insurance has exnired. A review of Byte's job worksheets show that there are unbilled revenues in the amount of $9,000 for the 31 period of June 28-30. Col The fixed assets have estimated useful lives as follows: Building-31.5 years Computer Equipment -5.0 years 32. Office Equipment - 7.0 years 500 Use the straight-line method of depreciation. Management has decided that assets purchased during month are treated as if purchased on the first day of the month. The building's scrap value is $8,000. The office equipment has a serap value of $500. The computer equipment has no scrap value. Calculate the depreciation for one month. i.o00 a A review of the payroll records show that unpaid salaries in the amount of $501.00 are owed by Byte for 33. 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. ate of 12 percent annually. Interest expense should be computed based on a 360 day year. Closing Entries 35. Close the rever enue accounts. 36. Close the expense accounts. 37. Close the income summary account. 38. Close the withdrawals account. BA& AG/ A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2019 Adiusting Entries Adjusted Trial Balance Debit 47.226.00 10.159.00 5,405.00 3.200.00 Income Statement Credt Unadjusted Trial Balance Credit 0.00 Balance Sheet Debit 47.226 00 10,159.00 5,405.00 3,200.00 202.00 1,798.00 Account Debit Credit Debit 0.00 9,000.00 Debit umber Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip. 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip. 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Hudson Bloom, Capital 3300 Hudson Bloom, Withdrawals Credit 0.00 0.00 Credit 47.226.00 1,159.00 5.640.00 4.800.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 235.00 1,600.00 303.00 0.00 0.00 0.00 505.00 202.00 1.798.00 1,798.00 0.00 205.770.00 0.00 80,000.00 0.00 15.000.00 0.00 0.00 0.00 0.00 15.45 0.00 15.45 15.45 205,770.00 205.770.00 0.00 0.00 0.00 0.00 0.00 0.00 3.429.50 0.00 3.429 50 3.429.50 0.00 0.00 0.00 0.00 1420 00 80,000.00 80,000 00 190.48 190.48 190.48 15,000.00 0.00 0.00 0.00 15.000.00 0.00 1,420.00 1,420.00 0.00 0.00 0.00 0.00 85.500.00 103.500.00 161.368.00 0.00 1.289.61 1,289.61 501.00 85 500 00 103.500.00 161.368.00 0.00 1,289.61 501.00 0.00 501.00 0.00 0.00 0.00 0.00 0.00 0.00 85.500.00 103.500.00 161.368.00 0.00 0.00 0.00 0.00 0.00 1.600.00 1,600.00 0.0 1,600.00 24,785.00 24,785.00 24,785.00 9,000.00 15,785.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 4100 Computer & Consulting Revenue 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 O & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense 0.00 0.00 0.00 1,670.00 275.00 1.215.00 915.00 0.00 0.00 1,600 00 2.171.00 275.00 1,215.00 915.00 303.00 1,289.61 235.00 3.635.43 1.600.00 2.171.00 275.00 1,215.00 915.00 303.00 1,289.61 235.00 3,635 43 1,600 00 501.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 303.00 1.289.61 235.00 3,635.43 0.00 0.00 0.00 0.00 0.00 370,360.00 381,090.04 11.639.04 381.997.93 24.785.00 16.564 04 381.999.04 367,573.00 367.573.00 16,564.04 Total NET INCOME Balance A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. Transaction Date Name Description Credit 01 01 01 Jun 01 Jun 01 Jun 01 1110 Cash 1311 Computer Equip. 3100 Hudson Bloom, Capital lowner investment owner investment owner investment 125.718 00 35.650 00 161.368.00 02 Jun 01 Jun 01 1211 Office Equip. 1110 Cash purchased offfice equip. with check ! purchased offfice equip. with check 5000 598.00 02 598.00 03 Jun 01 Jun 01 1311 Computer Equip 1110 Cash purchased computer equip. check 50 purchased computer equip. check 5001 10.120.00 03 10,120.00 Jun 02 04 1311 Computer Equip. 1110 Cash 2202 Notes Payable purchased computer equip. check 5 160,000.00 purchased computer equip. check 5002 purchased computer equip. check 5002 04 Jun 02 32.000.00 128,000.00 04 Jun 02 05 05 Jun 04 Jun 04 1211 Office Equip. 2101 Accounts Payable office equip discount computer office equip discount computer 500.00 500.00 2101 Accounts Payable 1211 Office Equip. Jun 08 06 office equip returned office equip returned 100.00 06 Jun 08 100.00 07 Jun 10 Jun 10 2202 Notes Payable 1110 Cash payment office equip Chk 5003 payment office equip Chk 5003 24,500.00 07 24,500.00 1130 Prepaid Insurance 1110 Cash 08 Jun 14 purchased 1 year computer insurand purchased 1 year computer insurance check5004. 5,640.00 08 Jun 14 5,640.00 Jun 16 1110 Cash 4100 Computer & Consulting (check received pitman pictures 09 check received pitman pictures 6,000.00 09 Jun 16 6,000.00 1411 Building 1510 Land 1110 Cash 2201 Mortgage Payable 10 10 Jun 16 Jun 16 purchased building for storage chec purchased building for storage check purchased building for storage check 5005 purchased building for storage check 5005 80,000.00 15.000.00 Jun 16 Jun 16 10 9,500.00 85,500.00 10 1140 Prepaid Rent 1110 Cash 11 11 Irent paid check 5006 rent paid check 5006 Jun 17 4,800.00 Jun 17 4,800.00 RR Note: You can only enter data into the yellow filled cells Transaction Date Account Name Description Credit Debit 12 Jun 17 Jun 17 5030 Advertising Expense 2101 Accounts Payable Local newspaper ad Local newspaper ad 275.00 275.00 13 13 Jun 21 Jun 21 1120 Accounts Receivable 4100 Computer & Consulting (billed billed 4,400.00 4,400.00 14 Jun 21 1211 Office Equip. purchased fax machine chk5008 purchased fax machine chk5008 14 Jun 21 800.00 1110 Cash 800.00 15 Jun 21 Jun 21 2101 Accounts Payable 1110 Cash paid acct payable chk 5007 paid acct payable chk 5007 15 400.00 400.00 16 16 Jun 22 2101 Accounts Payable 1110 Cash paid newpaper ad chk 5010 Jun 22 275.00 paid newpaper ad chk 5010 275.00 Jun 22 Jun 22 17 5040 Repairs&Maint. Expensrepairs computer equip 2101 Accounts Payable 1.215.00 17 repairs computer equip 1,215.00 Jun 22 Jun 22 5020 Salary Expense 18 18 equip operators week ending 6/18 p equip operators week ending 6/18 paid chk 5009 835.00 1110 Cash 835.00 19 Jun 23 1110 Cash 1120 Accounts Receivable 3525.00 received from debitor cash 3525.00 received from debitor cash 19 3,525.00 Jun 23 3,525.00 Jun 23 Jun 23 20 20 1150 Office Supplies 2101 Accounts Payable puchsed ofice supplies staples acct puchsed ofice supplies staples acct 505.00 505.00 21 21 Jun 28 Jun 28 1120 Accounts Receivable 4100 Computer & Consulting (billed customers billed customers 5,385.00 5,385.00 122 | A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. Account 1110 Cash 1120 Accounts Receivable Date Jun 29 Jun 29 Debit 5,101.00 Transaction Name Description cash received for billing cash received for billing 22 22 5,101.00 23 Jun 29 Jun 29 2101 Accounts Payable paid bill for computer repairs chk 501 paid bill for computer repairs chk 5011 1,215.00 23 1110 Cash 1,215.00 24 24 Jun 29 5020 Salary Expense 1110 Cash Jequip operators week ending 6/25 p equip operators week ending 6/25 paid chk 5012 835.00 Jun 29 835.00 25 25 Jun 30 5050 Oil & Gas Expense 2101 Accounts Payable ol and gas bill oil and gas bill 915.00 Jun 30 915.00 26 Jun 30 3300 Hudson Bloom, Withdravairline tickets for kids chk 5013 1110 Cash 1,600.00 26 Jun 30 airline tickets for kids chk 5013 1,600.00 27 27 Jun 30 Jun 30 5010 Rent Expense 1140 Prepaid Rent one month rent expense one month rent expense 1,600.00 1,600.00 28 Jun 30 Jun 30 5080 Supplies Expense 1150 Office Supplies supplies used supplies used 28 303.00 303.00 Jun 30 Jun 30 5090 Interest Expense 2103 Interest Payable 29 inccured intrest expense inccured intrest expense 258.28 29 258.28 Jun 30 Jun 30 5100 Insurance Expense 1130 Prepaid Insurance 30 30 insurance expense inccured insurance expense inccured 235.00 235.00 1120 Accounts Receivable 4100 Computer & Consulting funbilld fees Jun 30 Jun 30 31 31 unbilld fees 9,000.00 9,000.00 5110 Depreciation Expense depriciation expense one month 1212 Accum. Depr.-Office Equdepriciation expense one month 1312 Accum. Depr.-Computer depriciation expense one month Jun 30 Jun 30 Jun 30 32 32 32 3,635.43 15.45 3.429.50 4pedo A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. T 32 Description 1412 Accum. Depr.-Building depriciation expense one month Name Debit Jun 30 190.48 33 Jun 30 Jun 30 5020 Salary Expense 2105 Salaries Payable uppaid salaries uppaid salaries 501.00 33 501.00 34 Jun 30 Jun 30 5090 Interest Expense 2103 Interest Payable 1,031.33 intrest is due 34 1,031.33 intrest is due 35 Jun 30 Jun 30 4100 Computer & Consulting[transfer of revenue 3400 Income Summary 24,785.00 35 transfer of revenue 24,785.00 36 3400 Income Summary 5010 Rent Expense 5020 Salary Expense 5030 Advertising Expense 5040 Repairs &Maint. Expenstransfer of expenses 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense Jun 30 transfer of expenses transfer of expenses transfer of expenses transfer of expenses 11,639.04 36 36 Jun 30 Jun 30 1,600.00 2,171.00 275.00 1,215.00 915.00 36 Jun 30 36 Jun 30 36 Jun 30 Jun 30 Jun 30 transfer of expenses transfer of expenses transfer of expenses transfer of expens transfer of expenses 36 303.00 1,269.61 36 36 Jun 30 Jun 30 235.00 3,635.43 36 Jun 30 Jun 30 3400 Income Summary 3100 Hudson Bloom, Capital transfer of income to capital 37 transfer of income to capital ### 37 Jun 30 Jun 30 3100 Hudson Bloom, Capital 3300 Hudson Bloom, Withdra Need a Description 38 1,600.00 38 1,600.00 nsaction unoa

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Research

Authors: David A. Aaker, V. Kumar , George S. Day

8th Edition

047123057X, 9780471230571

More Books

Students also viewed these Accounting questions

Question

=+3. What are the components of a social media communication audit?

Answered: 1 week ago