IN BRIEF
Learn how to reconcile differences between Worldpay (formerly Payrix) transfers and data in iClassPro. You’ll compare totals from the Bank Deposit Report (FIN-2) and Program Deposit Split Report (FIN-4) against your Worldpay Settlements and Portal records.
Overview
This article explains how to review and reconcile differences between transfers from Worldpay (formerly Payrix) and financial reports in iClassPro.
By using the Bank Deposit Report (FIN-2) and Program Deposit Split Report (FIN-4) alongside your Worldpay Settlements, you can accurately match daily deposits to recorded transactions.
You’ll also learn how to adjust settings in your Worldpay Portal to display the correct transaction information.
Accessing the Feature
You can access both of the iClassPro reports from the Financial section of the Reports page in iClassPro.
-
Bank Deposit Report (FIN-2)
- Used to review deposits made into your account and identify which programs and charge categories the payments were applied to.
-
Program Deposit Split Report (FIN-4)
- Used to view how payment amounts are distributed across individual programs.
To view your Worldpay settlements:
- Log in to your Worldpay Portal.
- Access your Transaction or Activity details to review deposits and settlement dates.
Step-by-Step Instructions
Step 1: Generate the Bank Deposit Report (FIN-2)
- Navigate to REPORTS>FINANCIAL>Bank Deposit Report (FIN-2).
- Under Display Options, enable Show Programs and Charge Categories.
- Generate the report as an XLSX file.
- Use the exported file to compare daily totals to the amounts shown in your Worldpay Settlements.
The Bank Deposit report shows:
- Individual payments recorded in iClassPro for each day.
- The total payment amounts for each day.
- The Programs to which each payment was applied.
- The Charge Categories associated with each payment.
This report helps determine which programs and charge categories are tied to each bank deposit.
NOTE: Any payments that were not applied to charges on the day they were taken will show as Unapplied.
Step 2: Review the Program Deposit Split Report (FIN-4)
- Navigate to REPORTS>FINANCIAL>Program Deposit Split Report (FIN-4).
- Run the report for the same date range you used for the Bank Deposit Report.
- Review the totals applied to each program.
This report shows:
- Amounts applied to each Program in iClassPro during the date range of the report.
- Totals based on when payments were applied to charges, not when the payments were deposited into your account.
Use this report together with the Bank Deposit Report to correlate what was collected in iClassPro with what was deposited into your account.
Step 3: Review Transactions in the Worldpay Portal
- Log in to your Worldpay Portal.
- Access the section that lists Transactions or Activity.
- Filter the results by Transaction/Activity Date (instead of Settlement Date).
This ensures transactions display based on when they were initiated, rather than when funds were deposited.
Using this filter makes it easier to match transactions in Worldpay to the totals in your iClassPro reports.
Troubleshooting & FAQ
-
Why don’t my totals in iClassPro match my bank deposits?
- The Program Deposit Split Report (FIN-4) shows when payments were applied to charges, while the Bank Deposit Report (FIN-2) shows when payments were actually taken/initiated.
- Compare both reports to match transaction timing and program details.
-
My Worldpay Portal totals don’t match my settlements. What should I check?
- Confirm that you are filtering by Transaction/Activity Date in the Worldpay Portal.
- Depending on your settlement time, settlement dates can differ from transaction dates, which can cause temporary mismatches.
-
Why do I need to enable “Show Programs and Charge Categories” on the Bank Deposit Report?
- This option breaks down payments by Program and Charge Category, helping you identify exactly how deposits are distributed.