Rachel Nalundasan
Created Jul 08, 2022How to generate Transaction Fees Report to validate Apxium Billing
The Transaction fees on your Apxium monthly invoice relate to the total credit card usage during the month.
You can see all credit card transactions each month by exporting a report from the Payments Page.
On your Apxium Dashboard, click on the Banking Menu and select Payments
Tick the Detailed View box
Filter payments based on transaction dates.
Time column:
-Click on the filtering icon
-Select "In range" to choose the range of transaction dates you want to filter.
Filter Visa and Master Card Payments
On Type Column:
- Key in Mastercard,
- select OR,
- and key in Visa
Filter Successful Transactions
On Status Column, Key in Paid to filter all payments with successful transactions.
Click on Export to CSV
Calculate the transaction fees from your exported file
Total = Sum of total amount column
Number of Transactions = Total count of transactions
Card Rate = 0.715% per transaction
Cost per transaction = 0.29c
Fees on Card rate= Sum of total amount x Card Rate
Fees per transaction= Total number of transaction x cost per transaction
Total Fees Payable = Feed on Card Rate + Fees per transaction
Sample Calculation
