Reconciliation & Exports

PIK maintains a full transaction ledger for every account. You can retrieve history via the API at any time, filter by date range or type, and export for reconciliation with your accounting system.

Transaction Types

Type	Description
payment_in	Inbound payment received and settled to the wallet
payment_out	Outbound payout sent from the wallet
fx_conversion	Currency conversion between wallet balances
transfer_in	Funds moved into this wallet from another PIK wallet
transfer_out	Funds moved from this wallet to another PIK wallet
fee	Platform fee or PIK fee deducted
reversal	Returned payout credited back to wallet

Retrieve Transaction History via API

http

GET /api/v1/accounts/{account-id}/transactions
Authorization: Bearer YOUR_PLATFORM_API_KEY
x-on-behalf-of: {connected-account-id}

Query parameters:

Parameter	Type	Description
currency	string	Filter by currency: AUD, USDT, USDC, USD, HKD, SGD
type	string	Filter by type: payment_in, payment_out, fx_conversion, etc.
from_date	ISO 8601 date	Return transactions on or after this date
to_date	ISO 8601 date	Return transactions on or before this date
limit	integer	Results per page. Max 100, default 20
cursor	string	Pagination cursor from previous response

Example — retrieve all settled USDT payments in April 2025: http

GET /api/v1/accounts/{account-id}/transactions
  ?currency=USDT
  &type=payment_in
  &from_date=2025-04-01
  &to_date=2025-04-30
  &limit=100

Transaction Response Fields

Each transaction in the response includes:

Field	Description
transaction_id	Unique transaction identifier
type	Transaction type (see table above)
currency	Currency code
amount	Transaction amount as decimal string
fee	Fee deducted (if applicable)
net_amount	Amount after fee
reference	Reference string set at time of transaction
status	settled, pending, failed
created_at	ISO 8601 timestamp
counterparty	Counterparty details where applicable

Matching Payments to Internal Records

The reference field is the primary reconciliation key. When creating a payment request or payout, always set your internal order ID or invoice number as the reference. PIK records this on the transaction and returns it in every API response and webhook payload. Reconciliation workflow:

Pull transactions for the period using GET /api/v1/accounts//transactions
For each transaction, match the reference field to your internal records
Mark matched records as reconciled
Flag unmatched transactions for manual review

Exporting Data

To export a full transaction history, paginate through the transactions endpoint using the cursor field until all pages are retrieved, then combine into a single dataset. PIK does not currently offer a one-click CSV export via the API. Transform the JSON response into CSV using your preferred tooling. Dashboard export: Transaction history can be exported as CSV from the PIK Dashboard under Transactions > Export.

Accounting Integrations

PIK does not currently offer native integrations with Xero, QuickBooks, or MYOB. Use the API to pull transaction data and import into your accounting system using the CSV export or a custom integration. For enterprise integration support, contact hi@pik.global.

​Transaction Types

​Retrieve Transaction History via API

​Transaction Response Fields

​Matching Payments to Internal Records

​Exporting Data

​Accounting Integrations