Important Notice: This article applies to the New ParishSOFT Platform. If your diocese hasn’t migrated yet, explore our knowledge base for relevant resources.

This article will give you the steps to follow to create a 5-year pledge projection report in Excel. The report will provide a projection of income from a pledge for the next 5 years.

To produce the report, you will create and run a query in IQ and export the data from the query into an Excel spreadsheet that will produce the report.

Build the Query

Open MS Excel Template linked to the bottom of this document. 

Open ParishSOFT and choose the Intelligent Query module.

Jump here to get a list of Result Column suggestions for building out the query.

Choose the funds you want to report on. If appropriate, set a condition for Pledge Start Date to limit the report to pledges that were given in a specific date range.

Execute and Save Query Results

Click Execute Query to produce the list of query results. It may take some time for the query to run.

When the query runs, select Query Results and choose Export to CSV. A file will download to your computer. The specific way to open the file depends on your web browser and computer setting. 

Copy Results to Spreadsheet template and View

Open the CSV export file.

Highlight and copy all the cells in the CSV export file.

Paste the cells into the Data tab of the PledgeProjectionCN_Master.xlsx spreadsheet.

Select the Report worksheet.

Review and/or Print as desired.

How to create the Pledge Production Data Pull Query in IQ

The IQ query "PledgeProjectionPull" needs to produce exactly the right result columns in order to be read by the spreadsheet. To create the query, go through the following steps:

For Query Condition, use Pledges: Fund DUID. This should include the Fund ID for the fund you want to get projections for. You can use multiple funds or limit the results to pledges given during a specific time period.

For Result Columns, enter the following columns in the exact order specified below:

1. Pledges Pledge DID
2. Pledges Family DID
3. Pledges Total Pledge Amount
4. Pledges Pledge Date
5. Pledges Start Date
6. Pledges Months Amortized
7. Pledges_Down Payment Down Payment Amount
8. Pledges Total Paid
9. Pledges Balance
10. Pledges Installment Amount (Unfiltered)
11. Pledges Billing Frequency ID
12. Pledges Billing Frequency
13. Pledges Fund DUID
14. Funds Fund Name
15. Funds Description
16. Pledges Jan
17. Pledges Feb
18. Pledges Mar
19. Pledges Apr
20. Pledges May
21. Pledges Jun
22. Pledges Jul
23. Pledges Aug
24. Pledges Sep
25. Pledges Oct
26. Pledges Nov
27. Pledges Dec
28. Pledges Total Adjustment Amount
29. Pledges Last Adjustment Date
30. Pledges Installment Amount (or Balance)
31. Pledges is Paid In Full
32. Pledges Latest Payment Amount
33. Pledges Latest Payment Date
34. Pledges Months Remaining
35. Pledges Months Since Pledge Inception
36. Pledges Number of Months Billed
37. Pledges Original Pledge Amount
38. Pledges Payment Count
39. Pledges Percent of Pledge Fulfilled
40. Pledges Fulfillment Method
41. Pledges End Date

• PledgeProjectionCN_Master.xlsx7 MB

Updated February 20, 2025 17:21