Trial Balance Mar 2023.xlsx

	A	B	C	D	F	I	L	S	T	W	Y
1	School District R2 Wheatland						Trial Balance Report
2							07/2022- 03/2023
3
4	Fund:	10		GENERAL
5								Beginning Balance	Debits	Credits	Ending Balance
6	Current Assets
7	10 1111					CASH IN BANK		915,802.94	1,672,183.89	1,187,272.00	1,400,714.83
8	10 1131					CASH ON HAND		500.00	0.00	0.00	500.00
9	10 1141 100					TRUST ACCT SAVINGS		27,673.01	232.38	0.00	27,905.39
10	10 1141 300					ACTIVITIES ACCOUNT		1,309.08	13,135.33	12,190.40	2,254.01
11	10 1141 592					CD 136592		65,625.99	793.43	0.00	66,419.42
12	10 1141 593					CD 136593		66,095.53	799.10	0.00	66,894.63
13	10 1141 594					CD 136594		65,658.31	793.82	0.00	66,452.13
14	10 1141 973					CD 131973		610,001.40	5,537.40	0.00	615,538.80
15			Total:		Current Assets			1,752,666.26	1,693,475.35	1,199,462.40	2,246,679.21
16	Current Liabilities
17	10 2151					FED WITHOD PAYABLE		0.00	15,195.41	15,195.41	0.00
18	10 2152					OASDI PAYABLE		0.00	38,463.54	38,463.54	0.00
19	10 2153					MEDICARE TAX PAYABLE		0.00	9,118.16	9,118.16	0.00
20	10 2154					MO INCOME TAX PAYABLE		0.00	6,158.69	6,158.69	0.00
21	10 2154 006					AFA INSURANCE		0.00	1,915.90	1,915.90	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,000.00	1,000.00	0.00
24	10 2154 026					TEXAS LIFE		0.00	280.80	280.80	0.00
25	10 2154 052					HICKORY COUNTY CIRCUIT COURT		0.00	445.33	445.33	0.00
26	10 2154 054					BAILY LAW FIRM		0.00	582.40	582.40	0.00
27	10 2157					ANTHEM INSURANCE		(1,034.69)	78,417.06	78,417.06	(1,034.69)
28	10 2158					TEA RETIRE PAYABLE		0.00	1,287.22	1,287.22	0.00
29	10 2159					NON TEA RET PAYABLE		(123.40)	50,576.32	50,576.32	(123.40)
30	10 2165					MSTA		0.00	180.00	180.00	0.00
31			Total:		Current Liabilities			(1,157.94)	203,620.83	203,620.83	(1,157.94)
32	Fund Balance
33	10 3111					FUND BALANCE		1,753,867.64	1,196,963.71	1,690,976.66	2,247,880.59
34	10 3321					INS LOSS CLEARING		(43.44)	0.00	0.00	(43.44)
35			Total:		Fund Balance			1,753,824.20	1,196,963.71	1,690,976.66	2,247,837.15
36	Revenue
37	10 5111					CURRENT TAXES		0.00	0.00	1,233,108.91	1,233,108.91
38	10 5112					DELINQUENT TAXES		0.00	0.00	46,134.65	46,134.65
39	10 5114					FINANCE INST TAXES		0.00	0.00	82.45	82.45
40	10 5115					M & M SURTAX		0.00	0.00	11,317.57	11,317.57
41	10 5141					EARNINGS ON INVEST		0.00	0.00	20,285.09	20,285.09
42	10 5141 100					EARN ON INVEST-TRUST		0.00	0.00	231.71	231.71
43	10 5151					STUDENT MEALS		0.00	0.00	14,881.20	14,881.20
44	10 5161					ADULT MEALS		0.00	0.00	723.20	723.20
45	10 5181					CS PRESCHOOL TUITION		0.00	0.00	5,420.00	5,420.00
46	10 5198					MISC LOCAL REVENUE		0.00	0.00	3,414.76	3,414.76
47	10 5221					RAILROAD, UTILITY TAX		0.00	0.00	50,187.67	50,187.67
48	10 5231					FLOOD CONTROL		0.00	0.00	1,358.46	1,358.46
49	10 5237					OTHER COUNTY REVENUE		0.00	0.00	453.64	453.64
50	10 5312					TRANSPORTATION REV		0.00	0.00	101,864.00	101,864.00
51	10 5314					ECSE EARLY CHILDHOOD		0.00	0.00	4,209.26	4,209.26
52	10 5412					MEDICAID		0.00	0.00	5,350.96	5,350.96
53	10 5422 000 0000 42205					ESSER III SUMMER SCHOOL GRANT		0.00	0.00	1,648.00	1,648.00
54	10 5442 000 0000 44200					ECSE FEDERAL		0.00	0.00	3,592.00	3,592.00
55	10 5445					FEDERAL LUNCH PROGRAM		0.00	0.00	48,984.04	48,984.04
56	10 5445 000 0000 44500					SCHOOL LUNCH PROGRAM		0.00	0.00	24,102.15	24,102.15
57	10 5446					FEDERAL BREAK PROGRAM		0.00	0.00	18,957.82	18,957.82
58	10 5446 000 0000 44600					SCHOOL BREAKFAST PROGRAM		0.00	0.00	9,263.85	9,263.85
59	10 5451 022 0000 45100					TITLE I		0.00	0.00	9,238.33	9,238.33
60	10 5451 023 0000 45100					TITLE I		0.00	0.00	23,650.95	23,650.95
61	10 5461 023 0000 46100					TITLE IV		0.00	0.00	367.56	367.56
62	10 5465 022 0000 46500					TITLE II.A		0.00	0.00	1,379.52	1,379.52
63	10 5465 023 0000 46500					TITLE II.A		0.00	0.00	6,468.23	6,468.23
64	10 5492 000 0000 49200					REAP		0.00	0.00	13,073.80	13,073.80
65			Total:		Revenue			0.00	0.00	1,659,749.78	1,659,749.78
66	Expenditure
67	10 1111 6311 000 4020 1 00000					EL PUR INSTR-TESTING		0.00	1,332.85	1,332.85	0.00
68	10 1111 6343 000 4020 1 00000					EL TRAVEL		0.00	23.62	0.00	23.62
69	10 1111 6371 000 4020 1 00000					EL DUES/MEMBERSHIPS		0.00	579.00	0.00	579.00
70	10 1111 6411 000 4020 1 00000					EL GEN SUPPLIES		0.00	12,065.52	124.04	11,941.48
71	10 1111 6411 000 4020 4 46100					EL TITLE IV GEN SUPP		0.00	784.02	0.00	784.02
72	10 1111 6412 000 4020 1 00000					EL TECH SUPPLIES		0.00	9,668.88	0.00	9,668.88
73	10 1111 6412 000 4020 4 49200					EL TECH SUPP REAP		0.00	6,639.40	0.00	6,639.40
74	10 1111 6431 000 4020 1 00000					EL TEXTBOOK		0.00	842.99	972.00	(129.01)
75	10 1151 6343 000 1050 1 00000					HS TRAVEL		0.00	2,351.23	0.00	2,351.23
76	10 1151 6371 000 1050 1 00000					HS DUES/MEMBERSHIPS		0.00	1,700.00	0.00	1,700.00
77	10 1151 6391 000 1050 1 00000					HS PURCHASE SERVICE		0.00	651.00	0.00	651.00
78	10 1151 6411 000 1050 1 00000					HS GEN SUPPLIES		0.00	35,185.44	365.15	34,820.29
79	10 1151 6412 000 1050 1 00000					HS TECH SUPPLIES		0.00	6,364.89	0.00	6,364.89
80	10 1151 6412 000 1050 4 49200					HS TECH SUPP REAP		0.00	2,829.30	0.00	2,829.30
81	10 1151 6431 000 1050 1 00000					HS TEXTBOOK		0.00	1,993.21	0.00	1,993.21
82	10 1221 6319 000 1050 3 12210					SE PROF SERVICE		0.00	125.00	0.00	125.00
83	10 1221 6343 000 1050 3 12210					SE TRAVEL		0.00	84.40	0.00	84.40
84	10 1221 6343 000 4020 3 12210					SE TRAVEL		0.00	156.40	0.00	156.40
85	10 1221 6411 000 1050 1 12210					SE GEN SUPPLIES		0.00	410.42	0.00	410.42
86	10 1221 6411 000 4020 1 12210					SE GEN SUPPLIES		0.00	410.43	0.00	410.43
87	10 1251 6151 000 4020 3 12210					SI ADMIN STIPEND		0.00	125.00	0.00	125.00
88	10 1251 6151 200 4020 4 45100					SI ADMIN STIPEND		0.00	875.00	8.58	866.42
89	10 1251 6221 000 4020 3 12210					SI ADMIN STIP NON TEACH RETIRE		0.00	17.16	0.00	17.16
90	10 1251 6221 200 4020 4 45100					SI ADMIN NON TEAC RET		0.00	60.06	0.00	60.06
91	10 1251 6231 000 4020 3 12210					SI ADMIN STIP SOC SEC		0.00	15.50	0.00	15.50
92	10 1251 6231 200 4020 4 45100					SI ADMIN STIP SOC SEC		0.00	54.25	7.75	46.50
93	10 1251 6232 000 4020 3 12210					SI ADMIN STIP MEDICARE		0.00	3.62	0.00	3.62
94	10 1251 6232 200 4020 4 45100					SI ADMN STIP MEDICARE		0.00	12.67	1.81	10.86
95	10 1251 6411 000 4020 4 45100					SI GEN SUPPLIES		0.00	27,204.71	3,538.30	23,666.41
96	10 1311 6411 000 1050 1 00000					VO AG GEN SUPPLIES		0.00	4,054.71	0.00	4,054.71
97	10 1331 6411 000 1050 1 00000					FACS GENERAL SUPPLIES		0.00	802.68	0.00	802.68
98	10 1421 6131 000 1050 3 00000					ADP COACHING PAY		0.00	2,305.72	0.00	2,305.72
99	10 1421 6131 100 1050 3 00000					ADP CERT GAME STIPEND		0.00	0.00	0.00	0.00
100	10 1421 6211 100 1050 1 00000					TEACHERS' RETIREMENT		0.00	163.09	0.00	163.09