Hello,
Does anyone have a recommendation about how to track expected cash for contributions that have not been booked and cannot be booked as pledges? Then once the money is received we could automatically delete or alter the expected amount.
Thank you,
Erica Weitze
Development Operations Coordinator
Opera Philadelphia
weitze@operaphila.org
Erica,
This might be something you could track in Plans; you'd create a new Plan for the constituent you're expecting to receive cash from (tied to the appropriate Campaign and Fund), and you can enter the amount expected under the Ask or Goal fields. Then, as the cash actually comes in, you could associate the contributions to the plan and then you won't even have to delete anything once the final cash contribution amount is received.
Brian
Hi Brian,
Thanks for your response! What I'm actually looking for is tracking expected cash by month. Especially for donors with multiple payments coming in. Any suggestions?
Thanks,
Erica
Hmm... I know that there's the Yearly Cash Planning Report which would probably give you exactly what you're looking for, but it's going to function off of what's been entered into Tessitura as a formal pledge. I don't *think* there's a way to do it without actually putting the pledge with a payment schedule in through contributions.
If money wasn't received, you could always zero out or write-off the pledge, but I imagine such a recommendation might not go over too swimmingly with your Finance Department if they're not necessarily on board with the pledge entry.
Hi Erica,
It sounds like you may be trying to deal with verbal commitments for DAF gifts. A couple ideas:
-We've created a non-FY DAF campaign that allows us to book "pledges" that track to a dummy GL/no correlation to finance. That is so we can put in real payment dates so staff can properly follow up on those pledges, and presumably could be used for cash flow considerations. There are considerations to this: the pledge needs to be adjusted out after the actual gift is received (double work not so great) and I suggest that you would not include this campaign in your revenue reporting since it's not dependable until the monies are received. It's nice b/c these can show up in the yearly cash planning report as well as outstanding pledge reports. We've done a similar thing to track revocable planned gifts - booked in Tess so we can properly track and steward the gift, but the fund GLs are all zeros and our finance office does not book these.
-If you are talking about DAFs, it is possible to get the Fidelity/Schwab/etc to provide a written pledge that actually allows you to book the patron's pledge. This wouldn't be useful all the time, but if you're dealing with significant commitments you may look into it.
MeganSeattle Symphony