Adjusting a written off pledge

Cross Posted to Devo/Technical Heeellpp! A member of our devo team wrote off part of a pledge that really should have been an adjustment. Unfortunately, since write-offs can't be adjusted after-the-fact, now we are stuck. I know I have seen this problem come up for others before and I think someone had a back-end solution-- let me know if you do! Here are the particulars (with some dummy amounts): 1. pledge is entered ($10 due) 2. payment is received ($6 received) 3. pledge was written off ($4 written off) Now the pledge is un-adjustable, but we need to move a portion of the $6-- say $2-- into a different fund. Aaaaaaaahh. Obviously, going forward, better write-off protocols are the answer, but in the mean time-- what should I do? Thanks, Sheila
  • Sheila,

    So the pledge has been partially paid and part of the amount has been written off; would it be possible to back out the payment (put to on account or adjustment), adjust off the pledge, and then re-enter the money received however it needs to be portioned out by fund? You'll end up with a few orphaned 0 line items in the contributions tab, but you'll regain your flexibility with the funds received.

    Thank you,

    Brian

  • Side note: this is also why we have a strict rule about how we handle pledges that will not be fulfilled. If we know that a pledge won't be fulfilled within the current fiscal year, it gets adjusted down to $0 or whatever the amount is that we'll actually be receiving instead of being written off with the actual write off tool.

    The only pledges we ever write off are pledges from a previous fiscal year that has been closed out.

    It sounds like that's how you're operating (except for this unhappy accident!) but I figured I'd share our approach to the accounting.

  • Shelia,

    I had this same question a couple of years ago, I don't know if this thread will help (you may have already seen it): http://www.tessituranetwork.com/Community/forums/t/11996.aspx

    I ended up leaving the write off alone, but you could do it through the back end.

    Melissa

  • Thanks, Melissa and Brian.

    Brian-- I wish it were that simple-- but writing it off locks it from any type of adjustment at all.

    Melissa-- thanks for the link! I did end up choosing the route of editing from the back end (in case it comes up for anyone else-- go directly into the database and set t_contribution.cancel to 'N' and pledge_status = 2 for that contribution, as described here http://www.tessituranetwork.com/Community/forums/t/10593.aspx). 

    Cheers,

    Sheila