Written Off Pledges

Options
Hello all - a member of my team runs an export of pledges on our CC weekly and on this export/report we have a pledge that has been written off. The pledge still shows at the full amount and does not reflect the write off. Does anyone know a way to fix this, or a work around? 



Any feedback is appreciated!
Tagged:

Comments

  • Is the report set only to show write offs in a certain time frame?  Also, there is a check box that limits pledge activity to the dates of the report- that could be the issue.  
  • We dont use the reporting function for this, its done through an export.
  • Can we back up?  How is the pledge written off?  Through a write off from the gift tab of the gift?  Does it show that it's written off on the gift record?  Is balance $0?  If not possibly the write off did not get done correctly. 



    Before trying to answer questions on a report or export, I'm wondering what the actual pledge gift record shows.
  • Yes, it was written off through the WO function in the gift tab with a balance of 0.
  • Does it still show on your report?  Or is issue dates as Christine suggested? 



    Is the pledge by chance one with split gifts?  I've seen that create some wierd, erroneous figures on reports.



    Are you taking a query to your export file?  Is query dynamic?  Does the gift show in the query prior to export?  Is there a criteria/option in query that is bringing it to Export?



    Does the written off pledge show on the Reports > Pledges... > Written Off report?



    Just trying to think of some possible causes?

     
  • Hi Everyone thanks so much for your help so far!



    Yes - it is showing off in the WO report.



    Yes - Query is dynamic



    Yes - the gift DOES show at the full pledge amount in the Query output, so the query is pulling it wrong. 



    No - Not a split gift 

    :/
  • The query is just not pulling what you're expecting.  A write off doesn't change the pledge amount.  It only changes the balance.  See what happens if you use "pledge balance" for your criteria/output - not sure your criteria/output are for this export or what you're trying to do with it.  If you need pledge to be $0 and there were no payments made to it, you could possibly use an adjustment instead of a write off.  That will change the pledge amount.



     
  • you are so right. Thanks so much!

Categories