CMS Contributions - I Need To Know How Much Income To Budget For My Pledgeable Fund Each Year

PROBLEM: I have a multi-year Pledgeable fund, and I need to know how much income I can anticipate for each year.

SOLUTION: You can find that information very quickly by using your Calculate Pledge Balance Process in the CMS Contribution System.

From CMS Contribution, click Process | Calculate Pledge Balances/Set Statement Date.

Click into the date field and type in the last day of the first year of the pledge, i.e. 12/31/2008.  Click Calculate.

This process will calculate your Year to Date/Drive To Date pledges to this date.

Next, click Reports | Pledge & Contribution Summaries | Multi Year Fund Summary.



Click the Funds button and click Remove All and add back only your Multi Year Fund.  Click OK.

Click Print and allow the report to print to screen.

Click to the last page of the report and print only the last page of the report.

Find the Drive to Date Pledge column and circle the Total between the single and double lines.  

This is the total of how much you can anticipate in income for that fund through that date.

Close out of this report.

Go back to Process | Calculate Pledge Balances/Set Statement Date and set the date to the last date of the next pledge year, i.e. 12/31/2009 and click Calculate.

Once complete, go back to Reports | Pledge & Contribution Summaries | Multi Year Fund Summary.



Click the Funds button and click Remove All and add back only your Multi Year Fund.  Click OK.

Click Print and allow the report to print to screen.

Click to the last page of the report and print only the last page of the report.

Find the Drive to Date Pledge column and circle the Total between the single and double lines.  

This is the total of how much you can anticipate in income for that fund through that date.

Repeat these steps for each year of your pledge.

You can subtract the Drive to Date Pledge total from each year to determine the anticipated income for each year of the pledge.

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.