ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Jan 17Feb 17Mar 17Apr 17May 17Jun 17Jul 17Aug 17Sep 17Oct 17Nov 17Dec 1720172016 ActVar2016 BudVariance
2
BudBudBudBudBudBudBudBudBudBudBudBudTotal Budonly US numbers2017 vs 2016 BudNotesComment / Assumption
3
ACCRUAL BASEDCASH BASED
4
Ordinary Income/Expense
5
Income
6
Membership Income
7
Corporate
 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 33,333 $ 400,000 $ 400,250 $ (250) $ 400,000 $ - reduced $26K 60 Corp, 5@20K, 55@5K
8
Corporate - Chapter/Project
 $ - $ 2,000 $ - $ 4,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Is Allocation from Gross Amt?
9
EU Corporate
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
10
Individual
 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 78,000 $ 76,163 $ 1,837 $ 110,000 $ (32,000) 2200 Paying Individuals
11
Individual - Chapter/Project
 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 48,000 $ 40,444 $ 7,556 $ - $ 48,000 Is Allocation from Gross Amt?
12
Local Chapter
 $ - $ - $ - $ - $ - $ 905 $ (905) $ 850 $ (850) Sourced from?? 2015 Actuals
13
Local Chapter - Chapter/Project
 $ - $ - $ 10,108 $ (10,108) $ 7,650 $ (7,650) Sourced from?? 2015 Actuals
14
Total Membership Income
 $ 43,833 $ 45,833 $ 43,833 $ 47,833 $ 43,833 $ 43,833 $ 43,833 $ 43,833 $ 43,833 $ 43,833 $ 43,833 $ 43,833 $ 532,000 $ 533,869 $ (1,869) $ 518,500 $ 13,500
15
AppSec Conference Income 2017
 $ - $ - $ -
16
AppSec EU 2017
 $ - $ - $ - $ 550,000 $ - $ - $ - $ - $ 550,000 $ 233,081 $ 316,919 $ 400,000 $ 150,000 Kept APSEC to Bud, added back $150K in revenueAssumes All Income from Detail Worksheet
17
AppSec US 2017
 $ 1,165,000 $ 1,165,000 $ 1,111,675 $ 53,325 $ 1,000,000 $ 165,000 Took out $146K to keep at Bud for Sept 2016
18
AppSec LATAM Tour 2017
 $ - $ - $ - $ - $ 20,000 $ (20,000)Is this happening, not as budgeted??
19
AppSec China 2017
 $ - $ - $ - $ - $ - $ - $ - $ 50,000 $ (50,000)Is this happening, not as budgeted??Adjusted down from 100K to 50K
20
Other Global Event
 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 78,000 $ 73,438 $ 4,562 $ - $ 78,000 Did this take the place of the above or is it 1&2 in exp
21
Total Global AppSec Conf. 2017
 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 556,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 1,171,500 $ 6,500 $ 6,500 $ 1,793,000 $ 1,418,193 $ 374,807 $ 1,470,000 $ 323,000
22
Local & Regional Events 2017
 $ - $ - $ - Assumes All Income from Detail Worksheet
23
AppSec CALIF 2017
 $ 160,000 $ - $ - $ - $ - $ - $ 160,000 $ 158,023 $ 1,977 $ 160,000 $ - it was over bud in rev
24
LASCON 2017
 $ - $ - $ - $ - $ - $ 115,000 $ 115,000 $ 112,771 $ 2,229 $ 80,000 $ 35,000
25
Other Local/Regional
 $ 990 $ - $ 3,000 $ - $ 1,200 $ 3,770 $ 4,060 $ 327 . $ - $ - $ 13,347 $ 13,347 $ - $ 160,000 $ (146,653)
26
Other Local/Regional
 $ - $ 1,039 $ (1,039) $ - $ -
27
AppSec IL 2017
 $ - $ 2,000 $ (2,000) $ - $ -
28
Other Local/Regional
 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 1,500 $ 18,000 $ 12,631 $ 5,370 $ - $ 18,000
29
Total Local & Regional Events
 $ 162,490 $ 1,500 $ 1,500 $ 4,500 $ 1,500 $ 2,700 $ 5,270 $ 5,560 $ 1,827 $ 1,500 $ 116,500 $ 1,500 $ 306,347 $ 299,811 $ 6,536 $ 400,000 $ (93,653)
