Get all bank statements

GET /api/v1/bank-statement

Headers

  • X-PLANNR-ACCOUNT-UUID string

Query parameters

  • filter[uuid] string

    Filter by a comma separated list of UUIDs.

  • filter[statement_uuids] string

    Comma separated list of payment period statement UUIDs. e.g. fb8ca37d-6c5b-4688-bb69-1aacfffb8bea

  • filter[name] string

    Comma separated list of partial bank statement names. e.g. Natwest

  • filter[reference] string

    Comma separated list of partial bank statement references. e.g. SW#324

  • filter[date_from] string

    Statement date from in format YYYY-MM-DD e.g. 2022-10-15

  • filter[date_to] string

    Statement date from in format YYYY-MM-DD e.g. 2022-12-30

  • filter[amount_from] integer

    Total amount of transactions within bank statement to, in pennies e.g. 5000

  • sort string

    Field to sort by. Valid fields are [created_at, updated_at, name, reference, date, total_amount]. Negative sign to denote DESC. Defaults to '-created_at'.

  • per_page integer

    Number of results to return with pagination (Default 15. Max 500).

Responses

  • 200 application/json
    Hide response attribute Show response attribute object
    • data array[object]
      Hide data attributes Show data attributes object
      • uuid string
      • created_at string
      • updated_at string
      • number integer
      • reference string
      • date string
      • name string
      • statement object
        Hide statement attributes Show statement attributes object
        • uuid string
        • created_at string
        • updated_at string
        • name string
        • start_date string
        • end_date string
        • locked boolean
        • locked_at string
        • locked_by string
        • total_expectations object
          Hide total_expectations attributes Show total_expectations attributes object
          • amount string
          • currency string
          • formatted string
        • total_statement_transactions object
          Hide total_statement_transactions attributes Show total_statement_transactions attributes object
          • amount string
          • currency string
          • formatted string
        • total_bank_transactions object
          Hide total_bank_transactions attributes Show total_bank_transactions attributes object
          • amount string
          • currency string
          • formatted string
        • total_expectation_amount_reconciled_to_bank object
          Hide total_expectation_amount_reconciled_to_bank attributes Show total_expectation_amount_reconciled_to_bank attributes object
          • amount string
          • currency string
          • formatted string
        • total_expectation_percentage_reconciled_to_bank object
          Hide total_expectation_percentage_reconciled_to_bank attributes Show total_expectation_percentage_reconciled_to_bank attributes object
          • amount string
          • currency string
          • formatted string
        • expectations_count integer
        • statement_transactions_count integer
        • statement_transactions string
      • bank_transactions_count integer
      • bank_transactions array[object]
        Hide bank_transactions attributes Show bank_transactions attributes object
        • uuid string
        • created_at string
        • updated_at string
        • date string
        • amount object
          Hide amount attributes Show amount attributes object
          • amount string
          • currency string
          • formatted string
        • reference string
        • metadata object
          Hide metadata attribute Show metadata attribute object
          • client_name string
        • filename string
        • bank_statement string
        • statement string
        • account string
        • firm string
      • total_amount object
        Hide total_amount attributes Show total_amount attributes object
        • amount string
        • currency string
        • formatted string
      • reconciled_amount object
        Hide reconciled_amount attributes Show reconciled_amount attributes object
        • amount string
        • currency string
        • formatted string
      • reconciled_percentage number
GET /api/v1/bank-statement
curl \
 --request GET 'https://api.plannrcrm.com/api/v1/bank-statement' \
 --header "Authorization: Bearer $ACCESS_TOKEN" \
 --header "X-PLANNR-ACCOUNT-UUID: {YOUR_PLANNR_ACCOUNT_UUID}"
Response examples (200)
{
  "data": [
    {
      "date": "2025-06-26",
      "name": "Aviva",
      "uuid": "9a1f3fea-6e8c-4dd5-b48d-64a22fcd37a6",
      "number": 23,
      "reference": "SW#8434",
      "statement": {
        "name": "01/06/2022 - 30/06/2022",
        "uuid": "9e5e2ab7-4414-495a-bd77-6b170dc04c11",
        "locked": false,
        "end_date": "2022-06-01",
        "locked_at": "2025-06-26T11:37:09+01:00",
        "locked_by": "App\\Http\\Resources\\AccountResource",
        "created_at": "2025-06-26T11:37:09+01:00",
        "start_date": "2022-06-30",
        "updated_at": "2025-06-26T11:37:09+01:00",
        "expectations_count": 6,
        "total_expectations": {
          "amount": "124585",
          "currency": "GBP",
          "formatted": "£1,245.85"
        },
        "statement_transactions": "App\\Http\\Resources\\StatementTransactionResource",
        "total_bank_transactions": {
          "amount": "125599",
          "currency": "GBP",
          "formatted": "£1,255.99"
        },
        "statement_transactions_count": 6,
        "total_statement_transactions": {
          "amount": "125599",
          "currency": "GBP",
          "formatted": "£1,255.99"
        },
        "total_expectation_amount_reconciled_to_bank": {
          "amount": "125599",
          "currency": "GBP",
          "formatted": "£1,255.99"
        },
        "total_expectation_percentage_reconciled_to_bank": {
          "amount": "8570",
          "currency": "GBP",
          "formatted": "£85.70"
        }
      },
      "created_at": "2025-06-26T11:37:09+01:00",
      "updated_at": "2025-06-26T11:37:09+01:00",
      "total_amount": {
        "amount": "345895",
        "currency": "GBP",
        "formatted": "£3,458.95"
      },
      "bank_transactions": [
        {
          "date": "2022-07-15",
          "firm": "App\\Http\\Resources\\FirmResource",
          "uuid": "8fdbaeb9-6e73-4a3a-a4dd-770e9571a04f",
          "amount": {
            "amount": "12399",
            "currency": "GBP",
            "formatted": "£123.99"
          },
          "account": "App\\Http\\Resources\\AccountResource",
          "filename": "Natwest June 2022 Statement.xlsx",
          "metadata": {
            "client_name": "Gareth Thompson"
          },
          "reference": "VitalityLtd",
          "statement": "App\\Http\\Resources\\StatementResource",
          "created_at": "2025-06-26T11:37:09+01:00",
          "updated_at": "2025-06-26T11:37:09+01:00",
          "bank_statement": "App\\Http\\Resources\\BankStatementResource"
        }
      ],
      "reconciled_amount": {
        "amount": "12849",
        "currency": "GBP",
        "formatted": "£128.49"
      },
      "reconciled_percentage": 95.68,
      "bank_transactions_count": 6
    }
  ]
}