Your help is more than appreciated!
Prepare journal entries to record the Docember transactions in the General Joumal Tab in the excel template fle "Accounting Cycle Excel Tomplate x dexc. Use the folowing accounts as appropriate: Sinp 2. Post all of the Decomber transactions from the "Gonerai Joumal" tab to the T-accourits under the "General Ledger/T-Accounts" tab in the excel Stop 3: Compule the balanoe for each T-nocount atior all of the entries have been posted. Stop 4: Prepare the unadjusted trial balance on the "Unadjusted Trial Balance" tab. 1 Provide the total of the credit column from the Unadussed Trial Balance Stop 5: Record the December adjusting entries on the "General Jouma" tab. 31-Dec One month's insurance has expired $110. 31-Dec The remaining iventory of unused offce supplies is $90. 31-Dec The estimated depreciation on equipment is $70. 31-Dec Salaries incurred from December 20 to December 31 but not yot paid or recorded total $540. Step 6: Post all of the acfusting entries to the Tatecounts on the "T-Accounte" tab. Compute the balance for each T-account after all of the acjusting entries have been posted. Prepare the adusted trial balance on the "Adjusted Trial Belunon" tab. Cheok point 1: Adjusled trial bolance total debiticredit = 35,380 Provide the following amounts from the Adjusted Trlal Balance: (Be sure to enter all numbers as positive and no anwwer should be left blank.) Prepare the Incorne Statement, Statement of Siockholder's Equity and Classifod Balince Sheet an the "Financial Staternonis" tab for the month ended Docember 31,20x. Previde the following amount from the Income Statement: (Be sure to enter all numbers as positive and no answsr should be left blank) Provide the following aceount balances from the Balance Sheot (Be sure to enter all numbers as positive and no answer should be lift blank-) Provide the following acceunt balance from the Statement of atoekholders' Equity: (Rife sure to enter all numbers as pesative and ne) answer should be left biank.) 28 Divisenes Reverd the tiosing entries on the "Cenerie Joumal" tab Provide the following account balance from the Statement of stoekhelders' Equity: (Be sure to enter all numbers as positive and no answer should be left blank.) 28. Dividends Record the closing entries on the "Cennral Joumal" tab. Post at of the ciesing entries to the Taocounts on the "T-Accounts" tak. Compute the balance for each T-ascount affer all of the dosing entries have been posted. Prepare the post closing trial balance for the month anded Decernber 31, 20x0x on the Post-Ciosing Triel Balanoe tab. 29 Provide the total of the debt column from the Post Closing Tris Balance 30 Provide the balahce of the Retained Faminge T.acoount atec closing ervities have beon pontedi Check Point 2 Total Assets 5,27,640 ESTION 2 31. Does the ending balance of the Retained Earnings t-acoount agree with the balance: of Retained Farnings on the Balance Sree 1
