---
title: Settlement History API
slug: nicepay-api-laporan-bisnis-settlement-history-api
description: Informasi tentang Settlement History dari API Laporan Bisnis yang terdapat pada sistem NICEPAY
image: https://archbee-image-uploads.s3.amazonaws.com/ZHvSjR5ZrsoxwKbJa3xmo/zLrN-wVCZF12WE4h_NLm7_nicepay-docs-logo.png
icon: {"faIcon":"fa-solid fa-circle-arrow-up"}
docTags: 
createdAt: 2024-07-01T06:14:38.512Z
---

# Tentang Settlement History API

***

Settlement History API dapat digunakan untuk rekonsiliasi laporan dana Settlement dengan NICEPAY. Dengan API ini, Merchant akan mendapatkan daftar data Settlement hingga 5.000 data per *request* sesuai dari tanggal yang diminta.

:::Iframe{iframeHeight="0" code="Merchant harus menghubungi <a style=&#x22;color:blue;text-decoration-line:underline&#x22; href=&#x22;mailto:cs@nicepay.co.id&#x22;>NICEPAY Customer Service</a> dengan mengirimkan IP Merchant untuk proses Whitelist pada NICEPAY terlebih dahulu dan melakukan pengajuan kredensial API untuk menggunakan Settlement History API."}

:::



# Settlement History API

***

