Guide To Trial Balance Excel Sheet And Adjusting Entries For AAA Services

AAA Services
Worksheet
for the year end 30 Jun 2018
	Trial Balance	Adjusting Entries	Adjusted Trial Balance	Income Statement	Balance Sheet
Accounts Name	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit	Debit	Credit
Cash	40860				40860				40860
Accounts Receivable	11800				11800				11800
Office Supplies	45600			36960	8640				8640
Prepaid Rent	72000			24000	48000				48000
Equipment	160000				160000				160000
Accum. Depreciation – Equipment				13200		13200				13200
Accounts Payable		10400				10400				10400
Notes Payable		40000				40000				40000
Utilities Payable		7928				7928				7928
Interest Payable				300		300				300
Unearned Revenue		8000	3000			5000				5000
Common Stock		200000				200000				200000
Service Revenue		165200		3000		168200		168200
Wages Expense	76400				76400		76400
Miscellaneous Expense	6940				6940		6940
Electricity Expense	4940				4940		4940
Telephone Expense	2988				2988		2988
Supplies Expense			36960		36960		36960
Rent Expense			24000		24000		24000
Depreciation Expense			13200		13200		13200
Interest Expense			300		300		300
Dividend	10000				10000				10000

Total	431528	431528	77460	77460	445028	445028	165728	168200	279300	276828

Profit for the month							2472			2472
			77460	77460	445028	445028	168200	168200	279300	279300


AAA Services
Journal Entries

Date	Particulars	Debit	Credit

30-06-2018	Supplies Expense	36960
	Office Supplies		36960

30-06-2018	Rent Expense	24000
	Prepaid Rent		24000

30-06-2018	Depreciation Expense	13200
	Accumulated Depreciation – Equipment		13200

30-06-2018	Interest Expense	300
	Interest Payable		300

30-06-2018	Unearned Revenue	3000
	Service Revenue		3000


AAA Services
Income Statement
for the year ended June 30,2018
Particulars	Amount

Service Revenue	1,68,200

TOTAL REVENUE	1,68,200

Wages Expense	-76,400
Miscellaneous Expense	-6,940
Electricity Expense	-4,940
Telephone Expense	-2,988
Supplies Expense	-36,960
Rent Expense	-24,000
Depreciation Expense	-13,200
TOTAL OPERATING EXPENSES	-1,65,428

NET OPERATING PROFIT	2,772
Interest Expense	-300

NET PROFIT FOR THE PERIOD	2,472

AAA Service
Statement of Change in Equity
for the period ended June 30,2018
Particulars	Common Stock	Retained Earnings	TOTAL

Balance as on 1 July 2017	2,00,000	0	2,00,000
Add: Net Profit for the period		2,472	2,472
Less: Dividends		-10,000	-10,000

Balance as on 30 June 2018	2,00,000	-7,528	1,92,472

AAA Services
Balance Sheet
as on June 30,2018
Particulars	Amount

Current Assets:
Cash	40,860
Accounts Receivable	11,800
Office Supplies	8,640
Prepaid Rent	48,000
TOTAL CURRENT ASSETS	1,09,300

Non-Current Assets:
Equipment	1,60,000
Accum. Depreciation – Equipment	-13,200
TOTAL NON-CURRENT ASSETS	1,46,800

TOTAL ASSETS	2,56,100

Current Liabilities:
Accounts Payable	10,400
Utilities Payable	7,928
Unearned Revenue	5,000
Interest Payable	300
TOTAL CURRENT LIABILITIES	23,628

Non-Current Liabilities:
Notes Payable	40,000
TOTAL NON-CURRENT LIABILITIES	40,000

TOTAL LIABILITIES	63,628

Equity:
Capital	2,00,000
Retained Earnings	-7,528
TOTAL EQUITY	1,92,472

TOTAL LIABILITIES & EQUITY	2,56,100

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Guide To Trial Balance Excel Sheet And Adjusting Entries For AAA Services ”

Get high-quality paper

NEW! AI matching with writer

How Our Essay Writing Service Works

First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.

Complete the order form

Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.

Writer’s assignment

As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.

Completing the order and download