Insights
  • 07 Apr 2023
  • Comment
  • PDF

Insights

  • Comment
  • PDF

Article Summary

Synctera Insights is our world-class analytics and dashboarding workbench.  You can access it directly at insights.synctera.com or by clicking on the "Insights" callout in the left navbar on the Synctera Console.

Synctera Insights is currently automatically available to all people who have accounts on the Synctera Console. Contact your workspace manager to get access to the Synctera Console. You can identify your workspace manager at this link here

Insights overview

Insights page consists of a variety of reports, mainly focussing on overview of the program, Risk & Compliance reports and Operations reports. Some of these are applicable only to banks and some of these reports need special permissions to view. You can also use ‘My Data’ section in the Insights page to build your own reports on customers, accounts, transactions, addresses and cards 

 


Program Executive Overview

This report gives you an overview of how your product / program is doing. You can see details around customer adoption including New customer onboarding trends and Account opening trends. You can use this report to understand details around account balances, card transaction spend and interchange amounts which are primary indicators of usage and revenue.  If you are a bank, you can use filters on top to dig deeper into individual fintech information.

You may also use any of the questions (panels) in this, or other dashboards, to jumpstart your own analytics. You may do so by clicking on any of the panel headers; as shown below

Compliance Dashboards

This section has a collection of reports that helps you dig deeper into the Risk & Compliance angle of your program.

ACH Return Rates - This report gives you insights into the ACH return rates of your program. You can use this report to understand if you are within the ACH return rate thresholds set by NACHA. If you are exceeding the thresholds you might want to add additional controls to ensure payments are not returned, e.g, ensuring you do a balance check before initiating a debit. 

AML & Related Cases - All transactions on the platform are monitored for AML and Fraud and cases are raised when a transaction is suspicious. This report helps you understand AML case trends.

Compliance search (314a) - This report is specifically available only for BSA analysts with special permissions. If you need access to this report, contact your workspace manager. This report is used to see trends around customers who are subjects of criminal investigations, if any.

Deposit Risk dashboard - This is available only for banks to keep an oversight on customer balance ranges.

Dispute & Related cases - This report will show you trends around disputes raised by customers and related cases. 

KYC and customers - This report will give you insights into KYC trends, related cases and KYC top rejection reasons. You can use this information to adjust your onboarding experience to ensure seamless onboarding for your customer base.

Operations Dashboards

These reports are primarily used by the Synctera / Bank Operations team to ensure smooth functioning of payment operations. 

Card Settlement Reporting - This report gives insights into fees, interchange amounts, and settlement amounts across partners and networks. This report is used to ensure the network settlement matches the transactions that occurred on your product / program.

Card Settlement File Validation - This is used by the Synctera Operations team to further investigate network settlement files that are used for reconciliation.

ACH Settlement File Validation - This is used by the Synctera Operations team to further investigate into ACH settlement files that are used for reconciliation.

Interest Accrual - This report shows you interest accrual trends for your customer accounts. 

Internal Money Movement - This report is used by theSynctera Operations team to keep track of internal money movements that occur between 2 accounts on the platform.

Trial balances report - This report provides excellent visibility into FinTech account balances on a day-to-day basis. This report tracks all customer account balances by effective date. It is synchronized with the bank at the end of each day. It can be used by your Operations team to validate the FBO account balance for a specific date and make sure that the FBO account balance matches the balances in FinTech customer accounts.

Quarterly Mastercard report - All Principal Members of Mastercard are mandated to submit Quarterly Mastercard Reporting (QMR) to Mastercard on the 15th of the month following quarter end (or on the last business day prior to the 15th if the 15th falls on a weekend and/or US holiday).

The QMR includes data about cardholder activity (transactional), chargebacks, EMV volumes, etc. This data is required by Mastercard as Mastercard does not process around 30-50% of its volume, and does not have the card/account details, and other metrics required in the QMR.

The QMR is provided to the bank in the form of CSV files through Secure File Exchange (files are made available to the bank on the 2nd business day of the quarter).

The QMR is submitted by the bank to Mastercard through Mastercard Connect, i.e. the bank will need to create a Mastercard Connect account, which provides access to the QMR tool.

It is the bank’s responsibility to submit these files. Synctera provides these files to support your obligations in this matter. Please ensure that you’ve specified the correct contact information which is required as part of this submission.

My Data

This is a collection of row-level data elements which will help you build your own dashboards. 

You will see Accounts, Customers, Addresses, Transactions and Cards data in this dashboard. You can click on each header of the card (e.g click on Customers [Preview]) to dig deeper into the detail view for each of them. 

Once you are in the detail view of each report, you can click on Filter to filter your data.


Choose your appropriate filters and click on ‘Apply Filter’



You can also click on Summarize to group the data by certain parameters.

Once you click Summarize you will see all the columns that you can summarize by. Click on the ‘X’ button to remove the columns that you don’t want to summarize by. 

E.g If you want to count the number of accounts by account type, you would do this.




You can also do additional data manipulation by clicking on Editor to see the visual editor tool.


On the editor tool, you can do more data manipulation like joining with other tables, or adding formulas / columns etc.


Most of the data you will need to segregate by is already available in individual tables. But in case you want additional data, you can click on Join data to join with other tables - Eg. you want to group accounts by customer address for some reason, you can do so by joining with the customer address table. 



You will have to choose a column that combines account and customer address tables, in this case it would be the customer ID which exists on both account and customer address tables. 



You can filter the data as per your needs.



You can also summarize the data in other ways. 

E.g To get average balances by account type, you would do the following. Note that summarization goes hand in hand with the ‘by’ clause. 

You can sort the report by default as per your needs by clicking on the ‘Sort’ button.


 Or create a custom column using some formula. To understand more about custom columns / formula, click on the link https://www.metabase.com/docs/v0.45/questions/query-builder/expressions.html 



Was this article helpful?

What's Next

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.