#1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xlsx". Use the following accounts as appropriate: Cash, Accounts Receivable, Supplies, Prepaid Insurance, Equipment, Accumulated Depreciation, Accounts Payable, Wages Payable, Common Stock, Retained Earnings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense.
Pics of all required steps #1-#10 will be pictured below in the last 3 photos at bottom. Photos of Excel Template forms are also below
****I need help with all answers and Excel spreadsheet. THANK U!
***CAN VENMO OR PAYPAL***
Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Upda X v fx 122 General Journal Description Date Debit $ 10,000 Credit Dec. 1 Cash Common Stock $ 10,000 General Journal T-Accounts Unadjusted Trial Balance Adjusted Trial Balance Ready Paste Format T B A ' 2 2 Merge & Center $ % ) 288 Conditional Format Formatting as Table Cel Styles insert Delete Format Office Update To keep up to date with security updates, fixes, and improvements, choose Check for Updates P19 XVfx L M N O P Common Stock Account Receivables Retained Earnings General Journal Accounts adjusted Trial Balance Adjusted Trial Balance Financial Statements + * Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates x & fx CoE F Unadjusted Trial Balance Accounts Debit 6 Cash 7 Accounts Receivables 8 Supplies 9 Prepaid Insurance 10 Equipment 11 Accumulated Depreciation 12 Accounts Payable 13 Wages Payable 14 Common Stock 15 Retained Earnings 16 Dividends 17 Service Revenue 18 Rent Expense 19 Wages Expense 20 Insurance Expense 21 Supplies Expense 22 Depreciation Expense 23 Totals General Journal T-Accounts Unadjusted Trial Balance Adjusted Trial Balance Ready Paste B TU Format & Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Upc B6 x & fx F G H Adjusted Trial Balance Debit Credit 6 Cash 7 Accounts Receivables 8 Supplies 9 Prepaid Insurance 10 Equipment 11 Accumulated Depreciation 12 Accounts Payable 13 Wages Payable 14 Common Stock 15 Retained Earnings 16 Dividends 17 Service Revenue 18 Rent Expense 19 Wages Expense 20 Insurance Expense 21 Supplies Expense 22 Depreciation Expense 23 Totals General Journal T-Accounts Unadjusted Trial Balance Adjusted Trial Balance Ready ock for updates For Income Statement month Ended December 31, 20XX Statement of Stockholde Equity For the month Ended December 31, 20XX Cewed Balance Sheet A December 20XX General Journal Accounts h austed Trial Balance Adjusted Balance Question Completion Status: 31-Dec Der Wages incurred from December 29 to December 31 but not yet paid or recorded total $510. 6 Post all of the adjusting entries to the T-accounts under the "T-Accounts tab. Compute the balance for each T-account after all of the adjusting entries have been posted. These are the adjusted balance as of December 31. #7. Prepare the adjusted trial balance under the "Adjusted Trial Balance" tab as of December 31 in the excel template file "Accounting Cycle Excel Template.xlsx. Provide the following accounts balances from the Adjusted Trial Balance: Cash Accounts Receivable Supplies Prepaid Insurance Equipment Accumulated Depreciation Accounts Payable Wages Payable Common Stock Retained Earnings Prepare Income Statement, Statement of Stockholder's Equity, and Classified Balance Sheet under the Financial Statements" tab for the month ended December 31, 20xx in the excel template file "Accounting Cycle Excel Template.xlsx Provide the following amount from the Income Statement Service Revenue Depreciation Expense Wages Expense Supplies Expense Chick Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers Save and Submit Question Completion Status: Supplies Expense Rent Expense Insurance Expense Net Income Provide the following account balance from the Statement of Stockholders' Equity Dividends Provide the following account balances from the Balance Sheet: Current Assets Long-Term Assets Total Liabilities Total Stockholder's Equity Cash 19. Record the closing entries under the "General Journal tab. #10 Post all of the closing entries to the T-accounts under the "T-Accounts" tab. Compute the balance for each T-account after all of the closing entries have been posted. Provide the ending balance of Cash at December 31 from the T-accoun Provide the balance of the Retained Earnings T-account after closing entries have been posted. Does the ending balance of the Retained Earnings T-account agree with the balance of Retained Earnings on the Balance Sheet? Check Point: Total Assets $ 20,300.00 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save Al Answers Save and Submit M N O P General Journal Accounts Unadjusted Trial Balance Adjusted Trial Balance Financial Statements - Ready