Reporting
Reporting is a critical to the merchant manageing their business or for partners managing their merchants. Exact payments offers up a reporting API that will allow the merchant or partner to have access to reports which include Account (Merchant Onboarding), Transactional data, Settlement data, Chargeback data, Fee and Payout data. All data is currently available as a Data/Time range and can be for a single or multiple merchants. A report can then be generated from the data in either a comma delimited or Json file format. Also each report has a expiration date that can be set through the API.
Account Data: This report shows current status of all onboarding merchants for a given user during the specified report. Status includes Approved, Declined, Closed, Terminated or Pending merchant accounts
Transactional Data: This report includes all transactions (Payments API) or events run during the specified period whether approved or declined by the Exact Payments platform.
Chargeback Data: This includes and Chargebacks (Credit or ACH) that have occured during the specified period. Chargebacks are transactions that were previously approved, but the consumer(Buyer) is now stating was not a charge they made.
Settlement Data: This includes all payment type transactions that have been approved to be funded both credit card and ACH. The funding of credit cards can take up to two days and that of ACH up to four days.
Fees and Payouts Data (Coming Soon): This report will show the daily fees and payouts for the given merchant(s) during the specified period. This is valuable for the merchant to match deposits and understand the fees they are paying for processing transactions
To creat a report the clients should submit a JSON request as follows:
--url https://api.exactpaysandbox.com/report/transaction \
--header 'accept: application/json' \
--header 'content-type: application/json' \
--data '
{
"parameters": {
"accounts": [
"Merchant Store 35 in Arizona"
],
"start": "2022-01-01T00:00:00.000Z",
"end": "2022-11-15T23:59:59.999Z",
"user": "61a78fe82c3156b0945ef135"
},
"expiresAt": "2030-01-01T00:00:00.000Z"
}
'
Then to Download the report the clients should submit a JSON request as follows:
--url 'https://api.exactpaysandbox.com/report/61a91d429bf82a2d8e95738f?format=csv' \
--header 'accept: application/json'
```