Need Help with putting this into a excel sheet

profilerickmanheather
Unit3IPTemplate.xls
Home>Business & Finance homework help>Accounting homework help>Need Help with putting this into a excel sheet

General Journal

General Journal
GENERAL JOURNAL
Date Super Hero Theme Park P. R. Debit Credit
1-Jan Cash 50,000 50,000
J. Strange Owners Equity
Initial Investment
5-Jan Equipment 100,000 100,000
From Gotham Company
8-Jan Advertisng Expense 1800 1800
Mr. Freeze Agencies
11-Jan Salary Expense 1500 1500
Employees
12-Jan Telephone Expense 200 200
Cell Phone Bill
13-Jan Prepaid Insurance Policy 1500 1500
One Year Insurance Policy
17-Jan Jack Strange Drawing 600 600
Personal Use
20-Jan Admissions Revenue 5700 5700
Cash Admissions Fees
22-Jan Unearned Admission Revenue 3000 3000
Cash Admissions Fees
25-Jan Accounts Receivable 2500 2500
Collected in Advance for park use
30-Jan Accounts Payable 700 700
For Advertising on Jan. 8
167,500 167,500

General Ledger

General Ledger
GENERAL LEDGER
For The Super Hero Theme Park for Januarry 2020
Cash ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
-
-
-
-
-
-
-
-
Prepaid Insurance ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
13-Jan Prepaid Insurance 1500 1500 1,500
Equipment ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
5-Jan Purchased Equipment 100,000 100,000
Accounts Receivable ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
25-Jan Collected in Advance from Cust. 2500 2500 2,500
Accounts Payable ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
30-Jan Advertising from Jan. 8th 700 700 700
700
700
Unearned Admission Revenue ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
22-Jan Billed Corporate Cust. 3000 3000 3,000
Jack Strange, Capital ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
1-Jan J. Stange Owner Equity 50,000 50,000 50,000
Jack Strange, Drawing ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
17-Jan J. Strange withdrawal 600 600 600
Admission Revenue ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
20-Jan Admission Fees 5700 5700 5,700
5,700
Advertising Expense ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
8-Jan Mr. Freeze Agency 1800 1800 1,800
Salaries Expense ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
11-Jan Paid Employees 1500 1500 1,500
Telephone Expense ACCOUNT NO. ____
Date Explanation P.R. DEBIT CREDIT BALANCE
12-Jan Paid Cell Phones 200 200 200

Trial Balance

Trial Balance
Debit Credit
Cash
Accounts Receivable 2500 2500
Prepaid Insurance 1500 1500
Equipment 100000 100000
Accounts Payable 700 700
Unearned Admission Revenue 3000 3000
Jack Strange, Capital 50000 50000
Jack Strange, Drawing 600 600
Admission Revenue 5700 5700
Advertising Expense 1800 1800
Salaries Expense 1500 1500
Telephone Expense 200 200
Totals 167500 167500

Income Statement

Income Statement
Income Statement The Super Hero Theme Park
For January 2020
Revenue:
Admission Revenue 5700
Expenses
Advertising Expense 1800
Salaries Expense 1500
Telephone Expense 200
Total Expenses 3500
Net Income 2200

BS & Owner's Equity

Statement of Changes in Owner's Equity
For January 2020
Jack Strange, Capital 1/1/XX 50000
Add: Net Income 2200
Subtotal 52200
Less: Jack Strange, Drawing 600
Jack Strange Capital 1/31/XX 51600
Balance Sheet for The Super Hero Theme Park
Jan-20
Assets:
Cash
Accounts Recievable 2500
Prepaid Insurance 1500
Equipment 100000
Total Assets 104000
Liabilities
Accounts Payable 700
Unearned Admission Revenue 3000
Total Liabilities 3700
Owner's Equity
Jack Strange, Capital 50000
Total Liabilities & Owner's Equity 53700