50.1K

Verified Solution

Link Copied!

Please can someone help me with the part 2 on this excel format, i need it asap

Chart of Accounts $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ Part Two Instructions Before you prepare the eight adjusting joumal entries below in an Excel spreadisheet, please make sure corrections have been made to any of the previous joumal entries in part one. The following are the Gdiusting iournal entries for the month of January. Record all adjusting entries as of January 31, 2023. Record Adjusting Entries: Record the following month end adjusting entries for the month of January. Write the journal entries in the practice set atter the original journal entries. Round all answers to the nearest cent. a. $70 of office supplies remained on hand. b. $200 of shipping supplies remained on hand. c. $1,300 of wages for the part-time help from lrene's Temp Services for January should be accrued. Do not worry about payroll taxes: Temp Services inc. will handle these. d. Make the necessary adjusting entries for one month's depreciation for the Computer Equipment using Straight Line Depreciation. e. Make the necessary adjusting entry for one month's depreciation for the furniture and fixtures using Straight Line Depreciation. f. One month of the prepaid insurance has expired. g. One month of the prepaid rent has expired. h. Record the interest for the loan from Wells Fargo for one month. Make sure you prepare the adjusting entries and write them in the template for the adjusting entries. Follow the same instructions for the adjusting journal entries that you did in part one. Once the adjusting entries have been completed in the spreadsheet use the spreadsheet to answer the questions in Blackboard then upload the spreadsheet to Blackboard. Follow these instructions. Step 1: Enter the adjusting journal entries in an Excel spreadsheet and print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder n the corresponding week. itep 3: Once you complete entering information into Blackboard upload the spreadsheet into lackboard. 'Do not enter the information highlighted in vellow into BB, Some transactions will have more then one debit or eredit so enter the smallest account first. Do not enter the transaction H in BE: Use with or without grithines. Chart of Accounts $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ $$\text{Unknown environment 'tabular'}$$ Part Two Instructions Before you prepare the eight adjusting joumal entries below in an Excel spreadisheet, please make sure corrections have been made to any of the previous joumal entries in part one. The following are the Gdiusting iournal entries for the month of January. Record all adjusting entries as of January 31, 2023. Record Adjusting Entries: Record the following month end adjusting entries for the month of January. Write the journal entries in the practice set atter the original journal entries. Round all answers to the nearest cent. a. $70 of office supplies remained on hand. b. $200 of shipping supplies remained on hand. c. $1,300 of wages for the part-time help from lrene's Temp Services for January should be accrued. Do not worry about payroll taxes: Temp Services inc. will handle these. d. Make the necessary adjusting entries for one month's depreciation for the Computer Equipment using Straight Line Depreciation. e. Make the necessary adjusting entry for one month's depreciation for the furniture and fixtures using Straight Line Depreciation. f. One month of the prepaid insurance has expired. g. One month of the prepaid rent has expired. h. Record the interest for the loan from Wells Fargo for one month. Make sure you prepare the adjusting entries and write them in the template for the adjusting entries. Follow the same instructions for the adjusting journal entries that you did in part one. Once the adjusting entries have been completed in the spreadsheet use the spreadsheet to answer the questions in Blackboard then upload the spreadsheet to Blackboard. Follow these instructions. Step 1: Enter the adjusting journal entries in an Excel spreadsheet and print it out. Step 2: Use the Excel spreadsheet to answer the questions in Blackboard in the content folder n the corresponding week. itep 3: Once you complete entering information into Blackboard upload the spreadsheet into lackboard. 'Do not enter the information highlighted in vellow into BB, Some transactions will have more then one debit or eredit so enter the smallest account first. Do not enter the transaction H in BE: Use with or without grithines

Answer & Explanation Solved by verified expert

See Answer