Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

#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

#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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Question Completion Status Prepare journal entries to record the December transactions in the General journal in the excel template "Accounting CydleExcel De Templates. Use the following accounts as appropriate: Cash Accounts Receivable Supplies Prepaid insurance Equipment, Accumulated Depreciation Accounts Payable. Wapes Payable, Common Stock, Retained Earnings Dividends, Service Revenue Depreciation Expense, Wages Expense Supplies Expense, Rent Expense and insurance Expense 1- Begin business by depositing $10000 a bank account theme of the company in exchange for 1000 shares of $10 per share common stock 1-Dec Paid the rent for the current month $1400 1-Dec Pald the premium on a one year insurance policy. 51200 De Purchased Equipment for 3500 cash Purchase of succes from XY Company on account S-Dec 15 Dec Provided services to customers for 1000 cash. 16-Dec Provided service to customers ABC in on account, 57900 21-Del Received 53300 cash from ABC Inc., customer on account 23. Pad 51700 XYZ.company for supplies purchased on account on 28 December 28 DePad wages for the period December through Dec 1750 30-Det bedared and dividend to stockholders 1200 Postal of the December transactions from the General journal tab to the accounts under the 'T Accounts tab in the excel template file "Accounting Cydeclame Assume there are no beginning balances in any of the accounts. 13. Compute the balance for each account of the trave been posted. These are the adjusted balances of December c e in the wel template file "Accounting Cycle Excel 4. Prepare the unadjusted tw balance under the United Tra Templates Provide the of the credit cum from the United Trial 5. Record the following for ons gered e neral Journal 31. One month insurance has been used by the company 31-Det The remaining inventory of unused supplies is 590 31 The estima t ion on event is 160 Wages are become pad or recorded Chand Subove and suche Se Allt alans . - - s 16 S 1 WERTYUIOP SPAGHOKOAG H M Local 510. 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. 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 fle Accounting Cycle Excel Template.xlsx Provide the following amount from the income Statement: Service Revenue Depreciation Expense Wages Expense Supplies Expense submit Clicks Click Save and submit to All An Save Alwers towall ans Save and 858 / 3 / 4 / T ISTO11 o DEOPOK t in Completion Status: Service Revenue Depreciation Expense Wages Expense 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 Liabetes Total Stockholder's Equity Cash 19. Record the closing entries under the "General Journalta Post all of the closing entries to the accounts under the 10 entries have been posted Accounts tab Computer the balance for each account after all of the dosing I Provide the ending balance of Cash at December 31 from the T-accoun Provide the balance of the Retained Earnings T account wher closing entries have been Does the ending balance of the Retained a ng account agree with the balance of Retained Earnings on the balance Sheet Check Point Total Assets 120.10.50 Click Save and submit to send it. Chick See All An t a ll answers AS Office Update To keep up-to-date with security updates, X v fx General Journal Description Debit $ 10,000 Credit $ 10,000 . General Journal T-Accounts Unadjusted Tral Balance Adjusted Tral Balance Finano P19 th e Austral Balance Financial Paste BIU . LA E * Format Office Update To keep up-to-date with security updates, fixes, and improvements, choose Chec B6 x Unadjusted Trial Balance WN 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 Ready Office Update To keep up-to-date with security updates, fixes, and improvements, ch B6 x V for DEF Adjusted Trial Balance un WN 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 Adjuste TOP UOMO Office Update To keep up-to-date with security updates, fixes, and improve 26 : x x Income Statement For the month Ended December 31, 20xx Statement of Stockholders' Equity For the month Ended December 31, 20XX Classified Balance Sheet At December 31, 20XX General Journal Accounts Unadjusted Trial Balance Adjusted Trial Balance Financial Statements Ready

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

Essentials Of Auditing And Assurance Services An Integrated Approach

Authors: Alvin A. Arens, Randal J. Elder, Mark S. Beasley, Al Arens

1st Edition

0130463035, 9780130463036

More Books

Students also viewed these Accounting questions

Question

Locate the centroid (xc, yc) of the exparabolic segment of area.

Answered: 1 week ago