Gift Detail and Summary Report re: Write Offs
When you all are running your Gift Detail and Summary reports to report on total commitments, what is your strategy to ensure you are not counting current fiscal year pledges that have been written off?
It recently came to my attention that in the Gift Detail and Summary Report, if a constituent pledges $100 this fiscal year and that pledge is written off the following day, this transaction now has two Gift Types, Pledge and Write Off. We know this is true because if you run the Gift Detail and Summary report with only two columns, Pledges and Write offs, you will see a dollar value in both columns.
Here's my problem. Typically when I report commitments, I include all gift types with the exception of pledge payments and write offs. The problem is, I can't easily tell which of those Pledges are write offs and therefore should not be included in my commitments. One clarifying note, I realize if I check the box to report only on the Pledge Balance I will not see dollar totals on the written off Pledges in the Pledge column, but for the purpose of reporting all commitments I need to see the entire pledge amount, not just the remaining balance.
To complicate things more, let's imagine I put an additional column in my report called Write Offs so that I can see the Pledge and the Write Off on the same line. The issue here is that if the Pledge was made in a previous fiscal year, yet the Write Off happened in the current fiscal year, I will see the Write Off, but in this case I should ignore the Write Off because the commitment was in a previous fiscal year and thus isn't included in this fiscal year's commitments total.
So, the question again is, When you all are running your Gift Detail and Summary reports, what is your strategy to ensure you are not counting current fiscal year pledges that have been written off and that additionally, you are ignoring Write Offs where the Pledge was made in a previous fiscal year (again, this is for calculating total commitments for this fiscal year)?
Thanks in advance-
Aaron
Comments
-
If you need to be that specific, I would suggest utilizing the reports under Pledge and Recurring Gift Reports >> Written Off Report is very handy, give you the amount pledge and the amount written off.
There is also the Cash Flow Report if you want to see what is committed to coming.
The Pledge Status Report shows you the Full Pledge Amount, the payment schedule, Write Off if there is one. You can set the window of time to look for Pledges, then you can subract out those that you feel you do not need to count this FY.
Lastly, the Cash Flow report will give you a picture of what is committed to coming in. You can break down by year, quarter, month, whatever
Hope this helps0 -
It's a good question. Whenever we have run reports or queries or exports where there are write offs it always seems to take a fair amount of manual editing. Generally our unpaid pledges for 2015 are written off in 2016. Yes, it can make a reporting mess. And donors will pull with original pledge amount for many listings instead of what their gift was after write off. It is sort of frustrating to us.
Will be watching for the solution if another user has found it.1 -
Thanks for your input Christine as those are good suggestions. I haven't used those reports because I'm not having a hard time finding the write offs. I can see them in the Gift Detail and Summary report. It's the research part of finding which ones to back out of my commitment totals and which to ignore that I was hoping to somehow automate. JoAnn seems to face a similar challenge. And I hear you JoAnn on the Write Offs happening the following FY making reporting a mess. We wrote off our pledges on July 14 of this year and I won't be doing that again, lesson learned. I've already spoken with our gift processing manager and our plan is to write everything off on June 30 and recreate pledges if gifts for any of those write offs come in the first two weeks of the next fiscal year. We're still working on how to sell that story to the directors/VPs.0
-
instead of writing a new pledge why not do an adjustment and carry it forward? That way you will not lose the original entry date, which is on the books with finance?
What if you wrote a query looking for JUST the gift type of Write Off and then pulled that through gift detail and summary?
Or use the query to do an export that would list the original pledge date/amount/fund and and then the same with the write off info.0 -
In theory (logically) lots of things should work with write offs.
Christine, what would you change in your gift adjustment? The fund? Sorry, I'm not seeing what an adjustment would do to solve reporting issues of pledge from previous year.
To me there are unresolved issues with write-offs in RE. You would think that you could query (constituent or gift) on write offs to a specific fund. Not so that I've found...the only way to get that info in a query is an output from Reports > Write offs.2 -
We view write-offs as an "expense" which wouldn't change the "commitment" total.0
-
I am not sure if this resolves your specific problem, but I recently found something that relieved much of my frustration when looking back in time at totals raised for a particular fund or campaign using the Gift Detail and Summary report. I recently discovered that using all of the Cash types, all of the Stock types, and Recurring Gift Pay-Cash in one column then using the gift type Pledge in another column while choosing the 'Use gift balance instead of gift amount option' along with the 'Calculate gift balance based on date range, campaign, fund, and appeal' option on that Pledge column, I can see the amount paid towards the pledge and the balance of the pledge at any particular time during the year. For example, we have a constituent who made a $300 pledge in November, paid $100 of it in December, then had us write off the $200 balance in January. If I choose an end date of November 30 on tab one of my parameters for the report, I see the whole pledge amount ($300) in the Pledge column and in the Total column. If I choose December 31 as the date, I see the amount paid toward the pledge ($100) in the Cash In column, the Pledge balance ($200) in the Pledge column, and $300 in the Total column. If I choose today's date, I see $100 in the Cash In column, $0.00 in the Pledge column, and $100 in the Total column.
Aaron Rothberg:
Thanks for your input Christine as those are good suggestions. I haven't used those reports because I'm not having a hard time finding the write offs. I can see them in the Gift Detail and Summary report. It's the research part of finding which ones to back out of my commitment totals and which to ignore that I was hoping to somehow automate. JoAnn seems to face a similar challenge. And I hear you JoAnn on the Write Offs happening the following FY making reporting a mess. We wrote off our pledges on July 14 of this year and I won't be doing that again, lesson learned. I've already spoken with our gift processing manager and our plan is to write everything off on June 30 and recreate pledges if gifts for any of those write offs come in the first two weeks of the next fiscal year. We're still working on how to sell that story to the directors/VPs.
0 -
I don't remember all of the reasoning, but one of my first major frustrations with RE was write-offs. I decided, with buy-in from my boss, to avoid the write-off function and use Gift Adjustments instead. This allows a Query to show the Original Pledge Amt and the Adjusted Amt both (I could never find an option other than the Gift Record itself that shows the Write-Off Amt). Every such gift gets a Subtype of "Write-Off", a GiftNote that fully explains the circumstances (including approvals from Finance/CFO and VP Development), and on the Adjustment, the Reason is "less $150 (from $200)" with a short description or "see GiftNote".
However, we do not use RE canned reports, so if we were to start using them, we'd need to do some careful testing. Instead, we export our data (from Export or from Query...and I know Query is not supposed to be used for exporting, but these Queries have been thoroughly tested) and run custom reporting outside of RE.
I wish RE would create an actual Gift Record for a write-off, that could be opened, edited, exported, etc. just like any other gift, except you could include or exclude the record in data outputs (reports, queries, exports). I suppose that's an option...use Gift Type: Other (which becomes Pay-Other) with Subtype: Write-Off and enter it as a payment. Again, would need to do some testing with canned reports (and edit some code in my custom reports!).0 -
Bleh, write-offs.
I don't know that I would use the gift type of other for write-offs. I have sometimes found other uses for the other type (specifically charity campaigns, but that's another post). But mostly I would worry that the write-off could look like a gift. It would be nice if you could use the legend to make that row red or gray or something, but if you are using other for any other gifts they would also appear red.
Personally, I think perhaps at lease seeing the write-offs without having to go through the original pledge record. I also think that if the write-offs would export like a negative number it would help when reconciling with finance.3 -
with the Gift Detail and Summary Report you can also choose to have the Write Off amount as a column that would be included, choose that Gift Type to go into one of the columns.
I find that utilizing the 4 columns available this wait is most straightforward and tells the story the clearest:
Column 1 are gift types of: header is cash/stock - Cash, Stock/Property, Stock/Property(sold), recurring gift, other
Column 2 are gift types of: header is full pledge - Pledge and MG Pledge AND
the :"use gift balance instead of gift amount" is UNchecked
Column 3 are gift types of: header is payments - Pay-cash, MG Pay-cash, Recurring Gift pay-cash, Pay-stock/property,
MG Pay-stock/property, pay-Stock/property(sold), MG Pay-stock/property(sold), Pay-Other, MG Pay-Other
Column 4 are gift types of: hear is write off - Write off and MG Write Off
That will give you the 4 categories most everyone is looking at.0 -
We have similar issues with write-offs. We use an attribute on the gift of Pledge Date on the pledge and pay cash (payments) so we can pull in the pledges within the period we want to see the initial pledge. Then pull in the pledge balance and calculate accordingly.
It is frustrating that write offs are not linked to the original pledge.
Hoping for improvements!!
Jane1
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