Overview
Reconciliation is the process of comparing transactions and activity to supporting documentation. Further, reconciliation involves resolving any discrepancies that may have been discovered. The process of reconciliation ensures the accuracy and validity of financial information. Also, a proper reconciliation process ensures that unauthorized changes have not occurred to transactions during processing.
Reconciliation between TE.com and DCW/SCW is a necessary process for all centers to ensure accurate payments. When two systems share data, there is always a chance for discrepancies. However, since TE and DCW/SCW are integrated with each other, we were able to build a process to make reconciliation very simple.
Step 1: Pull the TE Bank Activity Report from TE
Navigate to www.tuitionexpress.com and generate the Bank Activity Report. The payments displayed on this report should match the funds in your bank account and in DCW/SCW.
Please Note: The image below highlights the batch ID.
Step 2: Pull the TE Balancing Report from DCW/SCW
- Navigate to the Payments > Online/POS Payments
- Click Actions, then select the Tuition Express Balancing Report
- Choose your center from the drop-down. Please Note: If your TE setup has more than one merchant ID, the report cannot be run at the business level. Coming December 2021! You can run the report by Business Level, Brand, Division, or District even with different merchant IDs per center.
- Select your date range. The date range must include one day prior to the first batch included on the Bank Activity Report due to cutoff times.
- Example: The first batch on this Bank Account Activity report is 8/16/2021, so we must run the TE Balancing report one day prior to that. Please Note: ACH payments after 4 p.m. ET and credit card payments made after 7 p.m. local time will display on the next day's batch.
- Example: The first batch on this Bank Account Activity report is 8/16/2021, so we must run the TE Balancing report one day prior to that. Please Note: ACH payments after 4 p.m. ET and credit card payments made after 7 p.m. local time will display on the next day's batch.
- Review the Summary Tab of the TE Balancing Report to ensure the DCW batch totals equal the TE batch totals. If batch totals are equal, the TE and DCW systems are in sync; if the batches are not equal, continue to step 3.
Step 3: Comparing Reports and Reviewing Mismatched Batch Totals
Mismatches typically occur when a registration is pending or dropped new family registration (see below). If there are mismatched transactions, they will be displayed in yellow at the top of the TE Payment Detail tab of the TE Balancing Report from DCW.
Please Note: To avoid mismatches due to pending registration in the future, we recommend using “Charge on Approved” to help with reconciliation. This option can be found on the Setup > System Config > Registration screen.
Dropped New Family Registration
New Family registrations can show up as a mismatch if a parent closes their internet browser before the new registration can complete or if they lose internet connectivity for longer than 30 seconds. If either of these situations happen, it is possible that the initial payment submission was successful on TE’s end. However, if they lose connection or close the browser, DCW/SCW can never receive that successful response. In the event of a connection break or temporary loss of service, we will reach out to TE multiple times requesting a payment status update. If the parent has the browser open and connection is regained, the registration will process as normal.
If DCW/SCW does not receive a reply from TE we will deny the registration, and this is where you would potentially see a mismatch highlighted.
Correcting Mismatches
On the TE Payment Detail tab, there are two options that will display in the Reconcile column:
- “O-Post” displayed in the Reconcile column of the Balancing Report means a new family registration has failed in DCW. This is caused by user internet connectivity (mentioned above). It is recommended that the payment is refunded in TE and the registration is resubmitted.
- When a “P” is displayed, this means the new family registration is pending. As stated above, we recommend using “Charge on Approved” on the System Config > Registration screen. If a pending registration is manually approved, the charge will then display on the family ledger and will no longer display as a mismatch.
- If there are any mismatches from the current day, please wait until they are at least a day old before attempting to fix. The application has an automatic nightly process that will fix most mismatches that are not related to the above issues.
Once corrections have been made, rerun the TE Balancing report, which should now be equal with zero mismatches. If mismatches still display, please contact Support.
Please Note: Once the above process becomes familiar and trusted, you may skip pulling the bank account activity report. The “TE Batch Total” column on the TE Balancing report may be compared to your bank account.
Optional: School/Center Allocations
Allocations are needed when a customer is sending all money to one bank account and needs to know which center the money belongs to. In this case, our customers use the TE Settlement Allocation GL Builder Report. Please Note: This step is not necessary for all customers.
Step 4: Set Up the Ledger Type Fees
To use the TE Settlement Allocation GL Builder report, you must navigate to the Setup > System Config > Valid Values screen to set up the Type fees. Please Note: This step is required if you meet all criteria below:
- You have multiple schools/centers.
- Your school has one merchant ID for all schools.
- Money is allocated out to each school.
The following Type fees must be set up. For each Type fee to show on the GL Builder report, GL codes must be associated to each type fee.
- Tuition/NFEE Type fee:
- Registration Fee/REG Type fee:
Step 5: Matching the Reports for Allocations
The Settlement report is used only for allocations. It’s important to match up the batch totals in the TE Settlement Report to the TE Balancing Report to ensure all payments are being allocated. When the batch totals in both reports equal it means all three sections (Bank, DCW, Allocations) are equal.
- Pull the TE Settlement/Allocation Report. Important: When pulling the Settlement report, it is recommended to pull this report for 2 days prior and 2 day after the date range of the balancing report. This is recommended because of payment postdates. If there are extra batches on the Settlement report that are not on the TE Balancing report, those can easily be deleted in the next steps.
- Open the Summary tab of both reports.
- Delete any rows from the Settlement/Allocation report that are not listed on the Balancing Report (two highlighted examples below). If batch balances are not equal, there could be a returned payment that needs to be accounted for (see next step). Please Note: The last batch may need to be removed as well. This is also due to TE Batch cutoff times.
- If your totals are not matching, scroll to the Settlement Totals – Refund section of the TE Settlement Report for the refund total (see below). Then, subtract your refunds from your TE Settlement Total Transactions.
- Example: Using the example reports, 16,208.50-218.01=15,990.49 (TE Settlement total – refund total = TE Balancing Report Grand Total)
- Scroll to the Transaction Totals section of the TE Settlement/Allocation report and remove any manual transactions not processed through TE, such as third-party payments. Transactions processed through TE that should remain in the list are: Credit Card, ACH/Check, or Returned Payments.
For further assistance, please contact our Support Department.