How 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.

 

1. On your Apxium Dashboard, click on the Banking Menu and select Payments

On your Apxium Dashboard, click on the Banking Menu and select Payments

2. Tick the Detailed View box

Tick the Detailed View box

3. 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 payments based on transaction dates.

4. Filter Visa and Master Card Payments

On Type Column:

- Key in Mastercard,
- select OR,
- and key in Visa

Filter Visa and Master Card Payments

5. Filter Successful Transactions

On Status Column, Key in Paid to filter all payments with successful transactions.

Filter Successful Transactions

6. Click on Export to CSV

Click on Export to CSV

7. Calculate the transaction fees from your exported file

Total = Sum of total amount column
Number of Transactions = Total count of transactions

Card Rate = e.g. 0.88% per transaction

Cost per transaction = e.g. 0.28c


Fees on Card rate= Sum of total amount x Card Rate

Fees per transaction= Total number of transactions x cost per transaction

Total Fees Payable = Feed on Card Rate + Fees per transaction

8. Sample Calculation

Screen Shot 2023-01-12 at 5.33.40 PM