Hi! I'm looking for a report that will show me pledges paid within a certain time frame - when the cash actually came in. The New Contributions report only shows me when a pledge has been made, but not a payment on a pledge, which is not helpful when recording cash flow. Is there a report that shows just payments on pledges made with the amount and the date? Pledge Balance Detail, Pledge Gift, Pledge Receivable by Period and Pledge Receivable Report are all not what I am looking for, unless I am inputting something wrong.
Hi Rachel - the Fund Activity Report (located in the Finance folder of reports) may be just what you want. It gathers up activity within a range of transaction, posting, or contribution dates you provide, and then outputs it with separate columns that track pledges made, pledge payments made, and gifts. It's one of my favorites!
Hi Evan! Thanks for your help. The Fund Activity Report is ALMOST exactly what I need, and maybe I'm just missing something. The only thing I can't find with that is how to see the date the contribution was made or the pledge was paid. Is there an easy way to include that in the report?
Thanks!
Ah, I see. I don't think that level of detail is visible in the report within the Tessitura client, but if you save it to a .csv and open it up in Excel, there should be a lot of additional columns of data to work with. If you're running the report with Show Constituent Detail = Yes (so that it outputs separate rows per gift/pledge instead of bundling them up into totals per campaign/fund/designation), then the .csv output should include a row for the original pledge, and then additional rows for each payment made against it. Each of those rows will show the values of contribution_dt and transaction_dt in two separate columns, so you can track when the original pledge was made as well as the precise day that each pledge payment transaction got logged in the system. I hope that covers it!
Evan - I did this and it worked perfectly! Thanks for your help. I think I'll just start running this report on the first of the month to make sure that I'm not missing any pledge payments. Should work for what I need.