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

image text in transcribed

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 Earings, Dividends, Service Revenue, Depreciation Expense, Wages Expense, Supplies Expense, Rent Expense, and Insurance Expense #2 1-Dec Began business by depositing $8500 in a bank account in the name of the company in exchange for 850 shares of $10 per share common stock Paid the premium on a one-year insurance policy, $1320 1-Dec Paid the rent for the current month, $1250 1-Dec 1-Dec 5-Dec Purchased Equipment for $3600 cash. Purchased office supplies from XYZ Company on account, $300 15-Dec Provided services to customers for $8400 cash. 16-Dec Provided service to customers ABC Inc. on account, $7000 21-Dec Received $3000 cash from ABC Inc, customer on account Paid $170 to XYZ company for supplies purchased on account on 23-Dec December 5 28-Dec Paid wages for the period December 1 through December 28, $5040 30-Dec Declared and paid dividend to stockholders $200 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"

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

Financial Accounting

Authors: Walter T. Harrison, Charles T. Horngren

7th edition

0135012848, 978-0135012840

More Books

Students also viewed these Accounting questions

Question

Describe the benefits provided by the traditional Medicare program?

Answered: 1 week ago