# Get a settlement report by ID

**GET** `/reporting/{settlement_report_id}`

Get a settlement report by its ID. Please refer to our [Reporting Guides](/guides/reporting) for more details.

### Path Parameters

- `settlement_report_id` `string` _(required)_ — Unique identifier for the settlement report.

**Request**

```shell
curl 'https://api.column.com/reporting/<settlement_report_id>' \
  -u :<YOUR API KEY>
```

**Response 200**

```json
{
  "id": "srpt_27kkUzwpYqt78g3L1DWU7cBRjyL",
  "created_at": "2022-04-13T17:38:11Z",
  "updated_at": "2022-04-13T17:38:11Z",
  "type": "bank_account_transaction",
  "status": "completed",
  "time_zone": "America/Los_Angeles",
  "from_date": "2022-03-02",
  "to_date": "2022-03-02",
  "initiated_at": "2022-04-13T17:10:15Z",
  "completed_at": "2022-04-13T17:11:15Z",
  "row_count": 666,
  "columns": [
    "effective_at",
    "effective_at_utc",
    "bank_account_id",
    "bank_account_type",
    "account_number_id",
    "entity_id",
    "entity_name",
    "entity_type",
    "transaction_id",
    "transaction_type",
    "currency",
    "available_amount",
    "available_balance",
    "pending_amount",
    "pending_balance",
    "locked_amount",
    "locked_balance",
    "holding_amount",
    "holding_balance"
  ],
  "csv_document_id": "docu_27kh6IxwJjShHV314ig7ioPEwSf",
  "json_document_id": "docu_27kh6KhcfYDkPthUdoMSCHD3tv9",
  "parquet_document_id": "docu_27kh6LSgYvc1gdcLlpQnAOGzPl6"
}
```