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

# Search Expense Reports

`GET /business/v2/expense-reports`

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.

---

[API](https://skmtc.net/soldo/apis/soldo-business-api-v2-0.md) · [All operations](https://skmtc.net/soldo/apis/soldo-business-api-v2-0/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/soldo/soldo-business-api-v2-0/revisions/7be21448a2b3/schema)