Get all reconciliations on a bank transaction

GET /api/v1/bank-transaction/{bankTransaction_uuid}/reconciliations

Query parameters

  • Filter by a comma separated list of UUIDs.

  • sort string

    Field to sort by. Valid fields are [created_at, updated_at, type, 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 attributes Show response attributes object
    • uuid string

      The UUID of the resource.

    • The timestamp of when the resource was created.

    • The timestamp of when the resource was updated.

    • amount object

      The amount that has been reconciled.

      Additional properties are allowed.

    • The statement transaction the reconciliation has been made against.

      Additional properties are allowed.

    • The bank transaction this reconciliation is for.

      Additional properties are allowed.

    • account object

      The account that created the reconciliation.

      Additional properties are allowed.

GET /api/v1/bank-transaction/{bankTransaction_uuid}/reconciliations
curl \
 -X GET https://api.plannrcrm.com/api/v1/bank-transaction/bankTransaction_uuid/reconciliations \
 -H "Authorization: Bearer {OAUTH_ACCESS_TOKEN or PERSONAL_ACCESS_TOKEN}" \
 -H "Content-Type: application/json" \
 -H "Accept: application/json" \
 -H "X-PLANNR-ACCOUNT-UUID: {YOUR_PLANNR_ACCOUNT_UUID}"
Response examples (200)
{
  "uuid": "dab89e47-278a-4474-a225-745237b2937b",
  "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": {
    "firm": "App\\Http\\Resources\\FirmResource",
    "name": "Gareth Thompson",
    "role": "client",
    "tags": "App\\Http\\Resources\\TagResource",
    "type": "client",
    "uuid": "5e008e3f-e454-4321-bbdd-f35e0a4fc135",
    "email": "gareth@codepotato.co.uk",
    "groups": "App\\Http\\Resources\\GroupResource",
    "owners": "App\\Http\\Resources\\AccountResource",
    "last_name": "Thompson",
    "created_at": "2024-11-20T13:24:04+00:00",
    "first_name": "Gareth",
    "updated_at": "2024-11-20T13:24:04+00:00",
    "with_login": true,
    "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": "2024-11-20T13:24:04+00:00",
    "has_joint_account": true,
    "current_time_entry": "App\\Http\\Resources\\TimeEntryResource",
    "first_contact_date": "2024-11-20T13:24:04+00:00",
    "external_references": "App\\Http\\Resources\\ExternalReferenceResource",
    "assigned_paraplanner": "App\\Http\\Resources\\AccountResource",
    "previous_review_date": "2024-11-20T13:24:04+00:00",
    "primary_phone_number": "App\\Http\\Resources\\ContactDetailResource",
    "assigned_administrator": "App\\Http\\Resources\\AccountResource",
    "anniversary_review_date": "2024-11-20T13:24:04+00:00"
  },
  "created_at": "2024-11-20T13:24:04+00:00",
  "updated_at": "2024-11-20T13:24:04+00:00",
  "bank_transaction": {
    "date": "2022-07-15",
    "firm": "App\\Http\\Resources\\FirmResource",
    "uuid": "b2f042b8-aa31-402d-8384-5380ddbd965f",
    "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": "2024-11-20T13:24:04+00:00",
    "updated_at": "2024-11-20T13:24:04+00:00",
    "bank_statement": "App\\Http\\Resources\\BankStatementResource"
  },
  "statement_transaction": {
    "date": "2024-11-20",
    "firm": "App\\Http\\Resources\\FirmResource",
    "uuid": "32b9d23e-7a15-44f9-89ea-982a0e8cc404",
    "reason": "Reason",
    "account": "App\\Http\\Resources\\AccountResource",
    "category": "initial_fee",
    "metadata": {
      "client_name": "Gareth Thompson"
    },
    "provider": "Aviva",
    "statement": "App\\Http\\Resources\\StatementResource",
    "created_at": "2024-11-20T13:24:04+00:00",
    "net_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"
      }
    },
    "updated_at": "2024-11-20T13:24:04+00:00",
    "client_name": "Gareth Thompson",
    "expectation": "App\\Http\\Resources\\ExpectationResource",
    "scheme_name": "Scheme name",
    "adviser_name": "Adviser name",
    "gross_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"
      }
    },
    "agency_number": "Agency number",
    "policy_number": "AVIVA_00001",
    "scheme_number": "Scheme number",
    "payment_origin": "provider",
    "customer_number": "Customer number",
    "bank_transactions": "App\\Http\\Resources\\BankTransactionResource",
    "product_reference": "Product reference",
    "provider_statement": "App\\Http\\Resources\\ProviderStatementResource",
    "policy_market_value": "Policy market value",
    "sender_id_sib_number": "Sender id sib number",
    "transaction_reference": "sdmrnVFjcw"
  }
}