Your CRM is integrated with the major payment processors for merchant portfolio reporting, including First Data, Paysafe, TSYS Wholesale, TSYS Retail, Nuvei, Priority, Vantiv, TriSource, Clearent, and Elavon.
For those integrated processors, the CRM retrieves the merchants' batch details directly from the processor every day and shows the information right on the merchant page:
If a merchant is using a non-integrated processor, you may still view their key transaction and volume data by importing it into the CRM manually.
Once the data is imported it can be viewed on the merchant page in the same way as for merchants that use an integrated processor.
Below are the instructions for importing the merchants' deposit data in a few easy steps.
Step 1: Import Residuals for Non-Integrated Processor
The process starts at Residual Import.
Residual Import is where ISOs can upload residual data into Merchant Central. The data is then transferred into Merchant Central’s advanced merchant portfolio reporting tools.
To learn how to import your residuals into Merchant Central please see our article on Importing Residuals.
Step 2: Update Processor Setting
In this step, you will tell Merchant Central to use the residuals volume total from merchants using the non-integrated processor, and how you would like Merchant Central to display the data.
Navigate to Manage > Administration > Processors > Processor Settings, select the non-integrated processor, and click the Edit Processor button:
In the Edit Processor popup, you’ll see a variety of options.
The one we are concerned with is titled Deposits Month. Click the dropdown to see several options, including:
- Do Not Apply
- Same Month as Residuals Report
- Month Prior to Residuals Report
- Two Months Prior to Residuals Report
ISOs typically receive their residuals report for a given month from the processor roughly 2-3 weeks into the following month. For example, on January 20th you may receive December residuals.
In order to ensure that the data is properly imported into Merchant Central’s advanced reporting, make sure to select the correct monthly setting based on the month of the residuals report data.
The Same Month as Residuals Report option in the processor settings provides for a vast majority of use cases while the proper setting for integrated processors is Do Not Apply.
The Month Prior to Residuals Report and Two Months Prior to Residuals Report options cover very specific use cases that are generally not applicable to most clients.
Viewing Merchant Data for Non-Integrated Processors
Now that the residuals data from the non-integrated processor has been properly imported into the CRM, you can start to take advantage of the data.
In the Deposits tab for a specific merchant, you will now see monthly transactions and volume data pulled directly from the residuals data that was imported.
The data source is included at the bottom-right of the report, so you know exactly where the data came from.
Navigate to the Financials tab to gain a view of how merchants using non-integrated processors are performing over time.
In the Financials tab, you can view monthly volume and transaction data in neatly organized columns, as well as in the graph.
In the past, these tabs would have provided little to no value for non-integrated partners because the data simply wasn’t available.
Support for non-integrated processors has been added to ensure that ISOs can gain a view of merchant performance over time whether they are using integrated or non-integrated processors.
For integrated processors, the Deposits tab contains daily volume and transaction data.
For non-integrated partners, the data in the Deposits tab is organized by month.
The Deposits tab will now include total monthly volume and transactions for any given month – so long as the data has been imported through Residuals Import, and the processor setting has been updated correctly (step 2).