Settlement Object – Pine Labs API

List all Settlements

Shown below is a sample response returned through our List all Settlements API.

{
  "data": [
    {
      "total_amount": 0.96,
      "actual_transaction_amount": 2,
      "total_deduction_amount": 0.08,
      "total_transactions_count": 2,
      "last_processed_date": "2024-10-09T07:00:00",
      "settled_date": "2024-10-09T10:59:46",
      "utr_number": "410092786849",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 0.98,
      "actual_transaction_amount": 1,
      "total_deduction_amount": 0.04,
      "total_transactions_count": 1,
      "last_processed_date": "2024-10-08T07:00:00",
      "settled_date": "2024-10-08T11:16:40",
      "utr_number": "410080488411",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 0.96,
      "actual_transaction_amount": 2,
      "total_deduction_amount": 0.08,
      "total_transactions_count": 2,
      "last_processed_date": "2024-10-07T07:00:00",
      "settled_date": "2024-10-07T11:36:44",
      "utr_number": "410077587729",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 3.92,
      "actual_transaction_amount": 4,
      "total_deduction_amount": 0.16,
      "total_transactions_count": 4,
      "last_processed_date": "2024-10-06T07:00:00",
      "settled_date": "2024-10-07T10:48:02",
      "utr_number": "410077424703",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 0.98,
      "actual_transaction_amount": 1,
      "total_deduction_amount": 0.04,
      "total_transactions_count": 1,
      "last_processed_date": "2024-10-05T07:00:00",
      "settled_date": "2024-10-05T10:58:12",
      "utr_number": "410055402704",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 1.94,
      "actual_transaction_amount": 3,
      "total_deduction_amount": 0.12,
      "total_transactions_count": 3,
      "last_processed_date": "2024-10-04T06:32:13",
      "settled_date": "2024-10-04T11:14:39",
      "utr_number": "410041942381",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    },
    {
      "total_amount": 0.98,
      "actual_transaction_amount": 1,
      "total_deduction_amount": 0.04,
      "total_transactions_count": 1,
      "last_processed_date": "2024-10-03T06:35:20",
      "settled_date": "2024-10-03T10:58:43",
      "utr_number": "410039900271",
      "programs": [
        "UPI"
      ],
      "system": "PG",
      "bank_name": "HDFC Bank Ltd",
      "bank_acc_number": "04992990009595"
    }
  ],
  "total_settlement_count": 7,
  "total_transactions_count": 14,
  "total_settlement_amount": 10.72
}

The table below lists the various parameters returned in the Settlements response object.

Parameter	Type	Description
data	`array of objects`	An array of objects that contains the settlement objects.
total_settlement_count	`integer`	The total number of settlement. Example: `7`
total_transactions_count	`integer`	The total number of transactions. Example: `14`
total_settlement_amount	`integer`	The total settlement amount. Example: `15`

Data [Child Object]

The table below lists the various parameters in the data child object. This is part of the settlement response object.

Parameter	Type	Description
total_amount	`integer`	Total settlement amount. Example: `0.98`
actual_transaction_amount	`integer`	The total transaction amount without deductions. Example: `1`
total_deduction_amount	`integer`	Total deduction amount for a transaction. Example: `0.04`
total_transactions_count	`integer`	The total number of transactions settled within a specific UTR [Unique Transaction Reference]. Example: `1`
last_processed_date	`string`	The date when the transaction was last processed and selected for settlement. Example: `2024-10-05T07:00:00`
settled_date	`string`	The date on which a batch of transactions was settled.. Example: `2024-10-03T10:58:43`
utr_number	`string`	Unique transaction reference [UTR] generated for the settlement. Example: `410039900271`
programs	`array of objects`	An array of objects that contains all the program details.
system	`string`	A constant string value. Has to be 2 digits. Example: `PG`
bank_name	`string`	Settlement bank name. Minimum length: 1 characters Maximum length: 50 characters. Example: `HDFC Bank Ltd`
bank_acc_number	`string`	Settlement bank account number. Minimum length: 1 characters Maximum length: 50 characters. Example: `04992990009595`

List Settlements by UTR

Shown below is a sample response returned through our list settlements by UTR API.

{
    "utr_number": "410092786849",
    "bank_name": "HDFC Bank Ltd",
    "bank_acc_number": "04992990009595",
    "programs": [
        "UPI"
    ],
    "total_transaction_count": 2,
    "total_transaction_amount": 2,
    "actual_transaction_amount": 2,
    "total_refund": 0,
    "total_chargeback_recovery_amount": 0,
    "total_loan_recovery_amount": 0,
    "total_mdr_amount": 0.04,
    "total_gst_amount": 0,
    "total_late_settlement_fee": 0,
    "total_settled_amount": 0.96,
    "total_mar_amount": 0,
    "split_fund_amount": 0,
    "total_platform_fee": 0,
    "other_deductions": 0,
    "additional_mdr_amount": 0,
    "total_convenience_fee": 0,
    "total_gst_on_c_c_f": 0,
    "total_cashback_amount": 0,
    "total_merchant_cashback": 0,
    "total_merchant_convenience_fee": 0,
    "transactions": [
        {
            "transaction_id": "v1-241008182747-aa-8JwMy9-up-k",
            "system": "PG",
            "processed_date": "2024-10-09T07:00:00",
            "transaction_date": "2024-10-08T00:00:00",
            "transaction_amount": 1,
            "actual_transaction_amount": 1,
            "total_deduction_amount": 0.02,
            "settled_amount": 0,
            "store_address": "sec 62 noida",
            "acquirer_name": "UPI_HDFC",
            "tid": "HDFC000028502654",
            "is_emi": false,
            "utr_number": "410092786849",
            "program": "UPI",
            "payout_status": "Success"
        },
        {
            "transaction_id": "v1-241008182412-aa-rnfH9Q-up-F",
            "system": "PG",
            "processed_date": "2024-10-09T07:00:00",
            "transaction_date": "2024-10-08T00:00:00",
            "transaction_amount": 1,
            "actual_transaction_amount": 1,
            "total_deduction_amount": 0.02,
            "settled_amount": 0.96,
            "store_address": "sec 62 noida",
            "acquirer_name": "UPI_HDFC",
            "tid": "HDFC000028502654",
            "is_emi": false,
            "utr_number": "410092786849",
            "program": "UPI",
            "payout_status": "Success"
        }
    ],
    "pagination": {
        "total_pages": 2,
        "current_page": "1"
    }
}

