Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

can i please get help with 5-8 please image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management And Cost Accounting

Authors: Colin Drury

9th Edition

1408093936, 978-1408093931

More Books

Students also viewed these Accounting questions

Question

What is meant by a green or sustainable strategy?

Answered: 1 week ago