Question

This company needs to create their worksheet at the end of the month with the following information
	*Fill in the Worksheet (Adjust the entries, create the Adjusted Trial Balance, Income Statement and Balance Sheet)
	Write the correct answer in the white and orange boxes
	Transactions:
	1 At the end of the period I have 500 of supplies on hand
	2. Depreciation is 250 for the period
	3. Interest accrued for the period for 400
	4. Insurance expires at a rate of 540
	5. Services provided but unbilled for 1750
	Account Name	Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
		Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr
	Cash	12400
	Accounts Receivable	2620
	Supplies	1250
	Prepaid Insurance	2000
	Equipment	32000
	Notes Payable		10000
	Accounts Payable		12350
	Common Stock		20000
	Dividends	600
	Service Revenue		13620
	Salaries Expense	3200
	Travel Expense	900
	Rent Expense	1000
	Supplies expense
	Depreciation expense
	Accumulated Depreciation
	Interest Expense
	Interest Payable
	Insurance Expense
	Net income
	TOTAL	55970	55970

Answer 1

Account Name	Trial Balance		Adjustments		Adjusted Trial Balance		Income Statement		Balance Sheet
	Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr	Dr	Cr
Cash	$12,400				$12,400				$12,400
Accounts Receivable	$2,620		$1,750 [5]		$4,370				$4,370
Supplies	$1,250			$750 [1]	$500				$500
Prepaid Insurance	$2,000			$540 [4]	$1,460				$1,460
Equipment	$32,000				$32,000				$32,000
Notes Payable		$10,000				$10,000				$10,000
Accounts Payable		$12,350				$12,350				$12,350
Common Stock		$20,000				$20,000				$20,000
Dividends	$600				$600				$600
Service Revenue		$13,620		$1,750 [5]		$15,370		$15,370
Salaries Expense	$3,200				$3,200		$3,200
Travel Expense	$900				$900		$900
Rent Expense	$1,000				$1,000		$1,000
Supplies expense			$750 [1]		$750		$750
Depreciation expense			$250 [2]		$250		$250
Accumulated Depreciation				$250 [2]		$250				$250
Interest Expense			$400 [3]		$400		$400
Interest Payable				$400 [3]		$400				$400
Insurance Expense			$540 [4]		$540		$540
Net income					$0		$8,330			$8,330
TOTAL	$55,970	$55,970	$3,690	$3,690	$58,370	$58,370	$15,370	$15,370	$51,330	$51,330