ACEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAM
1
1. Ending 2020 with an estimated surplus of over $100,000 due to increased giving, decreased costs and the PPP grant
2. In Dec 2020, Finance committee will consider surplus plan to a) hold back 1-2 months of expenses for slower giving and/or higher unexpected expense months, b) complete one time projects and c) give to denominations and other social justice causes
3. Surplus spent on one time projects would reduce some expenses shown here in 2021 budget
4. 2021 budget contains contingency expense plans built in for property/buildling projects that will only be pursued if we are making or exceeding budget.
5. Christmas mission donation will be our United Mission Fund offering which we have yet to do in 2020
2
3
Account 2021
Approved Budget
2020 Actual Revenue/ Expenses thru Nov 2020
Approved
Budget
2019
Actual Revenue/ Expenses
2018
Actual Revenue/ Expenses
Updated 11/10/2020
4
REVENUES
5
General Giving
6
4010.1 General Fund - Unidentified $ 500.00 $799.08 $ 6,000.00 $ 5,457.19 $ 6,634.28 2021: Since not meeting in person, not having as many unidentified giving
7
4010 General Fund - Pledged and Other Identified Giving $ 386,400.00 $352,739.10 $ 386,400.00 $ 341,299.20 $ 338,757.32 2021: Pledged amount $353,397
8
Subtotal General Giving $ 386,900.00 $353,538.18 $ 392,400.00 $ 346,756.39 $ 345,391.60
9
10
General Other Giving
11
4010.10 Insurance Proceeds $ - $0.00 $ - $ - $ 6,034.21 Unbudgeted / Passthrough
2017 Flood Insurance Reimbursement. There are some expenses in 2018 labeled Flood Related Expenses.
12
4010.5 Building Use $ - $2,160.00 $ 5,000.00 $ 4,675.00 $ 3,630.00 2021: Unsure if there will be any building use funds
13
4010.8 Music $ - $0.00 $ - $ 658.11 $ 1,904.00 Unbudgeted / Passthrough
Choir camp tuition. Revenue used to fund Music Ministers CE and children's choir expenses in 6020.05
14
Designated Money for Youth Director $ - $7,737.17 $ 4,000.00 $ 3,996.00 $ 3,998.00 2021: Goal to not use Dotty Casey Foundation Fund
15
Flower Donations $ - $0.00 $ - $ 465.00 $ - Unbudgeted / Passthrough
Easter flower. Revenue used to offset Worship Supplies 6000.01 for alterscapes/decorations
16
Go Green Fund $ - $0.00 $ - $ 83.44 $ 363.99 Unbudgeted / Passthrough
Revenue used to offset higher costs of "green" supplies in 6050.01 Fellowship Kitchen Supplies & 6120.04 Paper Goods/Toiletries
17
Subtotal General Giving Other (budgeted) $ - $9,897.17 $ 9,000.00 $ 8,671.00 $ 7,628.00
18
Subtotal General Giving Other(all) $ - $9,897.17 $ 9,000.00 $ 9,877.55 $ 15,930.20
19
20
Mission Giving
21
4020.1 United Mission Offering $ - $0.00 $ - $ 3,812.00 $ 2,135.00 Unbudgeted / Passthrough
This is special mission offerings for UCC/DOC which we collect in Feb as special offerings and then passthrough to the denominations. Expense line item is 6012.4 United Mission Offering
22
4020.2 Children's Designated Collection $ - $2,090.42 $ - $ 5,333.02 $ 3,217.96 Unbudgeted / Passthrough to organizations supported during Children's Offering. See Expense line item 6014.4 Children Des Exp
23
Subtotal Mission Giving $ - $2,090.42 $ - $ 9,145.02 $ 5,352.96
24
25
Other Designated Giving
26
4804 Building Fund $ - $1,204.00 $ - $ 20,207.11 $ 715.28
27
4805 Memorial Fund $ - $125.00 $ - $ 500.00 $ 1,395.00 Unbudgeted / Passthrough to separate Memorial Fund account
28
4806 Children's Ministry Giving $ - $1,091.00 $ - $ - $ 669.00 Unbudgeted / Passthrough for mission project of Vacation Bible School
29
4807 Specified Gifts $ - $0.00 $ - $ - $ 1,739.37 Unbudgeted / Passthrough
30
4808 Disaster Relief $ - $0.00 $ - $ 380.00 $ - Unbudgeted / Passthrough
Used in 2019 as special offering for hurricane relief
31
4809 Social Justice $ - $1,425.00 $ - $ 2,851.25 $ - Unbudgeted / Passthrough
Revenue offsets expense line item 6014.2 Social Justice Group
32
Church Camp Scholarship Donations $ - $0.00 $ - $ 1,230.00 $ 2,624.00 Unbudgeted / Passthrough
Revenue offsets expense line 6021.13 Church Camp
33
Youth Event Donations $ - $0.00 $ - $ - $ 195.25 Unbudgeted / Passthrough
Revenue offsets expense line 6021.02 Youth Events
34
Subtotal Other Designated Giving $ - $3,845.00 $ - $ 25,168.36 $ 7,337.90
35
36
Pumpkin Patch Revenue $ 11,912.00 $0.00 $ 11,912.00 $ 14,994.50 $ 11,646.17 Expense line item below "General Fundraising Expense (pumpkins)"
37
Thanksgiving Kids Camp $ - $0.00 $ - $ 250.00
38
Subtotal Other Fund Raising Projects $ 11,912.00 $0.00 $ 11,912.00 $ 15,244.50 $ 11,646.17
39
40
Subtotal Youth Fundraising $ - $2,581.70 $ - $ 14,076.29 $ 19,458.99
41
42
Youth Mission Trip $ - $6,431.47 $ - $ 22,421.00 $ 8,057.48 Unbudgeted / Passthrough
To Youth Mission Account
43
Yout Mission Trip - Parent Contributions $ - $2,200.00 $ - $ 13,400.00 $ 8,150.00 Unbudgeted / Passthrough
To Youth Mission Account
44
Misc Investment $ - -$7,737.17 $ - $ (3,996.00) $ (3,998.00)Offset is going for Meghan's Salary transfer from the Savings Account. It equals "Designated Money for Youth Director" in the revenue section. Have to have a debit and a credit :)
45
4608.53 Interest $ - $453.15 $ - $ 551.74 $ 724.41
46
Sub Total Misc Investment $ - -$7,284.02 $ - $ (3,444.26) $ (3,273.59)
47
48
Other Income $ - $0.00 $ - $ 5,792.64 $ 24,509.68 *includes passthroughs
49
50
TOTAL REVENUES $ 398,812.00 $373,299.92 $ 413,312.00 $ 458,437.49 $ 442,561.39
51
TOTAL BUDGETED REVENUES $ 398,812.00 $363,435.35 $ 413,312.00 $ 370,421.89 $ 364,665.77 excludes all passthroughs
52
53
EXPENDITURES
54
6023.3 Adult Retreat Exp $ - $0.00 $ 400.00 $ 200.00 $ -
55
Administration
56
6210.01 Computer Software/Hardware $ 5,000.00 $1,408.35 $ 1,750.00 $ 2,414.91 $ 1,832.16 NS: $1000 for computer for next pastorate updated laptop for office, video editing software
Icon, sugarsync
57
6210.02 Computer Maintenance $ - $0.00 $ - $ - $ -
58
6210.03 Copier Service $ 11,000.00 $9,293.38 $ 11,000.00 $ 10,441.57 $ 10,789.02
59
6210.04 Postage $ 1,000.00 $912.25 $ 1,000.00 $ 858.45 $ 501.50
60
6210.05 Office Supplies $ 2,000.00 $983.08 $ 1,000.00 $ 970.83 $ 761.35
61
Subtotal Administration $ 19,000.00 $12,597.06 $ 14,750.00 $ 14,685.76 $ 13,884.03
62
63
Building/Property
64
6100.01 Mortgage Payment $ 20,250.00 $20,493.28 $ 27,000.00 $ 26,600.23 $ 26,432.42 2021: at current payoff rate, payoff complete Sept 2021
65
6100.02 Mortgage Interest $ 1,846.50 $1,603.34 $ 2,462.00 $ 2,861.93 $ 3,029.74
66
6100.03 Mortgage Payment-Reno $ 3,993.00 $3,132.01 $ 3,993.00 $ 4,070.74 $ 4,122.09 2021: at current payoff rate, payoff complete Sept 2027
67
6100.04 Mortgage Interest-Renovation $ 2,613.00 $1,822.13 $ 2,613.00 $ 2,534.78 $ 1,814.37
68
Building Offset $ - $0.00 $ - $ - $ - Tied to Mortgage P&L
69
6110.01 Utility Expense $ 12,500.00 $7,765.41 $ 12,500.00 $ 12,928.62 $ 12,032.88 May be lower due to not meeting in building 1/2 year and new LED lights
70
6110.02 AC/Heating Maintenance Exp. $ 2,500.00 $1,255.16 $ 2,000.00 $ 1,735.65 $ 2,059.00 NS: Only 2 visits when usually 4
71
6110.03 AC/Heat Reserves $ 15,000.00 $0.00 $ - $ 19,208.19 $ - NS: 2019 actuals are results of Beat the Heat campaign plus a little pulled from Building Fund
2021: Contingency for additional a/c replacement; goal is to quarterly if cash flow positive, to move quarterly amount into Building Fund
72
6110.04 Security System Operating Exp. $ - $0.00 $ 475.00 $ 454.00 $ 454.00
73
6110.05 Security System/APD fee $ 110.00 $110.00 $ 50.00 $ 110.00 $ 50.00
74
6110.06 Life Safety Equip. Inspection $ 700.00 $3,347.34 $ 682.00 $ - $ 695.00 2020: 2019 & 2020 inspection paid
75
6110.07 Life Safety Equip.-Repairs/Rep. $ 5,000.00 $8,263.53 $ 500.00 $ 148.35 $ 574.88 2018: Leak in suppression system
2020: $2,496.75 transfered from building fund to get fire suppression system working with digital phones
2020: remainder is monitoring fee, 3 leak repairs, compressor repair, fire extinguisher inspection and backflow inspection
2021: monitor fee, required two inspections and funds for leak repairs or pipe replacements in fire suppression system due to aging building (NS - contractors say it would be way too expensive to replace pipe as it would require complete tear down of walls and such so better off to just fix leaks as they occur)
Goal is to at end of year, if cash flow positive, to move leftover amount into Building Fund
76
6110.08 Equipment Repair Expense $ 3,500.00 $0.00 $ 700.00 $ - $ 327.50 2021: Aging building contingency line item.
Goal is to quarterly if cash flow positive, to move quarterly amount into Building Fund
77
6110.09 Phone/Fax/Internet$2,000.00$3,095.36 $ 3,900.00 $ 4,223.08 $ 3,894.16 2021: Monthly fees now consistent
78
6120.01 Janitorial Service $ 9,000.00 $5,085.00 $ 8,136.00 $ 8,136.00 $ 7,872.94 2021: 1/2 year with every other a week; 1/2 week with every week; $2000 for any special cleanings
79
6120.03 Cleaning Supplies $ 2,000.00 $79.76 $ 400.00 $ 310.36 $ 106.10 2021: Assume more cleaning supplies will be needed once back in building
80
6120.04 Paper Goods/Toiletries $ 1,000.00 $0.00 $ 500.00 $ 386.63 $ 680.64
81
6130.01 Lawn/Landscaping Expense $ 3,000.00 $610.00 $ 500.00 $ 108.53 $ 386.63 2021: Aging building contingency line item.
Possible projects: rekey building, keyless entry, replace ceiling tiles, realign doors so no gaps
Goal is to quarterly if cash flow positive, to move quarterly amount into Building Fund
82
6150.01 Other Property Expense $ 8,000.00 $3,507.86 $ 5,100.00 $ 3,897.27 $ 2,335.56 2021: Aging building contingency line item.
Possible projects: rekey building, keyless entry, replace ceiling tiles
Goal is to quarterly if cash flow positive, to move quarterly amount into Building Fund
83
Flood Related Expenses $ - $0.00 $ - $ 2,801.09 $ 1,065.50
84
Property Insurance $ 8,000.00 $5,967.00 $ 6,500.00 $ 7,149.50 $ 6,489.00
85
Workman's Comp Insurance $ 2,000.00 $1,155.00 $ 1,800.00 $ 1,172.00 $ 916.00
86
Subtotal Building/Property $ 103,012.50 $67,292.18 $ 79,811.00 $ 98,836.95 $ 75,338.41
87
88
Education
89
Adult and Other Education
90
6022 Adult Curriculum $ 200.00 $34.99 $ 300.00 $ - $ -
91
Subtotal Adult and Other Education $ 200.00 $34.99 $ 300.00 $ - $ -
92
93
Children's Education
94
6020.01 Curriculum $ 300.00 $64.96 $ 300.00 $ 279.60 $ 58.72
95
6020.02 Equipment and Supplies $ 400.00 $380.30 $ 400.00 $ 296.76 $ 614.95
96
6020.04 Vacation Bible School $ 700.00 $766.94 $ 800.00 $ 619.64 $ 696.62
97
6020.05 Children's Choir $ - $0.00 $ - $ 117.90 $ - See Revenue line 4010.8 Music
98
6021.13 Church Camp $ 600.00 $0.00 $ 600.00 $ 1,130.00 $ 665.00 See Revenue line Church Camp Scholarship Donations
99
Flood Related Expenses $ - $0.00 $ - $ - $ 519.99 See Revenue line 4010.10 Insurance Proceeds
100
6020.06 Fellowship $ 50.00 $0.00 $ 50.00 $ - $ -