---
title: "Search Expense Reports"
method: GET
path: "/business/v2/expense-reports"
tags: ["Expense Reports"]
---

# Search Expense Reports

`GET /business/v2/expense-reports`

## Request

- Base URL: `https://api.soldo.com`
- URL: `https://api.soldo.com/business/v2/expense-reports`
- Auth: OAuth 2
  - Client credentials
  - Token URL: `https://api.soldo.com/oauth/authorize` scopes: `expense_report_read`
- TypeScript: <https://skmtc.dev/soldo/apis/soldo-business-api-v2-0/docs/business/v2/expense-reports/get.ts> (a function with typed inputs; its response is checked against the schema)

Endpoint to search `ExpenseReport` using filtering parameters.

## Query parameters

- `number` string: The `ExpenseReport` number.
- `trxOwnerId` string: The ID of the `User` who made the expenses included in the `ExpenseReport`.
- `trxDateFrom` string, date-time
- `trxDateTo` string, date-time
- `status` ExpenseReportStatus[]: The `ExpenseReport` status.
- `type` ExpenseReportType[]: The `ExpenseReport` type.
- `toReimburse` boolean: It determines whether only reports with or without an amount to be reimbursed should be returned.
- `exportedDate` string, date-time
- `p` integer: It indicates the specific page to display (the counter starts from zero).
- `s` integer: It indicates the number of items per page.
- `d` 'ASC' | 'DESC': It indicates how the pages are ordered.
- `props` string[]: It indicates the sorting direction applied to the above parameters. To apply a sorting on multiple parameters, set as many times the `props` parameter in the request.

## Response `200`

The result is an array containing `ExpenseReport`.

- ExpenseReports
  - `total` integer: It represents the total number of available items in the list.
  - `pages` integer: It represents the total number of available pages.
  - `page_size` integer: It represents the number of items per page.
  - `current_page` integer: It indicates the current page (the counter starts from zero).
  - `results_size` integer: It indicates the size of the array results.
  - `results` ExpenseReport[]
    - `reimburse_amount` number: The amount to be reimbursed to the user.
    - `deduct_amount` number: The amount to be deducted from the user.
    - `process_amount` number: The amount to be processed.
    - `file_url` string: The Base64 string of the File URL encrypted by DES in ECB mode, Pkcs7 padding scheme and using Token for key.
    - `id` string: The `ExpenseReport` ID .
    - `protocol` string: The `ExpenseReport` ID protocol.
    - `number` string: The `ExpenseReport` number.
    - `type` 'EMPLOYEE' | 'COMPANY'
    - `status` 'PROCESSED' | 'CANCELLED' | 'DELETED' | 'TO_BE_PROCESSED'
    - `exported_date` string: The date when the `ExpenseReport` got exported.
    - `exported_by` string: The ID of the user who exported the `ExpenseReport`.
    - `trx_owner_id` string: The ID of the user who made the expenses included in the `ExpenseReport`.
    - `trx_date_from` string: The date of the oldest expense included in the `ExpenseReport`.
    - `trx_date_to` string: The date of the most recent expense included in the `ExpenseReport`.
    - `processed_date` string: The date when the expense report got processed.
    - `processed_by` string: The ID of the user who processed the `ExpenseReport`.
    - `reimbursement_transaction_id` string: The ID of the transaction of the `ExpenseReport`.

## Other responses

- `400`: Your request has missing arguments or is malformed.

## Changes

- **2026-08-06** `7be21448a2b3`: 3 info
  - for the `query` request parameter `exportedDate`, the type was generalized from no type to `string`, and format from no format to `date-time`
  - for the `query` request parameter `trxDateFrom`, the type was generalized from no type to `string`, and format from no format to `date-time`
  - for the `query` request parameter `trxDateTo`, the type was generalized from no type to `string`, and format from no format to `date-time`

[Operation history](https://skmtc.dev/soldo/apis/soldo-business-api-v2-0/changes/business/v2/expense-reports/get.md)

---

[API](https://skmtc.dev/soldo/apis/soldo-business-api-v2-0.md) - [All operations](https://skmtc.dev/soldo/apis/soldo-business-api-v2-0/llms.txt) - [OpenAPI document](https://skmtc.dev/soldo/apis/soldo-business-api-v2-0/revisions/23fc5d07b367?raw)