Statement Report

Export merchant statement reports by date range using the Merchant Statement API.

Export a merchant statement report by sending a date range and file format to the statement export endpoint.

Use the Merchant Statement API to generate a statement report for a selected period. The API returns the report as a downloadable file, such as statement.csv when you request format: "csv".

Endpoint

POST https://backend.sa.amwal.tech/accounting/merchant_statement/

Prerequisites

  1. Get your merchant API key from the Merchant Portal.
  2. Get your X-Amwal-Key for the environment you want to export from.
  3. Choose the report date range using YYYY-MM-DD format.

Export a statement report

Send a POST request with the report start date, end date, and export format.

curl 'https://backend.sa.amwal.tech/accounting/merchant_statement/' \
  --compressed \
  -X POST \
  -H 'Authorization: YOUR_API_KEY' \
  -H 'Accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'X-Amwal-Key: YOUR_AMWAL_KEY' \
  --data-raw '{"start":"2026-01-01","end":"2026-05-10","format":"csv"}' \
  -o statement.csv

When the request succeeds, cURL writes the exported report to statement.csv in your current directory.

Request headers

HeaderRequiredDescription
AuthorizationYesYour merchant API key.
AcceptYesSet to application/json.
Content-TypeYesSet to application/json because the request body is JSON.
X-Amwal-KeyYesThe Amwal environment key for the merchant account you are exporting from.

Request body fields

FieldTypeRequiredDescriptionExample
startstringYesStart date for the statement report in YYYY-MM-DD format.2026-01-01
endstringYesEnd date for the statement report in YYYY-MM-DD format.2026-05-10
formatstringYesExport file format. Use csv to download a CSV report.csv

Output file

Use the -o option to save the exported report to a file:

-o statement.csv

You can change the filename to match your reporting workflow, for example merchant-statement-2026-01-01-to-2026-05-10.csv.

Highlighted output fields

The exported statement report includes the following fields:

FieldDescriptionPossible values
DateDate associated with the statement report row.
Transaction_idUnique transaction identifier in the statement report.
Order IDMerchant order identifier associated with the transaction.
DescriptionDescription for the transaction report row.
Payment OptionPayment option used for the transaction.
Installment DurationInstallment plan duration selected for the transaction.3 months, 6 months, 12 months, 24 months
Payment Link IDPayment link identifier associated with the transaction.
Order Refund IDRefund identifier associated with the order, when a refund exists.
Disputed StatusCurrent dispute status for the transaction.PENDING, RESOLVED, LOST
DebitDebit amount recorded for the statement report row.
CreditCredit amount recorded for the statement report row.
BalanceRunning balance after the statement report row is applied.
Payment BrandPayment brand used for the transaction.
Branch NameBranch name associated with the transaction.
Merchant Payout IDPayout ID linked to each transaction..

Do not publish real Authorization or X-Amwal-Key values in your documentation or client-side code. Store keys securely and replace the placeholders before running the request.