Trial Balance Sept 2023.xlsx

	A	B	C	D	F	I	L	N	S	T	W	Y
1	School District R2 Wheatland						Trial Balance Report
2							07/2023 - 09/2023	09/2023
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	113,538.76	397,971.99	761,027.72
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	235.77	0.00	28,328.03
10	10 1141 300					ACTIVITIES ACCOUNT			898.77	6,001.13	5,789.00	1,110.90
11	10 1141 592					CD 136592			66,792.00	378.79	0.00	67,170.79
12	10 1141 593					CD 136593			67,269.89	381.50	0.00	67,651.39
13	10 1141 594					CD 136594			66,824.90	378.98	0.00	67,203.88
14	10 1141 973					CD 131973			620,729.19	6,654.56	0.00	627,383.75
15			Total:		Current Assets				1,896,567.96	128,169.49	403,760.99	1,620,976.46
16	Current Liabilities
17	10 2151					FED WITHOD PAYABLE			0.00	3,822.27	3,822.27	0.00
18	10 2152					OASDI PAYABLE			0.00	8,879.06	8,879.06	0.00
19	10 2153					MEDICARE TAX PAYABLE			0.00	2,119.02	2,119.02	0.00
20	10 2154					MO INCOME TAX PAYABLE			0.00	1,548.73	1,548.73	0.00
21	10 2154 006					AFA INSURANCE			0.00	261.60	261.60	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	250.00	250.00	0.00
24	10 2154 026					TEXAS LIFE			0.00	70.20	70.20	0.00
25	10 2154 052					HICKORY COUNTY CIRCUIT COURT			0.00	237.80	237.80	0.00
26	10 2156 012					BP HSA ADDITIONAL BEN			0.00	310.00	310.00	0.00
27	10 2157					ANTHEM INSURANCE			(1,034.69)	18,597.01	18,096.11	(1,535.59)
28	10 2158					TEA RETIRE PAYABLE			0.00	433.74	433.74	0.00
29	10 2159					NON TEA RET PAYABLE			(123.40)	11,084.28	11,084.28	(123.40)
30			Total:		Current Liabilities				(1,157.94)	47,613.71	47,112.81	(1,658.84)
31	Fund Balance
32	10 3111					FUND BALANCE			1,897,769.34	390,422.07	115,331.47	1,622,678.74
33	10 3321					INS LOSS CLEARING			(43.44)	0.00	0.00	(43.44)
34			Total:		Fund Balance				1,897,725.90	390,422.07	115,331.47	1,622,635.30
35	Revenue
36	10 5111					CURRENT TAXES			0.00	0.00	47,016.21	47,016.21
37	10 5112					DELINQUENT TAXES			0.00	0.00	212.09	212.09
38	10 5141					EARNINGS ON INVEST			0.00	0.00	13,163.22	13,163.22
39	10 5141 100					EARN ON INVEST-TRUST			0.00	0.00	235.77	235.77
40	10 5151					STUDENT MEALS			0.00	0.00	2,293.75	2,293.75
41	10 5161					ADULT MEALS			0.00	0.00	633.10	633.10
42	10 5165					NON-PROGRAM RECEIPTS			0.00	0.00	0.35	0.35
43	10 5181					CS PRESCHOOL TUITION			0.00	0.00	812.00	812.00
44	10 5198					MISC LOCAL REVENUE			0.00	0.00	500.00	500.00
45	10 5312					TRANSPORTATION REV			0.00	0.00	33,962.00	33,962.00
46	10 5412					MEDICAID			0.00	0.00	2,030.52	2,030.52
47	10 5422 000 0000 42205					ESSER III SUMMER SCHOOL GRANT			0.00	0.00	3,117.00	3,117.00
48	10 5442 000 0000 44200					ECSE FEDERAL			0.00	0.00	2,052.00	2,052.00
49	10 5492 000 0000 49200					REAP			0.00	0.00	8,405.20	8,405.20
50			Total:		Revenue				0.00	0.00	114,433.21	114,433.21
51	Expenditure
52	10 1111 6411 000 4020 1 00000					EL GEN SUPPLIES			0.00	13,670.05	318.13	13,351.92
53	10 1111 6412 000 4020 4 49200					EL TECH SUPP REAP			0.00	7,041.32	0.00	7,041.32
54	10 1111 6431 000 4020 1 00000					EL TEXTBOOK			0.00	13,189.21	80.00	13,109.21
55	10 1151 6343 000 1050 1 00000					HS TRAVEL			0.00	80.20	0.00	80.20
56	10 1151 6391 000 1050 1 00000					HS PURCHASE SERVICE			0.00	100.00	0.00	100.00
57	10 1151 6411 000 1050 1 00000					HS GEN SUPPLIES			0.00	17,791.66	0.00	17,791.66
58	10 1151 6412 000 1050 1 00000					HS TECH SUPPLIES			0.00	4,840.00	0.00	4,840.00
59	10 1151 6412 000 1050 4 49200					HS TECH SUPP REAP			0.00	4,604.14	0.00	4,604.14
60	10 1151 6431 000 1050 1 00000					HS TEXTBOOK			0.00	5,982.19	0.00	5,982.19
61	10 1221 6343 000 1050 3 12210					SE TRAVEL			0.00	25.60	0.00	25.60
62	10 1251 6151 000 4020 3 00000					SI ADMIN STIPEND			0.00	104.18	0.00	104.18
63	10 1251 6151 200 4020 4 45100					SI ADMIN STIPEND			0.00	145.82	0.00	145.82
64	10 1251 6221 000 4020 3 00000					SI ADMIN STIP NON TEACH RETIRE			0.00	7.14	0.00	7.14
65	10 1251 6221 200 4020 4 45100					SI ADMIN NON TEAC RET			0.00	10.00	0.00	10.00
66	10 1251 6231 000 4020 3 00000					SI ADMIN STIP SOC SEC			0.00	6.46	0.00	6.46
67	10 1251 6231 200 4020 4 45100					SI ADMIN STIP SOC SEC			0.00	9.04	0.00	9.04
68	10 1251 6232 000 4020 3 00000					SI ADMIN STIP MEDICARE			0.00	1.52	0.00	1.52
69	10 1251 6232 200 4020 4 45100					SI ADMN STIP MEDICARE			0.00	2.12	0.00	2.12
70	10 1251 6411 000 4020 4 45100					SI GEN SUPPLIES			0.00	4,614.01	0.00	4,614.01
71	10 1311 6343 000 1050 3 00000					VO AG TRAVEL			0.00	644.26	0.00	644.26
72	10 1311 6411 000 1050 1 00000					VO AG GEN SUPPLIES			0.00	3,829.79	0.00	3,829.79
73	10 1421 6131 000 1050 3 00000					ADP COACHING PAY			0.00	1,346.25	0.00	1,346.25
74	10 1421 6211 000 1050 3 00000					ADP TEACHER RETIREMEN			0.00	116.44	0.00	116.44
75	10 1421 6211 100 1050 1 00000					TEACHERS' RETIREMENT			0.00	0.00	0.00	0.00
76	10 1421 6221 000 1050 3 00000					ADP NON-TEACH RETIRE			0.00	5.72	0.00	5.72
77	10 1421 6221 100 1050 1 00000					NON-TEACHER RETIREMENT			0.00	0.00	0.00	0.00
78	10 1421 6231 000 1050 3 00000					ADP SOCIAL SECURITY			0.00	33.69	0.00	33.69
79	10 1421 6231 100 1050 1 00000					OASDI INSURANCE			0.00	0.00	0.00	0.00
80	10 1421 6232 000 1050 3 00000					ADP MEDICARE			0.00	19.51	0.00	19.51
81	10 1421 6232 100 1050 1 00000					MEDICARE			0.00	0.00	0.00	0.00
82	10 1421 6319 000 1050 1 00000					ADP OFFICIALS			0.00	5,789.00	0.00	5,789.00
83	10 1421 6319 100 1050 1 00000					ADP GATE/SCORE/CLOCK			0.00	0.00	0.00	0.00
84	10 1421 6343 000 1050 1 00000					ADP TRAVEL			0.00	86.40	0.00	86.40
85	10 1421 6391 000 1050 1 00000					ADP PURCHASE SERVICES			0.00	700.00	0.00	700.00
86	10 1421 6398 000 1050 1 00000					ADP ENTRY FEES			0.00	770.00	0.00	770.00
87	10 1421 6411 000 1050 1 00000					ADP GEN SUPPLIES			0.00	7,226.04	1,160.00	6,066.04
88	10 2125 6151 000 1050 3 00000					REC MAINT MOSIS STIP			0.00	117.50	0.00	117.50
89	10 2125 6151 000 4020 3 00000					REC MAINT MOSIS STIP			0.00	132.50	0.00	132.50
90	10 2125 6221 000 1050 3 00000					REC MAINT MOSIS RET			0.00	8.06	0.00	8.06
91	10 2125 6221 000 4020 3 00000					REC MAINT MOSIS RET			0.00	9.08	0.00	9.08
92	10 2125 6231 000 1050 3 00000					REC MAINT MOSIS SS			0.00	7.28	0.00	7.28
93	10 2125 6231 000 4020 3 00000					REC MAINT MOSIS SS			0.00	8.22	0.00	8.22
94	10 2125 6232 000 1050 3 00000					REC MAINT MOSIS MEDCR			0.00	1.70	0.00	1.70
95	10 2125 6232 000 4020 3 00000					REC MAINT MOSIS MEDCR			0.00	1.92	0.00	1.92
96	10 2134 6151 000 1050 3 00000					NU SALARY			0.00	1,290.00	0.00	1,290.00
97	10 2134 6151 000 4020 3 00000					NU SALARY			0.00	1,710.00	0.00	1,710.00
98	10 2134 6221 000 1050 3 00000					NU NON-TEA RETIREMENT			0.00	0.00	0.00	0.00
99	10 2134 6221 000 4020 3 00000					NU NON-TEA RETIREMENT			0.00	0.00	0.00	0.00
100	10 2134 6231 000 1050 3 00000					NU SOCIAL SECURITY			0.00	79.98	6.05	73.93