80.2K

Verified Solution

Link Copied!

can i please get help with 5-8 please

1: Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Template.xisx:" Use the following accounts as appropriate: Post all of the transactions from the "General Journal" tab to the T-accounts under the "T- 2: Accounts/General Ledger" tab in the excel template file "Accounting Cycle Excel Template xlsx: Assume there are no beginning balances in any of the accounts. 3: Compute the unadjusted balance for each T-account after all of the December entries have been p: 4: Prepare the unadjusted trial balance on the "Unadjusted Trial Balance" tab. rovide the total of the credit column from the Unadjusted Trial Balance 4 15: Record the December adjusting entries on the "General Journal" tab. Dec. 31: One month insurance has been used. Dec 31: Supplies remaining at the end of the month total $90. Dec 31: The estimated depreciation on equipment is $70. Dec 31: Salaries incurred from December 29 to December 31 but not yet paid or recorded tot: Post all of the adjusting entries to the T-accounts under the "T-Accounts/General Ledger" tab. Co balance for each T-account after all of the adjusting entries have been posted. Prepare the adjusted trial balance under the "Adjusted Trial Balance" tab as of December 31 in th "Accounting Cycle Excel Template.xdsx". * point 1: Adjusted trial balance total debit/credit =$20,390 Step 5: Record the December adjusting entries on the "General Journal" tab. Dec 31: One month insurance has been used. Dec 31: Supplies remaining at the end of the month total $90. Dec 31: The estimated depreciation on equipment is $70. Dec 31: Salaries incurred from December 29 to December 31 but not yet paid or recorded total $480. Check point 1: Adjusted trial balance total debit/credit =$20,390 Provide the following amounts from the Adjusted Trial Balance: (Be sure to enter all numbers as positive and no answers should be left blank.) 2 - Cash 3 - Accounts Receivable 8 - Accumulated Depreciation Prepare Income Statement, Statement of Stockholder's Equity, and Classified Step Balance Sheet under the "Financial Statements" tab for the month ended 8: December 31, 20XX in the excel template file "Accounting Cycle Excel Template. xsx

Answer & Explanation Solved by verified expert

See Answer