30
Total Conference Income 2015
 $ 168,990 $ 8,000 $ 8,000 $ 11,000 $ 558,000 $ 9,200 $ 11,770 $ 12,060 $ 8,327 $ 1,173,000 $ 123,000 $ 8,000 $ 2,099,347 $ 1,729,205 $ 370,142 $ 1,870,000 $ 229,347
31
Project Summit Income(Sponsorship)
 $ - $ - $ - Assumes Sponsorship but no Reg. Fees
32
Project Summit 1
 $ - $ - $ - $ 2,000 $ (2,000) $ 25,000 $ (25,000)Is this happening, not as budgeted??This is new Forecast
33
Project Summit 2
 $ - $ - $ - $ - $ - $ - $ 25,000 $ (25,000)
34
Total Project Summit Income
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,000 $ (2,000) $ 50,000 $ (50,000)
35
Marketing & Advertising Income
 $ - $ - $ -
36
Merchandise Income (as Sold)
 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 9,000 $ 5,780 $ 3,220 $ 2,400 $ 6,600
37
Banner Ads-website
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 8,550 $ (8,550) $ 8,500 $ (8,500)
38
Total Advertising Revenue
 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 9,000 $ 14,329 $ (5,329) $ 10,900 $ (1,900)
39
Donations & Grants-Other Income
 $ - $ - $ -
40
Donation direct to Local Chapter
 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 24,000 $ 22,842 $ 1,158 $ 10 $ 23,990 Assumes no Foundation split
41
Donation direct to Project
 $ - $ - $ - $ - $ 1,569 $ (1,569) $ 10 $ (10) " " " " and NOT from Member fee split
42
Donations to Foundation - PP, Amazon, etc.
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 10 $ (10) Charitable giving via website, etc.
43
Donation to Program (ie WASPY-WIA)
 $ - $ - $ - $ - $ - $ 10 $ (10)
44
GRANT (ie DHS)
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 10 $ (10)
45
GRANT - (ie Google)
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 10 $ (10)Cash or Non-Cash too?
46
Total Donations & Grants
 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 24,000 $ 24,411 $ (411) $ 60 $ 23,940
47
Total Income
 $ 215,573 $ 56,583 $ 54,583 $ 61,583 $ 604,583 $ 55,783 $ 58,353 $ 58,643 $ 54,911 $ 1,219,583 $ 169,583 $ 54,583 $ 2,664,347 $ 2,303,814 $ 360,533 $ 2,449,460 $ 214,887 Need to take a deep dive into the Revenue
48
Expense
 $ -
49
Payroll, Benefits & Staff Expenses
 $ -
50
Payroll - Salary
 $ - $ 370,683 $ (370,683) $ 337,536 $ (337,536)2015Baseline x 4% for 2016
51
Payroll Benefits & Fees-Insperity
 $ - $ 110,529 $ (110,529) $ 84,384 $ (84,384)Tax, Benefits, Insperity fee, etc ~25%
52
Commission
 $ - $ 26,547 $ (26,547) $ 29,250 $ (29,250)
53
Other
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 6,000 $ (6,000) $ (126) $ 126
54
Total Payroll Expenses
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 513,758 $ (513,758) $ 451,044 $ (451,044)Not sure why this is over bud 3 months into the year Need to see why $5K up after 3 months
55
Professional & Contractor Fees
 $ -
56
Virtual Mgmt Financial
 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 4,000 $ 48,000 $ 48,000 $ - $ 48,000 $ -
57
Accounting-US (Tax, etc.)
 $ - $ 20,000 $ - $ 20,000 $ 2,182 $ 17,818 $ 4,000 $ 16,000
58
VAT Services
 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 7,200 $ -
59
Accounting-EU (KPMG, other)
 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 875 $ 10,500 $ 6,500 $ 4,000 $ 11,500 $ (1,000)
60
Legal Services
 $ - $ - $ - $ - $ - $ 2,500 $ 2,500 $ 3,969 $ (1,469) $ 9,000 $ (6,500)
61
IT Support
 $ - $ - $ - $ - $ 10,000 $ (10,000) $ 12,000 $ (12,000) due to Dec 2015 and Jan paid in Jan 2016
62
Graphic Design
 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 600 $ 7,200 $ 7,175 $ 25 $ 14,400 $ (7,200)
