{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2024 Budget"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"2024 Budget","index":0,"n_rows":151,"n_cols":5,"rows_kept":151,"cut":false,"hidden":false,"merged":[]}
[null,"2024","2024","2025"]
[null,"Budget","Actual","Budget"]
["      40102 General Offering",920000,975553.84,990000,"+1.5%"]
["      40104 Loose Offering",16000,17780.419999999998,18000]
["      40110 Mission Offering",9200,12162.74,12000]
["      40112 Children's Offering",2300,1257.71,1300]
["      40114 Pastors' Discretionary Offerings",0,8323,3400]
["   Total Offering",{"$f":"SUM(B3:B7)","v":947500},1015077.71,1024700]
["   Miscellaneous Receipts"]
["      40119 Miscellaneous Receipts",0,468,0]
["      40123 Interest on Investment Acct",6000,13146.73,5000]
["      40125 Released from Restricted Accounts",4600,0,0]
["      40130 Space Fees",2600,1950,2600]
["      40140 Retreat Receipts",5000,0,0]
["      40143 Connections Receipts",1300,596.51,500]
["   Total Miscellaneous Receipts",{"$f":"SUM(B10:B15)","v":19500},16161.24,8100]
["   Christian Education Receipts"]
["      40134 Other Christian Ed Receipts",4550,1020,1200]
["      40136 Vacation Bible School Receipts",2500,2120,2250]
["      40138 BYG Registration & Fees",3500,2350,2500]
["      40139 SPARK Receipts",9750,7125,7500]
["   Total Christian Education Receipts",{"$f":"SUM(B18:B21)","v":20300},{"$f":"SUM(C18:C21)","v":12615},{"$f":"SUM(D18:D21)","v":13450}]
["   Youth Receipts"]
["      40135 Confirmation Receipts",17750,21125,18000]
["      40476 Youth Trips",4000,0,4000]
["      40478 Summer Stretch Receipts",8250,7350.99,8250]
["      40479 Common Hope Sponsorship",850,822.26,840]
["      40480 Other Youth Receipts",480,360,250]
["      40491 Soup Suppers",2500,1502,2000]
["   Total Youth Receipts",{"$f":"SUM(B24:B29)","v":33830},{"$f":"SUM(C24:C29)","v":31160.249999999996},{"$f":"SUM(D24:D29)","v":33340}]
["Total Revenues",{"$f":"B8+B16+B22+B30","v":1021130},{"$f":"C8+C16+C22+C30","v":1075014.2},{"$f":"D8+D16+D22+D30","v":1079590}]
["Expenses"]
["   Benevolence/Social Outreach"]
["      60102 Mission Support - ELCA",19300,19300,20000]
["      60108 Redeemer Lutheran Church",0,790.81,1000]
["      60110 Southern Valley Alliance",1000,1000,1000]
["      60112 Unallocated 2024",9000,0,4000]
["      60116 ELCA World Hunger et al",1000,1100,1000]
["      60118 Misc Other Donations",0,2440,500]
["      60130 Waconia United Food Shelf",2000,3030.42,2000]
["      60132 Green Lake Lutheran Ministries",0,1000,1000]
["      60135 Public Safety Ministries",3000,3000,3000]
["      60137 Common Hope",500,687.25,500]
["      60138 Cristo Obrero",5500,6364.3,5500]
["      60140 Camperships",1000,0,1000]
["      60146 Lutheran Campus Ministry TC",1000,1440,1500]
["      60154 Love Inc",1500,1933.44,4000]
["      60156 Pastors' Discretionary Outreach",0,8604.7199999999993,3500]
["   Total Benevolence/Social Outreach",{"$f":"SUM(B34:B48)","v":44800},{"$f":"SUM(C34:C48)","v":50690.94000000001},{"$f":"SUM(D34:D48)","v":49500}]
["   Christian Education"]
["      60404 SPARK Supplies (delete)",0,2014.33,0]
["      60405 SPARK Bibles",500,406.7,500]
["      60408 Baptism/First Communion",700,267.20999999999998,500]
["      60410 BYG Supplies (delete)",0,99.71,0]
["      60412 BYG Bibles",750,0,750]
["      60416 SPARK Expenses",3300,364.82,2400]
["      60418 BYG Expenses",5225,540.22,1200]
["      60424 Vacation Bible School",1900,1903.26,1900]
["      60442 Christian Education Other",900,917.44,600]
["   Total Christian Education",{"$f":"SUM(B51:B59)","v":13275},{"$f":"SUM(C51:C59)","v":6513.6900000000005},{"$f":"SUM(D51:D59)","v":7850}]
["   Youth Expenses"]
["      60414 Confirmation",16000,15547.97,14000]
["      60820 Soup Suppers",2500,1954.62,2000]
["      62006 Youth Trips",4000,0,4000]
["      62007 Common Hope Sponsorship",780,835,840]
["      62008 Summer Stretch Expenses",8000,6879.83,8250]
["      62009 Glow",1000,1004.7,1200]
["      62010 Other Youth Expenses",2500,1821.11,2500]
["   Total Youth Expenses",{"$f":"SUM(B62:B68)","v":34780},{"$f":"SUM(C62:C68)","v":28043.23},{"$f":"SUM(D62:D68)","v":32790}]
["   Worship/Music"]
["      60700 Worship/Music Budget",1500,2968.73,2800]
["      60722 Altar Supplies",1050,1404.43,1500]
["      60728 Contemporary Worship",500,1780.23,500]
["      60730 Copy Rights",1700,1598.75,1700]
["      60731 The Youth Choir",50,0,50]
["      60732 Faith Choir",700,141.47999999999999,700]
["      60734 Handbells",300,301.42,300]
["      60736 Piano Tuning",500,655,700]
["      60740 Worship Events",300,315.49,250]
["      60742 Summer Worship",3000,2211.6799999999998,2500]
["      60744 Guest Musicians",2500,3650,3000]
["   Total Worship/Music",{"$f":"SUM(B71:B81)","v":12100},{"$f":"SUM(C71:C81)","v":15027.21},{"$f":"SUM(D71:D81)","v":14000}]
["   Connections"]
["      60800 Connections Misc",2000,2894.7,3000]
["      60802 Hospitality",200,4.8499999999999996,10]
["      60804 New Member Expense",500,947.09,850]
["      60807 Connections Cafe",3000,1900.74,1300]
["      60808 SAGES",500,0,500]
["      60815 Small Groups",500,69.39,840]
["      60816 Adult Education",500,0,500]
["      60817 Moms Connect Childcare",100,0,0]
["      60819 Retreats",5000,0,0]
["      60826 Media / Devotionals",1000,909.04,750]
["   Total Connections",{"$f":"SUM(B83:B93)","v":13300},{"$f":"SUM(C83:C93)","v":6725.81},{"$f":"SUM(D83:D93)","v":7750}]
["   Stewardship"]
["      60500 Mailing and Supplies",1500,1825,2000]
["      60502 Envelopes",2100,3099.37,3100]
["   Total Stewardship",{"$f":"SUM(B96:B97)","v":3600},{"$f":"SUM(C96:C97)","v":4924.37},{"$f":"SUM(D96:D97)","v":5100}]
["   Pastoral Expense"]
["      60202 Pastors Salaries and Housing Allow",178264,177387,187460.5]
["      60203 Social Security Allowance",12843,13020.96,13623.96]
["      60206 Pension & Insurance",63319,62882.03,57246]
["      60208 Mileage",1000,2515.1799999999998,2500]
["      60210 Book Fund-Sr Pastor",300,425.06,300]
["      60212 Book Fund-Assoc Pastor",300,214.99,300]
["      60214 Continuing Ed-Sr Pastor",1500,2610,390]
["      60216 Continuing Ed-Assoc Pastor",3700,4175,1025]
["      60222 Pastoral Care Expenses",100,462.59,450]
["      60344 Pastors Cell Phone Allowance",1100,1080,1080]
["   Total Pastoral Expense",{"$f":"SUM(B100:B109)","v":262426},{"$f":"SUM(C100:C109)","v":264772.81},{"$f":"SUM(D100:D109)","v":264375.45999999996}]
["   Staff Expense"]
["      60230 Staff Salaries",320075,321892.78999999998,336398.76]
["      60232 FICA Expense",24333,24696.9,{"$f":"D112*0.0765","v":25734.505140000001}]
["      60234 Staff Cell Phone Allowance",1080,1080,1080]
["      60236 Sub Pianist",800,200,800]
["      60238 Staff Expense",2500,2316.29,2500]
["      60240 Continuing Ed-Staff",2500,793.19,1000]
["      60242 Workers Comp. Ins.",4200,4198,4200]
["      60243 Staff Pension/Insurance",23954,23770.25,24596.53]
["   Total Staff Expense",{"$f":"SUM(B112:B119)","v":379442},{"$f":"SUM(C112:C119)","v":378947.42},{"$f":"SUM(D112:D119)","v":396309.79514000006}]
["   IT/Communications"]
["      60320 Cloud Services",7824,6911.9,6434]
["      60321 Computer Hardware/Software",1600,3852.8,1790]
["      60334 Marketing",8930,6236.8,9198]
["      60336 Copy Machine Maintenance",9130,9060,9180]
["      60916 Telephone/Internet",6433,6322.46,6433]
["      60919 Other Tech Repair/Mtnce",500,1673.77,515]
["   Total IT/Communications",{"$f":"SUM(B122:B127)","v":34417},{"$f":"SUM(C122:C127)","v":34057.729999999996},{"$f":"SUM(D122:D127)","v":33550}]
["   Administration"]
["      60335 Processing Charges",9900,10096.59,11000]
["      60340 Synod Event Participation",1200,2011.95,2100]
["      60342 Office Supplies",3600,4129.2,3500]
["      60345 Consulting Fees",0,2500,250]
["      60346 Payroll Service",4500,4801.2299999999996,5000]
["      60348 Postage",2900,1505.04,2700]
["   Total Administration",{"$f":"SUM(B130:B135)","v":22100},{"$f":"SUM(C130:C135)","v":25044.010000000002},{"$f":"SUM(D130:D135)","v":24550}]
["   Property"]
["      60902 Building Maintenance",16000,13258.67,16000]
["      60904 Kitchen Mtnce/Supplies",1100,1783.6,4257]
["      60906 Grounds Keeping",10000,8722.6200000000008,8750]
["      60908 Insurance/ Bldg.",15355,11945.47,15355]
["      60912 Electrical Service",40250,33388.980000000003,36225]
["      60914 Gas Service",12650,7863.54,12650]
["      60918 Sewer & Water",3700,3896.21,3700]
["      60920 Sanitation",2500,2726.36,2500]
["      60924 Special Assessments",3500,3434.4,3500]
["      60950 Mortgage Interest",79955,79955.45,75983]
["      60975 Mortgage Principal",98761,98760.55,102733]
["   Total Property",{"$f":"SUM(B138:B148)","v":283771},{"$f":"SUM(C138:C148)","v":265735.84999999998},{"$f":"SUM(D138:D148)","v":281653}]
["Total Expenses",{"$f":"B49+B60+B69+B82+B94+B98+B110+B120+B128+B136+B149","v":1104011},{"$f":"C49+C60+C69+C82+C94+C98+C110+C120+C128+C136+C149","v":1080483.0699999998},{"$f":"D49+D60+D69+D82+D94+D98+D110+D120+D128+D136+D149","v":1117428.25514},"+3.4%"]
["Net Total",{"$f":"B31-B150","v":-82881},{"$f":"C31-C150","v":-5468.8699999998789},{"$f":"D31-D150","v":-37838.255140000023}]