Skip to main content

Connect XT.com to Finbooks via Excel file

šŸ”µ Crypto guide

In this article, you'll find all the information you need to import your transactions from XT.com to Finbooks via Excel file.


What you need to upload to Finbooks

To connect XT.com to Finbooks, you'll need the following files:

  • Spot deposits, contains your spot deposits

  • Spot withdrawals, contains your spot withdrawals

  • Spot trades, contains your executed spot trades

  • Futures transaction history, contains your futures ledger

Upload the files exactly as XT.com generates them, without editing them.

āš ļø You must import the complete history of your XT.com account

The files must cover the entire period of account usage, from the first day you used XT.com until the date you download them. Because XT.com limits each export to 10,000 records, you may need to download several files for each type. Together they must cover the whole period without gaps or overlaps.


How to export your Spot trades

  1. log in to XT.com and click on Order in the top menu, then select Spot Order

  2. in the left menu, click on Trade History

  3. click on the Export button

    1英.jpg

  4. in the Spot Account - Trading History pop-up, set Select Range to Last 7 Days, Last 30 Days or Customize (to choose your own date range)

  5. click on Export Now. The counter on the button (for example Export Now (5 times left)) shows how many exports you have left today

    3英.jpg

  6. the file appears in the Sheet list with the status Generating. Once the status changes to Generated, click on Download

    4英.jpg

How to export your Spot deposits and withdrawals

Deposits and withdrawals are exported from the same page, one file at a time:

  1. log in to XT.com and click on Funds in the top menu, then select Overview

    5英.jpg

  2. next to Deposit & Withdraw History, click on All. The Fund Records page opens

    6英.jpg

  3. select the Deposit tab and click on the Export button in the top-right corner

  4. choose the date range and click on Export Now

    7英.jpg

  5. when the file status changes to Generated, click on Download. The file is named "spot-deposit-..."

    8英.jpg

  6. go back to Fund Records, select the Withdraw tab and repeat the same steps. The file is named "spot-withdraw-..."


How to export your Futures transaction history

  1. log in to XT.com and click on Order in the top menu, then select Futures Order

  2. in the left menu, open Futures Account and click on Transaction History

  3. click on the Export button

    2英.jpg

  4. choose the date range and click on Export Now

  5. when the file status changes to Generated, click on Download. The file is named "future-transaction-history-..."

ā„¹ļø Make sure you export the Transaction History

Do not use the export in Order History. Finbooks needs the file named "future-transaction-history-...", which comes from Transaction History.


How to plan your exports

XT.com allows a maximum of 5 exports per day and 10,000 records per export. XT.com may change these limits at any time.

You need 4 file types, and each one needs at least one export. If you have a long history, or a lot of activity, you'll need more than one export per file type, so the work may take more than one day.

  • if the memo says Exceed limit, narrow the time range and export the period in several smaller ranges

  • use consecutive, non-overlapping date ranges, starting from the oldest period

  • add the start and end date to each file name so you can check there are no gaps

āš ļø Download your files promptly

Download links are valid for 7 days. Once a file shows Generated, download it right away. After 7 days you'll have to export it again, and this uses up one of your daily exports.


How to import your XT.com files into Finbooks

To learn how to import your files into a new connection or an existing one, please check out this article.

Did this answer your question?