The Funds Detail report summarizes the pledges made to selected funds and provides a detailed list of pledges and orders that contribute to each fund.
By providing both a high level summary and detail itemized by order, you can use this report to see how particular donations are proceeding at a glance.
Use this report to get a daily or weekly summarized view as to which funds donations have been made to, and from which appeals.
Criteria
The following table describes this report’s criteria:
Criteria |
Description |
Funds |
Filters the report by fund. |
Appeals |
Filters the report by appeal. Click |
Pledge Date Format |
Specifies the date to use for the report: •Date Range •Fiscal Year •Previous 7 Days (excluding today) •Today •Yesterday |
Pledges From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is selected from the 'Pledges Date Format' dropdown. Click |
Pledges To |
If you are entering a date range, this is the date to which data will be included in the report. This date is inclusive where the end time will be up to 23:59:59 on the selected date. Any value entered into this field will only apply if Date Range is selected from the 'Pledges Date Format' dropdown. Click |
Pledge Fiscal Year End |
Filters the report based on your organization's fiscal year. This will only apply if Fiscal Year is selected from the 'Pledge Date Format' dropdown. |
Transaction Date Format |
Specifies the date to use for the report: •Date Range •Fiscal Year •Previous 7 Days (excluding today) •Today •Yesterday |
Transactions From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is selected from the 'Transaction Date Format' dropdown. Click |
Transactions To |
If you are entering a date range, this is the date to which data will be included in the report. This date is inclusive where the end time will be up to 23:59:59 on the selected date. Any value entered into this field will only apply if Date Range is selected from the 'Transaction Date Format' dropdown. Click |
Transaction Fiscal Year End |
Filters the report based on your organization's fiscal year. This will only apply if Fiscal Year is selected from the 'Transaction Date Format' dropdown. |
Allocation Date Format |
Specifies the date to use for the report: •Date Range •Fiscal Year •Previous 7 Days (excluding today) •Today •Yesterday
If selected, the 'Paid' column will only display funds that have allocation activity during the date range |
Allocation From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Allocation To |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Allocation Fiscal Year End |
Filters the report based on your organization's fiscal year. Any value selected from the dropdown will only apply if Fiscal Year is selected from the 'Allocation Date Format' dropdown. |
Goal Date Format |
Specifies the date to use for the report: •Date Range •Fiscal Year •Previous 7 Days (excluding today) •Today •Yesterday |
Goal From |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Goal To |
If you are entering a date range, this is the date from which data will be included in the report. This date is inclusive where the starting time will be 0:00:00 on the selected date. Any value entered into this field will only apply if Date Range is used. Click |
Goal Fiscal Year End |
Filters the report based on your organization's fiscal year. This will only apply if Fiscal Year is selected from the 'Goal Date Format' dropdown. |
Show Detail? |
•Yes: Pledges to the fund are broken down by customer and order. •No: Pledges are summarized by fund. |
Output
The following table describes the report’s output if No is selected from the 'Show Detail?' dropdown:
Column |
Description |
Fund Name |
The name of the fund. Only those funds that you included as report criteria and to which donations have been pledged are displayed in the report. |
Pledge Count |
The total number of pledges allocated to the fund. |
Unique Donor Count |
The number of unique donors who have contributed to the fund.
Customers will appear once if they donate to the same fund in multiple orders. A customer can appear multiple times if they donate to multiple funds. |
Fund Amount |
The amount allocated to the fund. Since a donation can be allocated to multiple funds, this amount may not reflect the total amount donated. |
Pledged Amount |
The total pledges allocated to the fund. |
Average Pledge |
The average pledge amount of those pledges included in the report. |
Paid Amount |
The monetary value of the pledges that have been received. |
Unpaid Amount |
The monetary value of the pledges that are currently outstanding. |
Goal |
The monetary goal set on the fund. |
% of Goal |
The percentage of the goal that has been received. |
The following table describes the report’s output if Yes is selected from the 'Show Detail?' dropdown:
Column |
Description |
Fund Name |
The name of the fund. Only those funds that you included as report criteria and to which donations have been pledged are displayed in the report. |
Customer # |
The customer number associated with the donation. Click the link to view the customer’s details. Links will not function if you email or download the HTML version of the report. |
Customer Name |
The name of the customer associated with the donation. |
Order # |
The order on which the donation was made. Click the link to view the order details. Links will not function if you email or download the HTML version of the report. |
Appeal |
The name of the appeal to which the donation was pledged. |
Pledge Date |
This is typically the date that the pledge was physically received. It is a user inputted value. |
Fund Amount |
The amount allocated to the fund. Since a donation can be allocated to multiple funds, this amount may not reflect the total amount donated. |
Paid Amount |
The monetary value of the pledges that have been received. |
Unpaid Amount |
The monetary value of the pledges that are currently outstanding. |
Fund Summary |
The name of the fund. Only those funds that you included as report criteria and to which donations have been pledged are displayed in the report. |
Pledge Count |
The total number of pledges to the fund. |
Average Pledge |
The average pledge amount of those pledges included in the report. |
Totals |
•Fund Amount: The total monerary value donated to the fund. •Paid Amount: The total monetary value of the pledges that have been received. •Unpaid Amount: The total monetary value of the pledges that are currently outstanding. |