63
Tech Writer-Projects-New
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
64
Wiki Proj
 $ - $ - $ 18,750 $ - $ - $ 18,750 $ - $ - $ 18,750 $ - $ - $ 18,750 $ 75,000 $ - $ 75,000 $ - $ 75,000
65
Conference-Event Support-New
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
66
Admin Support-Intern-New
 $ - $ - $ - $ - $ - $ - $ 7,373 $ (7,373) $ 28,000 $ (28,000)Not hired yet
67
Other Contractor
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
68
Total Professional Fees
 $ 6,075 $ 6,075 $ 24,825 $ 6,075 $ 6,075 $ 24,825 $ 6,075 $ 26,075 $ 24,825 $ 6,075 $ 6,075 $ 27,325 $ 170,400 $ 85,198 $ 85,202 $ 126,900 $ 43,500
69
 $ -
70
General & Admin - Operations
 $ - Total2015
71
Merchandise
 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 750 $ 9,000 $ 10,893 $ (1,893) $ 12,000 $ (3,000)$8,698
72
Payroll includes Benefits
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!
73
Office Supplies & Equipment
 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 2,400 $ 2,382 $ 18 $ 2,640 $ (240)$2,652
74
Organization costs
 $ - $ - $ 350 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 350 $ 332 $ 18 $ 25 $ 325 $25
75
Phone Expenses
 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 1,333 $ 16,000 $ 15,707 $ 293 $ 14,400 $ 1,600 $13,693
76
Professional Improvement/Training
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,000 $ (2,000)$350
77
Employee Recognition
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,000 $ (2,000)$167
78
Board Travel
 $ - $ - $ - $ - $ - $ 6,500 $ - $ - $ 7,500 $ - $ - $ 14,000 $ 10,655 $ 3,345 $ 13,000 $ 1,000 $11,820
79
Board Meeting Costs
 $ - $ - $ - $ - $ - $ 4,500 $ (4,500) $ 4,500 $ (4,500)
80
Bank Service Charges
 $ -
81
Bank Fees
 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 333 $ 4,000 $ 4,006 $ (6) $ 5,100 $ (1,100)$5,200
82
Credit Card Fees
 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 125 $ 1,500 $ 1,474 $ 26 $ 3,000 $ (1,500)$3,000
83
Donation CC fees
 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 15 $ 180 $ 164 $ 16 $ 402 $ (222)$272
84
Membership CC Fees
 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 400 $ 4,800 $ 4,585 $ 215 $ 4,325 $ 475 $4,353
85
Insurance - Liability
 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 500 $ 6,000 $ 7,042 $ (1,042) $ 3,300 $ 2,700 $6,450
86
Insurance - D&O
 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 250 $ 3,000 $ 2,800 $ 200 $ 2,800 $ 200 $0
87
Shipping & Postage
 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 200 $ 2,400 $ 2,280 $ 120 $ 2,328 $ 72 $2,328
88
Portal & Website, Fonteva/Sales force lic fees
 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 1,667 $ 20,000 $ 9,750 $ 10,250 $ 19,249 $ 751 Not sure what the $12,180 in July is for, but these offset$19,249
89
AMS Migration proj
 $ 5,000 $ 10,000 $ 5,000 $ 20,000
90
Software & Internet -includes mailman conversion
 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 1,400 $ 16,800 $ 14,998 $ 1,802 $ 34,014 $ (17,214)left this as under bud$34,014
91
Staff Travel
 $ 2,000 $ 2,000 $ 3,800 $ 2,000 $ 2,000 $ 2,000 $ 3,800 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 2,000 $ 27,600 $ 15,465 $ 12,135 $ 13,017 $ 14,583 $13,017
92
Travel Fees
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 763 $ (763) $ 792 $ (792)$792
93
Marketing/Comm/PR
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
94
Wiki-Website Development
 $ - $ - $ - $ - $ - $ 30,000 $ (30,000) $ 30,000 $ (30,000)
95
Other 1
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -
96
Other 2
 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 101 $ (101) $ - $ -
97
TOTAL Gen Admin & Operations
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF! $ 137,898 #REF! $ 168,891 #REF!
98
 $ -
99
Conference Expenses 2016
 $ -
100
Conference Payroll Exp
#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!#REF!