Use the Contribution Analysis Report option to view pending or posted contributions, loan payments, or forfeitures for a specific date range or fiscal year. You can sort the participants by Participant ID or Name and the report itemizes the transactions for each participant. Note: only one transaction type selection can be made at a time. For example, Contributions - Posted and Loan Payments - Pending cannot be processed on the same report.
How to Access the Contribution Analysis Report Window
On the Reports menu, point to Contribution Reports, and then click Contribution Analysis Report. The Contribution Analysis Report window displays.
How to create a Contribution Analysis Report
1. Select the Plan for which you are generating the report.
Or
Select the All Plans check box to generate a report for all plan participants in all plans.
2. Enter the Effective Date range for the transactions you want to include in the report. Note: If you are running the report for All Plans, the date range is a one month period.
3. Enter the Payroll Date Range for the transactions you want to include in the report. Note: If you are running the report for All Plans, the date range is a one month period.
4. Select the sort order, either Participant ID or Name.
5. When you are done, click Process.
Explanation of Fields
Field |
Description and Requirements |
Required / Optional |
Effective Date |
The Effective Date is the date the transaction was posted to the participant's account. You can type the date using MM/DD/YYYY format or use the calendar. The calendar defaults to current date. Enter a date in both the From and To fields. |
One date identifier is required for Loan Payments |
Payroll Date Range |
The Payroll Date is the date the participant was paid. Enter a date in both the From and To fields. You can type the date using MM/DD/YYYY format or use the calendar. The calendar defaults to current date. |
One date identifier is required for Loan Payments |
Fiscal Year |
Enter the Enter the fiscal year. |
One date identifier is required for Loan Payments |
Transaction Type |
Select one of the following transaction types from the list: Contributions, Loan Payments, or Forfeiture Allocations. |
Required |
Posted |
Select the Posted check box to include posted transactions in the report. |
Optional |
Contribution Analysis Report Example