Build a report to calculate cash flow projections based on pledge and recurring donation installments forecasted during a specific timeframe.
When filtering by projected revenue, a date range must always be defined. You may filter for projected revenue in the future or the past, but there must always be an end date.
Projected Revenue is based on the installment amounts and does not take into consideration actual or missed payments. For examples:
Projected revenue in a specified date range remains the same even if there have already been payments received during that date range.
Projected revenue on fulfilled pledges remains the same even if a constituent overpays on a pledge.
Projected revenue remains the same even if there are missed payments on a recurring schedule, or overdue pledge payments.
However, if a pledge has been written off, unfulfilled installments will not 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 see 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 OK.
Click Add Column, then search for and select Projected Revenue.
Set the time frame, then click OK.
To see 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 OK.
To see 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 OK.
To add a column for Projected Revenue in a Transaction Report:
Click Add Column.
Search for and select Projected Revenue.
Select the time frame.
Select if you would like to see the Sum, Minimum, Maximum, or Average.
Click OK.
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.