council report - shepherd of the prairie
TRANSCRIPT
December 21, 2020
Council Report
“Caring for God’s Children of all ages, by growing disciples who make disciples.”
Shepherd of the Prairie Lutheran Church
Tel. 847-669-9448 10805 Main St. www.sotp.org Huntley, IL 60142 [email protected]
Shepherd of the Prairie December 21, 2020 Council Agenda
• Devotions – Ellen Nissen• Review and approve November Council Minutes• Other Business
a. 2021 Budget review – Cliffb. Annual Meeting discussion, Zoom, Date…. c. Nominating Committee – Pastor Markd. Constitution Congregation approval – Cliffe. Garage update – Cliff / Budf. Call for second pastor updateg. Vision Path Statement – Critical next steps.
• Ministry Team Updatesa. Review updates.
• Finance Review – Cliff Dungeyo Treasurer Report of Activity.
• Devotions for January meeting -• Next Meeting
o January 18, 2021
1 of 23
Shepherd of the Prairie-Council Meeting November 16, 2020
Minutes
Present: Pastor Mark Boster, Bud Hansen, Mike Luecht, Kathy McGuine, Cliff Dungey, Christa Serpe, Sarah Wolf Absent: Ellen Nissen
1. Devotions-Mike Luecht 2. Review and Approve October Council Minutes
a. Mike Luecht approved and Pastor Mark second. 3. Other Business
a. Nominating Committee i. Nominating committee will be meeting in the future to discuss filling open
positions (11/23 at 2:00) b. Covid 19 State Guidelines
i. Discussion held on Covid guidelines and current status. c. Constitution Synod Recommendation of Changes-Cliff
i. Cliff Dungey is currently in the process of connecting with the Synod to finish previous discussions and will update the Council with changes in the near future.
d. Garage Update-Cliff/Bud i. Council will table the garage for a couple of weeks until they receive
further information on expenses. Will provide the Property team an update next month.
e. HR Update-Mike/Sarah i. HR update was provided to the Council.
f. Call for Second Pastor-Next step i. Reconnect with Mike McCann and begin to discuss the process for calling
a second pastor. g. Vision Path Statement-Critical next steps
i. Discussion on next steps 4. Ministry Team Updates
a. Review Updates 5. Finance Review-Cliff Dungey
a. Treasurer Report of Activity 6. Devotions for December Meeting-Ellen Nissen 7. Next Meeting-December 21, 2020
2 of 23
SOTP FINANCE TEAM
Meeting Minutes
December 14, 2020
Attending: Cliff Dungey, Don Schneider, Melanie Chesny, Devin Burg, Bill Nesta, John Throckmorton, Bud Hansen, Bob Mollis
Meeting called to order at 7:16 PM
I. Approval of November 9, 2020 Meeting Minutes as presented
II. Accounting Administrator’s Report A. Balance Sheet as of November 30, 2020
i. Total Current Assets $615,380 ii. Total Fixed Assets $7,819,519
iii. Total Liabilities $3,585,304 (short and long term) iv. Assets include $95,000 from the SBA Paycheck Protection Program received on April
24, 2020 and recorded in restricted Account 3.191.000. Expected to be forgiven at end of program. The SBA Paycheck Protection Program is a Short-Term liability on the Balance Sheet until this loan is forgiven.
B. Income/Expenses through November 30, 2020 i. November GF income of $46,425 was $16,716 less than budgeted amount.
ii. November GF YTD income was $27,683 less than YTD budgeted amount. iii. November GF expenses of $55,119 was $8,706 less than budgeted amount. iv. November GF YTD expenses were $41,612 less than YTD budgeted amount.
C. Restricted Funds Detail Review through October 31, 2020 i. Account 3.175.000 Memorial Fund Balance is $1,841.85.
ii. Account 3.250.000 Good Samaritan Fund Balance is $9,336.95 iii. Account 3.192.000 Sanctuary Piano Fund Balance is 1,965.84. Concern expressed where
the final three months payments will get funded from. D. General Comments
i. Melanie showed a YTD GF giving growth of 2% YTD over 2019. ii. Discussion on how Loose offerings have declined by at least $23,000 in 2020 because not
being in public worship. It was also noted that Member Contributions have held up throughout the year. Committee expressed a need for Pastor to send out a letter reminding congregation to complete their giving commitment by the end of the year if they are behind.
iii. SOTP Ministries have done a good job of controlling expenses even with the attendance being inhibited by the Covid-19 restrictions.
iv. Discussion around Sanctuary Grand Piano fund. SOTP Finance would like to pay off by March 2021 payment at 0% interest. Currently have enough restricted funds for part December’s payment. Still need to raise $7,677 to pay off in full. Questions about availability of the Christmas Concert fund contribution.
III. Treasurer’s Report of Activity & Council Actions/Discussions i. October Treasure’s report supported the Accounting Administrator’s reports.
ii. Cliff reported on three projects that ministries are asking to be funded for 2021. 1. Facilities Ministry still would like to move forward with construction of a 24 X
24 garage for storage and leverage the building permit begin applied for by the Memory Garden project. Estimated cost around $35,000.
3 of 23
2. Audio Visual Ministry would like to improve our on-line worship service experience by adding cameras and lighting to the sanctuary.
3. Audio Visual Ministry would like to renovate a room and purchase addition equipment for Media production of SOTP recorded programs.
IV. Old Business A. Status of Paycheck Protection Program – Waiting for Heartland Bank to provide us with the
required forms to request forgiveness of the SBA PPP Loan. Currently Heartland Bank is working on forgiving $50K and under loans.
B. Status of computer equipment inventory and refresh budgeting cycle. Dennis has provided us with a list of 12 computers owned by SOTP. The oldest are from 2014/15/16. We will table discussion on a replacement plan; however we should discuss a replacement program and budget moving forward.
C. Status of Sanctuary Piano fund, invoice and remaining financing term. Discussed earlier, see II. D. iv. above.
D. Status of Restricted Adult Music Ministry Fund 3.330.000. Jane reported back to Finance that this fund is for special music for worship and other events recommended by Music Ministry. The Director of Worship and Music is to use and authorize funds as appropriate. There are a few contributors to this fund that are extremely into music and arts in the church that have given to this fund as well as other memorials.
E. Replacement status for Sue Wehnes as Financial Contribution Secretary. Request for volunteers are in the Friday Flourish and will be in the December Newsletter. Linda and Cliff Dungey have volunteered to be SOTP’s Financial Contribution Secretary and will arrange time to transition this role with Sue Wehnes.
F. Review Cyber Liability Insurance Quote from Guide One. Discussion and feedback collected from the team. Finance Team and Council have approved of the insurance coverage as proposed. Bob to contact Cheri Cribbet to add the recommended Cyber Liability coverage to our existing policy for the $367 annually.
G. Review of Preliminary 2021 Budget Worksheets. Don to update projected 2020 numbers based on November reports and Bob to list Highlights and Lowlights and forward to Council for their approval during their December meeting and publication in the January Annual Report.
V. New Business A. Review Vanco On-Line Giving Website list of 20 possible contribution funds. Finance team all
agreed that listing 20 accounts was confusing and too long. We agreed to go to a list of standard weekly giving account and a seasonal calendar to include the special giving accounts.
B. Next Finance Team meeting will be January 11, 2021, at 7:15 PM over Zoom. C. No other new business was presented.
VI. Adjourned 9:27 PM
4 of 23
Treasurer’s Report as of November 30, 2020 Assets include $95,000 from the SBA Paycheck Protection Program received on April 24, 2020. These funds are expected to be forgiven at the end of the program. This does not affect the year to date Operating Fund. General Fund Report The General Fund Balance is $186,043. Income for the month was $46,425 and Expenses for the month were $55,118. Mortgage Service Fund Report The Mortgage Service Fund Balance is $81,649. Income for the month was $17,109. The monthly mortgage payment is $19,536. This Month General Fund Actual Budget Difference Income: $ 46,425 $ 63,141 $ (16,715) Expenses: $ 55,118 $ 63,825 $ 8,706) Year-to-Date General Fund YTD Actual YTD Budget Difference Income: $ 666,868 $ 694,551 $ (27,682) Expenses: $ 652,275 $ 693,888 $ 41,612 Mortgage Service Fund Income for month: $ 17,109 Fund Balance: $ 81,649 Respectfully Submitted, Cliff Dungey Congregation Treasurer
5 of 23
Period ActivityYTD Balance Previous Year Balance
Account # Account Name
Page 1 of 2Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILBalance Sheet as of November 30, 2020
AssetsCurrent Assets
422.57510,579.33 418,851.991.100.000 Heartland Bank Checking1,815.97104,378.17 76,954.911.200.000 Mission Plus Building Fund Checking
0.00422.38 422.351.250.000 HBT/LPL Investment Account$2,238.54$615,379.88 $496,229.25Total Current Assets
Fixed Assets0.007,203,136.61 7,203,136.611.300.000 Building & Grounds
(806.19)1,002.70 N/A1.500.000 Donations Holding Account($806.19)$7,204,139.31 $7,203,136.61Total Fixed Assets
$7,819,519.19 $1,432.35 $7,699,365.86Total Assets
LiabilitiesCurrent Liabilities
9,173.569,323.51 74.212.000.000 Accounts Payable/Vendors0.0095,000.00 N/A2.000.100 SBA Loan Liability
(2,410.83)9,643.34 N/A2.000.200 Sanctuary Piano1,835.756,050.00 14,701.252.100.000 Prepaid General Fund Pledges1,764.251,764.25 1,688.002.110.000 Prepaid Mortgage Service Pledges
$10,362.73$121,781.10 $16,463.46Total Current Liabilities
Long Term Liabilities(8,014.17)3,463,523.42 3,595,346.832.200.200 MIF Commercial Loan Payable
($8,014.17)$3,463,523.42 $3,595,346.83Total Long Term Liabilities
$3,585,304.52 $2,348.56 $3,611,810.29Total Liabilities
Fund Balances & EquityUnrestricted Fund Balances
(6,298.04)186,043.39 180,291.323.100.000 General Fund Balance($6,298.04)$186,043.39 $180,291.32Total Unrestricted Fund Balances
Temporary Restricted Fund Balances762.002,422.75 4,255.753.170.000 Special Services Fund Balance(68.15)1,841.85 5,176.403.175.000 Memorial Fund Balance465.00840.00 416.253.180.000 Grafton Food Pantry Fund Balance
0.000.00 6.503.200.000 Heifer Fund Balance0.009,336.95 9,588.943.250.000 Good Samaritan Fund Balance
(920.00)4,264.01 5,031.253.260.000 Community Outreach Fund Balance154.00151.90 (248.00)3.270.000 Holiday Flowers Balance
3.300.000 Music Ministry Fund Balance(273.92)8,976.31 4,492.963.330.000 Adult Music Ministry Fund Balance
500.0011,811.11 11,453.243.332.000 Artist Series Balance0.00(104.37) 0.003.335.000 Bells Ministry Fund Balance
$226.08$20,683.05 15,946.20Total Music Ministry Fund Balance
0.00296.00 5,521.253.350.000 Prairie Crafters Fund Balance0.00925.00 1,000.003.380.000 Continuing Education Fund Balance
3.400.000 Youth Ministry Fund Balance(116.50)1,510.49 1,801.583.415.000 Youth Ministry Balance
0.007,198.84 3,149.803.417.000 Youth Mission Trips Balance0.00763.01 763.013.421.000 Youth Scholarship Balance0.00157.28 409.283.422.000 Operation Christmas Child Balance0.00(450.00) (450.00)3.423.000 Confirmation Retreat Fund Balance
($116.50)$9,179.62 5,673.67Total Youth Ministry Fund Balance
(213.16)4,962.60 6,781.173.500.000 Little Lambs Fund Balance
6 of 23
Period ActivityYTD Balance Previous Year Balance
Account # Account Name
Page 2 of 2Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILBalance Sheet as of November 30, 2020
0.00284.76 284.763.600.000 Prayer Shawl Ministry Fund Balance0.001,647.97 1,622.973.650.000 Quilters Ministry Fund Balance
25.0013,586.50 1,500.003.675.000 Memory Garden Balance0.00315.00 215.003.700.000 Disaster Relief Fund Balance0.00360.00 210.003.725.000 Miscellaneous Outside Charities Balance0.006,270.00 6,270.003.750.000 Seminary Scholarship Fund Balance
$69,252.11$77,367.96 $314.27Total
(2,426.03)81,649.26 76,954.913.140.000 Mortgage Service Balance0.003,817.08 3,817.083.165.000 Building on Faith Balance
(1,040.83)1,965.84 N/A3.192.000 Sanctuary Piano Balance($3,152.59)$164,800.14 $150,024.10Total Temporary Restricted Fund Balances
Reserves0.002,640.04 2,590.633.950.000 Barnabas Reserves Fund Balance0.0039,000.00 38,750.003.971.000 Roof Repairs/Replacement Balance0.002,845.00 2,845.003.972.000 Playground Maintenance Reserves Balance0.0011,912.00 11,699.003.973.000 Parking Lot Seal/Repair Reserves Balance0.0011,246.00 11,017.003.974.000 Lawn & Landscaping Reserves Balance0.0011,754.00 13,212.003.975.000 Maintenance Reserves Balance0.003,302.00 3,302.003.976.000 Carpeting Crossroads/Hallways Reserves Balance0.0019,000.00 18,750.003.977.000 Carpeting MP Room/Classrooms Balance0.0010,000.00 10,000.003.978.000 Security Lock System Reserves Balance
520.253,377.59 8,624.423.980.000 Equipment Reserves Balance0.001,986.11 1,965.113.981.000 Bells Maintenance Reserves Balance0.008,775.89 8,775.893.985.000 Sabbatical Reserves Balance0.005,857.32 5,857.323.988.000 Payroll Tax Reserves Balance
$520.25$131,695.95 $137,388.37Total Reserves
Permanently Restricted Funds0.0012,062.00 12,062.003.940.000 Endowment Fund Balance
$0.00$12,062.00 $12,062.00Total Permanently Restricted Funds
8,014.173,739,613.19 3,607,789.783.130.000 Building & Grounds Equity$8,014.17$3,739,613.19 $3,607,789.78Total Equity
$4,234,214.67 ($916.21) $4,087,555.57Total Fund Balances & Equity
$7,699,365.86$7,819,519.19 $1,432.35Total Liabilities and Fund Balances & Equity
If the accounts in the subtotals have changed or if ledger (marked with "*") and subsidiary account attributes have changed, Previous YTD totals may not represent a valid comparison.
7 of 23
Budget YTDPeriod Activity YTD BalanceMonthly Budget Annual BudgetAccount # Account NamePage 1 of 2Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILTreasurer's Report as of November 2020 for General Fund
Income45,868.67 655,759.7260,000.00 660,000.00 720,000.004.100.000 Member Contributions
348.25 9,830.422,957.00 32,527.00 35,480.004.150.000 Loose Plate and Growth0.00 0.000.00 0.00 0.004.200.000 Miscellaneous Income
200.00 1,141.00167.00 1,837.00 2,000.004.250.000 Flower Income8.59 137.3917.00 187.00 200.004.300.000 Interest Income (Heartland Bank)
$46,425.51 $666,868.53 $694,551.00 $757,680.00$63,141.00Total Income
ExpensesLay Ministry
$136.99 $603.90 $693.00 $750.00$63.00Lay Ministry
Mission Ministry$5,293.44 $66,421.51 $72,600.00 $79,200.00$6,600.00Mission Ministry
Outreach Ministry$0.00 $751.48 $7,788.00 $8,500.00$708.00Outreach Ministry
Adult Education Ministry$0.00 $71.00 $1,199.00 $1,300.00$109.00Adult Education Ministry
Youth and Education Ministry$0.00 $1,494.49 $6,149.00 $6,700.00$559.00Youth and Education Ministry
Children and Family Ministry$24.07 $1,503.79 $4,301.00 $4,700.00$391.00Children and Family Ministry
Music Ministry$1,013.00 $3,893.06 $5,775.00 $6,300.00$525.00Music Ministry
Worship Ministry$538.45 $6,883.97 $7,062.00 $7,700.00$642.00Worship Ministry
Facilities$6,193.43 $49,941.53 $68,860.00 $75,943.00$7,085.00Facilities
Office Expenses$2,647.09 $32,032.41* $30,481.00 $33,250.00$2,771.00Office Expenses
Staffing Ministry$37,911.76 $465,483.26* $465,341.00 $507,637.00$42,304.00Staffing Ministry
Other Church Expenses$1,376.15 $22,816.50 $23,639.00 $25,700.00$2,068.00Other Church Expenses
Providing for the Future
8 of 23
Budget YTDPeriod Activity YTD BalanceMonthly Budget Annual BudgetAccount # Account NamePage 2 of 2Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILTreasurer's Report as of November 2020 for General Fund
$0.00 $394.56* $0.00 $0.00$0.00Providing for the Future
$55,134.38 $652,291.46 $693,888.00 $757,680.00$63,825.00Total Expenses
$663.00 $0.00($684.00) $14,577.07($8,708.87)
* = Income/Expense exceeds amount budgeted to date
Difference
9 of 23
Heartland Checking/MIF Checking Reconciliation
31-Dec-19 31-Jan-20 29-Feb-20 31-Mar-20 30-Apr-20 31-May-20 30-Jun-20 31-Jul-20 31-Aug-20 30-Sep-20 31-Oct-20 30-Nov-20Heartland Checking Balance 452,279.48 474,521.65 450,568.15 459,909.99 599,679.00 600,904.30 596,594.16 576,982.16 581,792.53 543,927.07 550,156.76 550,579.33 Heartland Deposits in Transit - 1,500.00 2,365.98 1,808.89 1,002.70 HBT/LPL Account 422.35 422.35 422.35 422.35 422.35 422.35 422.35 422.35 422.38 422.38 422.38 422.38 Total 452,701.83 474,944.00 450,990.50 460,332.34 600,101.35 601,326.65 597,016.51 577,404.51 583,714.91 546,715.43 552,388.03 552,004.41
General Fund Balance 194,421.65 218,918.52 210,538.84 215,503.85 260,162.71 320,013.22 345,838.80 239,138.95 234,950.54 206,100.02 192,341.43 186,043.39 A/P Liabilities - - - 1,183.14 986.95 747.45 338.18 149.95 194.55 680.35 149.95 9,323.51 SBA Loan Liability 95,000.00 95,000.00 95,000.00 95,000.00 95,000.00 Sanctuary Piano 4,335.00 12,054.17 9,643.34 Prepaid Pledges 31,958.00 - - - - - - - - 4,214.25 7,814.25 Restricted Funds Balance 75,290.81 74,525.06 66,336.37 78,280.34 81,839.27 82,075.42 86,066.29 77,965.89 83,445.45 78,316.53 83,877.44 83,150.88 Reserves Balance 138,969.37 136,739.38 135,972.76 134,479.78 137,218.19 135,883.20 133,459.20 132,336.94 132,793.94 132,947.94 131,175.70 131,695.95 SBA Reserves Balance 83,205.41 29,920.29 - - - - - - Endowment Fund Balance 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 12,062.00 Sub-Total 452,701.83 442,244.96 424,909.97 441,509.11 575,474.53 580,701.58 577,764.47 556,653.73 558,446.48 529,441.84 530,874.94 534,733.32
Difference to Transfer - 32,699.04 26,080.53 18,823.23 24,626.82 20,625.07 19,252.04 20,750.78 25,268.43 17,273.59 21,513.09 17,271.09
Building Fund Balance - Mort Service 87,473.09 94,885.54 101,487.96 100,857.50 106,009.61 107,178.24 106,962.47 97,617.50 103,429.57 101,003.68 62,820.49 60,394.46 Building Fund Balance - Music/Ed Wing - - - - - - - - - - - - Add back accrued interest adjustment **Village of Huntley Compliance Bond - - - - - - - - - - - - MIF Checking Balance 87,473.09 62,186.50 75,407.43 82,034.27 81,382.79 86,553.17 87,710.43 76,866.72 78,161.14 83,730.09 41,307.40 43,123.37 Difference - 32,699.04 26,080.53 18,823.23 24,626.82 20,625.07 19,252.04 20,750.78 25,268.43 17,273.59 21,513.09 17,271.09
Debt Reduction Donations 5,815.07 10,627.40 40,000.00 Music Education Wing DonationsForward in Faith DonationsMortgage Service Donations 24,182.57 32,699.04 26,080.53 17,023.23 24,626.82 20,625.07 19,253.45 20,752.19 25,029.84 17,035.00 21,274.50 17,032.50 FORWARD Donations - - - - Transfers from Building on Faith - - - - - - - - - - - - Monthly Total 29,997.64 32,699.04 26,080.53 17,023.23 24,626.82 20,625.07 19,253.45 31,379.59 25,029.84 57,035.00 21,274.50 17,032.50 Adjustments * 1,800.00 238.59 Running Total 2,732,586.03 2,732,586.03 2,732,586.03 2,734,386.03 2,734,386.03 2,734,386.03 2,734,386.03 2,745,013.43 2,745,013.43 2,785,013.43 2,785,013.43 2,785,252.02
Transfers Made 29,997.64 32,699.04 26,080.53 18,823.23 24,626.82 20,625.07 19,253.45 31,379.59 25,029.84 57,035.00 21,274.50 17,032.50 Running Total to Transfer - - - - - - - - - - - 238.59
* Note: An adjustment is required when expenses for the Building Fund are paid with funds from the General Fund or vice-versa.3538.59
-1.41 1.41 238.59 238.59 238.59 238.5940000
New Donations Balances as of 12.10.2020 34499.04 26080.53 17023.23 24626.82 20625.07 19252.04 20752.19 25269.84 17035 21274.5 17032.5Difference (1,800.00) - 1,800.00 - - 1.41 10,627.40 (240.00) 40,000.00 - -
10 of 23
Current Activity YTD ActivityAccount # Account Name
Page 1 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
84,075.29 87,473.09Beginning Fund Balance
3.140.000 Mortgage Service Balance
IncomeMortgage Service Donations4.140.000 17,032.50 243,470.76MIF Checking Interest Income4.701.000 77.47 789.08
Total Income $244,259.84$17,109.97
ExpensesMortgage Service Principal Payments5.140.000 8,014.17 88,534.44Mortgage Service Interest Payments5.141.000 11,521.83 126,361.56Mortgage Service Principal Only Payments5.142.000 0.00 35,187.67
Total Expenses $250,083.67$19,536.00
Ending Fund Balance $81,649.26$81,649.26
3,817.08 3,817.08Beginning Fund Balance
3.165.000 Building on Faith Balance
Ending Fund Balance $3,817.08$3,817.08
1,660.75 8,054.99Beginning Fund Balance
3.170.000 Special Services Fund Balance
IncomeSpecial Services Donations4.170.000 762.00 6,657.00
Total Income $6,657.00$762.00
ExpensesSpecial Services Expense5.170.000 0.00 12,289.24
Total Expenses $12,289.24$0.00
Ending Fund Balance $2,422.75$2,422.75
1,910.00 5,510.20Beginning Fund Balance
3.175.000 Memorial Fund Balance
IncomeMemorial Donations4.175.000 50.00 7,293.00
Total Income $7,293.00$50.00
ExpensesMemorial Expense5.175.000 118.15 10,961.35
Total Expenses $10,961.35$118.15
Ending Fund Balance $1,841.85$1,841.85
375.00 255.00Beginning Fund Balance
3.180.000 Grafton Food Pantry Fund Balance
IncomeGrafton Food Pantry Donations4.190.000 840.00 3,927.00
Total Income $3,927.00$840.00
ExpensesGrafton Food Pantry Expense5.190.000 375.00 3,342.00
Total Expenses $3,342.00$375.00
Ending Fund Balance $840.00$840.00
11 of 23
Current Activity YTD ActivityAccount # Account Name
Page 2 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
3,006.67 0.00Beginning Fund Balance
3.192.000 Sanctuary Piano Balance
IncomeSanctuary Grand Piano Income4.192.000 1,370.00 27,752.50
Total Income $27,752.50$1,370.00
ExpensesSanctuary Grand Piano Expense5.192.000 2,410.83 25,786.66
Total Expenses $25,786.66$2,410.83
Ending Fund Balance $1,965.84$1,965.84
9,336.95 9,588.94Beginning Fund Balance
3.250.000 Good Samaritan Fund Balance
IncomeGood Samaritan Donations4.325.000 0.00 4,014.00
Total Income $4,014.00$0.00
ExpensesGood Samaritan Expense5.625.000 0.00 4,265.99
Total Expenses $4,265.99$0.00
Ending Fund Balance $9,336.95$9,336.95
5,184.01 3,603.37Beginning Fund Balance
3.260.000 Community Outreach Fund Balance
IncomeCommunity Outreach Donations4.260.000 30.00 810.00LSSI Donations4.260.100 0.00 200.00ELCA World Hunger Donations4.260.110 50.00 1,050.00
Total Income $2,060.00$80.00
ExpensesOutreach Ministry
Community Outreach Expense5.260.000 1,000.00 1,399.36Outreach Ministry 1,399.361,000.00
Total Expenses $1,399.36$1,000.00
Ending Fund Balance $4,264.01$4,264.01
(2.10) (293.75)Beginning Fund Balance
3.270.000 Holiday Flowers Balance
IncomeHoliday Flowers Income4.270.000 154.00 517.00
Total Income $517.00$154.00
ExpensesHoliday Flowers Expense5.270.000 0.00 71.35
Total Expenses $71.35$0.00
Ending Fund Balance $151.90$151.90
20,456.97 21,174.38Beginning Fund Balance
3.300.000 Music Ministry Fund Balance
3.330.000 Adult Music Ministry Fund Balance12 of 23
Current Activity YTD ActivityAccount # Account Name
Page 3 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
Beginning Sub Fund Balance 9,250.23 8,001.14Income
3,988.540.004.330.000 Adult Music Ministry DonationsTotal Income $3,988.54$0.00
Expenses3,013.37273.925.330.000 Adult Music Ministry Expense
Total Expenses $3,013.37$273.92
Ending Sub Fund Balance $8,976.31 $8,976.31
Beginning Sub Fund Balance 11,311.11 13,173.24
3.332.000 Artist Series Balance
Income10,039.00500.004.332.000 Artist Series Income
Total Income $10,039.00$500.00
Expenses11,401.130.005.332.000 Artist Series Expense
Total Expenses $11,401.13$0.00
Journal Entry CreditsJournal Entry Debits
Total Journal Entries0.000.00
1,200.00(1,200.00)
$0.00 $0.00Ending Sub Fund Balance $11,811.11 $11,811.11
Beginning Sub Fund Balance (104.37) 0.00
3.335.000 Bells Ministry Fund Balance
Income74.000.004.410.000 Bells Music Ministry Donations
Total Income $74.00$0.00
Expenses178.370.005.410.000 Bells Music Ministry Expense
Total Expenses $178.37$0.00
Ending Sub Fund Balance ($104.37) ($104.37)
Ending Fund Balance $20,683.05$20,683.05
296.00 0.00Beginning Fund Balance
3.350.000 Prairie Crafters Fund Balance
IncomePrairie Crafters Income4.355.000 0.00 296.00
Total Income $296.00$0.00
Ending Fund Balance $296.00$296.00
925.00 1,000.00Beginning Fund Balance
3.380.000 Continuing Education Fund Balance
ExpensesContinuing Education Expenses5.380.000 0.00 75.00
Total Expenses $75.00$0.00
Ending Fund Balance $925.00$925.00
9,296.12 5,621.67Beginning Fund Balance
3.400.000 Youth Ministry Fund Balance
3.415.000 Youth Ministry Balance13 of 23
Current Activity YTD ActivityAccount # Account Name
Page 4 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
Beginning Sub Fund Balance 1,626.99 1,801.58Income
25.000.004.415.100 Youth Ministry IncomeTotal Income $25.00$0.00
Expenses316.09116.505.415.100 Youth Ministry Expense
Total Expenses $316.09$116.50
Ending Sub Fund Balance $1,510.49 $1,510.49
Beginning Sub Fund Balance 7,198.84 3,349.80
3.417.000 Youth Mission Trips Balance
Income6,681.730.004.417.000 Youth Mission Trips Income
Total Income $6,681.73$0.00
Expenses5,832.690.005.417.000 Youth Mission Trips Expense
Total Expenses $5,832.69$0.00
Journal Entry CreditsJournal Entry Debits
Total Journal Entries0.000.00
3,000.000.00
$0.00 $3,000.00Ending Sub Fund Balance $7,198.84 $7,198.84
Beginning Sub Fund Balance 763.01 763.01
3.421.000 Youth Scholarship Balance
Ending Sub Fund Balance $763.01 $763.01
Beginning Sub Fund Balance 157.28 157.28
3.422.000 Operation Christmas Child Balance
Ending Sub Fund Balance $157.28 $157.28
Beginning Sub Fund Balance (450.00) (450.00)
3.423.000 Confirmation Retreat Fund Balance
Ending Sub Fund Balance ($450.00) ($450.00)
Ending Fund Balance $9,179.62$9,179.62
5,175.76 6,849.70Beginning Fund Balance
3.500.000 Little Lambs Fund Balance
IncomeLittle Lambs Tuition4.500.100 0.00 12,994.49
Total Income $12,994.49$0.00
ExpensesLittle Lambs Salary5.700.100 213.16 10,889.87Little Lambs Expenses5.700.110 0.00 3,991.72
Total Expenses $14,881.59$213.16
Ending Fund Balance $4,962.60$4,962.60
284.76 284.76Beginning Fund Balance
3.600.000 Prayer Shawl Ministry Fund Balance
Ending Fund Balance $284.76$284.76
3.650.000 Quilters Ministry Fund Balance14 of 23
Current Activity YTD ActivityAccount # Account Name
Page 5 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
1,647.97 1,622.97Beginning Fund Balance
IncomeQuilters Income & Donations4.650.000 0.00 25.00
Total Income $25.00$0.00
Ending Fund Balance $1,647.97$1,647.97
13,561.50 1,500.00Beginning Fund Balance
3.675.000 Memory Garden Balance
IncomeMemory Garden Income4.675.000 25.00 16,411.50
Total Income $16,411.50$25.00
ExpensesMemory Garden Expense5.675.000 0.00 4,325.00
Total Expenses $4,325.00$0.00
Ending Fund Balance $13,586.50$13,586.50
315.00 215.00Beginning Fund Balance
3.700.000 Disaster Relief Fund Balance
IncomeDisaster Relief4.710.000 0.00 100.00
Total Income $100.00$0.00
Ending Fund Balance $315.00$315.00
360.00 210.00Beginning Fund Balance
3.725.000 Miscellaneous Outside Charities Balance
IncomeMisc. Outside Charities Income4.725.000 0.00 150.00
Total Income $150.00$0.00
Ending Fund Balance $360.00$360.00
6,270.00 6,270.00Beginning Fund Balance
3.750.000 Seminary Scholarship Fund Balance
Ending Fund Balance $6,270.00$6,270.00
12,062.00 12,062.00Beginning Fund Balance
3.940.000 Endowment Fund Balance
Ending Fund Balance $12,062.00$12,062.00
2,640.04 2,653.63Beginning Fund Balance
3.950.000 Barnabas Reserves Fund Balance
ExpensesBarnabas Reserves Expense5.950.000 0.00 13.59
Total Expenses $13.59$0.00
Ending Fund Balance $2,640.04$2,640.04
39,000.00 39,000.00Beginning Fund Balance
3.971.000 Roof Repairs/Replacement Balance
Ending Fund Balance $39,000.00$39,000.00
15 of 23
Current Activity YTD ActivityAccount # Account Name
Page 6 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
2,845.00 2,845.00Beginning Fund Balance
3.972.000 Playground Maintenance Reserves Balance
Ending Fund Balance $2,845.00$2,845.00
11,912.00 11,912.00Beginning Fund Balance
3.973.000 Parking Lot Seal/Repair Reserves Balance
Ending Fund Balance $11,912.00$11,912.00
11,246.00 11,246.00Beginning Fund Balance
3.974.000 Lawn & Landscaping Reserves Balance
Ending Fund Balance $11,246.00$11,246.00
11,754.00 13,504.00Beginning Fund Balance
3.975.000 Maintenance Reserves Balance
ExpensesMaintenance Reserves Expense5.975.000 0.00 1,750.00
Total Expenses $1,750.00$0.00
Ending Fund Balance $11,754.00$11,754.00
3,302.00 3,302.00Beginning Fund Balance
3.976.000 Carpeting Crossroads/Hallways Reserves Balance
Ending Fund Balance $3,302.00$3,302.00
19,000.00 19,000.00Beginning Fund Balance
3.977.000 Carpeting MP Room/Classrooms Balance
Ending Fund Balance $19,000.00$19,000.00
10,000.00 10,000.00Beginning Fund Balance
3.978.000 Security Lock System Reserves Balance
Ending Fund Balance $10,000.00$10,000.00
2,857.34 8,887.42Beginning Fund Balance
3.980.000 Equipment Reserves Balance
IncomeEquipment Reserves Income4.980.000 414.00 4,634.00
Total Income $4,634.00$414.00
ExpensesEquipment Reserves Expense5.980.000 (106.25) 10,143.83
Total Expenses $10,143.83($106.25)
Ending Fund Balance $3,377.59$3,377.59
1,986.11 1,986.11Beginning Fund Balance
3.981.000 Bells Maintenance Reserves Balance
Ending Fund Balance $1,986.11$1,986.11
8,775.89 8,775.89Beginning Fund Balance
3.985.000 Sabbatical Reserves Balance
Ending Fund Balance $8,775.89$8,775.89
5,857.32 5,857.32Beginning Fund Balance
3.988.000 Payroll Tax Reserves Balance
16 of 23
Current Activity YTD ActivityAccount # Account Name
Page 7 of 7Friday, December 4, 2020
Shepherd of the Prairie - Huntley ILDetailed Fund Activity Report as of 11/30/2020
Ending Fund Balance $5,857.32$5,857.32
17 of 23
2018 YTD 2019 YTD 2020 YTD '20 vs '19January 83,355 83,355 78,678 78,678 84,238 84,238 7%February 42,878 126,233 46,773 125,451 49,923 134,161 7%March 57,965 184,198 63,915 189,366 66,819 200,980 6%April 62,060 246,258 67,399 256,765 95,815 296,795 16%May 57,268 303,526 56,239 313,004 63,400 360,195 15%June 49,855 353,381 57,184 370,188 53,470 413,665 12%July 60,480 413,861 48,046 418,234 45,901 459,566 10%August 51,585 465,446 51,864 470,098 48,459 508,025 8%September 51,545 516,991 57,780 527,878 52,271 560,297 6%October 55,146 572,137 57,182 585,060 52,934 613,231 5%November 47,935 620,072 60,299 645,359 45,869 659,100 2%December 70,305 690,377 79,903 725,262 - 659,100 -9%
Shepherd of the PrairieGeneral Fund Giving
18 of 23
Minutes for the Worship Committee November 23, 2020
Attending the meeting: Judie, Carolyn, Orv, Jane, Elaine, Diane, Barb Missing – Chris S., Andrew, Loretta The SOTP Worship Committee had its committee meeting via Zoom on Monday, November 23, 2020 at 7pm. The meeting was short. Jane alerted us and it was confirmed on Tuesday that church services will be live stream only going forward due to the COVID 19 surge of numbers and cases. This starts immediately with the Thanksgiving Eve service. Christmas Eve will be live streamed as well. There will be no ushers, no greeters, no communion stewards, no sanitizing. Jane did notice (as many of us) that people continue to gather in the gathering area after (and before) service while NOT practicing social distancing and making sure that their masks are worn properly. Jane reminded everyone that the annual report is due on December 5th. If you have not submitted your report, please get it to Jane and Carolyn by this weekend. Jane and Carolyn are meeting on December 2nd to finalize the report for Donna.
• November 27 as small team with change to Advent. • December 4th – we will decorate the church with the Christmas Trees and
other decorations at 930am. • December 6th there will be a rehearsal for the Christmas Concert (FYI) • December 11 the poinsettias for the concert will be delivered (FYI) • December 12th is the concert at 7pm live streaming (FYI) • December 21st the balance of the poinsettias will be delivered for Christmas
Eve service. • December 24th is the Christmas Eve service.
The meeting adjourned at 725pm. Respectfully submitted Carolyn Cuttle
19 of 23
Property Team meeting – December 14, 2020
The meeting was called to order by Mark Frendreis (Chair) at 7:07pm at Shepherd of the Prairie Church.
Attendees: Mark Frendreis, Rich Paeth, Jessica Panella, Chris Trodahl
Absent: Jerry Christopherson, Chuck Peterson, Tom Polzin, Dick Tabatt, Pete Walthers, Council Liaison - Ellen Nissen
Note: Property Team mailbox address is [email protected]
Old Business • Update on replacing soap and hand sanitizer dispensers with manual -Tom
o Tom was not in attendance • Garage update -Rich
o Attended the village planning meeting o Any trees that are moved must be replaced immediately o Once the permit is issued, we have 6 months to complete the project
• Lack of meeting with finance re: garage -Mark o Still waiting on a meeting to explain why we need this
• Confirm cleaning back to once a week -Chris o Chris will call them tomorrow
• Assign/Verify projects: o touch up paint with correct color
Need to identify the places where the wrong color is needing to be corrected and paint
The paint needs to be labeled as well o Replace bulb by west hallway door
Chuck was not in attendance to confirm o Reprogram fellowship hall lights
Jess will get this done 5 or 6 settings
o Fix sticky exterior door on west end Chris will call Jim to get it fixed – on a Friday
o Add water to ALL floor drains – Tom will do this Wednesday Tom was not in attendance to confirm
• Any word on new fire inspection date after no-show -Chris o Chris will call them to reschedule
• Door and window install in youth office on hold -Mark o This has been put on hold – it is not needed at this time
• Update on VAV in library and nursery not working- Mark o It is broken….Mark sent a lot of time testing o The shaft is broken in the VAV – the guys who built the building purchased another one
and we have it and can be reinstalled o The damper is bad on the one over the nursery o Mark is trying to see if Train is responsible to repair it
20 of 23
New business • Temperature change request and evaluation to follow
o Worship area is now set at 65 degrees permanently o If the music dept needs the temp up for the new piano, this should not be the property
team’s cost • Discussion on contribution vs submitting receipts
o We need to provide a monthly report to the council/finance team with receipts of time/material to help them understand the cost of maintaining the building
• Tessa TV found o It was in the library behind a couch
• At the ministry lead meeting Mike Y discussed new lighting and the “video studio” o How much will it be used and will the equipment age before we get the usage o The room will be more storage at first, may include a green screen wall o We need to purchase the equipment because the church does not own any of it o The goal will be to train others to use the room/equipment to use it more
The meeting was adjourned at 7:37pm. Prayerfully submitted: Jessica Panella
21 of 23
Mission Team MinutesDec. 12, 2020
Attendance: Sandy Hupert, Carl Hupert, Annette Petersen, Marty Jacobson, Becky Wright, Steve Legel and Donna Kelly ( New Member and Lay Member Coordinator )
Sandy opened the meeting with a reading from Matthew 7:7 and a prayer.
Old Business
1. Approval of Minutes: Carl moved and Becky seconded a motion to approve the Nov. minutes. Motion carried. 2. ELCA World Hunger : Donna Kelly reported $225.00 was collected from the Global Barnyard. Will be ordering two goats, 2 two piglets, four brood chicks and a honeybee farm. Working on getting Shepherd of the Prairie credit for this donation. Donna and Becky will work on getting information out to the congregation on project and future giving. 3. Missionary Support: Our missionaries have returned to the university in Tanzania and have resumed teaching duties. Question was raised about possibly sponsoring a different mission in Tanzania or elsewhere. Steve will explore this and report back to team. 4. NIFB: No report. 5. PADS: No report 6. Habitat for Humanity: No home building now. May start in Spring. Carl has testimonials from people Habitat helped. He will present them in Jan. to congregation to stimulate interest.No volunteers for ReStore at present. 7. Grafton Food Pantry: 150 families qualified for a Thanksgiving meal the Sat. before Thanksgiving. Christmas Meals were again given away Dec. 10th. No group has come forward to run “drive-thru” food drive next month. Will be discussed next meeting. 8. Home of the Sparrow: No report. 9. Senior Care: See #16 below. 10. Blood Drive: Nancy will do again next year. 11. FMSC: No report. 12. AARK: No report. 13. Justice Position: No report. 14. Christmas Offering: Will be split between PADS, Home of the Sparrow, Turning Point and LSSI Addiction Center ( Elgin ). 15. Giving Tree: Barb Hoppenstaadt, who organized this project, reported to Sandy that Turning Points was given 37 gift cards plus a $50 private donation and Grafton Food Pantry was given 52 gift cards ( for 15 families ) plus a $50 private donation and $30 cash. 3 additional gift cards were also donated. 16. Balance fo Funds: Marty moved and Carl seconded a motion that excess funds be split between Senior Care, LIRS and Justice for our Neighbors. Motion Carried. 17. LIRS Hope for the Holidays: 131 Christmas cards were sent. Need more publicity next year.
New Business
1. Sharing of joys and concerns. 2. Next scheduled meeting is Jan. 11th. 3. Marty moved and Annette seconded motion to adjourn. Motion carried.
Steve Legel, Secretary
22 of 23