FAQ: Reconciliation Reporting

Summary 

Reconciliation Reporting provides Paxos Crypto Brokerage Customers with two daily reports:

  1. a list of transactions (orders, executions, transfers, deposits and withdrawals) for a 24 hour interval
  2. a daily snapshot of account balances.

Reports are generated daily at a configurable time (00:00 UTC by default), and can be downloaded from Paxos SFTP servers in CSV format.

FAQ

Who can receive Reconciliation Reports?

All customers of Paxos Crypto Brokerage can sign up for Reconciliation Reports - ask your Paxos Account Representative if you are unsure.

What reports are available?

We provide two reports: the Profile Balances Report and Profile Transactions Report. Reports are generated on a daily basis (by default after 00:00:00 UTC) and cover transactions from 00:00:00 UTC of the previous day to 23:59:59 UTC of the current day. The timezone offset is configurable.

Both reports contain activities for a single day.

Profile Balances Report

A report of the start of day balance and end of day asset balance for all assets. 

Example file name:  2021-11-16_profile_balances.csv

Profile Transactions Report

A report of all transactions (orders and executions) and associated accounting movements (transfers, deposits and withdrawals) on each profile that occurred during the recon file window.

Example file name: 2021-11-16_profile_transactions.csv

Refer to Reconciliation Reporting Data Dictionary for details on all fields in the reports. 

How do I access and download reports? 

Reports are generated into the /reports/unprocessed folder on a SFTP server. The SFTP domains are sftp.sandbox.paxos.com for our sandbox environment and sft.paxos.com for our production environment.

After downloading and processing, it is recommended to move files to the /reports/processed folder. Old report files can be moved to /reports/archived folder.

If files for the current interval are not available in /unprocessed or /processed folders, they will be regenerated. 

To download files from SFTP server, customers can use a GUI Client (e.g. cyberduck, filezilla), or command line tools:  

sftp -i /path/to/my-private-key <account>@sftp.paxos.com:/<account>.prod.itbitprod.sftp/home/reports/unprocessed/2021-12-21_profile_balances.csv /local/folder

For <account> we use the company's name or any alias can be selected by the customer. This will be provided to you during onboarding for Reconciliation Reporting.

Can files be uploaded to another SFTP server?

No. Uploading reports to a customer’s SFTP is not an available option, the reports are intended to be ingested.

How can I sign up for Reconciliation Reports? 

In order to ensure the security of your data, we require customers to provide both an IP allowlist and SSH key. Step by step, the process is:

  1. Identify a list of external IP addresses that will be used to access the reports. Due to security requirements it is not allowed to create a connection open for access from any IP. 
  2. Generate a pair of Private/Public SSH keys that will be used to access SFTP Server. The following command can be used to generate a pair of SSH keys:
    ssh-keygen -t rsa -b 4096
  3. Select a timezone offset for the reports. By default reports cover transactions from 00:00:00 UTC of the previous day to 23:59:59 UTC of the current day.
  4. Submit a Support Ticket. Please include the Public SSH key file, list of IP addresses, and desired timezone offset.

Once the support ticket has been received, Paxos will configure the reports. This process typically takes 5 business days once all information has been received.

What is the retention policy for reports?

Paxos does not currently delete transaction reports, but this may change in the future. All users must independently store transaction data to ensure compliance with any legal or regulatory requirements.

In what format are the Reconciliation Reports generated? 

Reports are generated as CSV (comma separated values) files, which can be opened as a spreadsheet, imported into a database, or processed by a script.   

What is the difference between Timestamp and ResourceTimestamp fields in transaction reports?

“ResourceTimestamp” represents the time when the Resource has been created, i.e.: an Order / Execution / Transfer, while “Timestamp” shows the exact time of each action for this Resource.

Where can I see what fees have been paid on transactions?

In the profile transactions file there will be records with transaction type - COMMISSION. These can be used to calculate the fees.

I'm using Directed Settlement. Where can I find the recipient profile ID for a transaction?

The CreateOrder API allows users to specify a recipient_profile_id that will receive the base currency for buy orders, or quote currency for sell orders. In this case the order is executed from one profile but is settled to the profile specified in this field. Recipient Profile for such execution will appear in a separate line with transaction type "SETTLE_BASE" in the transaction reconciliation file.



Was this article helpful?
0 out of 0 found this helpful