Trial Balance June 2022.xlsx

	A	B	C	D	F	I	L	M	N	S	T	W	Y
1	School District R2 Wheatland						Trial Balance Report
2							07/2021	-	06/2022
3
4	Fund:	10		GENERAL
5										Beginning Balance	Debits	Credits	Ending Balance
6	Current Assets
7	10 1111					CASH IN BANK				898,714.68	2,032,444.20	2,015,355.94	915,802.94
8	10 1131					CASH ON HAND				500.00	0.00	0.00	500.00
9	10 1141 100					TRUST ACCT SAVINGS				27,539.74	134.05	0.78	27,673.01
10	10 1141 300					ACTIVITIES ACCOUNT				259.17	19,009.95	17,960.04	1,309.08
11	10 1141 592					CD 136592				65,330.70	295.29	0.00	65,625.99
12	10 1141 593					CD 136593				65,798.13	297.40	0.00	66,095.53
13	10 1141 594					CD 136594				65,362.88	295.43	0.00	65,658.31
14	10 1141 973					CD 131973				606,960.90	3,040.50	0.00	610,001.40
15			Total:		Current Assets					1,730,466.20	2,055,516.82	2,033,316.76	1,752,666.26
16	Current Liabilities
17	10 2151					FED WITHOD PAYABLE				0.00	21,864.79	21,864.79	0.00
18	10 2152					OASDI PAYABLE				0.00	56,983.58	56,983.58	0.00
19	10 2153					MEDICARE TAX PAYABLE				0.00	13,660.94	13,660.94	0.00
20	10 2154					MO INCOME TAX PAYABLE				0.00	9,307.27	9,307.27	0.00
21	10 2154 006					AFA INSURANCE				0.00	2,368.88	2,368.88	0.00
22	10 2154 007					AFA REIMBURSEMENT				0.00	0.00	0.15	0.15
23	10 2154 023					FORREST T JONES 403B				0.00	1,675.00	1,675.00	0.00
24	10 2154 026					TEXAS LIFE				0.00	421.20	421.20	0.00
25	10 2154 052					HICKORY COUNTY CIRCUIT COURT				0.00	560.25	560.25	0.00
26	10 2154 054					BAILY LAW FIRM				0.00	373.50	373.50	0.00
27	10 2157					ANTHEM INSURANCE				(1,034.69)	116,403.84	116,403.84	(1,034.69)
28	10 2158					TEA RETIRE PAYABLE				0.00	3,327.38	3,327.38	0.00
29	10 2159					NON TEA RET PAYABLE				(9.60)	75,363.14	75,249.34	(123.40)
30	10 2165					MSTA				0.00	180.00	180.00	0.00
31			Total:		Current Liabilities					(1,044.29)	302,489.77	302,376.12	(1,157.94)
32	Fund Balance
33	10 3111					FUND BALANCE				1,731,510.49	2,046,509.01	2,068,866.16	1,753,867.64
34	10 3321					INS LOSS CLEARING				0.00	43.44	0.00	(43.44)
35			Total:		Fund Balance					1,731,510.49	2,046,552.45	2,068,866.16	1,753,824.20
36	Revenue
37	10 5111					CURRENT TAXES				0.00	0.00	1,219,362.72	1,219,362.72
38	10 5112					DELINQUENT TAXES				0.00	0.00	65,975.66	65,975.66
39	10 5113					PROP C				0.00	0.00	106,829.50	106,829.50
40	10 5114					FINANCE INST TAXES				0.00	0.00	276.34	276.34
41	10 5115					M & M SURTAX				0.00	0.00	12,122.07	12,122.07
42	10 5141					EARNINGS ON INVEST				0.00	0.78	16,021.63	16,020.85
43	10 5141 100					EARN ON INVEST-TRUST				0.00	0.00	120.22	120.22
44	10 5151					STUDENT MEALS				0.00	138.00	459.75	321.75
45	10 5161					ADULT MEALS				0.00	0.00	750.40	750.40
46	10 5181					CS PRESCHOOL TUITION				0.00	0.00	9,798.00	9,798.00
47	10 5192					OTHER LOCAL-GIFTS				0.00	10,491.15	10,491.15	0.00
48	10 5192 000 0000 00009					OTHER LOCAL GIFTS WCC				0.00	0.00	10,491.15	10,491.15
49	10 5195					PRIOR PERIOD ADJ				0.00	0.00	925.00	925.00
50	10 5198					MISC LOCAL REVENUE				0.00	1,226.04	5,121.15	3,895.11
51	10 5198 000 0000 09102					MISC LOCAL - MFHG				0.00	0.00	220.00	220.00
52	10 5198 000 0000 09200					MISC LOC-MO RET TEACH				0.00	0.00	500.00	500.00
53	10 5198 000 1050 09120					MISC LOCAL MDC NATURE				0.00	0.00	385.00	385.00
54						UNBOUND
55	10 5221					RAILROAD, UTILITY TAX				0.00	6,197.63	62,033.00	55,835.37
56	10 5231					FLOOD CONTROL				0.00	0.00	3,219.86	3,219.86
57	10 5312					TRANSPORTATION REV				0.00	0.00	45,991.00	45,991.00
58	10 5314					ECSE EARLY CHILDHOOD				0.00	0.00	1,796.00	1,796.00
59	10 5333					ST FOOD SERVICE				0.00	0.00	2,232.77	2,232.77
60	10 5412					MEDICAID				0.00	0.00	11,171.71	11,171.71
61	10 5424 000 0000 42403					CARES STUDENT CONNECT ESSER				0.00	11,448.00	11,448.00	0.00
62	10 5425 000 0000 42500					CARES STUDENT CONNECT GEER				0.00	0.00	11,448.00	11,448.00
63	10 5442 000 0000 44200					ECSE FEDERAL				0.00	0.00	1,914.00	1,914.00
64	10 5445 000 0000 44500					SCHOOL LUNCH PROGRAM				0.00	250.00	151,592.86	151,342.86
65	10 5445 000 0000 44501					SCHOOL LUNCH SUPPLY CHAIN				0.00	0.00	10,535.09	10,535.09
66	10 5446 000 0000 44600					SCHOOL BREAKFAST PROGRAM				0.00	0.00	53,188.70	53,188.70
67	10 5451 022 0000 45100					TITLE I				0.00	0.00	9,293.70	9,293.70
68	10 5451 170 0000 45100					TITLE I				0.00	0.00	143.13	143.13
69	10 5461 021 0000 46100					TITLE IV.A				0.00	0.00	134.00	134.00
70	10 5461 022 0000 46100					TITLE IV				0.00	0.00	15,747.31	15,747.31
71	10 5465 022 0000 46500					TITLE II.A				0.00	0.00	13,975.69	13,975.69
72	10 5465 170 0000 46500					TITLE II.A				0.00	0.00	1,052.85	1,052.85
73	10 5471 000 0000 47100					CHILD NUTRITION PROGRAM CNEOC				0.00	0.00	10,371.62	10,371.62
74	10 5473 000 0000 47300					CARES SCHOOL LUNCH PROGRAM				0.00	20,695.50	20,695.50	0.00
75	10 5474 000 0000 47300					CARES BREAKFAST PROGRAM				0.00	7,463.32	7,463.32	0.00
76	10 5492 000 0000 49200					REAP				0.00	0.00	15,266.81	15,266.81
77	10 5497 000 0000 09401					OTHER FEDERAL REVENUE EPA				0.00	0.00	11,762.36	11,762.36
78						GRANT
79			Total:		Revenue					0.00	57,910.42	1,932,327.02	1,874,416.60
80	Expenditure
81	10 1111 6311 000 4020 1 00000					EL PUR INSTR-TESTING				0.00	97.50	0.00	97.50
82	10 1111 6343 000 4020 1 00000					EL TRAVEL				0.00	84.48	0.00	84.48
83	10 1111 6371 000 4020 1 00000					EL DUES/MEMBERSHIPS				0.00	300.00	0.00	300.00
84	10 1111 6411 000 4020 1 00000					EL GEN SUPPLIES				0.00	12,941.24	393.87	12,547.37
85	10 1111 6411 000 4020 4 46100					EL TITLE IV GEN SUPP				0.00	110.01	0.00	110.01
86	10 1111 6412 000 4020 1 00000					EL TECH SUPPLIES				0.00	349.85	0.00	349.85
87	10 1111 6412 000 4020 4 42403					SUPPLIES- CARES STUDENT				0.00	11,471.43	5,300.29	6,171.14
88						CONNECT ESSER
89	10 1111 6412 000 4020 4 49200					EL TECH SUPP REAP				0.00	6,453.80	6,453.80	0.00
90	10 1111 6431 000 4020 1 00000					EL TEXTBOOK				0.00	1,190.86	0.00	1,190.86
91	10 1151 6311 000 1050 1 00000					HS PUR INSTR-TESTING				0.00	135.00	0.00	135.00
92	10 1151 6343 000 1050 1 00000					HS TRAVEL				0.00	1,140.65	0.00	1,140.65
93	10 1151 6371 000 1050 1 00000					HS DUES/MEMBERSHIPS				0.00	1,420.00	0.00	1,420.00
94	10 1151 6391 000 1050 1 00000					HS PURCHASE SERVICE				0.00	535.33	35.00	500.33
95	10 1151 6411 000 1050 1 00000					HS GEN SUPPLIES				0.00	43,408.38	633.17	42,775.21
96	10 1151 6411 000 1050 1 09200					HS GEN SUP-MO RET TEA				0.00	504.79	0.00	504.79
97	10 1151 6412 000 1050 1 00000					HS TECH SUPPLIES				0.00	9,490.81	0.00	9,490.81
98	10 1151 6412 000 1050 4 42403					SUPPLIES- CARES STUDENT				0.00	5,276.86	0.00	5,276.86
99						CONNECT ESSER
100	10 1151 6412 000 1050 4 49200					HS TECH SUPP REAP				0.00	2,700.30	0.00	2,700.30