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.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Step 1: Define Trial Balance -

A Trial balance is a summarized form of a ledger. All the assets and expenses are recorded on the debit side and liabilities and incomes on the debit side.

The balance of debit and credit shall be balanced.

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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education