Get billing records

Requires read_payment access scope.
For more info, refer to:
access permission.
GET https://{handle}.myshopline.com/admin/openapi/v20260601/payments/store/balance_transactions.json
handle : The store's unique identifier, which is the prefix of the store's domain name. For example, if a store's domain name is open001.myshopline.com , the store handle is open001 .
Get billing records of the SHOPLINE Payments account.
Query Parameters
  • payout_id string
    Payout ID. The billing records from the time of the previous payout (excluded) to the time of the billing record specified by payout_id (included) are returned.
  • since_id string
    The ID of the billing record. When this value is provided, the query for billing records will start from the creation time (exclusive) of the specified billing record ID.
  • start_time string
    Specify the earliest date and time for billing records to query. Billing records created on and after this time are returned. If payout_id is not passed, then both start_time and end_time must be specified, and the time interval cannot exceed three months. Format: ISO 8601.
    Example: 2025-04-30T00:00:00+08:00
  • limit string
    Maximum number of records to be returned in the query.
    Value range: 1-100
    Default value: 50
  • account_type string
    The SHOPLINE Payments account type. Valid values are:
    • PendingSettlementAccount: The pending settlement account.
    • PayoutAccount: The payout account.
    • RevolvingMarginAccount: The revolving reserve account.
    • FixedMarginAccount: The fixed reserve account.
  • end_time string
    Specify the latest date and time for the billing records to query. Billing records created before this time are returned. If payout_id is not passed, then both start_time and end_time must be specified, and the time interval cannot exceed three months. Format: ISO 8601.
    Example: 2025-05-31T00:00:00+08:00
  • is_settlement_details string
    Whether to display billing details in the batch settlement report. Valid values are:
    • true: Display billing details instead of the settlement record.
    • false: Display the settlement record instead of billing details.
    Billing details refer to records with the following type values:
    • ADJUSTMENT
    • CHARGEBACK_FEE
    • CHARGEBACK_FEE_FROZEN
    • CHARGEBACK_FEE_UNFROZEN
    • CHARGEBACK_FROZEN
    • CHARGEBACK_INITIATED
    • CHARGEBACK_LOST
    • CHARGEBACK_UNFROZEN
    • CHARGEBACK_WON
    • FIXED_RESERVE_COLLECTED
    • FIXED_RESERVE_RELEASED
    • PAYMENT
    • PAYMENT_FEE_RETURNED
    • PAYOUT
    • PAYOUT_FAILED
    • PAYOUT_FEE
    • PAYOUT_FEE_FROZEN
    • PAYOUT_FEE_UNFROZEN
    • PAYOUT_FROZEN
    • PAYOUT_RETURNED
    • PAYOUT_UNFROZEN
    • PRE_CHARGEBACK_ACCEPTED
    • PRE_CHARGEBACK_FEE
    • PRE_CHARGEBACK_FEE_FROZEN
    • PRE_CHARGEBACK_FEE_UNFROZEN
    • PRE_CHARGEBACK_FROZEN
    • PRE_CHARGEBACK_REJECTED
    • PRE_CHARGEBACK_UNFROZEN
    • REFUND
    • REFUND_FAILED
    • REFUND_FEE
    • REFUND_FEE_FROZEN
    • REFUND_FEE_UNFROZEN
    • REFUND_FROZEN
    • REFUND_INITIATED
    • REFUND_UNFROZEN
    • ROLLING_RESERVE_COLLECTED
    • ROLLING_RESERVE_SETTLED_TO_FIXED_RESERVE
    • ROLLING_RESERVE_SETTLED_TO_PAYOUT_ACCOUNT
    • TRANSFER
    Settlement records refer to records whose type value is SETTLEMENT.
    Default value: false.
  • page_info string
    The unique identifier for pagination queries, used to locate a specific page.
    This parameter value is obtained from the link value in the response header of this API after you have queried the pagination information.
    For example, if the link value you obtained is <https://{handle}.myshopline.com/admin/openapi/{version}/payments/store/balance_transactions.json?limit=1&page_info=eyJzaW5jZUlkIjoiMTYwNTc1OTAxNTM4OTA4Mjk1MjExMTI3ODgiLCJkaXJlY3Rpb24iOiJuZXh0IiwibGltaXQiOjF9>; rel="next" , the value of page_info is eyJzaW5jZUlkIjoiMTYwNTc1OTAxNTM4OTA4Mjk1MjExMTI3ODgiLCJkaXJlY3Rpb24iOiJuZXh0IiwibGltaXQiOjF9 .
    For more information on how to use pagination, refer to Paging Mechanism.
