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
log in to XT.com and click on Order in the top menu, then select Spot Order
in the left menu, click on Trade History
click on the Export button
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)
click on Export Now. The counter on the button (for example Export Now (5 times left)) shows how many exports you have left today
the file appears in the Sheet list with the status Generating. Once the status changes to Generated, click on Download
How to export your Spot deposits and withdrawals
Deposits and withdrawals are exported from the same page, one file at a time:
log in to XT.com and click on Funds in the top menu, then select Overview
next to Deposit & Withdraw History, click on All. The Fund Records page opens
select the Deposit tab and click on the Export button in the top-right corner
choose the date range and click on Export Now
when the file status changes to Generated, click on Download. The file is named "spot-deposit-..."
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
log in to XT.com and click on Order in the top menu, then select Futures Order
in the left menu, open Futures Account and click on Transaction History
click on the Export button
choose the date range and click on Export Now
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.
