Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: #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

Required: #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. 1-Dec Began business by depositing $10000 in a bank account in the name 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 Paid the premium on a one-year insurance policy, $1200 . 1-Dec Purchased Equipment for $3600 cash. 5-Dec Purchased office supplies from XYZ Company on account, $300 . 15-Dec Provided services to customers for $9000 cash. 16-Dec Provided service to customers ABC Inc. on account, $7900 . 21-Dec Received $3300 cash from ABC Inc., customer on account. 23-Dec Paid $170 to XYZ company for supplies purchased on account on December 5 . 28-Dec Paid wages for the period December 1 through December 28, $4760 . 30-Dec Declared and paid dividend to stockholders $200 . #2. Post all of the December transactions from the General Journal tab to the T-accounts under the T-Accounts 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 balance for each T-account after all of the entries have been posted. These are the unadjusted balance as of December 31. #4. Prepare the unadjusted trial balance under the Unadjusted Trial Balance tab in the excel template file "Accounting Cycle Excel Template.xlsx" . Provide the total of the credit column from the Unadjusted Trial Balance #5. Record the following four transactions as adjusting entries under the General Journal tab. 31-Dec One months insurance has been used by the company $100. 31-Dec The remaining inventory of unused office supplies is $90. 31-Dec The estimated depreciation on equipment is $60. 31-Dec Wages incurred from December 29 to December 31 but not yet paid or recorded total $510. #6. 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.

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

Master Your Money Insider Secrets For Financial Success

Authors: William J. Ramirez

1st Edition

979-8865784432

More Books

Students also viewed these Accounting questions

Question

List behaviors to improve effective leadership in meetings

Answered: 1 week ago