Request Headers
  • Content-Type string required
    The field must be set to the fixed value application/json; charset=utf-8.
  • Authorization string required
    The access token for the API resource. Refer to App authorization to obtain the access token, and then pass the obtained token in the Bearer format.
    Example:
    Bearer eyJhbGciOiJIUzUxMiJ9.eyJhcHBLZXkiOiJmMjM3OWQyMTYyOGMzM2QxMWRiMWZkYjY5N2EzZjdjMjZlNGMwYTA5Iiwic2VsbGVySWQiOiIyMDAwMjM0ODgwIiwic3RvcmVJZCI6IjE2NzIzNjk3Mjk2MDYiLCJ2ZXJzaW9uIjoiVjIiLCJkb21haW4iOiJodHRwczovL3NsLW9wZW4tc2cubXlzaG9wbGluZS5jb20iLCJ0aW1lc3RhbXAiOjE2NzUzMTk0OTI0MzksImlzcyI6Inlzb3VsIiwiZXhwIjoxNzY5OTI3NDkyfQ.UwQzomM2veGCUaOZ0paUxq5dpc7DXuhHYFvsQ_uIAKduzWcb_j2E4q_36El83sp145D4cKbpcE5KCeeIz-JNQw
Status Codes
For the complete list of codes and messages, see Http status code.
Response Headers
  • link
    The URL link that provides the pagination data. You can obtain page_info from this parameter for subsequent pagination requests.
    This parameter is returned when the requested page has a previous or next page.
    For more information on how to use pagination, refer to Paging Mechanism.
  • traceId
    A globally unique identifier for the request. It is used to track the request flow throughout the system, allowing for easy location and debugging when issues arise.
Response Body
  • transactionsobject[]
    A list of billing records from the merchant's SHOPLINE Payments account.
  • account_balance string
    Account balance. The value is rounded to two decimal places.
  • account_currency string
    Account currency. The value of this parameter is a three-letter currency code that follows the ISO 4217 standard. Example: USD.
  • account_identify_code string
    The identification code of the SHOPLINE Payments account.
  • account_type string
    Account type. Valid values are:
    • PendingSettlementAccount: The pending settlement account.
    • PayoutAccount: The payout account.
    • RevolvingMarginAccount: The revolving reserve account.
    • FixedMarginAccount: The fixed reserve account.
  • amount string
    Settlement amount. The value is rounded to two decimal places. Negative values represent fees deducted from the merchant, and positive values represent refunds issued to the merchant.
  • exchange_rate string
    Settlement exchange rate. exchange_rage = transaction_amount / amount. The value is rounded to 10 decimal places. This field takes a positive value.
  • id string
    The unique identifier for a billing record.
  • interchange_fee string
    Interchange fee. The value is rounded to two decimal places. This field takes a negative value, referring to fees deducted from the merchant.
  • net string
    Net amount. net = amount + interchange_fee + scheme_fee + payment_method_fee + revolving_margin_account_balance. The value is rounded to two decimal places.
  • payment_method_fee string
    Payment method fee. The value is rounded to two decimal places. Negative values represent fees deducted from the merchant, and positive values represent refunds issued to the merchant.
  • payout_account_available_balance string
    Payout account available balance. The value is rounded to two decimal places.
  • payout_account_frozen_balance string
    Payout account frozen balance. This field takes a positive value. The value is rounded to two decimal places.
  • posting_time string
    The date and time when the SHOPLINE Payments billing record was created. Format: ISO 8601.
    Example: 2025-05-31T10:00:00+08:00
  • revolving_margin_account_balance string
    Revolving reserve amount. The value is rounded to two decimal places. Negative values represent revolving reserve deducted from the merchant, and positive values represent revolving margin refunds issued to the merchant.
  • scheme_fee string
    Scheme fee. The value is rounded to two decimal places. This field takes a negative value, referring to fees deducted from the merchant.
  • settlement_batch_id string
    Batch settlement ID.
  • source_order_id string
    The order ID associated with the billing record.
  • source_order_transaction_id string
    The transaction ID associated with the billing record, such as a payment or a refund order ID.
  • transaction_amount string
    Transaction amount. The value is rounded to two decimal places.
  • transaction_currency string
    Transaction currency. The value of this parameter is a three-letter currency code that follows the ISO 4217 standard. Example: USD.
  • type string
    The type of billing records. Valid values are:
    • ADJUSTMENT: balance adjustment
    • CHARGEBACK_FEE: chargeback fee
    • CHARGEBACK_FEE_FROZEN: chargeback fee frozen
    • CHARGEBACK_FEE_UNFROZEN: chargeback fee unfrozen
    • CHARGEBACK_FROZEN: chargeback frozen
    • CHARGEBACK_UNFROZEN: chargeback unfrozen
    • CHARGEBACK_INITIATED: chargeback initiated
    • CHARGEBACK_LOST: chargeback lost
    • CHARGEBACK_WON: chargeback won
    • FIXED_RESERVE_COLLECTED: fixed reserve charged
    • FIXED_RESERVE_RELEASED: fixed reserve released
    • PAYMENT: payment
    • PAYMENT_FEE_RETURNED: payment fee returned
    • PAYOUT: payout
    • PAYOUT_FAILED: payout failed
    • PAYOUT_FEE: payout fee
    • PAYOUT_FEE_FROZEN: payout fee frozen
    • PAYOUT_FEE_UNFROZEN: payout fee unfrozen
    • PAYOUT_FROZEN: payout frozen
    • PAYOUT_RETURNED: payout returned
    • PAYOUT_UNFROZEN: payout unfrozen
    • PRE_CHARGEBACK_ACCEPTED: pre-chargeback accepted
    • PRE_CHARGEBACK_FEE: pre-chargeback fee
    • PRE_CHARGEBACK_FEE_FROZEN: pre-chargeback fee frozen
    • PRE_CHARGEBACK_FEE_UNFROZEN: pre-chargeback fee unfrozen
    • PRE_CHARGEBACK_FROZEN: pre-chargeback frozen
    • PRE_CHARGEBACK_REJECTED: pre-chargeback rejected
    • PRE_CHARGEBACK_UNFROZEN: pre-chargeback unfrozen
    • REFUND: refund
    • REFUND_FAILED: refund failed
    • REFUND_FEE: refund fee
    • REFUND_FEE_FROZEN: refund fee frozen
    • REFUND_FEE_UNFROZEN: refund fee unfrozen
    • REFUND_FROZEN: refund frozen
    • REFUND_INITIATED: refund initiated
    • REFUND_UNFROZEN: refund unfrozen
    • ROLLING_RESERVE_COLLECTED: rolling reserve charged
    • ROLLING_RESERVE_SETTLED_TO_FIXED_RESERVE: rolling reserve settled to fixed reserve
    • ROLLING_RESERVE_SETTLED_TO_PAYOUT_ACCOUNT: rolling reserve settled to payout account
    • SETTLEMENT: settlement
    • TRANSFER: transfer
    • WITHHOLDING_PAYMENT: withholding payment
    • WITHHOLDING_PAYMENT_RETURNED: withholding payment return
