Sample Giving Spreadsheet

	B	C	D	E	F	G
1	This is a hypothetical example, for informational purposes only. To use it, make a copy for yourself by clicking on "file" and then selecting the fifth option "make a copy." Name it something you will remember.
2
3	Adjust the numbers in green for your situation
4	Prior Year Adjusted Gross Income	$150,000
5	Giving Target (%)	10%
6	Giving Target ($)	$15,000
7
8	Organization	Tax-Deductible Donation	Non-Tax-Deductible Donation	How much did I give last year?	Date	Notes
9	Diverse City Fund	$1,000			2/10/20	In honor of John Smith
10	Jews United for Justice	$1,000			4/1/20	As part of Heschel Awards
11	Janeese Lewis George		$50		5/2/20
12	Against Malaria Foundation	$2,000			6/3/20
13	PCCC c4		$500		6/5/20
14	Project Muso	$1,500			7/12/20
15	ACLU c3	$100			8/1/20
16	ACLU c4		$100		8/1/20
17
18
19
20
21
22
23
24
25
26
27	Sub-total	$5,600	$650
28	Adjusted sub-total	$5,600	$845
29
30	Adjusted total	$6,445
31	Giving Target	$15,000
32	Amount remianing toward target	$8,555
33
34	This spreadsheet is for informational purposes and doesn't constitute tax, legal, insurance or investment advice.
35
36
37
38
39
40
41
42
43
44
45
46
47
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