Funding Report Gateway Fee Reconciliation

Michael Engler
Michael Engler The chief of community conversations. Community manager Master (Platinum)
  • Updated

Introduction

Using Nomupay's gateway will trigger a fee based on your usage. When you are setup for Nomupay acquiring then the applicable gateway fee is reported via the daily funding report, which you receive either via email or can download from Nomupay's Portal. 

The gateway fee will be shown as one or more line items per day, and the line item(s) will indicate the usage that triggered the fee. You can reconcile the line item(s) in the funding report with your gateway usage by consulting the Transactions page in the Nomupay Portal.

 

Gateway fee line items

Your gateway usage is classified as events. The list of possible billable events are as follows:

Event type short nameDescription
three_d3D Secure
cpCapture
dbDebit
drDeregister
dsDeschedule
paPreauthorisation
rbRebill
rfRefund
rgRegister
rrReregister
rsReschedule
rvReversal
sdSchedule

In your daily funding report you will see one or more line items per day. The line item(s) linked to gateway fees can be identified by the following fields:

  • Transaction Type (transaction_type) = NT_Fee
  • Gateway Fee Amount (gateway_fee_amount) = The gateway fee amount calculated based on the count of events
  • Remarks (remarks) = The count of the events e.g. gatewayfee for 100 three_d 100 db 2 rf

 

Reconcile gateway fees with gateway usage

To reconcile the count of gateway fee events in the funding report with your gateway usage we advise to take the following steps:

  1. Sum the counts of line item(s) per event type for a day or a period, and
  2. Compare the sum per event type with the transactions in the Portal for the same day or period.

It should be noted that a single transaction can have multiple events, which means the reconciliation must be done per event type.

As an example:

(1) Extract data from daily funding report:

Transaction Date (trxn_date) = 01/09/25

remarks
gatewayfee for 100 three_d 100 db 2 rf
gatewayfee for 45 three_d 55 db 1 rf
gatewayfee for 5 db

 

(2) Sum the line items per event type for the given day:

Event type short nameDescriptionSum
three_d3D Secure100 + 45 = 145
dbDebit100 + 60 = 160
rfRefund2 + 1 = 3

 

(3) View the sums in the form of Total Transactions in Nomupay's Portal:

Go to the Transactions page and filter on 01/09/25

 

Filter on the event types

Event type short nameDescriptionClick on the dropdown and choose
three_d3D SecureChoose 3DSYes
cpCapturePayment TypeCP (Capture)
dbDebitPayment TypeDB (Debit)
drDeregisterPayment TypeDR (Deregister)
dsDeschedulePayment Type(DS) Deschedule
paPreauthorisationPayment Type(PA) Preauthorisation
rbRebillPayment Type(RB) Rebill
rfRefundPayment Type(RF) Refund
rgRegisterPayment Type(RG) Register
rrReregisterPayment Type(RR) Reregister
rsReschedulePayment Type(RS) Reschedule
rvReversalPayment Type(RV) Reversal
sdSchedulePayment Type(SD) Schedule

 

View the sum of Total Transactions returned by the Portal based on the applied filter

Note there can be smaller discrepancies due to time zone differences between Nomupay Gateway and the user logging into the Portal.

Future enhancements

Note that we plan to improve the customer experience when it comes to gateway event billing in the upcoming period. The planned changes will include:

  • A change of the Transaction Type (transaction_type) from NT_Fee to Gateway_Events,

  • Ensure that only one line item will be reported per day, and

  • Ease the reconciliation of gateway fees with gateway usage.

We we keep this article up to date to reflect the roll-out of the upcoming enhancements.

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request