This article will walk you through the reconciliation process. It is intended for Sage/Global E-Telecom clients.
1. Pulling your Data from Trisource
Log into https://myonlinereports4.eftchecks.com/WebUI/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 > Merchant Bank Statement > pull your desired date range as shown above. The totals you see on your Merchant Bank Statement will typically be 3 business days behind your ClubReady reporting.
You can use the export option on this Sage report if you like, or use the on-screen summary.
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. Once logged in, pull your desired date range of transactions, and using steps 1. and 2. above match up your deposits.
How to pull and mark Returns from Sage
1. Importing your Sage (Global E-Telecom) Returns
Use this Article to guide you through this process > How To Import Sage - Ach Returns Into ClubReady > https://www.clubready.com/wiki/WK23711324980
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 a staff type that has access to Reports > Sales > Pay Type Breakdown Report and Access to https://myonlinereports4.eftchecks.com/WebUI/login.aspx with the corresponding username/password.