Excel 102 - 2019_Budget Line by Line Detail.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1	AccountNumber	Fund	Fund Name	Dept	Dept Name	ELEMENT3NUMBER	ELEMENT4NUMBER	Acct #	Acct Name	ELEMENT6NUMBER	Acct Desc	ACCOUNTTYPECODE	FIRSTNUMBERINRANGE	LASTNUMBERINRANGE	RANGEDESCRIPTION	2016 History	2017 History	2018 History	2019 Actual	2019 Budget^	LASTUPDATEDTIMESTAMP	LASTUPDATEDBY	REPORTKEY
2	01-005-000-0000-6103	1		5		0	0	6103			Salaries & Wages	6	6100	6199	Personnel Expenses	110074	112168	115014	63520	118342	23:15.9	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
3	01-005-000-0000-6105	1		5		0	0	6105			Salaries & Wages-Com Per Diems	6	6100	6199	Personnel Expenses	18400	21200	21650	12700	25000	23:16.0	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
4	01-005-000-0000-6150	1		5		0	0	6150			Life Insurance - County Share	6	6100	6199	Personnel Expenses	278	204	204	102	204	23:16.1	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
5	01-005-000-0000-6152	1		5		0	0	6152			Dental Insurance - County Share	6	6100	6199	Personnel Expenses	2520	2520	2520	1260	2520	23:16.1	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
6	01-005-000-0000-6153	1		5		0	0	6153			Health Insurance - County Share	6	6100	6199	Personnel Expenses	71454	72139	76785	52404	81994	23:16.1	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
7	01-005-000-0000-6163	1		5		0	0	6163			Pera - County Share	6	6100	6199	Personnel Expenses	7002	6710	6833	3811	7167	23:16.1	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
8	01-005-000-0000-6175	1		5		0	0	6175			Fica - County Share	6	6100	6199	Personnel Expenses	2368	1285	1057	577	1770	23:16.1	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
9	01-005-000-0000-6176	1		5		0	0	6176			Medicare/County Share	6	6100	6199	Personnel Expenses	1344	1484	1483	822	2078	23:16.2	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
10	01-005-000-0000-6201	1		5		0	0	6201			Telephone	6	6200	6599	Operating Expenses	2102	2910	2940	1575	3200	23:16.2	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
11	01-005-000-0000-6240	1		5		0	0	6240			Advertising	6	6200	6599	Operating Expenses	13466	11161	13270	6786	12000	23:16.2	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
12	01-005-000-0000-6241	1		5		0	0	6241			Conference Registration & Dues	6	6200	6599	Operating Expenses	3834	4279	8129	2264	7000	23:16.2	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
13	01-005-000-0000-6260	1		5		0	0	6260			Prof & Tech Services	6	6200	6599	Operating Expenses	5987	0	1213	152	1500	23:16.2	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
14	01-005-000-0000-6330	1		5		0	0	6330			Travel Expenses	6	6200	6599	Operating Expenses	8977	10684	14143	6308	12000	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
15	01-005-000-0000-6379	1		5		0	0	6379			Other Misc Charges	6	6200	6599	Operating Expenses	44	25	50227	0	100	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
16	01-005-000-0000-6401	1		5		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	690	1539	314	355	500	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
17	01-005-000-0000-6660	1		5		0	0	6660			Equipment & Machinery ($500 Or More)	6	6600	6698	Capital Expenditures	27	2476	1726	0	3000	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
18	01-010-000-0000-5559	1		10		0	0	5559			Misc Revenues/Recoveries	5	5000	5999	Revenues	-600	-300	-600	-600	-600	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
19	01-010-000-0000-6260	1		10		0	0	6260			Prof & Tech Services	6	6200	6599	Operating Expenses	37153	44702	47377	41871	40000	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
20	01-035-000-0000-5101	1		35		0	0	5101			Fees For Services	5	5000	5999	Revenues	-41	0	0	0	0	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
21	01-035-000-0000-6103	1		35		0	0	6103			Salaries And Wages	6	6100	6199	Personnel Expenses	274191	291483	288274	173135	316814	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
22	01-035-000-0000-6107	1		35		0	0	6107			Salaries And Wages-Overtime	6	6100	6199	Personnel Expenses	3390	1971	5933	3028	4000	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
23	01-035-000-0000-6150	1		35		0	0	6150			Life Insurance-County Share	6	6100	6199	Personnel Expenses	266	191	188	-476	235	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
24	01-035-000-0000-6152	1		35		0	0	6152			Dental Insurance-County Share	6	6100	6199	Personnel Expenses	2384	2394	2311	1197	2898	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
25	01-035-000-0000-6153	1		35		0	0	6153			Health Insurance-County Share	6	6100	6199	Personnel Expenses	56067	58383	75149	53193	83819	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
26	01-035-000-0000-6163	1		35		0	0	6163			Pera-County Share	6	6100	6199	Personnel Expenses	21002	22010	22067	13213	24061	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
27	01-035-000-0000-6175	1		35		0	0	6175			Fica-County Share	6	6100	6199	Personnel Expenses	16529	17152	16470	9886	19891	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
28	01-035-000-0000-6176	1		35		0	0	6176			Medicare-County Share	6	6100	6199	Personnel Expenses	3867	4011	3853	2313	4652	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
29	01-035-000-0000-6201	1		35		0	0	6201			Telephone	6	6200	6599	Operating Expenses	2001	2388	1902	988	2500	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
30	01-035-000-0000-6202	1		35		0	0	6202			Postage	6	6200	6599	Operating Expenses	1715	1612	1568	0	1800	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
31	01-035-000-0000-6240	1		35		0	0	6240			Advertising	6	6200	6599	Operating Expenses	0	0	0	369	0	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
32	01-035-000-0000-6241	1		35		0	0	6241			Conference Registration/Dues & Lodging	6	6200	6599	Operating Expenses	5405	8501	4002	3310	8000	23:16.3	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
33	01-035-000-0000-6260	1		35		0	0	6260			Professional & Technical Fees	6	6200	6599	Operating Expenses	3292	3429	31662	2059	5000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
34	01-035-000-0000-6310	1		35		0	0	6310			Equipment Repairs & Maintenance	6	6200	6599	Operating Expenses	75	0	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
35	01-035-000-0000-6330	1		35		0	0	6330			Travel Expense	6	6200	6599	Operating Expenses	2056	3872	3647	1767	3500	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
36	01-035-000-0000-6340	1		35		0	0	6340			Rentals And Service Agreements	6	6200	6599	Operating Expenses	0	0	57	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
37	01-035-000-0000-6379	1		35		0	0	6379			Other Misc Charges	6	6200	6599	Operating Expenses	306	22	130	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
38	01-035-000-0000-6401	1		35		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	931	1558	784	2936	1000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
39	01-035-000-0000-6660	1		35		0	0	6660			Equipment & Machinery ($500 Or More)	6	6600	6698	Capital Expenditures	1556	10498	1895	3187	4000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
40	01-051-000-0000-6260	1		51		0	0	6260			Professional & Technical Fees	6	6200	6599	Operating Expenses	290	6550	3350	3350	6500	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
41	01-051-000-0000-6269	1		51		0	0	6269			Independent Auditing	6	6200	6599	Operating Expenses	37302	37056	34000	9000	35000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
42	01-060-000-0000-6010	1		60		0	0	6010			Reimbursed Expenditures	6	6000	6099	Public Assistance	-3916	-3194	-3663	-84	-3000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
43	01-060-000-0000-6270	1		60		0	0	6270			Data Processing Services	6	6200	6599	Operating Expenses	54889	56614	60516	44277	60327	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
44	01-060-000-0000-6340	1		60		0	0	6340			Rentals & Service Agreements	6	6200	6599	Operating Expenses	16347	15047	19531	8347	32452	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
45	01-060-000-0000-6401	1		60		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	516	572	1181	0	500	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
46	01-060-000-0000-6665	1		60		0	0	6665			Technology Fund Expenditures	6	6600	6698	Capital Expenditures	0	0	175000	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
47	01-060-000-0000-6685	1		60		0	0	6685			Software & Programing Upgrades	6	6600	6698	Capital Expenditures	10000	10000	10000	10000	10000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
48	01-061-000-0000-5103	1		61		0	0	5103			Filing Fees	5	5000	5999	Revenues	-290	0	-290	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
49	01-061-000-0000-5328	1		61		0	0	5328			MN Sec. of State	5	5000	5999	Revenues	0	0	-55740	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
50	01-061-000-0000-5559	1		61		0	0	5559			Misc Revenues	5	5000	5999	Revenues	-240	-1441	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
51	01-061-000-0000-5591	1		61		0	0	5591			Interest Income	5	5000	5999	Revenues	-61	-70	-72	-35	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
52	01-061-000-0000-6010	1		61		0	0	6010			Reimburse Expenditures	6	6000	6099	Public Assistance	-3413	0	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
53	01-061-000-0000-6202	1		61		0	0	6202			Postage	6	6200	6599	Operating Expenses	1978	342	1700	125	500	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
54	01-061-000-0000-6240	1		61		0	0	6240			Advertising	6	6200	6599	Operating Expenses	1950	0	1479	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
55	01-061-000-0000-6330	1		61		0	0	6330			Travel Expenses	6	6200	6599	Operating Expenses	1261	0	1365	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
56	01-061-000-0000-6340	1		61		0	0	6340			Rentals And Service Agreements	6	6200	6599	Operating Expenses	1232	0	1532	4933	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
57	01-061-000-0000-6379	1		61		0	0	6379			Other Misc Charges	6	6200	6599	Operating Expenses	0	397	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
58	01-061-000-0000-6384	1		61		0	0	6384			Misc. Grant Expenses	6	6200	6599	Operating Expenses	15457	5038	13173	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
59	01-061-000-0000-6401	1		61		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	16348	26	16858	0	20000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
60	01-061-000-0000-6660	1		61		0	0	6660			Equipment & Machinery ($500 Or More)	6	6600	6698	Capital Expenditures	0	0	61300	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
61	01-062-000-0000-6201	1		62		0	0	6201			Telephone	6	6200	6599	Operating Expenses	1756	2055	40	4378	2000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
62	01-062-000-0000-6202	1		62		0	0	6202			Postage	6	6200	6599	Operating Expenses	-1426	-218	586	4839	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
63	01-062-000-0000-6241	1		62		0	0	6241			Conference Registration & Dues	6	6200	6599	Operating Expenses	7850	8183	8601	9212	9212	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
64	01-062-000-0000-6260	1		62		0	0	6260			Professional & Technical Fees	6	6200	6599	Operating Expenses	1785	1183	1293	0	1000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
65	01-062-000-0000-6290	1		62		0	0	6290			Employee Training	6	6200	6599	Operating Expenses	0	1400	3059	1000	1000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
66	01-062-000-0000-6340	1		62		0	0	6340			Rentals & Service Agreements	6	6200	6599	Operating Expenses	4618	4387	3148	3207	5200	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
67	01-062-000-0000-6374	1		62		0	0	6374			Ditch Repair Liens	6	6200	6599	Operating Expenses	0	0	0	44	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
68	01-062-000-0000-6379	1		62		0	0	6379			Other Misc Charges	6	6200	6599	Operating Expenses	279	6455	0	343	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
69	01-062-000-0000-6401	1		62		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	798	600	792	310	750	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
70	01-062-000-0000-6403	1		62		0	0	6403			Copier Supplies	6	6200	6599	Operating Expenses	965	1185	388	0	1000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
71	01-062-000-0000-6566	1		62		0	0	6566			Vehicle Expenses	6	6200	6599	Operating Expenses	50	150	32	0	300	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
72	01-062-000-0000-6660	1		62		0	0	6660			Equipment & Machinery ($500 Or More)	6	6600	6698	Capital Expenditures	1125	0	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
73	01-062-000-0000-6707	1		62		0	0	6707			Capital Lease Payments	6	6699	6799	Debt Services	1643	3781	2181	1785	2380	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
74	01-062-000-0000-6710	1		62		0	0	6710			Capital Lease Interest	6	6699	6799	Debt Services	94	0	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
75	01-063-000-0000-5094	1		63		0	0	5094			Parcel Data License Fee	5	5000	5999	Revenues	-700	-700	-350	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
76	01-063-000-0000-6260	1		63		0	0	6260			Professional Svc-Technical Support	6	6200	6599	Operating Expenses	7303	1310	3634	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
77	01-063-000-0000-6273	1		63		0	0	6273			Gis Services	6	6200	6599	Operating Expenses	255	1700	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
78	01-063-000-0000-6340	1		63		0	0	6340			Rentals And Service Agreements	6	6200	6599	Operating Expenses	27266	44500	51541	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
79	01-063-000-0000-6401	1		63		0	0	6401			Office Supplies	6	6200	6599	Operating Expenses	50	0	25	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
80	01-063-000-0000-6660	1		63		0	0	6660			Equipment & Machinery ($500 Or More)	6	6600	6698	Capital Expenditures	156248	67227	45764	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
81	01-065-000-0000-5559	1		65		0	0	5559			Misc Revenues	5	5000	5999	Revenues	-4640	-5185	0	0	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
82	01-065-000-0000-6103	1		65		0	0	6103			Salaries And Wages	6	6100	6199	Personnel Expenses	0	0	0	6392	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
83	01-065-000-0000-6107	1		65		0	0	6107			Salaries And Wages-Overtime	6	6100	6199	Personnel Expenses	0	0	0	26	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
84	01-065-000-0000-6112	1		65		0	0	6112			Flexible Benefits Costs	6	6100	6199	Personnel Expenses	1528	3063	3033	1574	3000	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
85	01-065-000-0000-6113	1		65		0	0	6113			Flexible Benefit Loan	6	6100	6199	Personnel Expenses	0	0	0	30000	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
86	01-065-000-0000-6150	1		65		0	0	6150			Life Insurance-County Share	6	6100	6199	Personnel Expenses	0	0	0	-9	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
87	01-065-000-0000-6152	1		65		0	0	6152			Dental Insurance-County Share	6	6100	6199	Personnel Expenses	0	0	0	-32	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
88	01-065-000-0000-6153	1		65		0	0	6153			Health Insurance-County Share	6	6100	6199	Personnel Expenses	6952	-2045	0	2519	550	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
89	01-065-000-0000-6154	1		65		0	0	6154			Non-Working Paid-In Insurance	6	6100	6199	Personnel Expenses	87482	87130	103632	55113	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
90	01-065-000-0000-6155	1		65		0	0	6155			HealthPart Insurance Allocation	6	6100	6199	Personnel Expenses	1390928	1340067	1542186	850284	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
91	01-065-000-0000-6156	1		65		0	0	6156			Reimbursements-Insurance & Benefits	6	6100	6199	Personnel Expenses	-88553	-79498	-122639	-37085	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
92	01-065-000-0000-6157	1		65		0	0	6157			HealthPart Insurance Receipts	6	6100	6199	Personnel Expenses	-1461027	-1350350	-1525500	-798699	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
93	01-065-000-0000-6158	1		65		0	0	6158			Delta Dental Receipts	6	6100	6199	Personnel Expenses	-89218	-90101	-90740	-46297	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
94	01-065-000-0000-6159	1		65		0	0	6159			Delta Dental Allocation	6	6100	6199	Personnel Expenses	89349	90101	83290	53666	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
95	01-065-000-0000-6163	1		65		0	0	6163			Pera-County Share	6	6100	6199	Personnel Expenses	0	0	0	481	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
96	01-065-000-0000-6175	1		65		0	0	6175			Fica-County Share	6	6100	6199	Personnel Expenses	0	0	0	362	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
97	01-065-000-0000-6176	1		65		0	0	6176			Medicare-County Share	6	6100	6199	Personnel Expenses	0	0	0	85	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
98	01-065-000-0000-6177	1		65		0	0	6177			Unemployment	6	6100	6199	Personnel Expenses	0	72	9426	5829	0	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
99	01-065-000-0000-6179	1		65		0	0	6179			Worker's Compensation	6	6100	6199	Personnel Expenses	30811	42372	34615	40197	40197	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019
100	01-065-000-0000-6199	1		65		0	0	6199			Dental Deductible	6	6100	6199	Personnel Expenses	63	0	25	50	100	23:16.4	YMLACEY	Tue Jul 09 07:23:08 CDT 2019