Cash Flow Report needed

Heather

I just checked our reports here and sadly none give the date of payment or gift.  For payment and gifts within a range though Fund Activity is your best bet until you have a report it will let you use list and fund code to narrow the scope.  Pledge Gift won’t work because it will not give the payments on past pledges.

With the Fund Activity will give you more info than you want but it is a start.

Another could be Payment Method Detail report (can’t remember if this standard or a local).  It is a variation on the Fund Activity report but just shows payments and gifts sorted by payment method.  Exporting it to Excel could be give most of what you want as well.  If this is a local – it was developed using the Fund Activity as it’s a initial source and then modified. 

Heather,

I'm not sure these will give you exactly what you need but you should fool around with the Pledge Gift report in the Finance folder and also the Fund Activity Report. 

With FA report make sure to group by Constituent to get the detail. 

Dale

Heather,

This may be the long way around, but it will work. While it does not provide specific payment dates, you can use the Pledge Receivable by Period report with the Period criterion set to “Months,” and then run the report 12 times to get a year’s worth of cash flow. We run this report at the top of every month to monitor pledge payments/installment plans, and it could easily be retooled to your purposes, once you know how to read it.

As a matter of fact, because of the Received/Due Prior and After columns, you could run it 4 times to get a whole year’s worth of cash flow. A February report, for example, would actually get you payment information for January, February, and March.

Rey

---

A. Rey Pamatmat

Development Database Coordinator

The Public Theater

425 Lafayette Street

New York, NY 10003

(212) 539-8739

Heather,

This may be the long way around, but it will work. While it does not provide specific payment dates, you can use the Pledge Receivable by Period report with the Period criterion set to “Months,” and then run the report 12 times to get a year’s worth of cash flow. We run this report at the top of every month to monitor pledge payments/installment plans, and it could easily be retooled to your purposes, once you know how to read it.

As a matter of fact, because of the Received/Due Prior and After columns, you could run it 4 times to get a whole year’s worth of cash flow. A February report, for example, would actually get you payment information for January, February, and March.

Rey

---

A. Rey Pamatmat

Development Database Coordinator

The Public Theater

425 Lafayette Street

New York, NY 10003

(212) 539-8739

Heather

I just checked our reports here and sadly none give the date of payment or gift.  For payment and gifts within a range though Fund Activity is your best bet until you have a report it will let you use list and fund code to narrow the scope.  Pledge Gift won’t work because it will not give the payments on past pledges.

With the Fund Activity will give you more info than you want but it is a start.

Another could be Payment Method Detail report (can’t remember if this standard or a local).  It is a variation on the Fund Activity report but just shows payments and gifts sorted by payment method.  Exporting it to Excel could be give most of what you want as well.  If this is a local – it was developed using the Fund Activity as it’s a initial source and then modified. 

Heather,

I'm not sure these will give you exactly what you need but you should fool around with the Pledge Gift report in the Finance folder and also the Fund Activity Report. 

With FA report make sure to group by Constituent to get the detail. 

Dale

The issue I am having is that when I use any report to see a giving history, the "contribution date" is always the pledge date if it's a pledge. We need to be able to see the actual payment dates (when we recieved gifts/payments on pledges.)

Here is what we are looking to achieve.

Our goal to be able to see what money was received between a date range. Not JUST when it was pledged.  This is for cash flow projections.

For examples:

What money did we receive from our Board Members(Fund:Director GIfts) month by month for the fiscal year of 2008/09. 

What money did we receive from our Corporate Line(Campaigns:CorpSponsor08/09,CorpDonor08/09,CorpTrade08/09) month by month for the fiscal year of 2008/09(Start Date:6/30/08 End Date:7/1/09). 

What money did we receive from our Individual Line(Fund:Individuals) July 1, 2007 through July 30, 2007.

I've looked around our reports we have, and I haven't found anything that shows receivables dates, if there is something, please let me know. There is a canned report in place already that is "Yearly Cash Planning Report", but this just shows pledged money and when the future pledge due dates are. We need to be able to see when gifts were actually received on an individual person level.  We would like to be able to select multiple funds at a time and/or multiple campaigns at a time. To be clear this isn't just to include payments on pledges, this is all contributions.

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!