Automating Your Reconciliation With Our Statement API

Below are the steps you need to follow to automate your reconciliation process with our statement API.

Get the wallet id of the wallets you want their statement.
Request a statement via API.
Receive statement via webhook.
Parse the statement to reconcile.

Fetch Wallet ID of the Wallets

Before requesting a statement, you need to get the ids of the wallets you intend to get a statement. The get wallet endpoint can be used for retrieving your wallet ids. You can achieve this by simply sending companyId and the currency of the wallet when making the request.

Request

url: 'https://api-wallet-sandbox.vertofx.com/21/wallets?limit=100&skip=0&currency=USD'

Response

{
  "totalCount": 5,
  "items": [
    {
      "id": 2558,
      "totalBalance": 85566815.99,
      "availableBalance": 85566815.99,
      "currency": "USD",
      "type": "standard",
      "companyId": 525,
      "customReferenceLabel": "Default USD Wallet",
      "isDefault": true,
      "isDisabled": false,
      "fundingType": "account"
    }  ]
}

In the example above, the items[0].id is the wallet. You can then proceed to use the wallet id to request for the statement.

Request a Statement via API

To request the statement, you need the wallet ID which you just got above. Optionally, you can pass the date you want the statement and the format (UTC). Note that the default format is csv. For example if you want to retrieve the end of reconciliation, you will specify the following:

since: 2025-05-23T00:00:00.000Z UTC.
till: 2025-05-23T23:59:59.000Z UTC.
walletIds: the wallet id of the wallet.

Request

 url: 'https://api-wallet-sandbox.vertofx.com/statement/export?since=2024-12-12T00%3A00%3A00.000Z&till=2025-04-12T00%3A00%3A00.000Z&format=csv',

  Body:
{walletIds: [2558]}

Once the request is successful, we will send you a webhook with the statement file.

Receive Statement via Webhook

You need to set up a webhook for receiving the statement file. Specifically, you need to set up webhook beta to get events for wallet.statement.generated event.

Once the request is sent successfully, the statement will be sent to the webhook URL. You can then download and parse the file.

{
  "eventId": "aa8603b2-4814-ea40-da5e-fe025fdeb36f",
  "eventType": "wallet.statement.generated",
  "createdAt": "2025-04-24T15:40:30.647Z",
  "event": {
    "walletId": 13164,
    "companyId": "2513",
    "createdAt": "2025-04-24T15:40:30.647Z",
    "dateFrom": "2024-12-12T00:00:00.000Z",
    "dateTill": "2025-04-17T23:59:59.000Z",
    "transactionCount": 11,
    "url": "https://verto-reports-local.s3.eu-central-1.amazonaws.com/Wallet%20Statement%20%28Thu%20Dec%2012%202024%20-%20Thu%20Apr%2017%202025%29%20%3A%205bdeeeb3-6ed2-5ea6-d6de-32239b2758e4.csv?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAQJBHYLXIYE4245ZH%2F20250424%2Feu-central-1%2Fs3%2Faws4_request&X-Amz-Date=20250424T154030Z&X-Amz-Expires=86400&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEID%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaDGV1LWNlbnRyYWwtMSJGMEQCIHGJCMq7%2FDPYCadec3JrV%2Bf%2BGlYI9bujx%2BUjOWP5n8kZAiALma9cJ3%2BCJ5tlAOGidpKEPy23FT6p2fYSiJvq3FiNKyr5AggZEAMaDDAxOTQxMDczODY0MSIMB7ezFZqUP%2BS8uM8KKtYCr2X7IVigHazjhs5BxZO9VN7qOCK5fsLx7iDrjTJ5z%2FKkKEzeMZ8afpTC4wq2WCjMA1kJv%2Fy7IdrneNhHPGZRA6EeUaj5xS0O6DfGioL8Ap%2BnJXlHUG9KzBhr6CItMEp015jG62tX73d70P28ws6JbEcBcJJLsiHiv1cTEA6tfKWiaQKRejzq4BokHvUyvrMkBjoE8Oum8%2B1EGaZRKjnCNFMIp3JmrA7Pxc0EP6EumfzQt2XJJgjm79DCXpsjlg%2FQE1ZgRNmjMHfEN%2F2cuZ8AOGmn6hivzJIzT2HW7XbgqlRFE1FCN7J2up9a2GIqg9hznlId757%2FWr%2FzMl2ENDQB%2FQEMYUMJgQXCpxZnTpBTsco%2BJxV7MMspGHXoLt3Na9qArYvlzRrph%2F3YFX7ACtWRtfyJ1qrZ%2FHrStVHu0J9fm%2BjDc2I044GJbTBZhq9X4OIY4vEtzjIEMOW2qcAGOp8BeLoaSKSjsOZ2XM1GtVtrvFllVTyAq5S0WcHXFyQ2D3GLvUEs%2FJbd6EfD%2BjOgB9isQmgqX6QFuh%2BAqjVv2iy45jbG1iOp1kM5rFsIp1g%2FRFsxWIuiq10Nfhzop3M%2BEG7fHEzX1xap5OPqb3rhmgU89xXbURwsqHKtRcoCkJb2rI1wMu5UA%2Bcst4xmrT9c9nuRM8JcHBbpy3yh0M4r2Dy2&X-Amz-Signature=720fe36272e81f6f1cfac2da84df6e0809bc3435dabe37279148696c3b3458a0&X-Amz-SignedHeaders=host&x-id=GetObject"
  }
}

The file can be obtained via the URL field.

Parse the Statement to Reconcile

Once you receive the webhook, you can then proceed to parse the file using the URL field.