Skip to main content

Transaction Reporting

Endpoint for getting filtered transaction reports.

info

Please be aware that this endpoint requires a Transaction Reporting API Key.

GET /api/v1/groups/{group_id}/revere_pay/{linked_account_id}/transactions/reporting

Query Parameters

NameDescriptionTypeRequired
typeReport type: table, count, or amount_sum.stringRequired
limitNumber of results to return.uint64
offsetNumber of results to skip before collecting the result set.uint64
startStart date filter. Defaults to 6 months ago.string (RFC3339)
endEnd date filter. Defaults to now.string (RFC3339)
brandsCard brand filter. Values: Visa, Mastercard, Discover, American Express.string[]
payment_typesPayment type filter. Values: wallet, sale, refund, fulfillment, spendback, payout, fund.string[]
payment_methodsPayment method filter. Values: wallet, card, customer_card, customer_ach, ach, same_day_ach, ach_debit_fund, standard_ach, rtp_ach.string[]
settlement_batchesSettlement batch IDs filter.string[] (UUID)
payment_processorsPayment processor IDs filter.string[] (UUID)
transaction_sourcesTransaction source filter. Values: recurring, virtual_terminal, forms, wallet, api, invoice.string[]
currenciesCurrency filter. Values: USD.string[]
transaction_idTransaction IDs filter.string[] (UUID)
form_idsForm IDs filter.string[] (UUID)
form_custom_idsForm custom IDs filter.string[]
statusesTransaction status filter. Values: settled, voided, declined, partially_refunded, refunded, pending.string[]
order_idOrder ID filter.string
plan_idsPlan IDs filter.string[] (UUID)
subscription_idsSubscription IDs filter.string[] (UUID)
customer_idsCustomer IDs filter.string[] (UUID)
source_group_idSource group ID filter.string (UUID)
destination_group_idDestination group ID filter.string (UUID)
source_or_destination_group_idSource or destination group ID filter.string (UUID)
invoice_numbersInvoice number filter.string[]
invoice_idsInvoice IDs filter.string[] (UUID)
invoice_external_idsInvoice external IDs filter.string[]

Response

CodeDescription
200Success
400Bad Request / Validation error
500Internal Error

Example Usage

reporting.js
var headers = new Headers();
headers.append('Authorization', 'API_KEY');

var requestOptions = {
method: 'GET',
headers: headers,
redirect: 'follow'
};
const group_id = '';
const linked_account_id = '';
const url = `https://api.reverepayments.dev/api/v1/groups/${group_id}/revere_pay/${linked_account_id}/transactions/reporting?type=table`;
fetch(url, requestOptions)
.then((response) => response.text())
.then((result) => console.log(result))
.catch((error) => console.log('error', error));

Example Success Response

type=table

{
"items": [
{
"id": "c05861f0-6384-414d-b837-0ed71cefbbe5",
"group_id": "<group_id>",
"settlement_batch_ids": ["959c6c25-10f9-4341-ab93-1583898e33c9"],
"gateway": "revere_pay",
"processor_id": "ebc3e4dd-58fa-4c24-9afe-b076f60bc768",
"processor_name": "BASIC",
"processor_type": "revere_pay",
"transaction_type": "sale",
"payment_method": "card",
"payment_details": {
"card": {
"brand": "Visa",
"card_type": "debit",
"first_six": "411111",
"last_four": "1111",
"customer_name": "Joe Doe",
"expiration_date": "26/10",
"avs": "not available",
"cvv": "no match",
"issued_country": "US"
}
},
"amounts": {
"requested_amount": 3000,
"authorized_amount": 3000,
"captured_amount": 3000,
"included_tax_amount": 300,
"included_shipping_amount": 1000
},
"currency": "USD",
"description": "Lorem ipsum dolor sit amet.",
"source": "api",
"order_id": "",
"po_number": "",
"email_receipt": false,
"email_address": "test@example.com",
"billing_address": {
"first_name": "John",
"last_name": "Doe",
"company": "James' Company",
"city": "Scranton",
"line_1": "Slough Avenue",
"line_2": "1725",
"subdivision": "PA",
"postal_code": "18505",
"country": "US",
"email": "test@example.com"
},
"response_code": "SUCCESS",
"response_text": "confirmed",
"status": "settled",
"created_at": "2025-06-30T12:27:46.36004025Z"
}
],
"total_count": 1
}

type=count

{
"total_count": 142
}

type=amount_sum

{
"total_amount": 7500000
}