Skip to main content

Reporting

Exact's Reporting APIs enable our partners and customers (merchants) to access all Account (Merchant Onboarding), Transaction, Settlement, Chargeback, Fee and Payout data for their account or portfolio of accounts. Queries are defined by Date/Time range and can be for a single or multiple accounts. Report data is returned either in Json or comma delimited file format. Reports include a expiration date set through the API.

Account Data: Report data includes current status of all submitted account applications for a given user during the specified report range. Status includes Approved, Declined, Closed, Terminated or Pending.

Transaction Data: Report data includes all transactions (Payments API) or events processed by a given user during the specified report range whether approved or declined.

Chargeback Data: Report data includes any Chargeback (credit/debit card or ACH) posted during the specified report range.

Settlement Data: Report data includes all transactions that have been settled through a Payment Network (Visa, Mastercard, AMEX, Discover, NACHA) and approved for funding. Funding timelines are defined in the terms of services but generally range 1 - 2 days for credit and debit card and 3 - 4 days for ACH.

Fees and Payouts Data (Coming Soon): Report data includes daily fees and payouts for given accounts (merchants) during the specified period. This data is valuable for partner and merchant reconciliation where bank deposits are matched to settlement (payouts) data and fees assessed.

To create a report, submit a JSON request as follows:

Create Report
     --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 download the report with a JSON request as follows:

Download Report
     --url 'https://api.exactpaysandbox.com/report/61a91d429bf82a2d8e95738f?format=csv' \
--header 'accept: application/json'
```