Reconciliation Reports

Use these endpoints to retrieve daily transaction summaries, balance journals, and settlement totals for reconciliation and audit processes.

Common query parameters

  • Name
    start_date
    Type
    mandatory | date
    Description

    First report date, formatted as YYYY-MM-DD.

  • Name
    end_date
    Type
    mandatory | date
    Description

    Last report date, formatted as YYYY-MM-DD. It must be equal to or later than start_date.

  • Name
    projectId
    Type
    optional | integer
    Description

    Limits results to one project owned by the merchant associated with the authenticated project. Omit this parameter to return data from all projects owned by that merchant.

All monetary values are returned as integers in IDR. Report periods and daily boundaries use WIB (Asia/Jakarta).


GET{{HOST}}/v1/reports/daily-transactions

Daily Transaction Summary

Returns Cash In and Cash Out totals grouped by transaction created_at date and project.

Daily Transaction Summary

GET
{{HOST}}/v1/reports/daily-transactions
curl --request GET \
  '{{HOST}}/v1/reports/daily-transactions?start_date=2026-05-13&end_date=2026-05-13&projectId=13' \
  --header 'X-Client-Key: <PROJECT_KEY>' \
  --header 'X-Client-Token: <PROJECT_TOKEN>' \
  --header 'X-Signature: <HMAC_SHA512_SIGNATURE>'

Response

200
application/json
{
  "code": "OK",
  "message": "Daily transaction summary retrieved successfully.",
  "data": [
    {
      "date": "2026-05-13",
      "projectId": 13,
      "projectName": "QA Testing Project 1",
      "cashin": {
        "vendor_entries": 5,
        "vendor_paid": 500000
      },
      "cashout": {
        "vendor_entries": 5,
        "vendor_sent": 500000
      }
    }
  ]
}

Daily transaction fields

  • Name
    date
    Type
    date
    Description
    Transaction created_at date.
  • Name
    projectId
    Type
    integer
    Description
    Project identifier.
  • Name
    projectName
    Type
    string
    Description
    Project name.
  • Name
    cashin.vendor_entries
    Type
    integer
    Description
    Number of Cash In transactions created on the date.
  • Name
    cashin.vendor_paid
    Type
    integer
    Description
    Total net amount from paid Cash In transactions.
  • Name
    cashout.vendor_entries
    Type
    integer
    Description
    Number of Cash Out transactions created on the date.
  • Name
    cashout.vendor_sent
    Type
    integer
    Description
    Total customer amount from successful Cash Out transactions.

GET{{HOST}}/v1/reports/balance-journals

Daily Balance Journal

Returns daily opening balance, credit mutations, debit mutations, and closing balance for each project.

Daily Balance Journal

GET
{{HOST}}/v1/reports/balance-journals
curl --request GET \
  '{{HOST}}/v1/reports/balance-journals?start_date=2026-05-13&end_date=2026-05-13&projectId=13' \
  --header 'X-Client-Key: <PROJECT_KEY>' \
  --header 'X-Client-Token: <PROJECT_TOKEN>' \
  --header 'X-Signature: <HMAC_SHA512_SIGNATURE>'

Response

200
application/json
{
  "code": "OK",
  "message": "Balance journal retrieved successfully.",
  "data": [
    {
      "date": "2026-05-13",
      "projectId": 13,
      "projectName": "QA Testing Project 1",
      "open": 987000,
      "cashin": 150000,
      "cashout": 0,
      "close": 1137000
    }
  ]
}

Balance journal fields

  • Name
    open
    Type
    integer
    Description
    Project balance at the beginning of the date.
  • Name
    cashin
    Type
    integer
    Description
    Total positive balance mutations during the date.
  • Name
    cashout
    Type
    integer
    Description
    Absolute total of negative balance mutations during the date.
  • Name
    close
    Type
    integer
    Description
    Project balance at the end of the date.

GET{{HOST}}/v1/reports/settlements

Daily Settlements

Returns funds settled to the company's bank account, grouped by settlement date and project.

Daily Settlements

GET
{{HOST}}/v1/reports/settlements
curl --request GET \
  '{{HOST}}/v1/reports/settlements?start_date=2026-05-13&end_date=2026-05-13&projectId=13' \
  --header 'X-Client-Key: <PROJECT_KEY>' \
  --header 'X-Client-Token: <PROJECT_TOKEN>' \
  --header 'X-Signature: <HMAC_SHA512_SIGNATURE>'

Response

200
application/json
{
  "code": "OK",
  "message": "Daily settlement data retrieved successfully.",
  "data": [
    {
      "settlementDate": "2026-05-13",
      "projectId": 13,
      "projectName": "QA Testing Project 1",
      "grossAmount": 150000,
      "totalFeeMdr": 2250,
      "netSettlementAmount": 147750
    }
  ]
}

Settlement fields

  • Name
    settlementDate
    Type
    date
    Description
    Date the settlement batch completed.
  • Name
    grossAmount
    Type
    integer
    Description
    Total gross payment amount in settled transactions.
  • Name
    totalFeeMdr
    Type
    integer
    Description
    Total transaction fees included in the settlement.
  • Name
    netSettlementAmount
    Type
    integer
    Description
    Net amount credited to the project balance.

Was this page helpful?