Transactions Report

Use Transaction Report to get details of all customer transactions

Running a Transactions Report

Transactions Report can be used to fetch the details of all past customer transactions. Transactions report provide details like Customer Name, Transaction Date, Agreement Number, Purchase Amount within a time period specified in the Response Body of the Transactions Report API.

📘

Tip: Transaction Report can also be run from the PayBright portal optionally.

To run a transaction report, you will need to create the signature using the API Key and API Token shared with you by the PayBright team.

curl --location --request POST 'https://sandbox.paybright.com/checkout/reports.aspx' \
--header 'Content-Type: application/json' \
--data-raw '{
    "x_account_id": "Z9s7Yt0Txsqbbx",
    "x_test": "true",
    "x_transaction_type": "reports",
    "x_url_callback": "https://mystore.io/orders/1/done",
    "x_signature": "3a59e201a9b8692702b8c41dcba476d4a46e5f5c",
    "x_datefrom": "07/01/2020",
    "x_dateto":"07/16/2020",
    "x_reportname": "transactions"
}'

PayBright will send a response of Transactions Report API call as a POST request to x_url_callback and also to the initial request. You should receive a response that looks like this:

[{"x_customer_name":"Jamie Testhet","x_transaction_date":"7/16/2020 10:27:13
AM","x_agreement_number":"2033896-112-50515","x_purchase_amount":"1100.00","x_merchant_amount":"1078.55","x_fee_to_merchant":"0.00","x_fee_to_merchant_percentage":"0.00","x_customer_interest_rate":"0.00","x_original_term":"12","x_term_remaining":"0","x_outstanding_balance":"1100.00"},
{"x_customer_name":"Jamie
Testhet","x_transaction_date":"7/1/2020 7:00:57
AM","x_agreement_number":"2033923-124-49620","x_purchase_amount":"533.90","x_merchant_amount":"523.49","x_fee_to_merchant":"0.00","x_fee_to_merchant_percentage":"0.00","x_customer_interest_rate":"9.95","x_original_term":"24","x_term_remaining":"0","x_outstanding_balance":"533.90"}]

The following data will be returned for the Transaction Reports:

KEY

DESCRIPTION

CustomerEmail

Email address of the customer

CustomerName

Full name of the customer

TransactionDate

Date and time of customer transaction

AgreementNo

Unique number identifying the loan agreement between the customer and PayBright

PurchaseAmount

Amount of the purchased products/services by the customer

MerchantAmount

Amount that will be paid to the merchant, this is the PurcahseAmount minus any fees (admin, refund, or credit card)

InterestRate

Interest rate to be charged to the customer

Months

Original duration of the customer loan

MonthsRemaining

Number of months remaining in the customer's contract

OutstandingBalance

Amount of the loan amount that the customer still needs to pay

Descrip

System generated messaged describing payment transaction

Reference

Unique number identifying an order assigned by the merchant

Invoice

Unique number identifying the invoice of purchased products/service the customer receives from the merchant system

Description

Free text field where merchant users can include a message

DealId

Unique number provided for FX when non-CAD currency is used for a transaction

CaptureAmount

Total amount of payment captured by the merchant; this value may be less than the PurchaseAmount when the payment for different items in the order are captured at different points in time

SettlementAmountInCAD

If a transaction is settled between PayBright and the merchant in USD then the equivalent CAD amount will be displayed

SettlementAmountInUSD

If a transaction is settled between PayBright and the merchant in USD then the USD amount will be displayed

AdminFee

Fee charged to merchant to process a transaction

CreditcardFee

Fee charged to merchant for credit card purchases

RefundFee

Fee charged to merchant to process a customer refund

Funder

Identified entity providing the loan to the customer (e.g. PayBright or GoEasy)

Please check the API Reference for more Transactions Report API details.


What's Next