---
title: "GET /api/v1/expenses/grouped-by-user"
method: GET
path: "/api/v1/expenses/grouped-by-user"
tags: ["Expenses"]
---

# GET /api/v1/expenses/grouped-by-user

`GET /api/v1/expenses/grouped-by-user`

## Query parameters

- `userId` string[]
- `tagsId` string[]
- `confirmedIntegration` boolean
- `initialDate` string, date-time
- `finalDate` string, date-time
- `status` string
- `page` integer
- `pageSize` integer
- `orderBy` 0 | 1
- `desc` boolean

## Headers

- `publicKey` string
- `privateKey` string

## Response `200`

OK

- GetExpenseGroupedByUserResponsePaginatedResponseDto
  - `data` GetExpenseGroupedByUserResponse[], nullable
    - `userId` string, nullable
    - `name` string, nullable
    - `email` string, nullable
    - `documentNumber` string, nullable
    - `expenses` GetExpenseResponseDto[], nullable
      - `id` string, nullable
      - `source` string, nullable
      - `expenseValue` number, double, nullable
      - `originalValue` number, double, nullable
      - `expenseDate` string, date-time, nullable
      - `currency` string, nullable
      - `paymentType` ExpenseLabelAndNameResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
      - `expenseImage` string, nullable
      - `observations` string, nullable
      - `refundValue` number, double, nullable
      - `refundType` ExpenseLabelAndNameResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
      - `expenseType` ExpenseTypeResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `typeAccountingAccount` TypeAccountingAccountResponseDto
          - `code` string, nullable
          - `name` string, nullable
      - `expenseStatus` ExpenseStatusResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
        - `comment` string, nullable
        - `user` ExpenseUserResponseDto
          - `userId` string, nullable
          - `name` string, nullable
          - `email` string, nullable
          - `documentNumber` string, nullable
          - `registration` string, nullable
        - `registerDate` string, date-time, nullable
        - `updatedDate` string, date-time, nullable
        - `disapprovalReason` ExpenseRejectionTypeResponseDto
          - `reasonId` string, nullable
          - `name` string, nullable
        - `automaticUpdate` boolean
        - `automaticUpdater` 0 | 1
        - `approver` ExpenseApproverResponseDto
          - `userId` string, nullable
          - `userName` string, nullable
          - `companyApprovalGroupId` string, nullable
          - `companyApprovalGroupName` string, nullable
      - `refundStatus` ExpenseRefundStatusResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
        - `registerDate` string, date-time, nullable
        - `updatedDate` string, date-time, nullable
      - `currencyConversionTax` number, double, nullable
      - `expenseStoreName` string, nullable
      - `user` ExpenseUserResponseDto
        - `userId` string, nullable
        - `name` string, nullable
        - `email` string, nullable
        - `documentNumber` string, nullable
        - `registration` string, nullable
      - `mobility` ExpenseMobilityResponseDto
        - `code` string, nullable
        - `eventType` string, nullable
        - `data` ExpenseMobilityDataResponseDto
          - `rideId` integer
          - `status` string, nullable
          - `category` string, nullable
          - `taxiLocation` ExpenseMobilityLocationResponseDto
            - `latitude` number, double, nullable
            - `longitude` number, double, nullable
          - `originLocation` ExpenseMobilityLocationResponseDto
            - `latitude` number, double, nullable
            - `longitude` number, double, nullable
          - `originAddress` ExpenseMobilityAddressResponseDto
            - `coordinates` ExpenseMobilityLocationResponseDto
              - …
            - `input` string, nullable
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `landmark` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
          - `timeToOriginSec` integer, nullable
          - `timeToOrigin` string, nullable
          - `distanceToOriginKm` number, double, nullable
          - `destinyLocation` ExpenseMobilityLocationResponseDto
            - `latitude` number, double, nullable
            - `longitude` number, double, nullable
          - `destinationAddress` ExpenseMobilityAddressResponseDto
            - `coordinates` ExpenseMobilityLocationResponseDto
              - …
            - `input` string, nullable
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `landmark` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
          - `timeToDestinySec` integer, nullable
          - `timeToDestiny` string, nullable
          - `distanceToDestinyKm` number, double, nullable
          - `rideValue` number, double, nullable
          - `externalId` string, nullable
          - `driver` ExpenseMobilityDriverResponseDto
            - `driverId` integer, nullable
            - `name` string, nullable
            - `rating` number, double, nullable
            - `ddd` string, nullable
            - `phone` string, nullable
          - `finishDetails` ExpenseMobilityFinishDetailsResponseDto
            - `coordinate` ExpenseMobilityLocationResponseDto
              - …
            - `address` ExpenseMobilityAddressResponseDto
              - …
            - `distance` number, double, nullable
            - `journey` string, nullable
            - `staticMap` string, nullable
            - `date` string, date-time, nullable
          - `requestDate` string, date-time, nullable
          - `startDate` string, date-time, nullable
      - `tags` ExpenseLabelAndNameResponseDto[], nullable
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
      - `costCenter` ExpenseCostCenterResponseDto
        - `name` string, nullable
        - `code` string, nullable
      - `statusUpdates` ExpenseStatusHistoryResponseDto[], nullable
        - `name` string, nullable
        - `label` string, nullable
        - `comment` string, nullable
        - `registerDate` string, date-time, nullable
        - `user` ExpenseUserResponseDto
          - `userId` string, nullable
          - `name` string, nullable
          - `email` string, nullable
          - `documentNumber` string, nullable
          - `registration` string, nullable
        - `disapprovalReason` ExpenseRejectionTypeResponseDto
          - `reasonId` string, nullable
          - `name` string, nullable
        - `automaticUpdate` boolean, nullable
        - `automaticUpdater` 0 | 1
        - `approver` ExpenseApproverResponseDto
          - `userId` string, nullable
          - `userName` string, nullable
          - `companyApprovalGroupId` string, nullable
          - `companyApprovalGroupName` string, nullable
        - `workflowId` string, nullable
        - `workflowName` string, nullable
      - `intermediateGuid` string, uuid, nullable
      - `manualKmExpense` ExpenseKmSimulationResponseDto
        - `distance` number, double, nullable
        - `value` number, double, nullable
        - `duration` number, double, nullable
        - `routes` ExpenseKmSimulationRouteResponseDto[], nullable
          - `start` string, date-time, nullable
          - `end` string, date-time, nullable
          - `distance` number, double, nullable
          - `duration` number, double, nullable
          - `value` number, double, nullable
          - `arrivalLocation` ExpenseKmSimulationAddressResponseDto
            - `point` ExpenseMobilityLocationResponseDto
              - …
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `neighborhood` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
            - `label` string, nullable
            - `title` string, nullable
          - `departureLocation` ExpenseKmSimulationAddressResponseDto
            - `point` ExpenseMobilityLocationResponseDto
              - …
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `neighborhood` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
            - `label` string, nullable
            - `title` string, nullable
          - `staticMap` string, nullable
      - `refundPaymentDetails` ExpenseLabelAndNameResponseDto
        - `label` string, nullable
        - `name` string, nullable
        - `urlIcon` string, nullable
        - `color` string, nullable
      - `automaticKmExpense` ExpenseKmSimulationResponseDto
        - `distance` number, double, nullable
        - `value` number, double, nullable
        - `duration` number, double, nullable
        - `routes` ExpenseKmSimulationRouteResponseDto[], nullable
          - `start` string, date-time, nullable
          - `end` string, date-time, nullable
          - `distance` number, double, nullable
          - `duration` number, double, nullable
          - `value` number, double, nullable
          - `arrivalLocation` ExpenseKmSimulationAddressResponseDto
            - `point` ExpenseMobilityLocationResponseDto
              - …
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `neighborhood` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
            - `label` string, nullable
            - `title` string, nullable
          - `departureLocation` ExpenseKmSimulationAddressResponseDto
            - `point` ExpenseMobilityLocationResponseDto
              - …
            - `country` string, nullable
            - `state` string, nullable
            - `city` string, nullable
            - `neighborhood` string, nullable
            - `street` string, nullable
            - `streetNumber` string, nullable
            - `postalCode` string, nullable
            - `label` string, nullable
            - `title` string, nullable
          - `staticMap` string, nullable
      - `externalTransactionId` integer, nullable
      - `cardTransaction` ExpenseCardTransactionResponseDto
        - `transactionKey` string, nullable
        - `transactionTypeId` string, nullable
        - `transactionId` string, nullable
        - `eventId` string, nullable
        - `authorizationCode` string, nullable
        - `cardNumber` string, nullable
      - `vehicleCategory` ExpenseVehicleCategoryResponseDto
        - `description` string, nullable
        - `value` number, double
      - `qrCodeId` string, nullable
      - `expenseItems` ExpenseItemResponseDto[], nullable
        - `name` string, nullable
        - `code` string, nullable
        - `description` string, nullable
        - `unit` string, nullable
        - `unitValue` number, double, nullable
        - `quantity` number, double, nullable
        - `value` number, double, nullable
      - `destiny` ExpenseMobilityLocationResponseDto
        - `latitude` number, double, nullable
        - `longitude` number, double, nullable
      - `distance` number, double, nullable
      - `isDuplicated` boolean
      - `duplicatedExpenses` ExpenseDuplicatedResponseDto[], nullable
        - `expenseId` string, nullable
        - `storeName` string, nullable
        - `expenseValue` number, double, nullable
        - `userName` string, nullable
        - `paymentType` string, nullable
      - `attachments` string[], nullable
      - `isRefunded` boolean
      - `canEdit` boolean
      - `workflowUsing` boolean
      - `finalStatusDate` string, date-time, nullable
      - `companyBranchCnpj` string, nullable
      - `companyUnit` ExpenseCompanyUnitDto
        - `name` string, nullable
        - `code` string, nullable
  - `metadata` PaginationMetadata
    - `pageNumber` integer
    - `pageSize` integer
    - `totalCount` integer
    - `totalPages` integer
    - `hasPreviousPage` boolean
    - `hasNextPage` boolean

## Other responses

- `400` — Bad Request
- `401` — Unauthorized

---

[API](https://skmtc.dev/stuo/apis/external-api.md) · [All operations](https://skmtc.dev/stuo/apis/external-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/stuo/external-api/revisions/55217bb301d0/schema)