As well as real-time reporting within the MMS, the Gateway also offers you the ability to export ad hoc reports on demand. The reports functionality can be found under the Transactions tab.
There are a number of different reports you can export within the Transactions tab. In this article we will touch upon each report and the formats they can be exported in.
This type of report is only available to Resellers of the Gateway. This type of report allows you to view all of your Merchants processing counts and values, per action and per state. Allowing a full breakdown of processing between a set time-frame. This reporting tool is useful for reconciliation.
This report can be viewed online within the MMS or exported in a CSV if required. The CSV export contains further information on the values processed by each Merchant.
Download Transaction Reports
This type of report is available to all users of the Gateway. Within ‘Transaction Reports’ you are provided with a number of different reports to export in your chosen format. The reports include:
Transaction Activity: The Activity Report is based on the modification time of a transaction. Therefore any transactions that may have been modified (e.g. cancelled, refunded, settled etc.) on the defined date ranges will appear on this report. This type of report contains an extensive amount of data for reconciliation purposes. Example: If you are exporting all transactions from 5 May 2018 – you may see transactions from the 4 May appear on this export because settlement may have taken place in the early hours of 5 May 2018 (e.g. they were ‘updated’/modified).
Transaction History: The History Report is based on the create time of the transaction (i.e. the date it was processed). So unlike the Activity Report it will only display transactions that were processed on the defined date ranges. It contains an extensive amount of data for reconciliation purposes and is the most popular kind of report.
Transaction History (Original Format): Similar to the Transaction History Report, this type of report is based on the create time of the transaction. However using this format there is less information and it simply exports the generic information shown within the ‘Transaction History’ table.
Total Transaction Summary: This report exports the Customers Merchant Accounts and summarises the set frame processing counts and values per Merchant ID. It show the counts and values per action and per state.
Daily Transaction Summary: The Daily Transaction Summary report will break the counts and values of the Customers Merchant Account down per day. This allows you to see how many transactions (per action and state) have been processed each day during the set time-frame.
Daily Transaction Summary (Per Merchant Account): This report will break the counts and values of the Customers Merchant Account down per day and by Merchant ID.
Daily Transaction Summary (Original Format): This type of report is based on the daily breakdown. However it will only exported for the highlighted/selected Merchant Account.
Each of these reports are available to be exported in any of the following formats:
- CSV (Comma Separated Value)
- TSV (Tab Separated Value)
- XLS (Excel 2003 Spreadsheet)
- XML (XML Document)
- HTML (HTML Document)
- JSON (JSON Document)
Viewing Transaction Summary
This report provides an online view of the selected Merchant Account transaction counts and total values. This is completed on the set time-frame from the previous search.