| **API End Point**                                                     | [`https://bo.nicepay.co.id/settlmntdt.do`](https://bo.nicepay.co.id/settlmntdt.do) |
| --------------------------------------------------------------------- | ---------------------------------------------------------------------------------- |
| **Request Method&#x20;**<font color="#2166ae">application/json</font> | ****<font color="#3b9f0f">**POST**</font>                                          |
| **Description**                                                       | To check Settlement History with NICEPAY via API                                   |
| **Header**                                                            | `Content-Type: application/json`                                                   |
| **Request Format**                                                    | `application/json`                                                                 |

:::hint{type="info"}
Nilai transaksi dan nilai dana Settlement yang tersedia dalam laporan ini menggunakan mata uang Rupiah.
:::

## Request Parameter

| **Parameter**                                           | **Tipe** | **Ukuran** | **Deskripsi**                                                                                                                                                        | **Contoh / Catatan**  |
| ------------------------------------------------------- | -------- | ---------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- |
| `mid`<br /><font color="#2166ae">Required</font>        | VARCHAR2 | 10         | iMid Merchant                                                                                                                                                        | IONPAYTEST            |
| `passwd`<br /><font color="#2166ae">Required</font>     | VARCHAR2 | 100        | *Password* setelah proses Whitelist IP telah berhasil di-*register* di sisi NICEPAY <br />(Mohon untuk menghubungi **tim NICEPAY Customer Service** untuk asistensi) | 123456                |
| `settlmntdt`<br /><font color="#2166ae">Required</font> | VARCHAR2 | 8          | Tanggal data transaksi yang mau dilihat<br />Format: `YYYYMMDD`                                                                                                      | 20200113              |
| `startno`<br /><font color="#2166ae">Required</font>    | NUMBER   | 10         | Awal dari data transaksi yang akan mau dilihat                                                                                                                       | 1<br />Default: 1     |
| `endno`<br /><font color="#2166ae">Required</font>      | NUMBER   | 10         | Akhir dari data transaksi yang mau dilihat <br />Maksimal 5000                                                                                                       | 100<br />Default: 100 |

## Response Parameter

| **Parameter**                                             | **Tipe** | **Ukuran** | **Deskripsi**                                                                                     | **Contoh / Catatan**           |
| --------------------------------------------------------- | -------- | ---------- | ------------------------------------------------------------------------------------------------- | ------------------------------ |
| `HEADER`<br /><font color="#2166ae">Required</font>       | Object   | -          | -                                                                                                 | `"HEADER": { ... } `           |
| `CODE`<br /><font color="#2166ae">Required</font>         | NUMBER   | 4          | Code Response                                                                                     | 00                             |
| `MID`<br /><font color="#2166ae">Required</font>          | VARCHAR2 | 10         | iMid Merchant                                                                                     | IONPAYTEST                     |
| `SETTLMNT_DT`<br /><font color="#2166ae">Required</font>  | VARCHAR2 | 8          | Tanggal data Settlement yang di-*request*<br />Format: `YYYYMMDD`                                 | 20200113                       |
| `DATA`<br /><font color="#2166ae">Required</font>         | Object   | -          | -                                                                                                 | `"DATA": [  { ... } ] `        |
| `CODE`<br /><font color="#2166ae">Required</font>         | NUMBER   | 2          | Code Response                                                                                     | 10                             |
| `TXID`<br /><font color="#2166ae">Required</font>         | VARCHAR2 | 30         | ID Transaksi                                                                                      | IONPAYTEST02202001100933358310 |
| `SETTLMNT_DT`<br /><font color="#2166ae">Required</font>  | VARCHAR2 | 8          | Tanggal data Settlement yang di-*request*<br />Format: `YYYYMMDD`                                 | 20200113                       |
| `TRANS_STATUS`<br /><font color="#2166ae">Required</font> | NUMBER   | 2          | Status Transaksi: [Transaction Status Code](docId\:CrGE1s9poBnuAdENJUkb8)                         | 0                              |
| `PAY_METHOD`<br /><font color="#2166ae">Required</font>   | VARCHAR2 | 2          | Payment Method                                                                                    | 02                             |
| `TRANS_DT`<br /><font color="#2166ae">Required</font>     | VARCHAR2 | 8          | Tanggal data transaksi yang di-*request*<br />Format: `YYYYMMDD`                                  | 20200110                       |
| `TRANS_AMT`<br /><font color="#2166ae">Required</font>    | NUMBER   | 19,2       | Amount Transaksi                                                                                  | 1000                           |
| `SETTLMNT_AMT`<br /><font color="#2166ae">Required</font> | NUMBER   | 19,2       | Amount Settlement                                                                                 | 800                            |
| `FDS_FEE`<br /><font color="#2166ae">Required</font>      | NUMBER   | 19,2       | Biaya FDS (hanya dikenakan untuk metode Kartu Kredit)                                             | 0                              |
| `NICEPAY_FEE`<br /><font color="#2166ae">Required</font>  | NUMBER   | 19,2       | Biaya service NICEPAY yang dikenakan pada setiap transaksi yang berhasil terbayar                 | 545                            |
| `BANK_FEE`<br /><font color="#2166ae">Required</font>     | NUMBER   | 19,2       | Biaya Bank atau Mitra (akan dikenakan untuk tipe Settlement Fasilitator)                          | 0                              |
| `VAT`<br /><font color="#2166ae">Required</font>          | NUMBER   | 19,2       | Biaya PPN atau VAT (Value Added Tax)                                                              | 55                             |
| `ORDER_NO`<br /><font color="#2166ae">Required</font>     | NUMBER   | 10         | Nomor Referensi Merchant                                                                          | OrdNo20200933270               |
| `BANK_CD`<br /><font color="#2166ae">Required</font>      | VARCHAR2 | 4          | Code Bank atau Mitra                                                                              | BMRI                           |
| `CUSTOMER_NO`<br /><font color="#2166ae">Required</font>  | VARCHAR2 | 40         | Customer Account Transaction Number                                                               | 79150000090933358310           |
| `TAIL`<br /><font color="#2166ae">Required</font>         | Object   | -          | -                                                                                                 | `"TAIL": { ... }`              |
| `CODE`<br /><font color="#2166ae">Required</font>         | NUMBER   | 4          | Code Response                                                                                     | 99                             |
| `MID`<br /><font color="#2166ae">Required</font>          | VARCHAR2 | 10         | iMid Merchant                                                                                     | IONPAYTEST                     |
| `SETTLMNT_DT`<br /><font color="#2166ae">Required</font>  | VARCHAR2 | 8          | Tanggal data Settlement yang di-*request*<br />Format: `YYYYMMDD`                                 | 20200113                       |
| `APP_CNT`<br /><font color="#2166ae">Required</font>      | NUMBER   | 10         | Jumlah total volume transaksi                                                                     | 5                              |
| `APP_AMT`<br /><font color="#2166ae">Required</font>      | NUMBER   | 19,2       | Jumlah total amount transaksi                                                                     | 14000                          |
| `CC_CNT`<br /><font color="#2166ae">Required</font>       | NUMBER   | 10         | Jumlah total volume transaksi refund                                                              | 0                              |
| `CC_AMT`<br /><font color="#2166ae">Required</font>       | NUMBER   | 19,2       | Jumlah total amount transaksi refund                                                              | 0                              |
| `NICEPAY_FEE`<br /><font color="#2166ae">Required</font>  | NUMBER   | 19,2       | Jumlah total biaya service NICEPAY yang dikenakan pada setiap transaksi yang berhasil terbayar    | 2725                           |
| `BANK_FEE`<br /><font color="#2166ae">Required</font>     | NUMBER   | 19,2       | Jumlah total biaya Bank atau Mitra (akan dikenakan hanya untuk tipe Settlement Fasilitator)       | 0                              |
| `VAT`<br /><font color="#2166ae">Required</font>          | NUMBER   | 19,2       | Jumlah total biaya PPN atau VAT (Value Added Tax)                                                 | 275                            |
| `SETTLMNT_AMT`<br /><font color="#2166ae">Required</font> | NUMBER   | 19,2       | Jumlah total amount  Settlement                                                                   | 11000                          |

## Sample Parameter

:::CodeblockTabs
Request

```json
{
    "mid":"IONPAYTEST",
    "passwd":"123456",
    "settlmntdt":"20200113",
    "startno":"1",
    "endno":"5000"
}
```

Response

```json
{
  "HEADER": {
    "CODE": "00",
    "MID": "IONPAYTEST",
    "SETTLMNT_DT": "20200113"
  },
  "DATA": [
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001100933358310",
      "SETTLMNT_DT": "20200113",
      "TRANS_STATUS": "0",
      "PAY_METHOD": "02",
      "TRANS_DT": "20200110",
      "TRANS_AMT": 1000,
      "SETTLMNT_AMT": 400,
      "FDS_FEE": 0,
      "NICEPAY_FEE": 545,
      "BANK_FEE": 0,
      "VAT": 55,
      "ORDER_NO": "OrdNo20200933270",
      "BANK_CD": "BDIN",
      "CUSTOMER_NO": "79150000090933358310"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001100941229936",
      "SETTLMNT_DT": "20200113",
      "TRANS_STATUS": "0",
      "PAY_METHOD": "02",
      "TRANS_DT": "20200110",
      "TRANS_AMT": 1000,
      "SETTLMNT_AMT": 400,
      "FDS_FEE": 0,
      "NICEPAY_FEE": 545,
      "BANK_FEE": 0,
      "VAT": 55,
      "ORDER_NO": "OrdNo2020094119264",
      "BANK_CD": "BMRI",
      "CUSTOMER_NO": "70014000090941229936"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001102359040783",
      "SETTLMNT_DT": "20200113",
      "TRANS_STATUS": "0",
      "PAY_METHOD": "02",
      "TRANS_DT": "20200111",
      "TRANS_AMT": 10000,
      "SETTLMNT_AMT": 9400,
      "FDS_FEE": 0,
      "NICEPAY_FEE": 545,
      "BANK_FEE": 0,
      "VAT": 55,
      "ORDER_NO": "OrdNo20200235841270",
      "BANK_CD": "CENA",
      "CUSTOMER_NO": "44779000092359040783"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001110258241837",
      "SETTLMNT_DT": "20200113",
      "TRANS_STATUS": "0",
      "PAY_METHOD": "02",
      "TRANS_DT": "20200111",
      "TRANS_AMT": 1000,
      "SETTLMNT_AMT": 400,
      "FDS_FEE": 0,
      "NICEPAY_FEE": 545,
      "BANK_FEE": 0,
      "VAT": 55,
      "ORDER_NO": "OrdNo2020025819224",
      "BANK_CD": "BRIN",
      "CUSTOMER_NO": "88788000090258241837"
    },
    {
      "CODE": "10",
      "TXID": "IONPAYTEST02202001110323543251",
      "SETTLMNT_DT": "20200113",
      "TRANS_STATUS": "0",
      "PAY_METHOD": "02",
      "TRANS_DT": "20200111",
      "TRANS_AMT": 1000,
      "SETTLMNT_AMT": 400,
      "FDS_FEE": 0,
      "NICEPAY_FEE": 545,
      "BANK_FEE": 0,
      "VAT": 55,
      "ORDER_NO": "OrdNo2020032349682",
      "BANK_CD": "BMRI",
      "CUSTOMER_NO": "70014000090323543251"
    }
  ],
  "TAIL": {
    "CODE": "99",
    "MID": "IONPAYTEST",
    "SETTLMNT_DT": "20200113",
    "APP_CNT": 5,
    "APP_AMT": 14000,
    "CC_CNT": 0,
    "CC_AMT": 0,
    "NICEPAY_FEE": 2725,
    "BANK_FEE": 0,
    "VAT": 275,
    "SETTLMNT_AMT": 11000
  }
}
```
:::