Lobbying Against Charity Reform - 4-10 update.xlsx

	A	B	C	D	E	G	H	I	J	L	M	N	O	Q	R
1	Groups Lobbying on the Accelerating Charitable Efforts Act (S.1981 and H.R.6595) in 2021-2023
2	All information is from the U.S. government's LDA lobbying disclosure act database, via OpenSecrets.
3	When an organization listed multiple bills in their lobbying disclosures, we do not know how much money was spent by these organizations on each bill.
4	For this reason, estimated lobbying spent on the ACE Act is estimated assuming the organization spent equal amounts on each bill lobbied.
5	(Total amount spent on lobbying divided by the total number of bills lobbied, multiplied by the number of ACE Act bills lobbied.)
6
7
8		2021				2022				2023 (Q2 YTD)				TOTAL 2021-2023
9	Organization	Count of ACE Act Bills Mentioned in Quarterly Reports	Count of All Bills Mentioned in Quarterly Reports	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Count of ACE Act Bills Mentioned in Quarterly Reports	Count of All Bills Mentioned in Quarterly Reports	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Count of ACE Act Bills Mentioned in Quarterly Reports	Count of All Bills Mentioned in Quarterly Reports	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act
10
11	Vanguard Charitable Endowment Program	3	3	$200,000	$200,000	8	8	$300,000	$300,000	2	2	$90,000	$90,000	$590,000	$590,000
12	Charles Schwab Corp	0	0	$0	$0	1	1	$530,000	$530,000	0	0	$0	$0	$530,000	$530,000
13	Community Foundation Awareness Initiative	3	3	$470,000	$470,000	6	9	$650,000	$433,333	0	0	$0	$0	$1,120,000	$903,333
14	Philanthropy Roundtable	8	22	$260,000	$94,545	21	63	$440,000	$146,667	0	0	$0	$0	$700,000	$241,212
15	Jewish Federations of North America	2	2	$100,000	$100,000	5	5	$140,000	$140,000	0	0	$0	$0	$240,000	$240,000
16	National Philanthropic Trust	2	2	$80,000	$80,000	4	4	$140,000	$140,000	0	0	$0	$0	$220,000	$220,000
17	Council on Foundations	3	3	$90,000	$90,000	8	8	$120,000	$120,000	0	0	$0	$0	$210,000	$210,000
18	Fidelity Charitable Gift Fund	1	1	$10,000	$10,000	6	6	$30,000	$30,000	0	0	$0	$0	$40,000	$40,000
19	Leukemia & Lymphoma Society	0	0	$0	$0	6	109	$430,000	$23,670	0	0	$0	$0	$430,000	$23,670
20	Americans for Tax Reform	4	82	$100,000	$4,878	8	210	$190,000	$7,238	0	0	$0	$0	$290,000	$12,116
21	American Lung Assn	2	468	$140,000	$598	4	1163	$200,000	$688	0	0	$0	$0	$340,000	$1,286
22	Independent Sector	1	9	$10,000	$1,111	0	0	$0	$0	0	0	$0	$0	$10,000	$1,111
23	FreedomWorks	1	16	$10,000	$625	0	0	$0	$0	0	0	$0	$0	$10,000	$625
24
25	Total	30	611	$1,470,000	$1,051,758	77	1586	$3,170,000	$1,871,596	2	2	$90,000	$90,000	$4,730,000	$3,013,354
26
27
28
29	OLD DATA
30		2021				2022				2023 (Q2 YTD)				TOTAL 2021-2023
31	Organization	Count of ACE Act Bills Mentioned	Count of All Bills Mentioned	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Count of ACE Act Bills Mentioned	Count of All Bills Mentioned	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Count of ACE Act Bills Mentioned	Count of All Bills Mentioned	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act	Total Amount Spent on Lobbying	Estimated Amount Spent on ACE Act
32
33	Charles Schwab Corp		3	2710000	0		4	3020000	0		2	1970000	0	7700000	0
34	Fidelity Investments	1	32	2420000	75625	1	41	2590000	63170.73171		33	1865000	0	6875000	138795.7317
35	Vanguard Group	1	12	2380000	198333.3333	1	15	2120000	141333.3333	1	11	1800000	163636.3636	6300000	503303.0303
36	Leukemia & Lymphoma Society		40	635000	0	1	42	700000	16666.66667		25	760000	0	2095000	16666.66667
37	Jewish Federations of North America	1	6	869171	144861.8333	1		893032	0		3	600000	0	2362203	144861.8333
38	Community Foundation Awareness Initiative	1		620000	0	1	1	650000	650000		N/A	530000	0	1800000	650000
39	Philanthropy Roundtable	1		560000	0	1	1	690000	690000		4	480000	0	1730000	690000
40	American Lung Association	1	127	270000	2125.984252	1	188	200000	1063.829787		88	320000	0	790000	3189.814039
41	Council on Foundations	1		220000	0	1		240000	0		N/A	180000	0	640000	0
42	Americans for Tax Reform	1	54	230000	4259.259259	1	45	190000	4222.222222		37	160000	0	580000	8481.481481
43	National Philanthropic Trust	1		160000	0	1		180000	0		N/A	100000	0	440000	0
44	FreedomWorks	1	82	50000	609.7560976		21	60000	0		12	50000	0	160000	609.7560976
45	Independent Sector	1	13	90000	6923.076923		17	50000	0		9	30000	0	170000	6923.076923
46
47	Total	11	369	11214171	432738.2432	10	375	11583032	1566456.784	1	224	8845000	163636.3636	31642203	2162831.391
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
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