Trial Balalnce June 2024.xlsx

	A	B	C	D	F	I	L	O	T	U	X	Z
1	School District R2 Wheatland						Trial Balance Report
2							07/2023- 06/2024	06/2024
3
4	Fund:	10		GENERAL
5									Beginning Balance	Debits	Credits	Ending Balance
6	Current Assets
7	10 1111					CASH IN BANK			1,045,460.95	2,189,836.78	1,667,176.67	1,568,121.06
8	10 1131					CASH ON HAND			500.00	600.00	0.00	1,100.00
9	10 1141 100					TRUST ACCT SAVINGS			28,092.26	948.49	0.00	29,040.75
10	10 1141 300					ACTIVITIES ACCOUNT			898.77	23,200.14	23,674.00	424.91
11	10 1141 592					CD 136592			66,792.00	2,438.62	0.00	69,230.62
12	10 1141 593					CD 136593			67,269.89	2,456.06	0.00	69,725.95
13	10 1141 594					CD 136594			66,824.90	2,439.82	0.00	69,264.72
14	10 1141 973					CD 131973			620,729.19	27,178.07	0.00	647,907.26
15			Total:		Current Assets				1,896,567.96	2,249,097.98	1,690,850.67	2,454,815.27
16	Current Liabilities
17	10 2151					FED WITHOD PAYABLE			0.00	25,394.85	25,394.85	0.00
18	10 2152					OASDI PAYABLE			0.00	63,505.40	63,505.40	0.00
19	10 2153					MEDICARE TAX PAYABLE			0.00	15,226.92	15,226.92	0.00
20	10 2154					MO INCOME TAX PAYABLE			0.00	10,464.20	10,464.20	0.00
21	10 2154 006					AFA INSURANCE			0.00	1,579.20	1,579.20	0.00
22	10 2154 007					AFA REIMBURSEMENT			0.15	0.00	0.00	0.15
23	10 2154 023					FORREST T JONES 403B			0.00	1,500.00	1,500.00	0.00
24	10 2154 026					TEXAS LIFE			0.00	456.30	456.30	0.00
25	10 2154 050					CHILD SUPPORT			0.00	1,394.56	1,394.56	0.00
26	10 2154 052					HICKORY COUNTY CIRCUIT COURT			0.00	237.80	237.80	0.00
27	10 2156 012					BP HSA ADDITIONAL BEN			0.00	2,755.25	2,755.25	0.00
28	10 2157					ANTHEM INSURANCE			(1,034.69)	124,995.42	125,471.65	(558.46)
29	10 2158					TEA RETIRE PAYABLE			0.00	3,541.04	3,541.04	0.00
30	10 2159					NON TEA RET PAYABLE			(123.40)	87,486.86	87,486.86	(123.40)
31			Total:		Current Liabilities				(1,157.94)	338,537.80	339,014.03	(681.71)
32	Fund Balance
33	10 3111					FUND BALANCE			1,897,769.34	1,700,236.07	2,258,007.15	2,455,540.42
34	10 3321					INS LOSS CLEARING			(43.44)	0.00	0.00	(43.44)
35			Total:		Fund Balance				1,897,725.90	1,700,236.07	2,258,007.15	2,455,496.98
36	Revenue
37	10 5111					CURRENT TAXES			0.00	0.00	1,506,367.56	1,506,367.56
38	10 5112					DELINQUENT TAXES			0.00	0.00	1,358.75	1,358.75
39	10 5114					FINANCE INST TAXES			0.00	3.56	13.32	9.76
40	10 5115					M & M SURTAX			0.00	0.00	12,685.19	12,685.19
41	10 5141					EARNINGS ON INVEST			0.00	0.00	55,373.58	55,373.58
42	10 5141 100					EARN ON INVEST-TRUST			0.00	0.00	7,585.02	7,585.02
43	10 5151					STUDENT MEALS			0.00	0.00	21,754.22	21,754.22
44	10 5161					ADULT MEALS			0.00	0.00	6,141.21	6,141.21
45	10 5165					NON-PROGRAM RECEIPTS			0.00	0.00	263.40	263.40
46	10 5181					CS PRESCHOOL TUITION			0.00	0.00	6,900.00	6,900.00
47	10 5192					OTHER LOCAL-GIFTS			0.00	2,360.04	2,360.04	0.00
48	10 5195					PRIOR PERIOD ADJ			0.00	11,477.29	11,477.29	0.00
49	10 5198					MISC LOCAL REVENUE			0.00	0.00	9,847.48	9,847.48
50	10 5198 000 1050 09120					MISC LOCAL MDC NATURE			0.00	0.00	245.00	245.00
51						UNBOUND
52	10 5221					RAILROAD, UTILITY TAX			0.00	0.00	56,574.95	56,574.95
53	10 5231					FLOOD CONTROL			0.00	0.00	22,531.07	22,531.07
54	10 5312					TRANSPORTATION REV			0.00	0.00	162,229.17	162,229.17
55	10 5314					ECSE EARLY CHILDHOOD			0.00	0.00	5,729.11	5,729.11
56	10 5333					ST FOOD SERVICE			0.00	0.00	899.09	899.09
57	10 5384					SCHOOL SAFETY GRANT			0.00	0.00	50,000.00	50,000.00
58	10 5397 000 0000 00005					OTHER STATE HVAC GRANT			0.00	30,451.48	30,451.48	0.00
59	10 5412					MEDICAID			0.00	0.00	7,911.04	7,911.04
60	10 5422 000 0000 42200					ESSER III			0.00	0.00	21,735.62	21,735.62
61	10 5422 000 0000 42205					ESSER III SUMMER SCHOOL GRANT			0.00	0.00	3,117.00	3,117.00
62	10 5442 000 0000 44200					ECSE FEDERAL			0.00	0.00	4,172.00	4,172.00
63	10 5445					FEDERAL LUNCH PROGRAM			0.00	0.00	74,533.65	74,533.65
64	10 5445 000 0000 44501					SCHOOL LUNCH SUPPLY CHAIN			0.00	0.00	15,983.17	15,983.17
65	10 5446					FEDERAL BREAK PROGRAM			0.00	0.00	31,948.16	31,948.16
66	10 5446 000 0000 44600					SCHOOL BREAKFAST PROGRAM			0.00	0.00	3,836.32	3,836.32
67	10 5451 023 0000 45100					TITLE I			0.00	0.00	392.16	392.16
68	10 5451 024 0000 45100					TITLE I			0.00	0.00	31,851.58	31,851.58
69	10 5461 022 0000 46100					TITLE IV			0.00	0.00	789.88	789.88
70	10 5461 024 0000 46100					TITLE IV			0.00	0.00	45.96	45.96
71	10 5465 023 0000 46500					TITLE II.A			0.00	0.00	1,236.91	1,236.91
72	10 5465 024 0000 46500					TITLE II.A			0.00	0.00	7,732.70	7,732.70
73	10 5492 000 0000 49200					REAP			0.00	0.00	16,827.60	16,827.60
74	10 5497					OTHER FEDERAL			0.00	0.00	30,451.48	30,451.48
75	10 5631					NET INSURANCE RECOVER			0.00	0.00	10,641.29	10,641.29
76	10 5651					SALE OF PROPERTY			0.00	0.00	575.00	575.00
77			Total:		Revenue				0.00	44,292.37	2,234,568.45	2,190,276.08
78	Expenditure
79	10 1111 6411 000 4020 1 00000					EL GEN SUPPLIES			0.00	28,772.85	551.40	28,221.45
80	10 1111 6411 000 4020 4 46100					EL TITLE IV GEN SUPP			0.00	835.84	0.00	835.84
81	10 1111 6412 000 4020 1 00000					EL TECH SUPPLIES			0.00	432.70	0.00	432.70
82	10 1111 6412 000 4020 4 49200					EL TECH SUPP REAP			0.00	8,728.21	88.34	8,639.87
83	10 1111 6431 000 4020 1 00000					EL TEXTBOOK			0.00	14,253.58	12,253.15	2,000.43
84	10 1111 6431 000 4020 4 42200					EL TEXTBOOKS ESSER III			0.00	11,824.15	0.00	11,824.15
85	10 1151 6311 000 1050 1 00000					HS PUR INSTR-TESTING			0.00	255.60	0.00	255.60
86	10 1151 6343 000 1050 1 00000					HS TRAVEL			0.00	2,321.66	0.00	2,321.66
87	10 1151 6371 000 1050 1 00000					HS DUES/MEMBERSHIPS			0.00	2,282.00	0.00	2,282.00
88	10 1151 6391 000 1050 1 00000					HS PURCHASE SERVICE			0.00	891.00	0.00	891.00
89	10 1151 6411 000 1050 1 00000					HS GEN SUPPLIES			0.00	36,998.55	60.10	36,938.45
90	10 1151 6412 000 1050 1 00000					HS TECH SUPPLIES			0.00	5,170.86	4,900.00	270.86
91	10 1151 6412 000 1050 4 42200					HS TECH SUPPLIES ESSER III			0.00	4,840.00	0.00	4,840.00
92	10 1151 6412 000 1050 4 49200					HS TECH SUPP REAP			0.00	7,103.14	0.00	7,103.14
93	10 1151 6431 000 1050 1 00000					HS TEXTBOOK			0.00	6,182.19	5,074.47	1,107.72
94	10 1151 6431 000 1050 4 42200					HS TEXTBOOKS ESSER III			0.00	5,074.47	0.00	5,074.47
95	10 1221 6343 000 1050 3 12210					SE TRAVEL			0.00	110.21	0.00	110.21
96	10 1221 6343 000 4020 3 12210					SE TRAVEL			0.00	326.62	0.00	326.62
97	10 1221 6371 000 4020 3 12210					SE DUES/ MEMBERSHIPS			0.00	14.59	0.00	14.59
98	10 1221 6391 000 1050 1 12210					SE PURCHASE SERVICE			0.00	259.00	0.00	259.00
99	10 1221 6411 000 1050 1 12210					SE GEN SUPPLIES			0.00	64.92	0.00	64.92
100	10 1221 6411 000 4020 1 12210					SE GEN SUPPLIES			0.00	84.78	0.00	84.78