Support Team Tracking [Template]
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
Monthly Donations
2
NameAmountDateCurrentPayment DOMNotes
3
Your donor's name here
Monthly amount here
Date they started giving
Current on their donations? Type y or n. (see below for more info)
What day of the month do they pay on? I usually like to keep this section filtered by the DOM people give, so I can have a sequential list of people based on when they give throughout the month. Makes it easier to compare to my actual accounting numbers I double check this list against every month.
Additional Notes
4
Example:
5
Mom & Dad (example)$100.005/1/2017y1Instructions
6
Hi!
7
Glad you are interested in my Support Team Tracking spreadsheet. This has been super helpful for me, and I pray it is the same for you!
8
I have outline most of my instructions here on the document next to their appropriate spot, so that hopefully it will make sense. You might need to click on the cell to read the full notation, just a heads up.
9
It would probably be a good idea to delete the instructions when you are finished with them.
10
Feel free to email me with any questions!
11
May the God of all abundance and goodness bless you as you follow His call.
12
- Mat
13
14
Total$100.00
<-- As you add people and amounts into the above section, it will automatically update your monthly total
15
Goal$6,770.00
<-- Add your monthly total here! Not sure what your monthly total is? Check out the Support Budget Template here.
16
Progress1.48%<-- These two numbers will automatically update as you enter in people above, no need to mess with them!
17
Amount Remaining$6,670.00
18
19
Total Lapsed Support$0.00<-- This section is used as time goes on to keep track of donors month to month to see who is current on their donations. It will automatically update as you type either y or n for "yes" or "no" in Current category for each donor. No need to mess with it!
20
Total Current Support$100.00
21
Current Complete1.48%
22
23
24
25
26
27
28
29
30
31
32
33
34
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
Loading...