- Home
- API reference
- Reports
- Get the reconciliation
Get the reconciliation
Lists paid payments and their settlement state: reconciled, awaiting, late, checking or held.
/v1/reports/reconciliationbalances:read permission.Query parameters
Section titled “Query parameters”fromstringrequiredThe first day of the period, YYYY-MM-DD in Jakarta time. It is included.
Example: 2026-10-01
Pattern: ^\d{4}-\d{2}-\d{2}$
tostringrequiredThe last day of the period, YYYY-MM-DD in Jakarta time. It is included.
Example: 2026-10-26
Pattern: ^\d{4}-\d{2}-\d{2}$
statusstringoptionalFilter reconciliation rows by status: reconciled, awaiting, late, checking or held. The summary totals still cover the full period.
Example: late
Possible values: reconciled, awaiting, late, checking, held
Response (200)
Section titled “Response (200)”dataobjectrequiredThe returned object, or an array of objects for a list.
livemodebooleanrequiredtrue means this object belongs to live and can involve real payments; false means it belongs to the sandbox.
currencystringrequiredThe currency, an ISO 4217 code. Only IDR today.
Example: IDR
Value: IDR
fromstringrequiredThe first day of the period, YYYY-MM-DD in Jakarta time. It is included.
Example: 2026-10-01
Pattern: ^\d{4}-\d{2}-\d{2}$
tostringrequiredThe last day of the period, YYYY-MM-DD in Jakarta time. It is included.
Example: 2026-10-26
Pattern: ^\d{4}-\d{2}-\d{2}$
totalsobjectrequiredHow many payments are in each status, and what they net.
reconciledobjectrequiredPaid and matched with the provider's settlement.
countintegerrequiredNumber of payments whose settlement matched during this period.
Example: 12
net_amountintegerrequiredNet amount of the payments whose settlement matched, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 11916000
awaitingobjectrequiredPaid, and the settlement is not due yet.
countintegerrequiredNumber of paid payments still waiting for their expected settlement.
Example: 3
net_amountintegerrequiredNet amount of paid payments still waiting for settlement, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 2979000
lateobjectrequiredPaid, and the settlement should have come by now.
countintegerrequiredNumber of paid payments whose expected settlement date has passed.
Example: 0
net_amountintegerrequiredNet amount of paid payments past their expected settlement date, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 0
checkingobjectrequiredBeing checked by Baiyar because something did not add up.
countintegerrequiredNumber of payments Baiyar is checking because the settlement did not match.
Example: 0
net_amountintegerrequiredNet amount of payments Baiyar is checking against the settlement, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 0
heldobjectrequiredHeld back until a decision is recorded.
countintegerrequiredNumber of payments held while a settlement issue is reviewed.
Example: 0
net_amountintegerrequiredNet amount of payments held while a settlement issue is reviewed, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 0
rowsarray of objectrequiredEvery paid payment of the period with where its settlement stands.
payment_idstringrequiredThe id of the payment.
Example: pay_01k7q3m8x2v5t9n4b6c1d0e7fa
Prefixed with pay_.
project_idstringrequiredThe project this object belongs to. Its settings determine which payment methods and limits apply.
Example: prj_01k7q3m8x2v5t9n4b6c1d0e7fa
Prefixed with prj_.
merchant_referencestring | nullrequiredYour reference for the payment; null when it has none.
Example: order-1001
provider_codestringrequiredThe payment provider that carried the payment.
Example: singapay
payment_methodstringrequiredThe payment method, for example payment.qris or payment.va.bca.
Example: payment.qris
business_daystringrequiredThe Jakarta calendar day used to group this payment or balance entry, YYYY-MM-DD.
Example: string
Pattern: ^\d{4}-\d{2}-\d{2}$
paid_atstringrequiredWhen the payment was paid (RFC 3339, UTC).
Example: 2026-10-26T03:04:05.000Z
Format: date-time
charged_amountintegerrequiredTotal charged to the payer, including the fee when the payer bears it, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 1000000
fee_amountintegerrequiredBaiyar's fee for this payment, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 7000
net_amountintegerrequiredThe amount credited after the Baiyar fee, in the smallest unit of currency (Rp125.000 is 12500000).
Example: 993000
statusstringrequiredreconciled, awaiting, late, checking or held.
Example: reconciled
Possible values: reconciled, awaiting, late, checking, held
settled_atstring | nullrequiredWhen the provider settled it; null until then.
Example: 2026-10-26T03:04:05.000Z
Format: date-time
settlement_roundintegerrequiredWhich settlement round included this payment. The number increases if a settlement is reversed and matched again; null when the provider does not use rounds.
Example: 1
metaobjectrequiredRequest details such as its id and pagination cursor.
request_idstringrequiredThe id of this request. Quote it when you ask support about it.
Example: req_Hy3k9QzT2LmN8vXa
A failed request answers with the common error shape; see Errors.
curl "https://api.baiyar.com/v1/reports/reconciliation" \ -H "Authorization: Bearer $BAIYAR_KEY"{ "data": { "livemode": false, "currency": "IDR", "from": "2026-10-01", "to": "2026-10-26", "totals": { "reconciled": { "count": 12, "net_amount": 11916000 }, "awaiting": { "count": 3, "net_amount": 2979000 }, "late": { "count": 0, "net_amount": 0 }, "checking": { "count": 0, "net_amount": 0 }, "held": { "count": 0, "net_amount": 0 } }, "rows": [ { "payment_id": "pay_01k7q3m8x2v5t9n4b6c1d0e7fa", "project_id": "prj_01k7q3m8x2v5t9n4b6c1d0e7fa", "merchant_reference": "order-1001", "provider_code": "singapay", "payment_method": "payment.qris", "business_day": "string", "paid_at": "2026-10-26T03:04:05.000Z", "charged_amount": 1000000, "fee_amount": 7000, "net_amount": 993000, "status": "reconciled", "settled_at": "2026-10-26T03:04:05.000Z", "settlement_round": 1 } ] }, "meta": { "request_id": "req_Hy3k9QzT2LmN8vXa" }}