Cash Common stock Land Equipment Account Accounts payable Cash Accounts receivable Service revenue Cash Accounts receivable Supplies Cash Cash Unearned fees Dividends Cash Salaries expense Cash Rent expense Cash Utilities expense Cash Cash Rent revenue Debit 189,000 119,700 69,300 264,600 151,200 18,900 25, 200 18,900 151, 200 37,800 12,600 44,100 Credit 189,000 31,500 157,500 264,600 151,200 18,900 25,200 18,900 151,200 37,800 12,600 44,100 Required: 1) Post the transactions to the T-accounts. 2) Prepare the trial balance.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 16MCQ
icon
Related questions
Topic Video
Question

How do I do this in exel? The format? please help

Cash
Common stock
Account
Land
Equipment
Accounts payable
Cash
Accounts receivable
Service revenue
Cash
Accounts receivable
Supplies
Cash
Cash
Unearned fees
Dividends
Cash
Salaries expense
Cash
Rent expense
Cash
Utilities expense
Cash
Cash
Rent revenue
Debit
189,000
119,700
69,300
264,600
151,200
18,900
25, 200
18,900
151,200
37,800
12,600
44,100
Credit
189,000
31,500
157,500
264,600
151,200
18,900
25, 200
18,900
151, 200
37,800
12,600
44,100
Required:
1) Post the transactions to the T-accounts.
2) Prepare the trial balance.
Navigation:
1. Use the Open Excel in New Tab button to launch this question.
2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Transcribed Image Text:Cash Common stock Account Land Equipment Accounts payable Cash Accounts receivable Service revenue Cash Accounts receivable Supplies Cash Cash Unearned fees Dividends Cash Salaries expense Cash Rent expense Cash Utilities expense Cash Cash Rent revenue Debit 189,000 119,700 69,300 264,600 151,200 18,900 25, 200 18,900 151,200 37,800 12,600 44,100 Credit 189,000 31,500 157,500 264,600 151,200 18,900 25, 200 18,900 151, 200 37,800 12,600 44,100 Required: 1) Post the transactions to the T-accounts. 2) Prepare the trial balance. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting Equation
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning