Get all bank transactions

GET /api/v1/bank-transaction

Personal access token & O auth2

Headers

X-PLANNR-ACCOUNT-UUID string

Query parameters

include string

Comma separated list of relationships to include in the response. Valid relationships are [statement].
filter[uuid] string

Filter by a comma separated list of UUIDs.
filter[statement_uuids] string

Filter bank transaction by a statement UUID.
filter[bank_statement_uuids] string

Filter bank statement transactions by an exact bank statement UUID.
filter[date_from] string

Get bank transactions from a certain date.
filter[date_to] string

Get bank transactions to a certain date.
filter[amount_from] string

Get bank transactions greater than or equal to a certain amount in pennies.
filter[amount_to] string

Get bank transactions less than or equal to a certain amount in pennies.
filter[reference] string

Filter bank transactions by a partial transaction reference
filter[reconciliation] string

Filter bank transactions based on their reconciliation status. Available options: reconciled,unreconciled,partially_reconciled
filter[reconciliation_percentage_between] string

Filter bank transactions based on their reconciliation amount between two values as a percentage.
filter[reconciliation_amount_between] string

Filter bank transactions based on their reconciliation amount between two values in pennies.
sort string

Field to sort by. Valid fields are [created_at, updated_at, payment_date, reference, amount]. Negative sign to denote DESC. Defaults to 'date'.
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
  
  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 object
  
  Hide bank_statement attributes Show bank_statement attributes object
  
  uuid string
  
  created_at string
  
  updated_at string
  
  number integer
  
  reference string
  
  date string
  
  name string
  
  statement string
  
  bank_transactions_count integer
  
  bank_transactions 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
  
  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
  
  account object
  
  Hide account attributes Show account attributes object
  
  uuid string
  
  created_at string
  
  updated_at string
  
  type string
  
  role string
  
  first_name string
  
  last_name string
  
  name string
  
  email string
  
  firm string
  
  primary_phone_number string
  
  primary_email string
  
  current_time_entry string
  
  assigned_adviser string
  
  assigned_administrator string
  
  assigned_paraplanner string
  
  introduced_by string
  
  groups string
  
  tags string
  
  owners string
  
  first_contact_date string
  
  next_review_date string
  
  previous_review_date string
  
  anniversary_review_date string
  
  with_login boolean
  
  has_joint_account boolean
  
  can_be_deleted string
  
  joint_account_circle string
  
  ownership_percentage integer
  
  inactive_at string
  
  custom_fields string
  
  external_references string
  
  firm object
  
  Hide firm attributes Show firm attributes object
  
  uuid string
  
  created_at string
  
  updated_at string
  
  name string
  
  slug string
  
  address_1 string
  
  address_2 string
  
  town_city string
  
  county string
  
  postcode string
  
  country string
  
  regulatory_text string
  
  logo string
  
  logo_icon string
  
  brand_colours object
  
  Hide brand_colours attributes Show brand_colours attributes object
  
  sidebar_background string
  
  sidebar_accent string
  
  sidebar_text string
  
  sidebar_hover string
  
  sidebar_active string
  
  sidebar_title_background string
  
  sidebar_title_primary string
  
  sidebar_title_secondary string
  
  sidebar_title_secondary_hover string
  
  email_background string
  
  email_logo_background_panel string
  
  email_sub_text string
  
  email_button_background string
  
  email_button_text string
  
  portal_sidebar_button_background string
  
  portal_sidebar_button_hover string
  
  portal_sidebar_button_active string
  
  portal_brand_title string
  
  portal_brand_sub_title string
  
  portal_sidebar_title string
  
  portal_sidebar_text string
  
  portal_sidebar_text_hover string
  
  portal_sidebar_text_active string
  
  portal_sidebar_icon string
  
  portal_sidebar_icon_hover string
  
  portal_sidebar_icon_active string
  
  portal_background string
  
  portal_sidebar_account_title string
  
  portal_account_email string
  
  portal_sidebar_divider string
  
  portal_dashboard_bg_one string
  
  portal_dashboard_bg_two string
  
  is_subscribed boolean
  
  addon_subscriptions string
  
  keep_deleted_files_for integer
  
  tax number
  
  month_end integer
  
  statement_frequency string
  
  billing object
  
  Hide billing attributes Show billing attributes object
  
  invoice_address_1 string
  
  invoice_address_2 string
  
  invoice_town_city string
  
  invoice_county string
  
  invoice_postcode string
  
  invoice_country string
  
  invoice_email string
  
  task_board_template string
  
  ip_whitelist array[string]
  
  welcome_paragraph_html string
  
  email_welcome_paragraph_html string
  
  show_fact_find_illustrations boolean
  
  reconciliation object
  
  Hide reconciliation attributes Show reconciliation attributes object
  
  amount object
  
  Hide amount attributes Show amount attributes object
  
  amount object
  
  Hide amount attributes Show amount attributes object
  
  example string
  
  description string
  
  formatted object
  
  Hide formatted attributes Show formatted attributes object
  
  example string
  
  description string
  
  currency object
  
  Hide currency attributes Show currency attributes object
  
  example string
  
  description string
  
  percentage integer
  
  is_reconciled boolean
  
  reconciliations object
  
  Hide reconciliations attributes Show reconciliations attributes object
  
  uuid string
  
  created_at string
  
  updated_at string
  
  amount object
  
  Hide amount attributes Show amount attributes object
  
  amount object
  
  Hide amount attributes Show amount attributes object
  
  example string
  
  description string
  
  formatted object
  
  Hide formatted attributes Show formatted attributes object
  
  example string
  
  description string
  
  currency object
  
  Hide currency attributes Show currency attributes object
  
  example string
  
  description string
  
  statement_transaction string
  
  bank_transaction string
  
  account string

