Step Preporujouma enoles to record the December transactions in the General Joumal Tot in the col te Accounting Orde Excel Temu Use the following account as propre Cath Accounts Rece Supplies Prepaid sunce Event Accurred Deprecation Accounts Payable Deferred Revenue Saree Notes Payable Common Stock Rand Caring Divine Service Revenue Depreciation Experte Solaris per Suportes per Hart insurance pense Dec we common Mock exchange for cash 1.000 1-Dec Paid the premium in Vance on one year ce poly 1-00 Purchased Eventor 1.200 cash. S-D Purchase office supplies from XYZ Company on 100 15-De Provided services to customers for $8.600 cash 16 Dec Provided services to customer ABCine on scout $7.300 17.DOC Received $2.400 cash in advance to a customer for services to be provided in January 22-Dec Paid 5230 to XYZ company for the Dec purchase an account 23 Dec Received $3.100 cash from customer, ABC, on account 25-Dec Paid the rent for the current mon1.300 28-Dec Paid lines to employees for work performed From December 1 South December 21, 54200 29-Dec Declared and paid dividends to stockholders $550 30-Dec Purchased land by signing 3 year rote payable for $12.000 Step 2 Postal of the December transaction from the General Journabab toe Taccounts under the General Ledget-Accounts to the excel template file "Accounting Cycle Excel Templatex Adsure there are no beginning toes in any of the account Step 2 Post all of the December transactions from the "General Journal' tab to the T-accounts under the General Ledger Acosta in excel template file "Accounting Cycle Excel Template.xix Assume there are no beginning balances in any of the accounts Step 3: Compute the balance for each T-account after all of the entries have been posted Step 4: 1 Prepare the uradjusted trial balance on the "Unadjusted Trial Balance" tab. Provide the total of the credit column from the Unadjusted Trial Balance Record the December adjusting entries on the General Joumar tot Step 5 31-Dec 31-Dec One month's insurance has expired $80 The remaining inventory of unused office supplies is $90. The estimated depreciation on equipment is $70. Salaries incurred from December 29 to December 31 but not yet paid or recorded tobal $450 31-Dec 31-Dec Step 6. Post all of the adjusting entries to the Taccounts on the T-Accounts" tab Compute the balance for each T-account other all of the adjusting entries have been posted. Prepare the adjusted trial balance on the "Adjusted Trial Balance" tab. Check point 1 Adjusted trial balance total debit/credit $ 39,990 Step 7 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answer should be left blank.) Cash 2 3 Accounts Receivable 4 Supplies Step 7: Prepare the adjusted trial balance on the Adjusted Trial Balance tab Check point Adjusted til balance total debit credit $39.900 Provide the following amounts from the Adjusted Trial Balance (Be sure to enter all numbers as positive and no answer should be blank) Cash 2 3 Accounts Receivable 4 Supplies 5 Prepaid Insurance 6 Equipment Land 7 8 Accumulated Depreciation Accounts Payable Deferred Revenue Salaries Payable 10 11 12 Notes Payable Common Stock 13 14 Retained Eamings Prepare the Income Statement, Statement of Stockholder's Equity and Classified Balance sheet on the Financial Statements" tab for the month ended December 31, 20XX Step 8 Provide the following amount from the Income Statement: (Be sure to enter all numbers as positive and no answer should be left Wank.) Step 3: Prepare the Income Statement, Statement of Stockholder's Equity and Classified Balance Sheet on the Financial Statements" tab for the month ended December 31, 20XX Provide the following amount from the Income Statement: (Be sure to enter all numbers as positive and no answer should be left blank.) 15 Service Revenue 16 17 18 Depreciation Expense Salaries Expense Supplies Expense Rent Expense Insurance Expense 19 20 21 Net Income Provide the following account balances from the Balance Sheet(Be sure to enter all numbers as positive and no answer should be left blank.) 22 Current Assets 23 Long-Term Assets 24 Current Liabilities 25 LongTerm Liablites Total Liabilities 28 27 Total Stockholder's Equity Provide the following account balance from the Statement of stockholders' Equity: (Be sure to enter all numbers as positive and no answer should be left blank) 28 Dividends 29 Long 26 Total 27 Total Story Provide the following count balance from Statement of stockholders te bere we should be leak) 20 Dividends Record te keting entries on the real you are Post of the door tries to accounts on the moon Complete rencontre account for all the dengti have been poed Pre ne posting balance of the mornard Center 3.2004 on the Post Our Bence to 20 Provide the total of the boom from the Post Coang Trance de Provide the box of the Retained account afer eingeries have be posted Slap Step 10 Step 11 Check out 2 Total Assets QUESTION 2 Sport 3: Does the ending balance of the Retained in court with the balance of Retained Eamings on the Balance Sheet
