Reports can be created as JSON or CSV format. Each report returns a default set of fields/columns.
Payin Payments Report
The Payin Payments Report provides details on all payments from your customers to your account.
The following example shows the report output format:
text
id,created_at,updated_at,status,mode,amount,currency,bank_account_id,end_to_end_identification,mandate_id,payment_type,payment_scheme,partner_id,business_name,business_id,business_application_name,business_application_id,reference,external_reference,description,provider_name,failure_reason,provider_id,business_tag,execution_priority d9b332b0-5392-40ab-9f81-f919db1c814b,2024-10-09T08:58:58Z,2024-10-09T08:58:58Z,sent,test,30.00,AUD,e88ac547-3e99-41e4-9340-3d323a58c5ab,B-sz3wzQGSgRfWh,82698658-55e2-4783-bfa5-953dd32c86eb,PAY_IN,PAY_TO,6f2cee83-deae-4955-974b-c29c1f68e16d,Business Name,0b96ea7c-6202-41ac-b4b4-9b7b7af46bed,Test Application,f57d9099-3dc8-4814-9671-cb30317321f6,oioiWI09,external-reference,Payment for order #1234,Mock Bank,NULL,6cad4c25-b388-4d25-92cb-141979ae3c64,NULL,attended
json
[
{
"id": "d9b332b0-5392-40ab-9f81-f919db1c814b",
"created_at": "2024-10-09T08:58:58Z",
"updated_at": "2024-10-09T08:58:58Z",
"status": "sent",
"mode": "test",
"amount": "30.00",
"currency": "AUD",
"bank_account_id": "e88ac547-3e99-41e4-9340-3d323a58c5ab",
"end_to_end_identification": "B-sz3wzQGSgRfWh",
"mandate_id": "82698658-55e2-4783-bfa5-953dd32c86eb",
"payment_type": "PAY_IN",
"payment_scheme": "PAY_TO",
"partner_id": "6f2cee83-deae-4955-974b-c29c1f68e16d",
"business_name": "Business Name",
"business_id": "0b96ea7c-6202-41ac-b4b4-9b7b7af46bed",
"business_application_name": "Test Application",
"business_application_id": "f57d9099-3dc8-4814-9671-cb30317321f6",
"reference": "oioiWI09",
"external_reference": "external-reference",
"description": "Payment for order #1234",
"provider_name": "Mock Bank",
"failure_reason": null,
"provider_id": "6cad4c25-b388-4d25-92cb-141979ae3c64",
"business_tag": null,
"execution_priority": "attended"
}
]
Refund Report
The Refunds Report contains details to help track refunds issued against payments.
The following example shows the report output format:
text
id,original_payin_information,created_at,updated_at,amount,currency,bank_account_id,mode,end_to_end_identification,status,payment_type,payment_scheme,partner_id,business_name,business_id,business_application_name,business_application_id,refund_reference,provider_name,failure_reason,provider_id,business_tag,execution_priority bbc2c701-df62-4bc0-addf-c7676770bd81,d9b332b0-5392-40ab-9f81-f919db1c814b,2024-11-06T06:46:20Z,2024-11-06T06:46:29Z,30.00,AUD,03cb6800-9dba-4f62-b0c2-307cfc1e7204,test,B-eYQMwqWcWBtkm,sent,REFUND,NPP_SCT,ec25b518-32ca-4a1e-953c-ffc09e874cb6,Business Name,0dbd08ec-1149-497e-9b16-978bb85c2924,Test Application,d2f0812e-4463-49f3-a6c1-7546eddb2562,reference123,Mock Bank,NULL,4ff5b295-391d-4e41-a4b8-d85db4d91c28,NULL,unattended
json
[
{
"id": "bbc2c701-df62-4bc0-addf-c7676770bd81",
"original_payin_information": "d9b332b0-5392-40ab-9f81-f919db1c814b",
"created_at": "2024-11-06T06:46:20Z",
"updated_at": "2024-11-06T06:46:29Z",
"amount": "30.00",
"currency": "AUD",
"bank_account_id": "03cb6800-9dba-4f62-b0c2-307cfc1e7204",
"mode": "test",
"end_to_end_identification": "B-eYQMwqWcWBtkm",
"status": "sent",
"payment_type": "REFUND",
"payment_scheme": "NPP_SCT",
"partner_id": "ec25b518-32ca-4a1e-953c-ffc09e874cb6",
"business_name": "Business Name",
"business_id": "0dbd08ec-1149-497e-9b16-978bb85c2924",
"business_application_name": "Test Application",
"business_application_id": "d2f0812e-4463-49f3-a6c1-7546eddb2562",
"refund_reference": "reference123",
"provider_name": "Mock Bank",
"failure_reason": null,
"provider_id": "4ff5b295-391d-4e41-a4b8-d85db4d91c28",
"business_tag": null,
"execution_priority": "unattended"
}
]