When running the Gift Detail and Summary report, the pledge balance is the result of the filters of the report. In the Cash Flow report, the same applies. However, the Gift Date range in the Gift Detail and Summary report, when marking the option to Calculate gift balance based on date range, campaign, fund, and appeal, can cause the totals not to match.
Run the Gift Detail and Summary report on Installments: 1. Open the Gift Detail and Summary Report parameters 2. Select the General tab 3. Change the value in the Pledge Type to Installment
Ensure that the date range specified on the two reports matches: 1. Verify the date range on the General tab of the Gift Detail and Summary Report 2. Ensure that the start date of the date range in the Gift Detail and Summary Report is the same as what is specified for Commitments Made After on the General tab of the Cash Flow Report 3. Ensure that the entire date range is represented on the Report Periods tab of the Cash Flow Report
NOTE: If there were payments made on the pledges that would be excluded from the Gift Detail and Summary report, but included in the Cash Flow report (ie. after the Date range in the Gift Detail and Summary report filters), include a Gift Query of gifts in the specific date range in both reports, instead of using the report filter date range.
Example: If the date range on the Gift Detail and Summary Report is set for Include All Dates, the Commitments Made After date should also be Include All Dates. The Report Periods tab should have an end date past the date when all future installments will be due. Consider setting this well out into the future, for example, the year 2100, to reasonably encompass all pledge installments.