Ledger Report December 2023.xlsx

	A	C	F	I	L	R	S	T	U	W	Y	AA	AC
1	School Dist. 4 Bevier Cons.						Ledger Report with Fund Totals for Missouri						Page: 1
2	01/03/2024 11:39 AM				Exclude Accounts with No Activity; Processing Month 12/2023								User ID: CLC
3	Chart of Account Number			Account Description		Type		Budget	Year to Date	Encumbrances	Budget Balance	% of Budget	Current Month
4	Current Assets
5	10 1111			CASH IN BANK- MA BANK		1		0.00	165,170.95	0.00	(165,170.95)	0.00	80,057.37
6	20 1111			CASH IN BANK- MA BANK		1		0.00	(82,183.33)	0.00	82,183.33	0.00	(80,420.70)
7	40 1111			CASH IN BANK- MA BANK		1		0.00	60,027.81	0.00	(60,027.81)	0.00	60.71
8	50 1111			CASH IN BANK- MA BANK		1		0.00	(11,522.19)	0.00	11,522.19	0.00	(4,211.47)
9	60 1111			CASH IN BANK- MA BANK		1		0.00	83,867.08	0.00	(83,867.08)	0.00	(6,649.09)
10		Subtotal:	1111					0.00	215,360.32	0.00	(215,360.32)	0.00	(11,163.18)
11	10 1132			PETTY CASH		1		0.00	800.00	0.00	(800.00)	0.00	0.00
12		Subtotal:	1132					0.00	800.00	0.00	(800.00)	0.00	0.00
13	10 1141			SAVINGS-MOCAAT		1		0.00	922,050.90	0.00	(922,050.90)	0.00	4,120.71
14	40 1141			SAVINGS-MOCAAT		1		0.00	12,108.04	0.00	(12,108.04)	0.00	54.27
15		Subtotal:	1141					0.00	934,158.94	0.00	(934,158.94)	0.00	4,174.98
16	10 1142			TREASURY BILL		1		0.00	249,303.69	0.00	(249,303.69)	0.00	0.00
17	40 1142			TREASURY BILL		1		0.00	249,641.60	0.00	(249,641.60)	0.00	0.00
18		Subtotal:	1142					0.00	498,945.29	0.00	(498,945.29)	0.00	0.00
19	10 1143			CASH IN BANK-BANK NC		1		0.00	7,461.48	0.00	(7,461.48)	0.00	2,029.14
20	20 1143			CASH IN BANK -BANK NC		1		0.00	135.00	0.00	(135.00)	0.00	135.00
21	40 1143			CASH IN BANK -BANK NC		1		0.00	0.00	0.00	0.00	0.00	0.00
22	50 1143			CASH IN BANK- BANK NC		1		0.00	2,249.00	0.00	(2,249.00)	0.00	2,154.45
23	60 1143			CASH IN BANK- BANK NC		1		0.00	8,608.15	0.00	(8,608.15)	0.00	8,474.82
24		Subtotal:	1143					0.00	18,453.63	0.00	(18,453.63)	0.00	12,793.41
25		Total:	Current Assets					0.00	1,667,718.18	0.00	(1,667,718.18)	0.00	5,805.21
26	Current Liabilities
27	10 2151			FED WITHOD PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
28	20 2151			FED WITHOD PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
29	50 2151			FEDERAL INCOME TAXES PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
30		Subtotal:	2151					0.00	0.00	0.00	0.00	0.00	0.00
31	10 2152			SOC SEC PAYABLE		4		0.00	0.28	0.00	(0.28)	0.00	0.00
32	20 2152			SOC SEC PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
33	50 2152			SOCIAL SECURITY PAYABLE		4		0.00	(2.42)	0.00	2.42	0.00	0.00
34		Subtotal:	2152					0.00	(2.14)	0.00	2.14	0.00	0.00
35	10 2153			MO INCOME TAX PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
36	20 2153			MO INCOME TAX PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
37		Subtotal:	2153					0.00	0.00	0.00	0.00	0.00	0.00
38	10 2154			GROUP INSUR PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
39	20 2154			GROUP INSUR PAYABLE		4		0.00	4.00	0.00	(4.00)	0.00	0.00
40	50 2154			GROUP INSURANCE PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
41		Subtotal:	2154					0.00	4.00	0.00	(4.00)	0.00	0.00
42	10 2158			TEA RETIRE PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
43	20 2158			TEA RETIRE PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
44		Subtotal:	2158					0.00	0.00	0.00	0.00	0.00	0.00
45	10 2159			NON TEA RET PAYABLE		4		0.00	0.01	0.00	(0.01)	0.00	0.00
46	20 2159			NON-TEA RET PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
47	50 2159			NON-TEACHER RETIREMENT PAY		4		0.00	0.00	0.00	0.00	0.00	0.00
48		Subtotal:	2159					0.00	0.01	0.00	(0.01)	0.00	0.00
49	10 2161			HSA CONTRIBUTIONS PAY		4		0.00	0.00	0.00	0.00	0.00	0.00
50	School Dist. 4 Bevier Cons.						Ledger Report with Fund Totals for Missouri						Page: 2
51	01/03/2024 11:39 AM				Exclude Accounts with No Activity; Processing Month 12/2023								User ID: CLC
52	Chart of Account Number			Account Description		Type		Budget	Year to Date	Encumbrances	Budget Balance	% of Budget	Current Month
53	20 2161			HSA CONTRIBUTIONS PAY		4		0.00	0.00	0.00	0.00	0.00	0.00
54	50 2161			HSA CONTRIBUTIONS PAY		4		0.00	0.00	0.00	0.00	0.00	0.00
55		Subtotal:	2161					0.00	0.00	0.00	0.00	0.00	0.00
56	10 2162			ANNUITIES PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
57	20 2162			ANNUITIES PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
58	50 2162			ANNUITIES PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
59		Subtotal:	2162					0.00	0.00	0.00	0.00	0.00	0.00
60	10 2163			MISC DEDUCT PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
61	20 2163			MISC DEDUCT PAYABLE		4		0.00	0.00	0.00	0.00	0.00	0.00
62		Subtotal:	2163					0.00	0.00	0.00	0.00	0.00	0.00
63		Total:	Current Liabilities					0.00	1.87	0.00	(1.87)	0.00	0.00
64	Fund Balance
65	10 3111			FUND BALANCE		7		0.00	1,344,786.73	0.00	(1,344,786.73)	0.00	86,207.22
66	20 3111			FUND BALANCE		7		0.00	(82,052.33)	0.00	82,052.33	0.00	(80,285.70)
67	40 3111			FUND BALANCE		7		0.00	321,777.45	0.00	(321,777.45)	0.00	114.98
68	50 3111			FUND BALANCE		7		0.00	(9,270.77)	0.00	9,270.77	0.00	(2,057.02)
69	60 3111 000 003			CLASS OF 2022		7		0.00	(96.60)	0.00	96.60	0.00	0.00
70	60 3111 000 004			CLASS OF 2023		7		0.00	460.79	0.00	(460.79)	0.00	0.00
71	60 3111 000 005			CLASS OF 2024		7		0.00	923.68	0.00	(923.68)	0.00	0.00
72	60 3111 000 006			CLASS OF 2025		7		0.00	2,772.07	0.00	(2,772.07)	0.00	0.00
73	60 3111 000 007			CLASS OF 2026		7		0.00	2,122.00	0.00	(2,122.00)	0.00	0.00
74	60 3111 000 008			BASEBALL		7		0.00	509.28	0.00	(509.28)	0.00	0.00
75	60 3111 000 009			SR CHEERLEADERS		7		0.00	76.33	0.00	(76.33)	0.00	(389.61)
76	60 3111 000 010			SCIENCE CLUB		7		0.00	7.26	0.00	(7.26)	0.00	0.00
77	60 3111 000 011			STUDENT COUNCIL		7		0.00	506.53	0.00	(506.53)	0.00	270.30
78	60 3111 000 012			VARSITY CLUB		7		0.00	1,104.47	0.00	(1,104.47)	0.00	187.30
79	60 3111 000 014			ACADEMIC BOWL		7		0.00	510.00	0.00	(510.00)	0.00	0.00
80	60 3111 000 015			MISCELLANEOUS ACCT		7		0.00	524.63	0.00	(524.63)	0.00	100.00
81	60 3111 000 018			ART CLUB		7		0.00	1,902.97	0.00	(1,902.97)	0.00	0.00
82	60 3111 000 019			ACADEMIC BOWL		7		0.00	(3.26)	0.00	3.26	0.00	0.00
83	60 3111 000 026			NHS		7		0.00	3,419.92	0.00	(3,419.92)	0.00	465.57
84	60 3111 000 030			LIBRARY		7		0.00	890.49	0.00	(890.49)	0.00	0.00
85	60 3111 000 031			SR GIRL BASKETBALL		7		0.00	139.50	0.00	(139.50)	0.00	0.00
86	60 3111 000 034			YEARBOOK		7		0.00	20,687.05	0.00	(20,687.05)	0.00	662.00
87	60 3111 000 036			MAP CLUB		7		0.00	770.16	0.00	(770.16)	0.00	0.00
88	60 3111 000 039			COUNTRY MART CARD		7		0.00	5,862.09	0.00	(5,862.09)	0.00	0.00
89	60 3111 000 040			TECHNOLOGY FUND		7		0.00	1,623.50	0.00	(1,623.50)	0.00	0.00
90	60 3111 000 044			ELEMENTARY FUND		7		0.00	1,830.31	0.00	(1,830.31)	0.00	1,050.00
91	60 3111 000 049			ELEMENTARY FUND		7		0.00	(425.07)	0.00	425.07	0.00	(637.62)
92	60 3111 000 054			WEIGHT ROOM		7		0.00	151.53	0.00	(151.53)	0.00	0.00
93	60 3111 000 057			CLASS OF 2008		7		0.00	31.32	0.00	(31.32)	0.00	0.00
94	60 3111 000 059			SR BOYS BASKETBALL		7		0.00	203.67	0.00	(203.67)	0.00	0.00
95	60 3111 000 060			CLASS OF 2007		7		0.00	458.03	0.00	(458.03)	0.00	0.00
96	60 3111 000 066			SCIENCE		7		0.00	210.01	0.00	(210.01)	0.00	0.00
97	60 3111 000 069			TRACK		7		0.00	878.38	0.00	(878.38)	0.00	0.00
98	60 3111 000 070			CLASS OF 2005		7		0.00	468.91	0.00	(468.91)	0.00	0.00
99	60 3111 000 071			MS STUDENT COUNCIL		7		0.00	1,864.39	0.00	(1,864.39)	0.00	0.00
100	60 3111 000 073			FFA		7		0.00	5,937.85	0.00	(5,937.85)	0.00	(2,300.71)