Chp 18 10 column Worksheet Sample.xls

	A	B	C	D	E	F	G	I	J	K	L	N	O	P	Q	S	T	U	V	X	AC	AH	AM	AR	AW	BB
1	C																			Name____________________________________________________________ Date_____________ Class______________
2
3	Worksheet																			Worksheet
4
5		Account No.	Account Name	Trial Balance								Adjustments								Adjusted Trial Balance		Income Statement		Balance Sheet
6		Account No.	Account Name	Debit				Credit				Debit				Credit				Debit	Credit	Debit	Credit	Debit	Credit
7	1		Cash	14	9	0	0																			1
8	2		Accounts Receivable	3	8	0	0																			2
9	3		Merchandise Inventory	86	9	0	0									(a)7	1	0	0							3
10	4		Supplies	2	9	0	0									(b)1	9	0	0							4
11	5		Prepaid Insurance	1	9	0	0									( c)	8	0	0							5
12	6		Office Euipment	11	2	0	0																			6
13	7		Accounts Payable					7	7	0	0															7
14	8		Fed. Corp. Income Tax Payable													( d)	2	0	0							8
15	9		Employees' Federal Income Tax Pay						3	0	0															9
16	10		Employees' State Income Tax Pay						1	0	0															10
17	11		Social Security Tax Pay						1	0	0															11
18	12		Medicare Tax Pay						1	0	0															12
19	13		Federal Unemploy. Tax Pay						1	0	0															13
20	14		State Unemploy. Tax Pay						2	0	0															14
21	15		Sales Tax Payable					1	3	0	0															15
22	16		Capital Stock					55	0	0	0															16
23	17		Retained Earnings					30	9	0	0															17
24	18		Income Summary									(a)7	1	0	0											18
25	19		Sales					149	1	0	0															19
26	20		Purchases	93	9	0	0																			20
27	21		Fed. Corp. Income Tax Expense	2	2	0	0					(d)	2	0	0											21
28	22		Insurance Expense									( c)	8	0	0											22
29	23		Payroll Tax Expense	2	1	0	0																			23
30	24		Rent Expense	12	8	0	0																			24
31	25		Salaries Expense	12	3	0	0																			25
32	26		Supplies Expense									(b)1	9	0	0											26
33	27			244	9	0	0	244	9	0	0															27
34	28		NET INCOME (NET LOSS)																							28