Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 1 1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file Accounting Cycle Excel Required:

image text in transcribed
image text in transcribed
QUESTION 1 1. Prepare journal entries to record the December transactions in the General Journal Tab in the excel template file "Accounting Cycle Excel Required: #1. Template.xisx". 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 $6000 in a bank account in the name of the company in exchange for 600 shares of $10 per share common stock. 1-Dec Paid the rent for the current month, $500 . 1-Dec Paid the premium on a one-year insurance policy, $480 . 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 $5400 cash. 16-Dec $2500 . Provided service to customers ABC Inc. on account, 21-Dec Received $1500 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, $4200 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.xisx". 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

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_2

Step: 3

blur-text-image_3

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

Understanding Financial Accounting

Authors: Christopher D. Burnley

2nd Canadian Edition

1119406927, 978-1119406921

More Books

Students also viewed these Accounting questions

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago

Question

3. To retrieve information from memory.

Answered: 1 week ago