Importing Historical Transactions for a Private Account (CSV)

The Transactions import on a Private Account lets you bring in a history of deposits and withdrawals — either to set up a brand new account from scratch, or to update an existing account's records at any point going forward.

Two situations where this is useful

1. New account starting at $0 — If you're adding an account that already has trading history, you can import all the deposits and withdrawals that have occurred since you opened it. This gives you an accurate net P&L from day one rather than just a current balance snapshot.

2. Ongoing monthly updates — If you already have an account in Trader Node, you can use the Transactions import at the end of each month to record any new deposits, withdrawals, or balance changes. This keeps your P&L calculation current and accurate over time.

Finding your deposit and withdrawal history

Your broker's trade history statement will list all transactions. To find deposits and withdrawals quickly, open the statement and use Ctrl+F (or Cmd+F on Mac) to search for "deposit" or "withdrawal." Note the amount and date for each one.

If you're importing history since the account was first opened, go through the full statement and capture every deposit and withdrawal. The system uses these to calculate:

Net Trading P&L = Current Balance − Starting Balance − Deposits + Withdrawals

The more complete your transaction history, the more accurate this number will be.

Step 1: Download the template

Open your Private Account and go to the Transactions tab. Click the template icon to download the import file.

Step 2: Fill in your data

Field	Format	Example
Amount	Numbers only, no commas or symbols	`2000`
Date	MM/DD/YYYY only	`01/15/2025`
Description	Optional note	`Initial capital deposit`
pay_type	Must be exactly `DEPOSIT`, `WITHDRAWAL`, or `BALANCE UPDATE`, all caps	`DEPOSIT`
Source	Must be exactly `Csv`, capital C, lowercase sv	`Csv`

On pay_type values:

Value	What it does
`DEPOSIT`	Records a cash deposit into the account
`WITHDRAWAL`	Records a cash withdrawal from the account
`BALANCE UPDATE`	Saves a balance snapshot — use this to record your current account balance as of the import date

A correctly filled CSV for an account imported with full history looks like this:

Amount	Date	Description	pay_type	Source
5000	01/10/2025	Starting capital	DEPOSIT	Csv
1000	02/03/2025	Top up	DEPOSIT	Csv
500	03/15/2025	Partial withdrawal	WITHDRAWAL	Csv
6800	03/31/2025	End of March balance	BALANCE UPDATE	Csv

In this example: the account started with $5,000, received an additional $1,000, had $500 withdrawn, and the current balance as of 31 March is $6,800. The system will use all of this to calculate net P&L accurately.

Step 3: Export as CSV

Save or export the file as .csv.

Step 4: Upload

In the Transactions tab, click the upload icon. Select your CSV. Each row will appear as a transaction entry. You can click on any entry to edit it if something needs adjusting.

How often should you do this?

At minimum, once a month. Updating at the end of each month keeps your Private Account P&L accurate and makes your dashboard numbers reliable. If you go more than 30 days without an update, your current balance and P&L figures will be stale.

Common mistakes

2,000 instead of 2000 — no commas in the Amount field
deposit instead of DEPOSIT — pay_type must be fully capitalised
CSV instead of Csv — Source must be exactly capital C, lowercase sv
Forgetting the BALANCE UPDATE row — without it, your current balance won't update in the system
Using BALANCE_UPDATE with an underscore — the correct value is BALANCE UPDATE with a space