ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1
Hive13 Financial Summary Last 12 Months
WORKING DRAFT
2
3
4
Membership Totals
Jan 2021Feb 2021Mar 2021Apr 2021May 2021Jun 2021Jul 2021Aug 2021Sep 2021Oct 2021Nov 2021Dec 2021Jan 2022Feb 2022Mar 2022Apr 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022
5
 - Cornerstone members121313131315151515151514151515151616161616161616
6
 - Full members (PayPal subscriptions only)545459586062667075777774707480838486869294929198
7
 - Full Warden members333333445554466666444433
8
 - Student members222322212123242524232522252629272627292529282729
9
 - Student Warden members000000000000000000000000
10
Total PayPal Memberships (PayPal Recurring Payment Records)9193979597103109114119120122114114121130131132135135137143140137146
11
 - Full Member lump-sum pay via PNC Main once-per-year111111222222222222111111
12
 - Full Member lump-sum pay via PayPal once-per-year112222222233323333222333
13
- ZERO DOLLAR 'PlusOne' complementary memberships141415151517171717202017192123262729293031292931
14
Total Memberships (all sources)107109115113115123130135140144147136138146158162164169167170177173170182
15
16
Jan 2021Feb 2021Mar 2021Apr 2021May 2021Jun 2021Jul 2021Aug 2021Sep 2021Oct 2021Nov 2021Dec 2021Jan 2022Feb 2022Mar 2022Apr 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022
17
Combined Operating Accounts (PNC Main & PayPal) Beginning Balance
$ 20,343.54 $ 24,692.55 $ 25,630.14 $ 31,447.94 $ 31,056.07 $ 40,301.05 $ 37,385.19 $ 34,088.52 $ 31,876.61 $ 28,371.05 $ 29,534.36 $ 30,765.51 $ 29,800.07 $ 32,008.30 $ 34,343.17 $ 33,326.35 $ 38,953.07 $ 41,599.60 $ 41,453.18 $ 44,038.92 $ 44,283.88 $ 36,319.90 $ 39,989.74 $ 43,856.48
18
Encumbered Reserve (at end of each month) $ (20,960.00) $ (20,860.00) $ (25,971.00) $ (27,671.00) $ (32,482.00) $ (31,865.79) $ (23,865.79) $ (22,438.21) $ (24,108.58) $ (23,908.58) $ (23,393.58) $ (23,558.58) $ 24,174.40 $ 27,058.64 $ 23,909.75 $ 26,495.97 $ 24,216.22 $ 24,434.19 $ 29,972.07 $ 26,144.34 $ 27,429.30 $ 27,013.03 $ 29,229.97 $ 31,699.91
19
- Rainy Day 6-Month Reserve [6*($2875+$110+$250)] $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ (19,410.00) $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00 $ 19,410.00
20
- Lump Sum Membership Pre-Payment Reserve $ $ (550.00) $ (450.00) $ (1,750.00) $ (1,600.00) $ (2,050.00) $ (1,900.00) $ (2,300.00) $ (2,100.00) $ (1,900.00) $ (1,700.00) $ (1,500.00) $ (1,350.00) $ 1,100.00 $ 900.00 $ 1,250.00 $ 1,000.00 $ 750.00 $ 500.00 $ 950.00 $ 1,400.00 $ 1,250.00 $ 1,250.00 $ 1,050.00 $ 983.70
21
- Dungeon Buildout (Nov. 2022) (prior AC Fund Drive un-spent thru Oct. 2022)
$ (1,000.00) $ (1,000.00) $ (4,811.00) $ (6,661.00) $ (11,022.00) $ (9,942.00) $ (1,542.00) $ (1,542.00) $ (1,542.00) $ (1,542.00) $ (1,227.00) $ (1,542.00) $ 1,542.00 $ 1,542.00 $ 1,542.00 $ 1,742.00 $ 1,952.00 $ 1,952.00 $ 1,952.00 $ 1,952.00 $ 1,952.00 $ 1,952.00 $ 4,202.00 $ 5,202.00
22
- Member Vote budgeted and remaining un-spent $ (work-in-progress) $ (613.79) $ (613.79) $ 613.79 $ (1,256.58) $ (1,256.58) $ (1,256.58) $ (1,256.58) $ 2,122.40 $ 2,331.64 $ 1,707.75 $ 1,468.97 $ (1,173.95) $ 2,169.02 $ 7,256.90 $ 2,979.17 $ 4,817.30 $ 4,351.03 $ 4,517.97 $ 6,054.21
23
- Rent checks not yet cashed by the landlord $ - $ 2,875.00 $ - $ 2,875.00 $ 2,875.00
24
- 202204 T-Shirt income not yet transfered to Outreach Fund $ 50.00 $ 50.00 $ 50.00
25
Operating Income (PNC Main & PayPal accounts)
Jan 2021Feb 2021Mar 2021Apr 2021May 2021Jun 2021Jul 2021Aug 2021Sep 2021Oct 2021Nov 2021Dec 2021Jan 2022Feb 2022Mar 2022Mar 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022
26
Operating Income from memberships $ 4,269.14 $ 4,382.51 $ 6,019.14 $ 4,555.77 $ 5,255.77 $ 4,982.51 $ 5,820.88 $ 5,434.25 $ 5,695.88 $ 5,782.51 $ 5,809.25 $ 5,494.14 $ 5,434.25 $ 5,697.62 $ 6,637.73 $ 6,160.99 $ 6,297.62 $ 6,410.99 $ 6,987.73 $ 7,384.25 $ 6,787.73 $ 6,874.36 $ 6,585.99 $ 7,123.17
27
- Recurring PayPal Membership Income $ 4,269.14 $ 4,382.51 $ 4,619.14 $ 4,555.77 $ 4,655.77 $ 4,982.51 $ 5,220.88 $ 5,434.25 $ 5,695.88 $ 5,782.51 $ 5,809.25 $ 5,494.14 $ 5,434.25 $ 5,697.62 $ 6,037.73 $ 6,160.99 $ 6,297.62 $ 6,410.99 $ 6,387.73 $ 6,634.25 $ 6,787.73 $ 6,674.36 $ 6,585.99 $ 6,962.73
28
- Lump Sum Membership Income (PNC Main & PayPal) $ - $ - $ 1,400.00 $ - $ 600.00 $ - $ 600.00 $ - $ - $ - $ - $ - $ - $ - $ 600.00 $ - $ - $ - $ 600.00 $ 750.00 $ - $ 200.00 $ - $ 160.44
29
- TBD
30
Operating Income from all other sources $ 1,009.41 $ 88.62 $ 3,358.05 $ 1,778.23 $ 5,386.24 $ 98.23 $ 24.27 $ 107.90 $ 94.10 $ 18.82 $ 84.47 $ 47.05 $ - $ 39.64 $ 150.85 $ 275.28 $ 757.00 $ 37.64 $ 56.46 $ 253.82 $ 119.45 $ 1,018.82 $ 1,509.20 $ 143.82
31
- Stripe in (Soda Credits) PNC Main $ 9.41 $ 18.82 $ 47.05 $ 28.23 $ 47.05 $ 28.23 $ 37.64 $ 37.64 $ 94.10 $ 18.82 $ 18.82 $ 47.05 $ 37.64 $ 94.10 $ 75.28 $ 37.64 $ 37.64 $ 56.46 $ 18.82 $ 47.05 $ 18.82 $ 9.41 $ 18.82
32
- Amazon Smiles PNC Main $ 69.80 $ 56.56 $ 70.26 $ 65.65 $ 56.75 $ 56.60 $ 72.40 $ 49.78
33
- Wepay $ 0.01
34
- AC Fund Drive Donations (PNC Main & PayPal) $ 1,000.00 $ - $ 3,311.00 $ 1,750.00 $ 4,961.00 $ - $ - $ - $ 200.00 $ 210.00 $ - $ - $ 235.00 $ -
35
- Garden Street Scrap Iron Run $ 335.00 $ 2.00
36
- Donation (Glass Gas Usage) $ - $ - $ - $ 200.00 $ 210.00 $ - $ - $ 235.00 $ - $ 200.00 $ 125.00
37
- 202204 T-Shirt Order Income not yet transferred to Outreach $ 70.00 $ 452.76
38
- Membership donations and payment corrections $ (13.37) $ (13.37) $ 1,000.00 $ 1,250.00
39
- TBD
40
Total Operating Income (from all sources) $ 5,278.55 $ 4,471.13 $ 9,377.19 $ 6,334.00 $ 10,642.01 $ 5,080.74 $ 5,845.15 $ 5,542.15 $ 5,789.98 $ 5,801.33 $ 5,893.72 $ 5,541.19 $ 5,434.25 $ 5,737.26 $ 6,788.58 $ 6,436.27 $ 7,054.62 $ 6,448.63 $ 7,044.19 $ 7,638.07 $ 6,907.18 $ 7,893.18 $ 7,893.18 $ 7,893.18
41
Operating Expense (PNC Main & PayPal Accounts)
Jan 2021Feb 2021Mar 2021Apr 2021May 2021Jun 2021Jul 2021Aug 2021Sep 2021Oct 2021Nov 2021Dec 2021Jan 2022Feb 2022Mar 2022Apr 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022
42
Total Fixed Operating Expense (from all sources) $ (224.72) $ (3,102.81) $ (3,109.22) $ (5,982.23) $ (234.74) $ (6,051.80) $ (250.76) $ (6,017.46) $ (3,151.73) $ (4,852.93) $ (4,966.86) $ (4,970.43) $ (3,427.84) $ (752.09) $ (6,632.07) $ (570.77) $ (3,676.95) $ (3,485.53) $ (3,811.53) $ (4,272.28) $ (4,904.64) $ (3,866.12) $ (4,158.75) $ (6,733.14)
43
- Rent $ (2,875.00) $ (2,875.00) $ (5,750.00) $ (5,750.00) $ (5,750.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (5,750.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (2,875.00) $ (5,750.00)
44
- Insurance $ (103.59) $ (103.59) $ (103.59) $ (103.59) $ (103.59) $ (103.59) $ (103.59) $ (103.60) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.59) $ (104.51) $ (107.25) $ (107.25) $ (107.25) $ (107.25)
45
- PayPal Fees $ (121.13) $ (124.22) $ (130.63) $ (128.64) $ (131.15) $ (140.42) $ (147.17) $ (163.86) $ (172.14) $ (174.36) $ (175.88) $ (165.66) $ (164.46) $ (173.16) $ (196.81) $ (191.80) $ (190.54) $ (194.28) $ (190.82) $ (220.80) $ (205.74) $ (210.39) $ (203.23) $ (217.37)
46
- Warden Budget $ (704.82) $ (273.20) $ (202.55) $ (524.40) $ (241.30) $ (470.51) $ (286.30) $ (397.31) $ (282.47) $ (214.91) $ (304.29) $ (288.98) $ (283.79) $ (474.34) $ (580.67) $ (224.38) $ (506.82) $ (251.60) $ (491.12) $ (1,071.97) $ (819.18) $ (673.48) $ (969.79) $ (658.52)
47
- Meetup Cost $ (897.47)
48
- Other Operating Expense $ (57.79) $ (150.00)
49
Total Discretionary Expense (from all sources) $ (704.82) $ (430.73) $ (450.17) $ (743.64) $ (1,162.29) $ (1,944.80) $ (8,891.06) $ (1,736.60) $ (6,143.81) $ (1,484.07) $ (1,507.10) $ (1,536.20) $ (1,623.36) $ (2,650.30) $ (1,173.33) $ (238.78) $ (731.14) $ (3,109.52) $ (646.92) $ (3,120.83) $ (9,709.87) $ (525.71) $ (69.70) $ (762.85)
50
- Member Vote expenditures $ - $ (152.53) $ (202.83) $ (197.34) $ (198.00) $ (392.45) $ (204.76) $ (1,339.29) $ (5,714.64) $ (1,269.16) $ (1,202.81) $ (1,247.22) $ (1,623.36) $ (2,650.30) $ (1,173.33) $ (238.78) $ (713.32) $ (3,109.52) $ (646.92) $ (3,120.83) $ (9,709.87) $ (466.27) $ - $ (735.48)
51
- Membership payment corrections $ (5.00) $ (670.00) $ (1.84) $ (146.70) $ (27.37)
52
- AC Fund Pledge Drive Fees $ (44.79) $ (21.90) $ (52.99)
53
- AC Build-Out Expense $ (1,080.00) $ (8,400.00)
54
- Gas donation PP fee $ (0.99)
55
- 202204 T-shirt PP fee $ (16.83)
56
- TBD
57
Total Operating Expense (Fixed and Discretionary from all sources)
$ (929.54) $ (3,533.54) $ (3,559.39) $ (6,725.87) $ (1,397.03) $ (7,996.60) $ (9,141.82) $ (7,754.06) $ (9,295.54) $ (6,337.00) $ (6,473.96) $ (6,506.63) $ (5,051.20) $ (3,402.39) $ (7,805.40) $ (809.55) $ (4,408.09) $ (6,595.05) $ (4,458.45) $ (7,393.11) $ (14,614.51) $ (4,391.83) $ (4,228.45) $ (7,495.99)
58
Monthly Net = Total Operating Income - Total Operating Expense
$ 4,349.01 $ 937.59 $ 5,817.80 $ (391.87) $ 9,244.98 $ (2,915.86) $ (3,296.67) $ (2,211.91) $ (3,505.56) $ (535.67) $ (580.24) $ (965.44) $ 383.05 $ 2,334.87 $ (1,016.82) $ 5,626.72 $ 2,646.53 $ (146.42) $ 2,585.74 $ 244.96 $ (7,707.33) $ 3,501.35 $ 3,664.73 $ 397.19
59
Combined Operating Accounts (PNC Main & PayPal) Ending Balance
$ 24,692.55 $ 25,630.14 $ 31,447.94 $ 31,056.07 $ 40,301.05 $ 37,385.19 $ 34,088.52 $ 31,876.61 $ 28,371.05 $ 27,835.38 $ 28,954.12 $ 29,800.07 $ 32,008.30 $ 34,343.17 $ 33,326.35 $ 38,953.07 $ 41,599.60 $ 41,453.18 $ 44,038.92 $ 44,283.88 $ 36,576.55 $ 39,821.25 $ 43,856.48 $ 43,627.48
60
Discretionary Reserve (Operating Funds Ending Balance - Encumbered Reserve)
$ 3,732.55 $ 4,770.14 $ 5,476.94 $ 3,385.07 $ 7,819.05 $ 5,519.40 $ 10,222.73 $ 9,438.40 $ 4,262.47 $ 3,926.80 $ 5,560.54 $ 6,241.49 $ 7,833.90 $ 7,284.53 $ 9,416.60 $ 12,457.10 $ 17,383.38 $ 17,018.99 $ 14,066.85 $ 18,139.54 $ 9,147.25 $ 12,808.22 $ 16,472.95 $ 16,870.14
61
62
Jan 2021Feb 2021Mar 2021Apr 2021May 2021Jun 2021Jul 2021Aug 2021Sep 2021Oct 2021Nov 2021Dec 2021Jan 2022Feb 2022Mar 2022Mar 2022May 2022Jun 2022Jul 2022Aug 2022Sep 2022Oct 2022Nov 2022Dec 2022
63
Outreach Funds (PNC Outreach) Beginning Balance
$ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,722.06 $ 7,722.06 $ 7,722.06
64
Income $ 403.17
65
Expense $ (405.00) $ (500.00) $ (69.98)
66
Outreach Funds (PNC Ourtreach) Ending Balance
$ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 8,293.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,888.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,388.87 $ 7,722.06 $ 7,722.06 $ 7,722.06 $ 7,722.06
67
68
69
70
71
72
73
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