Description
I want an expert in Accounting and Excel to solve the problem mentioned here. It should be solved in Excel.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Title:
Institutional affiliation
Course:
Date:
Question 1: Journal
Page 1
Date
Account Name
1/7/2018 cash
-common stock
1/7/2018 Amount Receivable
-common stock
1/7/2018 Supplies
-common stock
1/7/2018 Office equipment
-common stock
1/7/2018 Rent
-cash
2/7/2018 Insurance expense
-cash
4/7/2018 Advanced payment
-unearned fees
5/7/2018 Office equipment
-cash
Debit
Credit
$13,500
$13,500
$20,800
$20,800
$3,200
$3,200
$7,500
$7,500
$4,800
$4,800
$4,500
$4,500
$5,500
$5,500
$6,500
$6,500
14/7/2018
Page 2
Date
17/7/2018
18/7/2018
20/7/1018
24/7/2018
26/7/2018
27/7/2018
29/7/2018
31/7/2018
31/7/2018
31/7/2018
31/7/2018
6/7/2018 Accounts receivable
-cash
10/7/2018 Newspaper Advertisement
-cash
12/7/2018 Debt payable
-cash
12/7/2018 Recorded service provided
-cash
Pay receptionist
-cash
Account Name
Fees earned
-cash
Account payable
- supplies
Service provided
-cash
Fees earned
-cash
Account receivable
-cash
Paid receptionist
-cash
Paid telephone bill
-cash
Paid electricity bill
-cash
Fees earned
-cash
Recorded service provided
-cash
Dividends
-cash
$15,300
$15,300
$400
$400
$5,200
$5,200
$13,300
$13,300
$1,750
$1,750
Credit
Debit
$9,450
$9,450
$600
$600
$6,650
$6,650
$4,000
$4,000
$12,000
$12,000
$1,750
$1,750
$325
$325
$675
$675
$5,200
$5,200
$3,000
$3,000
$12,500
$12,500
Question 2: Ledger
Date
14/7/2018
Description
Journal
Cash received from Steffy Lopez #JI
Amount Receivable
#J1
Supplies...