pledge balance report with cutoff date?

From: Julie Hamre <bounce-juliehamre9206@tessituranetwork.com>
Sent: 9/6/2012 7:58:33 AM

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mary French
Sent: Wednesday, September 05, 2012 10:29 AM
To: Julie Hamre
Subject: RE: [Tessitura Development Forum] pledge balance report with cutoff date?

That’s great!  Thanks!

It’s my understanding that you can’t get a report that really shows the balance back in time.  Rather, what happens is that the Current Balance shown is always the true current balance.  However, you can calculate backwards by using the Paid After Current Period column.

For example, you want balances as of June 30 but you are running the report today.  Run the Pledge Receivable by Period and use the following parameters:

Periods:            Months

Calc. Date:        6/30/09

Pledge Amt       $1 - $999,999,999 (would that we all had pledges that large!)

Pledge Bal.       $0 - $999,999,999

Contr. Dates     whatever you want – current fiscal year or, for longer campaigns, the date the campaign began

Funds               as appropriate

Mode                I like Detail by Pledge

This report will give you a list of ALL pledges made during the Contribution Dates you selected.  (If you use a Pledge Balance of $1 or more, you will get only the pledges that have a balance as of the date you run the report, not as of 6/30). 

The column headings refer to Current Period, and remember that you have defined the Current Period to be the month of June 2009 (Period = Months and Calc. Date = 6/30/09).  So the first four columns show the amount Pledged, the money received Prior to Current Period (i.e., before June), the money received in the Current Period (June), the money received After Current Period (since June), and the Current Balance.  So, to get the balance as of June 30 you take the Current Balance and add back in the money received After Current Period.

This is actually a cool report since you can define what you want for periods.  I run this every month to reconcile with our accounting dept on receivables, and at the end of the year I run a version where I define the Period to be Fiscal Year and it’s a nice summary of the year’s activities.

Hope this is helpful.

-----Original Message-----
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Kirk Mortensen
Sent: Wednesday, September 16, 2009 10:07 AM
To: Julie Hamre
Subject: RE: [Tessitura Development Forum] pledge balance report with cutoff date?

It didn’t seem to be working for me.  It could be because most of the pledges we’re looking at were converted into the system, so the dates could be a little wonky.  Does this report work that way for most others (i.e., the transaction start and end dates allow you to get a pledge balance snapshot back in time)?

The Pledge Balance Detail report has parameters for transaction start and end date (if you use the 'Next' button to go to the next group of parameters).  Does this not give you a historical snapshot of your pledge balances as of that end date?

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!

From: Julie Hamre <bounce-juliehamre9206@tessituranetwork.com>
Sent: 9/6/2012 7:58:33 AM

From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Mary French
Sent: Wednesday, September 05, 2012 10:29 AM
To: Julie Hamre
Subject: RE: [Tessitura Development Forum] pledge balance report with cutoff date?

That’s great!  Thanks!

It’s my understanding that you can’t get a report that really shows the balance back in time.  Rather, what happens is that the Current Balance shown is always the true current balance.  However, you can calculate backwards by using the Paid After Current Period column.

For example, you want balances as of June 30 but you are running the report today.  Run the Pledge Receivable by Period and use the following parameters:

Periods:            Months

Calc. Date:        6/30/09

Pledge Amt       $1 - $999,999,999 (would that we all had pledges that large!)

Pledge Bal.       $0 - $999,999,999

Contr. Dates     whatever you want – current fiscal year or, for longer campaigns, the date the campaign began

Funds               as appropriate

Mode                I like Detail by Pledge

This report will give you a list of ALL pledges made during the Contribution Dates you selected.  (If you use a Pledge Balance of $1 or more, you will get only the pledges that have a balance as of the date you run the report, not as of 6/30). 

The column headings refer to Current Period, and remember that you have defined the Current Period to be the month of June 2009 (Period = Months and Calc. Date = 6/30/09).  So the first four columns show the amount Pledged, the money received Prior to Current Period (i.e., before June), the money received in the Current Period (June), the money received After Current Period (since June), and the Current Balance.  So, to get the balance as of June 30 you take the Current Balance and add back in the money received After Current Period.

This is actually a cool report since you can define what you want for periods.  I run this every month to reconcile with our accounting dept on receivables, and at the end of the year I run a version where I define the Period to be Fiscal Year and it’s a nice summary of the year’s activities.

Hope this is helpful.

-----Original Message-----
From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Kirk Mortensen
Sent: Wednesday, September 16, 2009 10:07 AM
To: Julie Hamre
Subject: RE: [Tessitura Development Forum] pledge balance report with cutoff date?

It didn’t seem to be working for me.  It could be because most of the pledges we’re looking at were converted into the system, so the dates could be a little wonky.  Does this report work that way for most others (i.e., the transaction start and end dates allow you to get a pledge balance snapshot back in time)?

The Pledge Balance Detail report has parameters for transaction start and end date (if you use the 'Next' button to go to the next group of parameters).  Does this not give you a historical snapshot of your pledge balances as of that end date?

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!