Fee Summary report

  Last updated: 

 

  This feature is available to merchants using our TRU Acquiring services.

The "Fee Summary" report provides a statement-style view of the total number of transactions, fees, adjustments and other postings processed via the selected MID over a period of up to 31 days.


  Required user roles

Admin, Developer, TransactionUser, ViewFeesAndStatements, ViewTransactionsOnly


  How to access

  1. portal-reporting-selectmid.pngSelect “Reporting” from the side-bar to open the Reporting page.

  2. In the top left, select "MID" and then select a MID from the drop-down box.

  3. From "Stored Searches", select "Fee Summary".

  4. From "Account Type", select from the following options:
    • Acquiring Fee Account (Gross) - For accounts using the gross settlement model, this will only display fees.
    • DCC Commission Account - For accounts with DCC enabled, this will display DCC commissions.
    • Payment Account - This shows transactions, manual adjustments, chargebacks and the amount to be funded into your bank account. For accounts using the net settlement model, this also includes fees.
  5. From "Settlement Currency", select the currency used to display the amounts in the report.
    (Ensure you select a currency that is supported by your MID)
  6. From "Date", select the date range for the report.
    (This can be a range of up to but not exceeding 31 days)
  7. Select between displaying results "On Screen" or performing an "Export" (download report as an XLSX or CSV file).

  8. Click "Search".

  Searchable records are available up until the previous calendar day. Attempting to search the current day will yield no results.

  Reports displayed on screen can only be generated from a maximum of 1,000 records of data. If this limit is exceeded, this excess data will not be included in the report displayed, resulting in accurate data. In this situation, you should instead export the full report, as this will include all data.

portal-export-3.png

portal-paymentsummary4.png

 

For each row in the table, the following are displayed:

Column Description
Count The number of applicable transaction fees processed during the period searched.
Debit

Funds have been debited from this TRU Acquiring payment account for the reason shown on the left.

Funds can be debited to cover fees accrued, to facilitate refunds or chargebacks, to add funds to a rolling/fixed reserve, or to signify funds leaving this holding account to be paid into your bank account (shown with the label "Calculated Amount for Period").

  If you are viewing an account that uses a gross settlement model, most fees will not be shown here as these will instead be calculated and invoiced separately at the end of each month. These can be viewed by selecting the "Acquiring Fee Account (Gross)" Account Type.

Credit

Funds that have been credited to this TRU Acquiring payment account for the reason shown on the left.

Funds are typically credited from successful purchases performed by customers. At the end of the settlement period, debited funds are subtracted from the total credited funds and transferred to your bank account. You can view the status of this using the Merchant Payment Advice report.

If data is available for any of the following transactions/fees/adjustments, they will be displayed as rows in the table:

  If data is not available, the rows will be omitted from the table.

Row

Description
Purchases The amount customers have paid to facilitate purchases.
Refunds The amount paid to customers in refunds.
CFTs The amount paid to a credit/debit card using Credit Funding Transfer (CFT) accounts.
Chargebacks

The amount paid to customers to fulfil chargebacks.

Click the row in the table to view a full breakdown of how this value was calculated.

  Retrieval fee Fees associated with retrieval.
  Chargeback fee Fee applied by Trust Payments due to chargebacks.
  MasterCard Pre-Arbitration Fee Fee imposed by Mastercard during pre-arbitration.
Interchange Fees

The interchange fees paid to the issuing banks.

  If you are billed using a "blended" model, this field will not be visible. Instead, these fees are combined into the Payment Transaction Fee column.

Click the row in the table to view a full breakdown of how this value was calculated.

  Interchange Purchase Fee charged by issuing banks for purchases.
  Interchange Refund Fee charged by issuing banks for refunds.
Card Scheme Assessment Fees

The card scheme assessment fees paid to card schemes for using their networks.

  If you are billed using a "blended" model, this field will not be visible. Instead, these fees are combined into the Payment Transaction Fee column.

Payment Transaction Fee

The fees paid to Trust Payments for using their services.

  If you are billed using a "blended" model, this total will also encompass the Interchange and Card Scheme Assessment Fee values.

Chargeback Fees
The fees paid to the acquiring bank as a result of chargebacks.
Authorization Fees

The fees paid to the payment processor to facilitate the transaction.

Click the row in the table to view a full breakdown of how this value was calculated.

  Consolidated Authorisation Fee Fee charged for authorisations.
  Authorisation Visa EU Intra Fee Charge applied by Visa for EU intra transactions.
  Authorisation Visa EU Inter Fee Charge applied by Visa for EU inter transactions.
 

Authorisation Visa EU Domestic Fee

Charge applied by Visa for EU domestic transactions.
Minimum Processing Fee
The extra amount charged to ensure the minimum monthly fee has been reached.
Account StartUp Fee
The fee charged during account setup.
Monthly Service Charge
The monthly charge service charge.
Monthly Fees

The monthly fee applied.

Click the row in the table to view a full breakdown of how this value was calculated.

  Monthly Service Charge

Service fee applied monthly.

  Monthly Fee Fee applied monthly.
Annual Fee

The annual fee applied.

Click the row in the table to view a full breakdown of how this value was calculated.

  MasterCard Registration Fee Annual fee applied for transacting with Mastercard.
  Annual Fee Fee applied annually.
Cross Border Fees

The fees applied by card schemes to facilitate the cost of performing cross border transactions.

Click the row in the table to view a full breakdown of how this value was calculated.

  Visa International Ecommerce Fee International e-commerce fee applied by Visa.
  Visa International Acquirer Fee International acquirer fee applied by Visa.
  MasterCard Cross Border Non SEPA Rebate Charge applied by Mastercard for non SEPA rebate transactions.
  MasterCard Cross Border Non SEPA Inter EU Charge applied by Mastercard for non SEPA inter EU transactions.
  MasterCard Cross Border SEPA Intra EU Charge applied by Mastercard for SEPA intra EU transactions.
  MasterCard Cross Border SEPA Inter EU Charge applied by Mastercard for SEPA inter EU transactions.
  MasterCard International Ecommerce Fee Charge applied by Mastercard for international transactions.
PCI Portal Fee
Fee for accessing the PCI Portal.
Wire Transfer Fee
The fees paid to banks when performing wire transfers.
Manual Adjustments
The total manual adjustments processed over the selected period.
Other Postings
Miscellaneous postings not included in the other categories.
Rolling Reserve Held
Funds paid into your rolling reserve. Click here to learn more.
Fixed Reserve Held
Funds paid into your fixed reserve. Click here to learn more.
Calculated Amount for Period

Amounts to be funded to the merchant's bank account.

  To view a full breakdown of this data, you can click the "Calculated Amount for Period" heading in the table to open the Merchant Payment Advice report, which is automatically populated using the same MID, date range and settlement currency selected in the Fee Summary.
Was this article helpful?
0 out of 0 found this helpful