Hey guys,
You've all received an Excel spreadsheet called the Monthly Donor Sheet. As the name suggests, this will help you track your monthly donors and just how much money you've got represented with pledges. This is important because we do in fact take into account your pledges when working with your support deadlines.
Some of you have asked questions about how to work the Monthly Donor Worksheet. We've put together a little instruction manual for those of you who might want this. So here she is:
After opening the worksheet…
1) Enter the TOTAL AMOUNT CURRENTLY IN YOUR SUPPORT ACCOUNT into box C:1. DO NOT add anything to this amount!
2) Add the name of any and all monthly donors into column A under "DONOR" followed by the amount they have pledged to give each month in column B under "AMOUNT".
3) Column C is the part that gets a little tricky. Here you need to fill in the number of donations they have promised to give but HAVE NOT YET GIVEN. Keep in mind that the donations they have already given are figured into the total amount that is CURRENTLY in your support account. Thus, these numbers WILL CHANGE EVERY MONTH!
4) After you add in each monthly donor, their amount, and the number of donations left to give look at box K:1. Here you should see the amount that WILL be in your account AFTER all of these donations have been given. The worksheet does all the math for you. You shouldn't have to do anything else.
5) The columns on the right labeled "Month 1, Month 2, Month 3, etc." are there to help you keep your records. All you need to do is go through and put an "x" in the box if the donor has given each month. This is a way for you to ensure that you aren't accounting for donors that have stopped giving and also a great way for you to make sure that donors haven't forgotten to make a donation. These columns do not affect the totals in row 1, they are simply there for your records.
Hope this helps! I'm so proud of you guys and praying for a great support raising week!
Kayla
