This article will walk you through the reconciliation process. It is intended for CRPayments clients.
1. Pulling your Data from Trisource
Log into https://portal.trisourcesolutions.com/login.aspx, using your username/password. If you don't have this information, please contact us at Gateways@clubready.com and we will assist you.
Go to Reporting > Batches > pull your desired date range. The totals you see per Batch will typically be 1 business day your ClubReady reporting.
2. Pulling your Data from ClubReady
Log into your ClubReady site, go to Reports > Sales > Payment Type Breakdown > pull your desired date range.
Above is an example of your Summary Page, this gives you a Summary of transactions, per card type over your desired Date Range.
Above is an example of how to pull your Daily Batch Log. Set your Batch cut-off time to 23:00, then generate this report. It will be an excel download only, and will give you a day by day breakdown of transactions processed including refunds. This is the best report to use, when reconciling your account. When comparing this report to your bank account deposits, expect to see a 2 business day delay for Visa, MC, and Discover from this report to your Bank Statement. Expect a 3 business day delay for your Amex and ACH deposits, when comparing this to your bank statement.
3. Pulling your Data from your Bank Account
Log into your Bank Account that Trisource is depositing to, pull your desired date range of transactions, and using steps 1. and 2. above match up your deposits.
How to pull and mark Chargebacks from Trisource
1. Pulling your Data from Trisource
Log into https://portal.trisourcesolutions.com/login.aspx, using your username/password. If you don't have this information, please contact us at Gateways@clubready.com and we will assist you.
Go to Reporting > Chargeback > pull your desired date range.
Use the detail (as shown above) to search for the last four of your clients CC in ClubReady.
2. Marking Chargebacks in ClubReady
In ClubReady, go to Reports > Sales > Look up Transaction.
Use the tool, as shown above, to Look up the last four of your clients CC. Then click on the client's name using the Blue link, this will take you to their profile.
Once you are in their profile click on 'Invoices / Payments / Refunds / Transaction Ledger' > then click on 'Payments'.
Find the matching payment record > click on 'Mark Payment as a Chargeback' > match the reason code to the code listed in Elevate.
3. Matching Chargebacks in ClubReady
Once the Chargeback is marked, you will then need to match the chargeback. If you have a corporate portal, this step will need to be done from your corporate site.
Go to Reports > Sales > Import Returns > and select the Process Returns tab. Select today's date and then, click Fetch Returns.
This will generate a list of any Chargebacks that were marked today. From here you will change the drop-down on the Chargeback to "Matched".
Once the Chargeback is marked and matched, the 'Paid' invoice and payment record is reversed to show as 'Unpaid'. Late Fees and Return Fees are automatically added per your site settings found under Setup > Sales > General Settings > Late Pays.
The client's EFT will be disabled, an automatic note will be added to the client's account, and payment preferences automatically removed.
Should you have issues or questions on any of these steps in this document, please contact the Billing team > Billing@clubready.com.
Requirements - A master admin login or an staff type that has access to Reports > Sales > Pay Type Breakdown Report and Access to https://portal.trisourcesolutions.com/login.aspx with the corresponding username/password.