Skip to content

Payin transaction reconciliation

The payin transaction reconciliation shows all orders in the final state on the day according to the completion time of the transaction order.

Payin transaction report template:Merchant ID_payin

Bill HeaderHeader DescriptionBill Sample 1Bill Sample 2Enumeration
AppIDApp IDb1de8a8f728840739fcb7ab49b02f4cdf65bdb49d4924fb399e341559b02dca6
Txn Create TimeTransaction Create Time2023/2/1 0:31:00.02023/5/5 3:40:00.0
Txn Complete TimeTransaction Complete Time2023/2/13 9:32:00.02023/4/3 11:57:00.0
User IDUser ID341678574234541234
Transaction TypeTransaction TypePAYMENTCHARGE_BACKPAYMENT
CHARGE_BACK
REFUND
PAY_LINK
SUBSCRIPTION
COLLECTION
ADJUSTMENT_INCREASE
ADJUSTMENT_DECREASE
OriginalMerchant Txn IDOriginal Merchant Transaction ID3c19e07427642abf078f47ac51c1ca
Merchant Txn IDMerchant Txn ID3c19e61450645ec4b1a111155181953c19e07427642abf078f47ac51c1ca
Trade Order IDPayerMax Transaction IDTOKEN20230512228823425324O20230505034046314647849721
Txn StatusTransaction StatusCB RequestFAILED
SUCCESS
CLOSED
CB Request
CB Reversed
CountryCountrySAQA
Txn AmountTransaction Amount7100
Txn CurrencyTransaction CurrencySARQAR
Payment AmountPayment Amount7
Payment CurrencyPayment CurrencySAR
Payment Method TypePayment Method TypeCARDCARD
Payment MethodPayment MethodMADANAPS
Traget Org/Card OrgTraget Org/Card OrgMADANAPS
Txn FeeTransaction Fee-1-36.61
Txn Fee CurrencyTransaction Fee CurrencySARQAR
Rate FeeTransaction Rate Fee00
Fixed FeeTransaction Fixed Fee-1-36.61
Txn TaxTransaction Tax-0.2
Txn Tax CurrencyTransaction Tax CurrencySARQAR
Merchant Txn TaxMerchant Transaction Tax-0.3
Merchant Txn Tax CurrencyMerchant Transaction Tax CurrencySAR
Net AmountNet Amount5.5-136.61
Net CurrencyNet CurrencySARQAR
Exchange RateExchange Rate【Reserved field, temporarily empty】
Exchange rate TimeExchange rate Time【Reserved field, temporarily empty】
Exchange TypeExchange Type【Reserved field, temporarily empty】
Failure ReasonFailure ReasonPayment was not completed on time.
Trade DescriptionTransaction Descriptionsubject
Merchant Txn Tax RateTax rate on behalf of merchantsThe tax rates are subject to the policies of each individual country.
Fields to be addedWhen new business arises in the future, we will add new fields to the end of the billing statements to provide clarification and identification.

Calculation formulas for various fields:
Net Amount = Txn Amount + Txn Fee + Txn Tax + Merchant Txn Tax
Txn Fee = Rate Fee + Fixed Fee

Released under the MIT License.