Reports

View and download daily balance and transaction reconciliation reports.

Go to Admin > Reports to activate, view and download daily reconciliation reports as CSV.

The Profile Transactions Report lists every transaction during a 24 hour period, including the full list and definition of transaction types and transaction metadata. The Profile Balances Report provides the asset start and ending balances for every Profile during a 24 hour period.

Migrating to the Dashboard? Existing legacy reconciliation reports are available in the Dashboard. The historical reconciliation reports match the files on the SFTP server, where they continue to be available.

In the reports, the Profile’s starting balance is impacted by any associated Profile Transaction, and results in the corresponding Profile end balance.

• If a Profile has ever held a given asset at any point in the past, zero balances will be explicitly printed. For example, if Profile 1 held Bitcoin in the past, but not today, Profile Balances will appear as “BTC: 0”.
• If a Profile has never held an asset at any point in the past, zero balances will not be explicitly printed. For example, if Profile 1 has never held Bitcoin in the past, Profile Balances will not appear for the BTC asset at all.

Reports are in UTC 0 time, and have an exact hour cutoff for the UTC timezone indicated when activating reporting. Paxos delivers reports one time per day and does not support multiple cutoff times or changes to the pre-configured cutoff time.

Onboard to Reporting

To start receiving daily reports, fill out the form on Admin > Reports. Once submitted, you should start receiving reports in about five business days. Reports are delivered on a go-forward basis, starting the first day reporting is activated.

Contact Support for help obtaining older reports.

Reporting Data Dictionary

This data dictionary provides a full list and definition of balance types.

Profile Balances Report Fields

The following fields are provided on each row of the Profile Balances Report.

Field	Data Type	Example/Description
Asset	String	USD, BTC, ETH, BCH, LTC, PAXG
Balance	String	9977417.21588054
BalanceType	Enum	See BalanceType Value and Definitions.
ProfileID	UUID	7927d51a-a465-49b9-ab0e-1ca17b3a7c5b
Timestamp	Datetime	2020-01-17T00:00:00.000Z

Profile Transactions Report Fields

The following fields are provided on each row of the Profile Transactions report.

Field	Data Type	Always Returns Data	Example/Description
AccountID	UUID	No	1ab15e4f-6389-4a52-b908-62c3525b0da2
Amount	String	Yes	90.12345678
Assets	String	Yes	USD, ETH, BTC, PAXG, BCH, LTC
BalanceType	Enum	Yes	See BalanceType Values and Definitions.
BaseAmount	String	No	10.017 The amount in the base asset for this trade, currently only supported for QuoteExecutions.
Direction	String	Yes	CREDIT, DEBIT
ExternalID	String	No	Contains the transaction hash for a crypto deposit. Returns empty when no data is available.
Fee	String	No	0.017 The fee for this interaction. Currently only supported for Transfers.
GroupID	UUID	No	Link for the debit and credit legs of an Internal Transfer.
IdentityID	UUID	No	1ab15e4f-6389-4a52-b908-62c3525b0da2
Market	String	No	ETHUSD, XBTUSD, PAXGUSD, BCHUSD, LTCUSD
Metadata	String	No	{"key_1":"value_11","key_2":"value_23"} Contains the customer specified metadata during a transaction on platform (withdrawal, transfer, quote execution) in json-string format. Returns empty when no data is available.
OrchestrationID	UUID	No	7f716105-d501-40e8-a82f-309fffacd6d8 A unique identifier that links all related transactions within a single logical flow. For example, all balance updates during a deposit process.
OrchestrationRuleID	UUID	No	9e124f3d-7c88-4b36-b54a-e389f6c398b2 The unique identifier of the automation rule that triggered this transaction set.
OrderType	String	No	LIMIT, MARKET, POSTONLYLIMIT, STOPMARKET, STOPLIMIT, HRQ
Price	String	No	100.23
ProfileID	UUID	Yes	7927d51a-a465-49b9-ab0e-1ca17b3a7c5b
QuoteAmount	String	No	10.50 The amount in the quote asset for this trade, currently only supported for QuoteExecutions.
Resource	Enum	Yes	See Resource Values and Definitions.
ResourceID	UUID	Yes	ID of the Resource in question. For example, Order ID, Execution ID, Transfer ID.
ResourceRefID	String	No	Custom string specified in Create Order request as ref_id.
ResourceTimestamp	Datetime	No	The timestamp when the Resource was generated. For example, the time for an Order or an Execution.
RecourceTransferType	Enum	No	See ResourceTransferType Values and Definitions.
Side	String	No	SELL, BUY
Timestamp	Datetime	Yes	The record timestamp. For example: 2024-01-17T18:36:31.345Z
TransactionType	Enum	Yes	See TransactionType Values and Definitions.
UniqueTxID	String	Yes	Unique identifier for a Profile transaction. Use with direction to guarantee unique line-item.

BalanceType Values and Definitions

The BalanceType field indicates which specific balance the row is referring to. It provides a way to precisely follow movement of funds as transactions complete in the Profile Transaction Report, and identify the volume of funds held in reserve or in pending transactions at the end of each day in the Profile Balances Report.

