Build a report to project cash flow from pledge and recurring donation installments over a timeframe you choose.
When you filter by projected revenue, you always need to define a date range. You can look at projected revenue in the future or the past, but there must always be an end date.
Projected revenue is based on installment amounts, not on actual or missed payments. A few examples:
Projected revenue for a date range stays the same even if payments have already come in during that range.
Projected revenue on fulfilled pledges stays the same even if a constituent overpays.
Projected revenue stays the same even if a recurring schedule has missed payments or a pledge has overdue payments.
The one exception: if a pledge has been written off, its unfulfilled installments no longer count toward projected revenue.
Tip: We have a report template for Projected Cash Flow which lists pledges and recurring donations with projected revenue this fiscal year. Use the template as a starting point and modify the date range and add more filters and columns, as needed.
Transaction Reports
Create transaction reports to see a list of pledges and/or recurring donation schedules with projected revenue. You may run a list of both pledges and recurring donation schedules together, or separately with their corresponding payments.
To show a list of Pledges and Recurring Donation Schedules:
In the Include section, click Add Filter.
Search for and select Projected Revenue.
Set the time frame, then click Apply.
Click Columns.
Search for Projected Revenue.
Click Add.
Click Apply.
Click the column.
Set the time frame.
To show a list of Pledges and Pledge Payments:
In the Include section, click Add Filter.
Search for and select Pledges and Pledge Payments.
In the Include section, click Add Filter.
Search for and select Pledge Projected Revenue.
Set the time frame, then click Apply.
To show a list of Recurring Donation Schedules and Recurring Donation Payments:
In the Include section, click Add Filter.
Search for and select Recurring Donation Schedules and Payments.
In the Include section, click Add Filter.
Search for and select Schedule Projected Revenue.
Set the time frame, then click Apply.
To add a column for Projected Revenue in a Transaction Report:
Click Columns.
Search for Projected Revenue.
Click Add.
Click Apply.
Click the Projected Revenue column.
Select the time frame.
Select if you would like to see the Sum, Minimum, Maximum, or Average.
Click Apply.
Filter by Cumulative Amount of Projected Revenue
When filtering or adding columns for cumulative amounts in a constituent report, you can select Projected Revenue is an one of the options under Amount.