---
title: "Query reconciliations"
method: POST
path: "/v6/banks/reconciliations/query"
tags: ["Bank Reconciliations"]
---

# Query reconciliations

`POST /v6/banks/reconciliations/query`

Query reconciliations for the authenticated user

## Request body

- ReconciliationGetParam
  - `cursor` string, nullable — Cursor from the previous paginated response
  - `limit` integer — Page size, i.e. number of items to return per page
  - `sort` BankClosingsSort — Sort order for the items in the response.
    - `orderBy` 'END_DATE' — Sort column
    - `direction` 'ASC' | 'DESC' — Sort direction. Defaults to DESC
  - `filter` ReconciliationFilterParam — Filter for items in the response.
    - `status` EnumStatusListFilter — Status filter
      - `in` string[]
      - `notIn` string[]
      - `equal` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
      - `notEqual` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
      - `greaterThan` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
      - `greaterThanEqual` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
      - `lessThan` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
      - `lessThanEqual` 'ACTIVE' | 'INACTIVE' | 'REMOVED'
    - `reconciliationStatus` ReconciliationStatusListFilter — Closing status filter
      - `in` string[]
      - `notIn` string[]
      - `equal` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'
      - `notEqual` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'
      - `greaterThan` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'
      - `greaterThanEqual` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'
      - `lessThan` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'
      - `lessThanEqual` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY'

## Response `200`

Success

- PaginatedResponseReconciliationGetDto
  - `result` 'SUCCESS' | 'FAILURE' — The result of the action performed.
  - `data` ReconciliationGetDto[] — The data generated by the action performed.
    - `id` string, required — Id of the bank closing
    - `status` 'ACTIVE' | 'INACTIVE' | 'REMOVED', required — Status of the bank closing
    - `reconciliationStatus` 'IN_PROGRESS' | 'STAGED' | 'COMPLETED' | 'DISCREPANCY', required — Closing status of the bank closing
    - `bankAccount` BankAccountExpanded, required — Bank account of the matching bank transaction
      - `id` string, required — Id of the bank account
      - `name` string — Name of the bank account
      - `displayName` string — Display Name of the bank account
    - `bankStatement` ReconciliationStatementGetDto, nullable, required — Bank statement associated with this closing
      - `id` string, required — Id of the bank statement
      - `url` string, nullable, required — URL to the bank statement document
    - `period` ReconciliationPeriodGetDto, nullable, required — The date period covered by this bank closing
      - `beginDate` string, date, nullable, required — Start date of the closing period
      - `endDate` string, date, nullable, required — End date of the closing period
    - `endBalance` number, nullable, required — Ending balance for the closing period
    - `completedDateTime` string, date-time, nullable, required — Date and time the closing was completed
    - `createdByUser` AuditTrailEditorGetDto, nullable, required — User who completed this bank closing
      - `id` string, required — Id of the editor
      - `userId` string, required — User id of the editor
      - `email` string, nullable, required — Email of the editor
    - `completedByUser` AuditTrailEditorGetDto, nullable, required — User who completed this bank closing
      - `id` string, required — Id of the editor
      - `userId` string, required — User id of the editor
      - `email` string, nullable, required — Email of the editor
    - `customData` JsonNode, nullable — Custom JSON in which you can store any data with max length of 2000 characters
      - `empty` boolean
      - `array` boolean
      - `null` boolean
      - `object` boolean
      - `float` boolean
      - `string` boolean
      - `number` boolean
      - `missingNode` boolean
      - `valueNode` boolean
      - `nodeType` 'ARRAY' | 'BINARY' | 'BOOLEAN' | 'MISSING' | 'NULL' | 'NUMBER' | 'OBJECT' | 'POJO' | 'STRING'
      - `pojo` boolean
      - `integralNumber` boolean
      - `floatingPointNumber` boolean
      - `short` boolean
      - `int` boolean
      - `long` boolean
      - `double` boolean
      - `bigDecimal` boolean
      - `bigInteger` boolean
      - `textual` boolean
      - `boolean` boolean
      - `binary` boolean
      - `container` boolean
      - `embeddedValue` boolean
  - `cursor` ResponseCursor — Cursor to be used in your subsequent paginated request. Only populated if there are more pages available.
    - `after` string — After cursor - Fetches entities after this cursor. Useful for paging forwards.
    - `before` string — Before cursor - Fetches entities before this cursor. Useful for paging backwards.

## Other responses

- `400` — Bad request
- `401` — Not authenticated
- `403` — Not authorized
- `404` — Endpoint not found
- `500` — Internal server error

---

[API](https://skmtc.net/tight/apis/tight-api.md) · [All operations](https://skmtc.net/tight/apis/tight-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/tight/tight-api/revisions/e9f0790a89af/schema)