API Explorer
https://openapiceshidianpu.myshopline.com/admin/openapi/v20260601

ParamOptions

— header required
— query
— query
— query
— query
— query
— query
— query
— query

Language

curl --request GET \
     --url https://openapiceshidianpu.myshopline.com/admin/openapi/v20260601/payments/store/balance_transactions.json \
     --header 'Authorization: Bearer eyJhbGciOiJIUzUxMiJ9.eyJhcHBLZXkiOiJmMjM3OWQyMTYyOGMzM2QxMWRiMWZkYjY5N2EzZjdjMjZlNGMwYTA5Iiwic2VsbGVySWQiOiIyMDAwMjM0ODgwIiwic3RvcmVJZCI6IjE2NzIzNjk3Mjk2MDYiLCJ2ZXJzaW9uIjoiVjIiLCJkb21haW4iOiJodHRwczovL3NsLW9wZW4tc2cubXlzaG9wbGluZS5jb20iLCJ0aW1lc3RhbXAiOjE2NzUzMTk0OTI0MzksImlzcyI6Inlzb3VsIiwiZXhwIjoxNzY5OTI3NDkyfQ.UwQzomM2veGCUaOZ0paUxq5dpc7DXuhHYFvsQ_uIAKduzWcb_j2E4q_36El83sp145D4cKbpcE5KCeeIz-JNQw' \
     --header 'Content-Type: application/json; charset=utf-8' \
     --header 'accept: application/json'
Examples
Get billing records by start_time and end_time
Response
{
  "transactions": [
    {
      "account_balance": "-21.85",
      "account_currency": "AUD",
      "account_identify_code": "106103602",
      "account_type": "PayoutAccount",
      "amount": "-0.10",
      "exchange_rate": "0.0000000000",
      "id": "2505290030107014918095689226834",
      "interchange_fee": "0.00",
      "net": "-0.10",
      "payment_method_fee": null,
      "payout_account_available_balance": "-24.22",
      "payout_account_frozen_balance": "2.37",
      "posting_time": "2025-05-29T00:30:07+08:00",
      "revolving_margin_account_balance": "0.00",
      "scheme_fee": "0.00",
      "settlement_batch_id": "settlement_report_20250529_1",
      "source_order_id": "21070058445751144992545567",
      "source_order_transaction_id": "30012505287014075754036344870",
      "transaction_amount": "-0.10",
      "transaction_currency": "AUD",
      "type": "REFUND_SUCCESS"
    }
  ]
}
Was this article helpful to you?
SHOPLINE
SHOPLINE
SHOPLINE Enterprise
Legal
Privacy
Terms
Developer Agreement
LinkedInEmail
LinkedInEmail
© Copyright 2013-2026 SHOPLINE Limited.