In this article, you'll find all the information you need to import your transactions from Drift to Finbooks via CSV.
â ïž You must import the complete history of your Drift account
The CSV files must cover the entire period of account usage, from the first day you used Drift until the date you download the files.
Drift exports are one CSV per kind and per period, and each export covers only one subaccount. Repeat the download for every subaccount and every period, and make sure all uploaded files together cover the full period without gaps.
Which CSV files to import
To connect Drift to Finbooks, you'll need both of the following CSV files:
Deposits, contains the deposits and withdrawals on your subaccount
Settle PnL, contains the realised PnL settled into USDC
đš Do not upload Trades or Funding payments files
Finbooks refuses these files with the error drift_redundant_csv_export. Their amounts are already included in the Settle PnL export, so importing them would count the same amounts twice. You don't need them.
How to download the Drift CSV files
go to the Drift Trade App at app.drift.trade and connect your Solana wallet
open the Overview or Portfolio section
select the History tab
select your subaccount. If you use multiple subaccounts, switch between them on the Subaccounts page
select the Deposits history, then click on Export (or Download CSV) in the top-right corner of the history table and save the .csv file to your device
select the Settle PnL history and download the CSV file in the same way
repeat steps 4 to 6 for every subaccount and for every period you need to cover
Import your Drift CSV files into Finbooks
Upload all the Deposits and Settle PnL files together. To learn how to import your CSV files into a new connection or an existing one, please check out this article.
