Monthly statements for donors who pay by credit card.
We would like to start sending monthly statements to our donors who pay their pledges via credit card. Several donors have requested these and I am not sure the best way to run them.
I would like to just get the exported fields to merge into a letter showing their fund description, pledge amount, amount paid to date(total not each payment) and pledge balance. Also I would include their installment frequency. It would be nice to bring over their installment amounts too but I always seem to struggle with next installment amount.
Any help is appreciated.
Nicol
Comments
-
Nicol Hudson:
We would like to start sending monthly statements to our donors who pay their pledges via credit card. Several donors have requested these and I am not sure the best way to run them.
I would like to just get the exported fields to merge into a letter showing their fund description, pledge amount, amount paid to date(total not each payment) and pledge balance. Also I would include their installment frequency. It would be nice to bring over their installment amounts too but I always seem to struggle with next installment amount.
Any help is appreciated.
Nicol
Actually I think what we would really like to do is to run a quarterly statement for these folks just showing the pledge amount and any payments made during that quarter. Running this monthly would be way too time consuming and too much mail to each donor.
0 -
Nicol Hudson:
Actually I think what we would really like to do is to run a quarterly statement for these folks just showing the pledge amount and any payments made during that quarter. Running this monthly would be way too time consuming and too much mail to each donor.
Is this statement going to serve as the acknowledgement for the payments? Are you doing this through donor acknowledgement letters?
My donor acknowledgement letters for pledge payments include the original pledge amount and current balance. I do not think it includes next payment date or payment schedule but not sure if that is because it can not or we just never tried.
0 -
Melissa Graves:
Is this statement going to serve as the acknowledgement for the payments? Are you doing this through donor acknowledgement letters?
My donor acknowledgement letters for pledge payments include the original pledge amount and current balance. I do not think it includes next payment date or payment schedule but not sure if that is because it can not or we just never tried.
In quickly looking, it does not look like donor acknowledgement letters can include next payment info or payment schedule. You may want to add a comment to this suggestion in RE discovery to request it.
0 -
Melissa Graves:
In quickly looking, it does not look like donor acknowledgement letters can include next payment info or payment schedule. You may want to add a comment to this suggestion in RE discovery to request it.
Well I am not sure how we do this. Typically we don't acknowledge payments for people paying thru EFT or Credit card. So they were looking at a way to get them a statement to send quarterly just to touch base and let them know what their payments were during that quarter and what their balance now is.
I haven't found a way to do it. I tried using receipts but it generates a receipt per payment and I just really wanted on receipt with all the payments made during that quarter.
Using the pledge status or gift detail and summary report seemed to give me what I am looking for minus the frequency but it is a canned report and I was hoping to find a way to do this with a merge or an export.
0 -
Nicol Hudson:
Well I am not sure how we do this. Typically we don't acknowledge payments for people paying thru EFT or Credit card. So they were looking at a way to get them a statement to send quarterly just to touch base and let them know what their payments were during that quarter and what their balance now is.
I haven't found a way to do it. I tried using receipts but it generates a receipt per payment and I just really wanted on receipt with all the payments made during that quarter.
Using the pledge status or gift detail and summary report seemed to give me what I am looking for minus the frequency but it is a canned report and I was hoping to find a way to do this with a merge or an export.
These donors need acknowledgements to claim the gifts on their taxes. With monthly donors they can either get them each month or get a consolidated one in January (for the previous calendar year) for their taxes. .This is likely why your donors are requesting them. I would consider institituting annual receipts for anyone paying monthly. I think quarterly is strange.
We acknowledge the pledge (or recurring gift) immediately and tell the donor they will not get monthly acknowlwedgements but instead one in January for their taxes. We tell them they can contact us at any time for an update on where they are in the meantime. We enter the gifts and then mark them not acknowledged but use a letter code indicating it will be done with an annual receipt. This letter code is excluded in the daily letter runs. so these gifts remain not acknowledged.
In January, I use an export to export all unacknowledged gifts from the previous calendar year (pledge payments and recurring gift payments) and do a mail merge to get a summary statement for each person. It takes some work to set up but once done it is not hard to do.
0 -
Melissa Graves:
These donors need acknowledgements to claim the gifts on their taxes. With monthly donors they can either get them each month or get a consolidated one in January (for the previous calendar year) for their taxes. .This is likely why your donors are requesting them. I would consider institituting annual receipts for anyone paying monthly. I think quarterly is strange.
We acknowledge the pledge (or recurring gift) immediately and tell the donor they will not get monthly acknowlwedgements but instead one in January for their taxes. We tell them they can contact us at any time for an update on where they are in the meantime. We enter the gifts and then mark them not acknowledged but use a letter code indicating it will be done with an annual receipt. This letter code is excluded in the daily letter runs. so these gifts remain not acknowledged.
In January, I use an export to export all unacknowledged gifts from the previous calendar year (pledge payments and recurring gift payments) and do a mail merge to get a summary statement for each person. It takes some work to set up but once done it is not hard to do.
We do send out annual tax receipts to everyone regardless of their payment type..however there is discussion that other than seeing BMS on their credit card statement they are not receiving anything from us from the day the pledge to the time it is paid off. We are running a capital campaign.
I just want a receipt but I want it consolidated not printing a receipt for every payment but if I can put in a date range a receipt for payments made during a time period. We selected quarterly since we have so many different pledge schedules.
Our EFT/CC payments are not marked send reminders that is how they are excluded in our data pull.
0 -
Nicol Hudson:
We do send out annual tax receipts to everyone regardless of their payment type..however there is discussion that other than seeing BMS on their credit card statement they are not receiving anything from us from the day the pledge to the time it is paid off. We are running a capital campaign.
I just want a receipt but I want it consolidated not printing a receipt for every payment but if I can put in a date range a receipt for payments made during a time period. We selected quarterly since we have so many different pledge schedules.
Our EFT/CC payments are not marked send reminders that is how they are excluded in our data pull.
Are you printing your receipts through donor acknowledgement or receipts? If you use receipts, it's quite easy to send a consolidated receipt for whatever time frame you choose. Just have the EFT/CC donors marked for 'consolidated recetip' on the Bio 2 tab. Run your receipts at the end of each quarter. Any gifts not previously receipted will receipt.
We receipt annually for EFT/CC donors but we have added a summer letter to them to 'maintain good donor relations' as they weren't getting the monthly thank you/receipt. As others said in pledge thank you we state they'll get receipt at year end unless otherwise requested. No one's ever requested differently.
0 -
Nicol Hudson:
We do send out annual tax receipts to everyone regardless of their payment type..however there is discussion that other than seeing BMS on their credit card statement they are not receiving anything from us from the day the pledge to the time it is paid off. We are running a capital campaign.
I just want a receipt but I want it consolidated not printing a receipt for every payment but if I can put in a date range a receipt for payments made during a time period. We selected quarterly since we have so many different pledge schedules.
Our EFT/CC payments are not marked send reminders that is how they are excluded in our data pull.
But that is sometimes the benefit a donor sees in making a pledge. Other than the annual tax receipt you are not bothering them about their giving. Maybe you need to make your annual receipt for these people be more of a stewardship piece than a simple receipt? Do you not send newsletters? Have any stweardship pieces that go to these folks? I would not use a monthly or quarterly statement as a stewardship piece.
I agree - they should not be gerring reminders. (but payments do not get marked no reminders - pledges do) Frankly, a quarterly statement would seem too much to me like a reminder.
In my opinion, if you are trying to create a stewardship program for your donors in pledges I would not start with statements. That is a basic and it sounds like you have an annual receipt that is already being done. Why duplicate that? Maybe it needs work to kick it up a notch but I think you need to work on basic touches with these folks that have nothing to do with their pledge. A semi annual letter from your president keeping them up to date on what the organization is doing, newsletters, event invitations, etc.
Regardless - if you want to do this - you will have to export the data and create a custom mail merge. I use a constituent export and export all of the payments in separate columns of each constituent row. This will allow you to mail merge one letter per person and get each gift detailed. I do not think you can do it from Mail.
0
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 1 YourCause® from Blackbaud®
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 1.1K ARCHIVED FORUMS | Inactive and/or Completed EAPs
- 3 Blackbaud Staff Discussions
- 7.7K ARCHIVED FORUM CATEGORY [ID 304]
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board