---
title: "Get consolidated funding"
method: GET
path: "/data/api/v1.0/reporting/ConsolidatedFunding"
tags: ["Report"]
---

# Get consolidated funding

`GET /data/api/v1.0/reporting/ConsolidatedFunding`

Retrieve itemized transactions for a specified timeframe, including batch and funding details for reconciliation.

## Query parameters

- `merchantNumber` unknown
- `startDate` unknown, required
- `endDate` unknown, required
- `sortColumn` unknown
- `sortDirection` unknown
- `transactionBatchId` unknown
- `fundingRequestId` unknown
- `pageNumber` unknown, required
- `pageSize` unknown, required

## Response `200`

Success

- ConsolidatedFundingResponse
  - `pageSettings` PageSettings — Contains pagination details for the response.
    - `pageNumber` unknown
    - `pageSize` unknown
    - `totalPages` unknown
    - `totalRecords` unknown
    - `grandTotal` unknown
  - `content` ConsolidatedFundingContent[] — Contains details of consolidated funding transactions.
    - `MerchantNumber` unknown
    - `ResellerBusinessDBA` unknown
    - `ResellerMerchantNumber` unknown
    - `ParentBusinessDBA` unknown
    - `ParentMerchantNumber` unknown
    - `TaxpayerLegalName` unknown
    - `BusinessDBA` unknown
    - `NextDayFunding` unknown
    - `FundingRequestID` unknown
    - `TotalDepositAmount` unknown
    - `SettlementDate` unknown
    - `ExpectedDepositDate` unknown
    - `BatchReceivedDateTime` unknown
    - `TransactionBatchID` unknown
    - `BatchNumber` unknown
    - `BatchTransactionCount` unknown
    - `BatchAmount` unknown
    - `BatchDepositAmount` unknown
    - `AcquirerReferenceNumber` unknown
    - `ApprovalCode` unknown
    - `AuthorizationAmount` unknown
    - `AuthorizationDateTime` unknown
    - `AuthorizationResponseCode` unknown
    - `AVSResult` unknown
    - `BillingCity` unknown
    - `BillingCompany` unknown
    - `BillingCountry` unknown
    - `BillingName` unknown
    - `BillingPhone` unknown
    - `BillingState` unknown
    - `BillingStreet1` unknown
    - `BillingStreet2` unknown
    - `BillingZip` unknown
    - `CardNumberMasked` unknown
    - `CardProduct` unknown
    - `CardTransactionID` unknown
    - `CardType` unknown
    - `CreditDebitName` unknown
    - `Invoice` unknown
    - `IsCardPresent` unknown
    - `IsCashAdvance` unknown
    - `IsForeignCard` unknown
    - `OrderID` unknown
    - `POSEntryModeName` unknown
    - `PurchaseOrder` unknown
    - `ReferenceNumber` unknown
    - `SalesTaxAmount` unknown
    - `ServiceFee` unknown
    - `SoftwareType` unknown
    - `TipAmount` unknown
    - `TransactionAmount` unknown
    - `TransactionDate` unknown
    - `TransactionType` unknown
    - `BaseAmount` unknown
    - `DDALastFour` unknown
    - `isConveyed` unknown
  - `metadata` Metadata — Contains metadata for the API response.
    - `exchangeId` unknown
    - `timestamp` unknown

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `500` — Internal Server Error

---

[API](https://skmtc.dev/xplorpay/apis/external-us-onboarding-workflow.md) · [All operations](https://skmtc.dev/xplorpay/apis/external-us-onboarding-workflow/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/xplorpay/external-us-onboarding-workflow/revisions/f37077c24b66/schema)