| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | Title of this worksheet is in cell at right. Enter year in cell Q2. Next instruction is in cell A4. | 2026 Budget | 2026 | |||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | Labels are in cells C4 through P4. | REVENUE | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | |||||||||||
7 | Membership Renewals (+recurring) | $4,765.00 | $4,765.00 | $2,765.00 | $9,425.00 | $6,680.00 | $8,680.00 | $8,180.00 | $9,765.00 | $7,765.00 | $16,785.00 | $0.00 | $0.00 | $79,575.00 | ||||||||||||
8 | New Members | $1,000.00 | $0.00 | $0.00 | $1,000.00 | $0.00 | $2,000.00 | $85.00 | $1,000.00 | $3,085.00 | $3,000.00 | $0.00 | $0.00 | $11,170.00 | ||||||||||||
10 | Additional Donations | $40.00 | $240.00 | $540.00 | $40.00 | $40.00 | $540.00 | $13,942.00 | $40.00 | $40.00 | $1,040.00 | $0.00 | $0.00 | $16,502.00 | ||||||||||||
11 | Events | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $33,674.00 | $0.00 | $0.00 | $14,445.00 | $0.00 | $0.00 | $48,119.00 | ||||||||||||
12 | Miscellaneous | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
13 | Total Revenue | $5,805.00 | $5,005.00 | $3,305.00 | $10,465.00 | $6,720.00 | $11,220.00 | $55,881.00 | $10,805.00 | $10,890.00 | $35,270.00 | $0.00 | $0.00 | $155,366.00 | ||||||||||||
14 | ||||||||||||||||||||||||||
15 | Labels are in cells C11 through P11. | EXPENSES | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YEAR | |||||||||||
17 | Events | $0.00 | $53.00 | $0.00 | $4,651.00 | $1,535.38 | $0.00 | $0.00 | $0.00 | $1,891.00 | $23,406.00 | $0.00 | $0.00 | $31,536.38 | ||||||||||||
18 | Projects and Commitments | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $155,000.00 | $0.00 | $0.00 | $155,000.00 | ||||||||||||
19 | Miscellaneous | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
20 | Total Expenses | $0.00 | $53.00 | $0.00 | $4,651.00 | $1,535.38 | $0.00 | $0.00 | $0.00 | $1,891.00 | $178,406.00 | $0.00 | $0.00 | $186,536.38 | ||||||||||||
21 | TOTAL NET | $5,805.00 | $4,952.00 | $3,305.00 | $5,814.00 | $5,184.62 | $11,220.00 | $55,881.00 | $10,805.00 | $8,999.00 | -$143,136.00 | $0.00 | $0.00 | -$31,170.38 | ||||||||||||
22 | ROLLOVER | $75,659.60 | $75,659.60 | |||||||||||||||||||||||
23 | CURRENT BALANCE | $81,464.60 | $86,416.60 | $89,721.60 | $95,535.60 | $100,720.22 | $111,940.22 | $167,821.22 | $178,626.22 | $187,625.22 | $44,489.22 | $44,489.22 | $44,489.22 | $44,489.22 | ||||||||||||
24 | ||||||||||||||||||||||||||
25 | EXPENSE DETAIL | |||||||||||||||||||||||||
26 | EVENTS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
27 | Enter Transportation expenses in table starting in cell C29. Next instruction is in cell A38. | Garden Party | $4,651.00 | $1,535.38 | $6,186.38 | |||||||||||||||||||||
28 | Membership Events | $53.00 | $53.00 | #N/A | ||||||||||||||||||||||
29 | Conservation BTS | $1,716.00 | $1,716.00 | #N/A | ||||||||||||||||||||||
30 | Annual Dinner | $175.00 | $23,406.00 | $23,581.00 | ||||||||||||||||||||||
31 | Total | $0.00 | $53.00 | $0.00 | $4,651.00 | $1,535.38 | $0.00 | $0.00 | $0.00 | $1,891.00 | $23,406.00 | $0.00 | $0.00 | $31,536.38 | ||||||||||||
32 | #N/A | |||||||||||||||||||||||||
33 | PROJECTS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
34 | 2026 Project Commitment | $155,000.00 | ||||||||||||||||||||||||
35 | Advancing Access (P2 2025) | $1,049.00 | $3,181.00 | $8,944.36 | $781.00 | $440.00 | $575.00 | $2,621.00 | $17,591.36 | |||||||||||||||||
36 | Enter Entertainment expenses in table starting in cell C38. Next instruction is in cell A45. | ArchivesSpace (P4 2025) | $0.00 | #N/A | ||||||||||||||||||||||
37 | LTS Flat File (P5 2025) | $6,000.00 | $6,000.00 | #N/A | ||||||||||||||||||||||
38 | Climate Chamber (P6 2025) | $25,000.00 | $25,000.00 | #N/A | ||||||||||||||||||||||
39 | Internship (P7 2025) | |||||||||||||||||||||||||
40 | Total | $0.00 | $0.00 | $25,000.00 | $7,049.00 | $3,181.00 | $8,944.36 | $781.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $48,591.36 | ||||||||||||
41 | Enter Health expenses in table starting in cell C45. Next instruction is in cell A55. | |||||||||||||||||||||||||
42 | MISCELLANEOUS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
43 | Gifts in Honor | $0.00 | #N/A | |||||||||||||||||||||||
44 | Operating | $0.00 | #N/A | |||||||||||||||||||||||
45 | Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
46 | #N/A | |||||||||||||||||||||||||
47 | REVENUE DETAIL | |||||||||||||||||||||||||
48 | MEMBERSHIP RENEWAL | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
49 | $1,000 Renewal (+recurring) | $4,765.00 | $4,765.00 | $2,765.00 | $9,425.00 | $6,680.00 | $3,680.00 | $8,180.00 | $9,765.00 | $7,765.00 | $16,785.00 | $74,575.00 | ||||||||||||||
50 | $2,500 Renewal | $5,000.00 | $5,000.00 | #N/A | ||||||||||||||||||||||
51 | $5,000 Renewal | $0.00 | #N/A | |||||||||||||||||||||||
52 | Total | $4,765.00 | $4,765.00 | $2,765.00 | $9,425.00 | $6,680.00 | $8,680.00 | $8,180.00 | $9,765.00 | $7,765.00 | $16,785.00 | $0.00 | $0.00 | $79,575.00 | ||||||||||||
53 | ||||||||||||||||||||||||||
54 | NEW MEMBERS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
55 | $1,000 Level (+recurring) | $1,000.00 | $1,000.00 | $2,000.00 | $85.00 | $1,000.00 | $3,085.00 | $3,000.00 | $11,170.00 | |||||||||||||||||
56 | Enter Personal expenses in table starting in cell C81. Next instruction is in cell A89. | $2,500 Level | $0.00 | #N/A | ||||||||||||||||||||||
57 | $5,000 Level | $0.00 | #N/A | |||||||||||||||||||||||
58 | Total | $1,000.00 | $0.00 | $0.00 | $1,000.00 | $0.00 | $2,000.00 | $85.00 | $1,000.00 | $3,085.00 | $3,000.00 | $0.00 | $0.00 | $11,170.00 | ||||||||||||
59 | ||||||||||||||||||||||||||
60 | Enter Financial Obligations in table starting in cell C89. Next instruction is in cell A97. | ADDITIONAL DONATIONS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | ||||||||||
61 | Non-membership donations | $40.00 | $240.00 | $540.00 | $40.00 | $40.00 | $540.00 | $13,942.00 | $40.00 | $40.00 | $1,040.00 | $16,502.00 | ||||||||||||||
62 | Total | $40.00 | $240.00 | $540.00 | $40.00 | $40.00 | $540.00 | $13,942.00 | $40.00 | $40.00 | $1,040.00 | $0.00 | $0.00 | $16,502.00 | ||||||||||||
63 | ||||||||||||||||||||||||||
64 | Enter Miscellaneous Payments in table starting in cell C97. Next instruction is in cell A105. | EVENTS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | ||||||||||
65 | Garden Party | $0.00 | #N/A | |||||||||||||||||||||||
66 | Night at The Mariners' | $33,674.00 | $33,674.00 | #N/A | ||||||||||||||||||||||
67 | Conservation BTS | $0.00 | #N/A | |||||||||||||||||||||||
68 | Annual Dinner | $14,445.00 | $14,445.00 | #N/A | ||||||||||||||||||||||
69 | Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $33,674.00 | $0.00 | $0.00 | $14,445.00 | $0.00 | $0.00 | $48,119.00 | ||||||||||||
70 | ||||||||||||||||||||||||||
71 | PROJECTS | January | February | March | April | May | June | July | August | September | October | November | December | Year | Sparkline | |||||||||||
72 | Miscellaneous | $0.00 | #N/A | |||||||||||||||||||||||
73 | Total | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | ||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 | ||||||||||||||||||||||||||
101 | ||||||||||||||||||||||||||
102 | ||||||||||||||||||||||||||
103 | ||||||||||||||||||||||||||