Receipt Amount is Doubling When I Summarize - Pledges are the issue

So I have built a report that tracks board participation.


The biggest issue I am running into is total giving and total receipted. I exported the Summary Gifts info from RE (i.e. Total Gift Amount and Total receipt amount) and the total giving is correct but for some reason, on gifts that have pledges, the receipt amount is doubled. NOTE: I asked it to pull pledge balance v. total pledge. How do I keep this from happening?


Help!!!!

 

Comments

  • Dariel Dixon
    Dariel Dixon Community All-Star
    Seventh Anniversary Kudos 5 First Reply PowerUp Challenge #3 Gift Management
    I had an issue with a report that was doubling pledges either.  I haven't quite figured it out yet, but I think that when you're counting both pledges and payments, maybe the receipt amount has not been zeroed out on one.  Therefore, when looking at the report, it would report double on the receipt amount.  I don't know if it matters which is zero, the pledge or the payment, but now that I think about it, I'm almost certain this is what caused my issue as well.  I'm thinking it would probably depend on which one you report on more.  Obviously, if you zero the payments, then the full amount would be receipted before the pledge is fulfilled, however only the amount paid so far would be reported if you zero the receipt amount from the pledge.


    I think I might have to do some research and add this to my procedure manual.