GET /api/v1/bank-transaction

curl \
 --request GET 'https://api.plannrcrm.com/api/v1/bank-transaction' \
 --header "Authorization: Bearer $ACCESS_TOKEN" \
 --header "X-PLANNR-ACCOUNT-UUID: {YOUR_PLANNR_ACCOUNT_UUID}"

Response examples (200)

{
  "data": [
    {
      "date": "2022-07-15",
      "firm": {
        "tax": 17.5,
        "logo": "https://api.plannrcrm.com/images/plannr.jpg",
        "name": "Codepotato",
        "slug": "codepotato",
        "uuid": "beefbd46-a7a5-4c3f-818f-33fa0e3dd30e",
        "county": "Hampshire",
        "billing": {
          "invoice_email": "gareth@codepotato.co.uk",
          "invoice_county": "Hampshire",
          "invoice_country": "United Kingdom",
          "invoice_postcode": "PO7 7YH",
          "invoice_address_1": "Suite E, 5 The Briars",
          "invoice_address_2": "Waterberry Drive",
          "invoice_town_city": "Waterlooville"
        },
        "country": "United Kingdom",
        "postcode": "PO7 7YH",
        "address_1": "Suite E, 5 The Briars",
        "address_2": "Waterberry Drive",
        "logo_icon": "https://api.plannrcrm.com/images/plannr-icon.jpg",
        "month_end": 25,
        "town_city": "Waterlooville",
        "created_at": "2025-06-26T11:37:09+01:00",
        "updated_at": "2025-06-26T11:37:09+01:00",
        "ip_whitelist": [
          "192.168.0.1",
          "127.0.0.1"
        ],
        "brand_colours": {
          "sidebar_text": "#ffffff",
          "sidebar_hover": "#0A0A42",
          "email_sub_text": "#ffffff",
          "sidebar_accent": "#36367E",
          "sidebar_active": "#53DBB8",
          "email_background": "#0E0E56",
          "email_button_text": "#ffffff",
          "portal_background": "#f6f6f6",
          "portal_brand_title": "#323b4b",
          "sidebar_background": "#0E0E56",
          "portal_sidebar_icon": "#828994",
          "portal_sidebar_text": "#323b4b",
          "portal_account_email": "#828994",
          "portal_sidebar_title": "#11151d",
          "sidebar_title_primary": "#FFC634",
          "portal_brand_sub_title": "#828994",
          "portal_sidebar_divider": "#e3e5e9",
          "email_button_background": "#36367E",
          "portal_dashboard_bg_one": "#EF4583",
          "portal_dashboard_bg_two": "#FFC634",
          "sidebar_title_secondary": "#ffffff",
          "sidebar_title_background": "#36367E",
          "portal_sidebar_icon_hover": "#828994",
          "portal_sidebar_text_hover": "#323b4b",
          "portal_sidebar_icon_active": "#828994",
          "portal_sidebar_text_active": "#323b4b",
          "email_logo_background_panel": "#36367E",
          "portal_sidebar_button_hover": "#ffffff",
          "portal_sidebar_account_title": "#11151d",
          "portal_sidebar_button_active": "#ffffff",
          "sidebar_title_secondary_hover": "#ffffff",
          "portal_sidebar_button_background": "#f6f6f6"
        },
        "is_subscribed": true,
        "regulatory_text": "Regulatory text",
        "addon_subscriptions": "App\\Http\\Resources\\Addons\\AddonSubscriptionResource",
        "statement_frequency": "monthly",
        "task_board_template": "App\\Http\\Resources\\Board\\BoardResource",
        "keep_deleted_files_for": 30,
        "welcome_paragraph_html": "<h1>Welcome.</h1>",
        "email_welcome_paragraph_html": "Welcome to Plannr!",
        "show_fact_find_illustrations": true
      },
      "uuid": "90d6e14f-3655-4040-9ce8-47f950cc1e13",
      "amount": {
        "amount": "12399",
        "currency": "GBP",
        "formatted": "£123.99"
      },
      "account": {
        "firm": "App\\Http\\Resources\\FirmResource",
        "name": "Gareth Thompson",
        "role": "client",
        "tags": "App\\Http\\Resources\\TagResource",
        "type": "client",
        "uuid": "1d3196f8-51b1-478e-ab86-704e4d4db1ca",
        "email": "gareth@codepotato.co.uk",
        "groups": "App\\Http\\Resources\\GroupResource",
        "owners": "App\\Http\\Resources\\AccountResource",
        "last_name": "Thompson",
        "created_at": "2025-06-26T11:37:09+01:00",
        "first_name": "Gareth",
        "updated_at": "2025-06-26T11:37:09+01:00",
        "with_login": true,
        "inactive_at": "2025-06-26",
        "custom_fields": "App\\Http\\Resources\\CustomFieldValueResource",
        "introduced_by": "App\\Http\\Resources\\AccountResource",
        "primary_email": "App\\Http\\Resources\\ContactDetailResource",
        "can_be_deleted": "false",
        "assigned_adviser": "App\\Http\\Resources\\AccountResource",
        "next_review_date": "2025-06-26T11:37:09+01:00",
        "has_joint_account": true,
        "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
        "first_contact_date": "2025-06-26T11:37:09+01:00",
        "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
        "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
        "joint_account_circle": "App\\Http\\Resources\\CircleResource",
        "ownership_percentage": 100,
        "previous_review_date": "2025-06-26T11:37:09+01:00",
        "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
        "assigned_administrator": "App\\Http\\Resources\\AccountResource",
        "anniversary_review_date": "2025-06-26T11:37:09+01:00"
      },
      "filename": "Natwest June 2022 Statement.xlsx",
      "metadata": {
        "client_name": "Gareth Thompson"
      },
      "reference": "VitalityLtd",
      "statement": {
        "name": "01/06/2022 - 30/06/2022",
        "uuid": "ca27a7eb-69ab-4a8a-a6c8-06018b72c018",
        "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",
      "bank_statement": {
        "date": "2025-06-26",
        "name": "Aviva",
        "uuid": "70ac76ab-59fc-4186-89d1-628b15b463da",
        "number": 23,
        "reference": "SW#8434",
        "statement": "App\\Http\\Resources\\StatementResource",
        "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": "App\\Http\\Resources\\BankTransactionResource",
        "reconciled_amount": {
          "amount": "12849",
          "currency": "GBP",
          "formatted": "£128.49"
        },
        "reconciled_percentage": 95.68,
        "bank_transactions_count": 6
      },
      "reconciliation": {
        "amount": {
          "amount": {
            "example": "4000",
            "description": "Money amount at their lowest denominator (for example: pennies)"
          },
          "currency": {
            "example": "GBP",
            "description": "Currency of the money"
          },
          "formatted": {
            "example": "£40.00",
            "description": "Money amount formatted with currency"
          }
        },
        "percentage": 100,
        "is_reconciled": true
      },
      "reconciliations": {
        "uuid": "d61a22b9-9560-417f-a549-eb6daf42e902",
        "amount": {
          "amount": {
            "example": "4000",
            "description": "Money amount at their lowest denominator (for example: pennies)"
          },
          "currency": {
            "example": "GBP",
            "description": "Currency of the money"
          },
          "formatted": {
            "example": "£40.00",
            "description": "Money amount formatted with currency"
          }
        },
        "account": "App\\Http\\Resources\\AccountResource",
        "created_at": "2025-06-26T11:37:09+01:00",
        "updated_at": "2025-06-26T11:37:09+01:00",
        "bank_transaction": "App\\Http\\Resources\\BankTransactionResource",
        "statement_transaction": "App\\Http\\Resources\\StatementTransactionResource"
      }
    }
  ]
}