Case 2 Based on what you learned in the text and using the Sample Company, you are to add the following activities to your company: 1. Open and review your previously customized report named Trial Balance 1/31/19. Adjusting Entries Chapter 9 2. Record the appropriate adjusting journal entries on 1/31/19 based on the following:

a. An inventory of supplies reveals that only $200 of supplies remain as of 1/31/19.

b. $1,800 of prepaid expenses expired (representing prepaid insurance) in the month of January.

c. A bill for $750 was received and recorded in the next month for legal fees performed in the current month. Create a new liability account as you did earlier in the chapter.

d. Custom painting services recorded on invoice \#1003 for $4,500.00 to Hagen's toys were never performed even though invoiced. Thus, the revenue had not been earned. Create a new liability account as you did earlier in the chapter.

e. Repair services of $6,298 were performed on the last day of the month for a new customer: Kelly's Awesome Copters but not invoiced to the customer or recorded into the accounting records until a few days into the next month. Create a new asset account as you did earlier in the chapter.

f. Depreciation Expense of $1,000 ( $375 and $625 for Furniture and Machinery \& Equipment, respectively) needed to be recorded for the month. Before recording this journal entry edit the "Depreciation" expense account so the new name is "Depreciation Expense." Also, change the account title for Machinery \& Equipment accumulated depreciation from "Depreciation" to "Accumulated Depreciation" like you did in the chapter.

3. Open, print, and export to Excel your previously customized report named Trial Balance 1/31/19, which should reflect your adjusting journal entries.

4. Open, print, and export to Excel your previously customized report named Transaction Detail by Account, which should reflect your adjusting journal entries.

Case 02
Trial Balance
As of January 31, 2019
	Debit	Credit
Checking	31,860.68
Accounts Rceivable	1,425.00
Iventory Asset	5,410.00
Prepaid Epenses	6,800.00
Supplies Asset	450.00
Undeposited Funds	925.00
Furniture:Original Cost	4,875.00
Machinery & Equipment: Depreciation		1,000.00
Machinery & Equipment: Original Cost	10,000.00
Investment	3,200.00
Accounts Payable		8,670.00
AMEX		240.00
Payroll Tax Payable		2,484.94
Notes Payable		27,625.00
Common Stock		25,100.00
Opening balance equity		0.00
Retained Earnings		7,585.00
Sales		5,700.00
Services		225.00
Cost of Goods Sold	3,020.00
Advertising	500.00
Insurance	400.00
Interest Expense	300.00
Meals and Entertainment	240.00
Payroll	9,224.26
TOTAL	$ 78,629.94	$ 78,629.94

UPDATED EXCEL SHEET THAT SHOWS EVERY ADJUSTMENT AND NEW BALANCE. I HAD IT ANSWERED TWICE AND IT WASNT UPDATE PROPERLY. PLEASE UPDATE EVERY ADJUSTMENT CORRECTLY IN EXEL FORMAT TO UNDERSTAND IT VISUALLY.