BalanceType Enum Value	Description
AVAILABLE	Balance that is currently available to trade or transfer.
PENDING_DEBIT	Balance that is currently reserved for pending debits. For example, an outgoing transfer has been requested but not completed.
TRADING	Balance that is currently reserved for trading. For example, a limit order has been placed but not filled.
PENDING_CREDIT	Balance that is currently reserved for pending credits. For example, an incoming transfer has been requested but not completed.

Resource Values and Definitions

The Resource field denotes the category of transaction being recorded on each row of the Profile Transactions Report.

Resource Enum Value	Description
CONVERSION	Stablecoin conversion transaction.
EXECUTION	An execution of an order on the order book. There can be multiple executions for one order.
ORCHESTRATION	A multi-step workflow to move between assets, networks, and rails.
ORDER	A market or limit order placed for trading. Using either FIX or the v2 Order service.
QUOTE_EXECUTION	A Held Rate Quote transaction.
TRANSFER	A transfer on or off the Paxos platform. For example, a wire withdrawal or crypto deposit.
WIRE_WITHDRAWAL_UPLOAD	A manually created wire withdrawal.

ResourceTransferType Values and Definitions

The ResourceTransferType identifies the direction of each transfer and whether it was a movement of fiat into or out of the Paxos Platform (WIRE_, SEN_), a movement of crypto asset into or out of Paxos (CRYPTO_), or a movement of crypto or fiat between profiles within the Paxos platform (PROFILE_TRANSFER).

Resource	TransferType	Description
TRANSFER	CRYPTO_DEPOSIT	A crypto deposit into Paxos.
TRANSFER	CRYPTO_WITHDRAWAL	A crypto withdrawal out of Paxos.
TRANSFER	INTERNAL_TRANSFER_CREDIT	Transfer received from another Profile.
TRANSFER	INTERNAL_TRANSFER_DEBIT	Transfer sent to another Profile.
TRANSFER	PAXOS_TRANSFER_CREDIT	Transfer received from another Peer.
TRANSFER	PAXOS_TRANSFER_DEBIT	Transfer sent to another Peer.
TRANSFER	SEN_DEPOSIT	Deprecated. Does not appear in new reports. A deposit into Paxos platform on the Silvergate Exchange Network.
TRANSFER	SEN_WITHDRAWAL	Deprecated. Does not appear in new reports. A withdrawal out of Paxos on the Silvergate Exchange Network .
TRANSFER	WIRE_DEPOSIT	A wire deposit into Paxos.
TRANSFER	WIRE_WITHDRAWAL	A wire withdrawal out of Paxos.

TransactionType Values and Definitions

The values of the TransactionType vary depending on the Resource. The TransactionType denotes the specific purpose of the transaction.

Resource	TransactionType	Description
CONVERSION	CONVERSION_CANCELLATION	A transaction to unreserve funds for a created stablecoin conversion.
CONVERSION	CONVERSION_CREATION	A transaction to reserve funds for a stablecoin conversion.
CONVERSION	CONVERSION_SETTLEMENT	Settlement of the stablecoin conversion transaction.
EXECUTION	COMMISSION	A transaction to collect commission from an executed trade.
EXECUTION	SETTLE_BASE	Settlement of the base (crypto) side of the trade to/from the counterparty.
EXECUTION	SETTLE_QUOTE	Settlement of the quote (cash) side of the trade to/from the counterparty For example, a SELL order has been executed.
EXECUTION	SETTLE_UNRESERVE	A transaction to unreserve funds for trading because of a BUY side price improvement on an executed order. For example, a limit order used a BUY price of 90,000 but executed at 89,000).
ORCHESTRATION	ORCHESTRATION_RESERVE	A transaction to reserve funds for Orchestration processing.
ORCHESTRATION	ORCHESTRATION_UNRESERVE	A transaction to unreserve funds in case of Orchestration failure.
ORDER	RESERVE	A transaction to reserve funds for trading. For example, a limit order has been placed.
ORDER	UNRESERVE	A transaction to unreserve funds for trading. For example, a limit order has been canceled.
QUOTE_EXECUTION	COLLECT_FROM_EXECUTOR	A record of transaction indicating a credit of the account.
QUOTE_EXECUTION	FUND_EXECUTOR	A record of transaction indicating a debit of the account.
TRANSFER	DEPOSIT_COMPLETION	A transaction to complete a deposit, resulting in funds being credited.
TRANSFER	DEPOSIT_CREATION	A transaction to deposit funds into the Paxos platform.
TRANSFER	DEPOSIT_FAILURE	A transaction to reserve the funds of a failed deposit into pending debit where they can move off the Paxos platform back to their source.
TRANSFER	FEE_DEBIT	A transaction to debit the fees upon completion of the transfer.
TRANSFER	FEE_ENCUMBERMENT	A transaction to reserve the transfer fee.
TRANSFER	INTERNAL_TRANSFER	A book transfer of funds to another profile under the same customer account.
TRANSFER	PAXOS_TRANSFER	A book transfer of funds to another Paxos customer.
TRANSFER	WITHDRAWAL_COMPLETION	A transaction to complete a withdrawal, resulting in the transfer of funds off the Paxos platform.
TRANSFER	WITHDRAWAL_CREATION	A transaction to initiate a withdrawal typically reserving the debit amount. For example, a wire withdrawal or crypto withdrawal.
TRANSFER	WITHDRAWAL_FAILURE	A transaction to return funds previously reserved for a failed withdrawal.