B C D Student's Name: 1 E Version B Your Name Here Directions F G H Use this Excel template file (see tabs) to complete the required accounting activities and rename it to begin with your last name (i.e. Doe Jane ACC 120 Case #2). 2 Journalize each adjusting entry on page 3 of your journal. (Do not complete PR) 3 Post adjusting entries to Ledger (Do not complete PR-post reference) 4 Prepare an Adjusted Trial Balance. 5 Prepare financial statements for the month of November. Income Statement Statement of Owner's Equity Balance Sheet Notes/Tips: There were no investments by owner during the reporting period. This company prepares an Adjusted Trial Balance and Financial Statements at the end of each month. All adjustments are for the last 30 days. (Effective date Nov 30) Print the completed journal before you post to the ledger and completed ledger before you prepare the ATB. May help avoid errors. Fern Landscaping Company Unadjusted Trial Balance Directions Journal Ledger Adjusted Trial Balance Financial Statements 1 X B C D E Directions F G H Use this Excel template file (see tabs) to complete the required accounting activities and rename it to begin with your last name (i.e. Doe Jane ACC 120 Case #2). 2 Journalize each adjusting entry on page 3 of your journal. (Do not complete PR) 3 Post adjusting entries to Ledger (Do not complete PR-post reference) 4 Prepare an Adjusted Trial Balance. 5 Prepare financial statements for the month of November. Income Statement Statement of Owner's Equity Balance Sheet Notes/Tips: There were no investments by owner during the reporting period. This company prepares an Adjusted Trial Balance and Financial Statements at the end of each month. All adjustments are for the last 30 days. (Effective date Nov 30) Print the completed journal before you post to the ledger and completed ledger before you prepare the ATB. May help avoid errors. Fern Landscaping Company Unadjusted Trial Balance November 30, 2020 Account 110 Cash Directions Journal Ledger Debit Credit 40.860 Adjusted Trial Balance Financial Statements Home Insert Page Layout Formulas Data Review View Developer Help ROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. BC D E F G H Fern Landscaping Company Unadjusted Trial Balance November 30, 2020 Account Debit Credit 110 Cash 120 Accounts Receivable 40,860 6,550 130 Supplies 2,100 140 Prepaid Insurance 1,200 150 Land 100,000 160 Building 75,000 161 Accumulated Depreciation - Building 170 Landscaping Equipment 10,500 171 Accumulated Depreciation - Landscaping Equipment 210 Accounts Payable 29,200 220 Unearned Landscaping Revenue 30,000 230 Wages Payable 310 J. Doe, Capital 320 J. Doe, Drawings 410 Landscaping Revenue 510 Wages Exp 520 Rent Exp 530 Depreciation Exp-Building 540 Depreciation Exp-Landscaping Equipment 550 Utilities Exp 560 Supplies Expense 570 Insurance Expense 580 Misc. Exp 168,550 3,500 23,100 4,800 3,000 2,240 Total 1,100 250,850 250,850 Directions Journal Ledger Adjusted Trial Balance Financial Statements Enabl