The table below lists the various parameters returned in the Settlements response object.

Parameter	Type	Description
utr_number	`string`	Unique Transaction Reference [UTR] provided by the Bank. Minimum length: `16` characters. Maximum length: `50` characters. Example: `410092786849`
bank_name	`string`	Settlement bank name. Example: `HDFC Bank Ltd`
bank_acc_number	`string`	Settlement bank account number. Example: `04992990009595`
programs	`array of object`	An array of objects that contains all the program details.
total_transaction_count	`integer`	The total number of transactions settled within a specific UTR [Unique Transaction Reference]. Example: `1`
total_transaction_amount	`integer`	The total transaction amount settled after deductions within a specific UTR [Unique Transaction Reference]. Example: `2`
actual_transaction_amount	`integer`	The total transaction amount without deductions. Example: `1`
total_refund	`integer`	Total refund amount deducted within a UTR. Example: `0`
total_chargeback_recovery_amount	`integer`	The total chargeback recovery amount in given UTR. Example: `0`
total_loan_recovery_amount	`integer`	The total amount recovered from loan in given UTR. Example: `0`
total_mdr_amount	`integer`	The total MDR [Merchant Discount Rate] amount deducted in given UTR. Example: `0.04`
total_gst_amount	`integer`	The total GST amount charged within a given UTR. Example: `0`
total_late_settlement_fee	`integer`	The total fee charged for late settlement in the given UTR. Example: `0`
total_settled_amount	`integer`	The total amount settled within a given UTR. Example: `0.96`
total_mar_amount	`integer`	The total Merchant Acquisition Rate [MAR] charged. Example: `0`
split_fund_amount	`integer`	The split amount of the transaction. Example: `0`
total_platform_fee	`integer`	The total fee charged by the platform. Example: `0`
other_deductions	`integer`	Other deductions of the transaction. Example: `0`
additional_mdr_amount	`integer`	Additional MDR [Merchant Discount Rate] deducted. Example: `0`
total_convenience_fee	`integer`	The total convenience fee charged. Example: `0`
total_gst_on_c_c_f	`integer`	GST charged on convenience fees. Example: `0`
total_cashback_amount	`integer`	The total cashback amount provided. Example: `0`
total_merchant_cashback	`integer`	The total cashback amount provided. Example: `0`
total_merchant_convenience_fee	`integer`	The total convenience fee charged. Example: `0`
transactions	`array of objects`	An array of objects that contains the transaction details.
pagination	`object`	An object that contains the pagination details.

Transactions [Child Object]

The table below lists the various parameters in the transactions child object. This is part of the settlements by UTR response object.

Parameter	Type	Description
transaction_id	`string`	Unique identifier for a transaction in Pine Labs Online database. Example: `v1-241008182747-aa-8JwMy9-up-k`
system	`string`	A constant string value. Has to be 2 digits. Example: `PG`
processed_date	`string`	The date when the transaction was processed. Example: `2024-10-09T07:00:00`
transaction_date	`string`	The date of the transaction. Example: `2024-10-08T00:00:00`
transaction_amount	`integer`	The transaction amount. Example: `1`
actual_transaction_amount	`integer`	The total transaction amount without deductions. Example: `1`
total_deduction_amount	`integer`	Total deduction amount for a transaction. Example: `0.02`
settled_amount	`integer`	The total settlement amount of the transaction. Example: `0`
store_address	`string`	The address of the store where the transaction was created. Example: `sec 62 noida` Note: Applicable only in case of pos transactions.
acquirer_name	`string`	The name of the acquirer. Example: `UPI_HDFC`
tid	`string`	The Terminal ID for the transaction. Example: `HDFC000028502654`
is_emi	`boolean`	This Indicates if the transaction was an EMI [Equated Monthly Installment]. Example: `false`
utr_number	`string`	Unique Transaction Reference [UTR] provided by the Bank. Minimum length: `16` characters. Maximum length: `50` characters. Example: `410092786849`
program	`string`	The payment method used for the transaction. Example: `UPI`
payout_status	`string`	The status of the payout. Example: `Success`

Pagination [Child Object]

The table below lists the various parameters in the pagination child object. This is part of the settlements by UTR response object.

Parameter Type Description

total_pages

Parameter	Type	Description
total_pages	`integer`	The total number of pages. Example: `2`
current_page	`string`	Current page. Example: `1`

integer

The total number of pages.

Example: 2

current_page

string

Current page.

Example: 1