A | C | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | AI | AJ | AK | AL | AM | ||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | $ - | $ - |