Reconciliation

Below you find an example of how to use the APIs to reconcile a single day; specifically reconciliation of postings for the 2023-08-14.

First we get the opening balance for an account by calling /v1/accounts/{accountNumber}/balances with a time of 2023-08-14T00:00:00. This results in the following:


{
  "balance": {
    "value": "1000.00",
    "currency": "DKK"
  },
  "availableFunds": {
    "value": "800.00",
    "currency": "DKK"
  }
}

Afterward we get the closing balance by calling /v1/accounts/{accountNumber}/balances with the time 2023-08-14T23:59:59. This yields:


{
  "balance": {
    "value": "2100.00",
    "currency": "DKK"
  },
  "availableFunds": {
    "value": "2100.00",
    "currency": "DKK"
  }
}

Lastly, call /v1/postings with a time filter where from is set to 2023-08-14T00:00:00 and to is set to 2023-08-15T00:00:00. This will return a list of postings where the posting time is in the interval [from, to), i.e. a posting which occurs exactly on 2023-08-15T00:00:00 will not be included in the list:


{
  "accountNumber": "45588281470610",
  "postings": [
    {
      "postingId": "d53e59c6-f9c1-4639-8ad1-b1c144d1c9aa",
      "amount": {
        "value": "100.00",
        "currency": "DKK",
        "credit": false
      },
      "postingTime": "2023-08-14T02:04:11",
      "shortMessage": "Movie tickets",
      "longMessage": [],
      "postingType": "DOMESTIC_CREDIT_TRANSFER",
      "reversal": false
    },
    {
      "postingId": "7d8919bc-1c4f-402b-8a55-bbd42b87f640",
      "amount": {
        "value": "500.00",
        "currency": "DKK",
        "credit": true
      },
      "postingTime": "2023-08-14T15:18:23",
      "shortMessage": "ShareIt",
      "longMessage": [],
      "postingType": "DOMESTIC_CREDIT_TRANSFER",
      "reversal": false
    },
    {
      "postingId": "7c13e98d-d680-4408-8a1c-8ccc6f7d8a55",
      "amount": {
        "value": "700.00",
        "currency": "DKK",
        "credit": true
      },
      "postingTime": "2023-08-14T22:11:37",
      "shortMessage": "Zalando",
      "longMessage": [],
      "postingType": "DOMESTIC_CREDIT_TRANSFER",
      "reversal": false
    }
  ],
  "nextCursor": "7faf5be2-7f70-4048-9c34-ee02ec351bd7"
}

Now the postings can be reviewed and summed up – and in this case we can close the day.