Importing Broker Statements

Instead of manually entering every balance update and transaction, you can import broker statements. The platform extracts key information and updates your records automatically.

What Statement Import Does

When you import a broker statement, the platform:

  1. Reads the file — Parses the statement format

  2. Extracts balance — Finds your current or ending balance

  3. Identifies transactions — Locates deposits and withdrawals

  4. Creates records — Adds entries to your account history

  5. Updates metrics — Recalculates P&L with new data

This is faster than manual entry, especially for catching up on historical data.

Supported File Types

The platform supports:

  • CSV files — Comma-separated data exports

CSV Transaction Types

When importing a CSV, each row uses one of three pay_type values:

  • DEPOSIT — money moved into the account

  • WITHDRAWAL — money moved out of the account

  • BALANCE_UPDATE — records the broker's ending balance as a new balance snapshot

BALANCE_UPDATE is how your account's current balance enters the system through import, rather than as a deposit or withdrawal. It creates a balance history entry, not a ledger transaction.

This means a single CSV can both record the capital movements (deposits and withdrawals) and bring your ending balance up to date in one import.

How to Import a Statement

  1. Open the private account by clicking on it

  2. Go to the Transactions tab

  3. Click Import button

  4. Select your file

  5. Review the extracted data

  6. Confirm the import

The Import Process

Step 1: Upload File

Choose the statement file from your computer. The platform will begin processing.

Step 2: Verify

After import, check the Transactions tab to verify everything looks correct.

What Gets Created

Balance History Entry

A snapshot recording the balance at the statement date. When a CSV includes a BALANCE_UPDATE row, this is the row that creates it.

Deposit Entries

For each deposit found:

  • Type: Deposit

  • Amount: From statement

  • Date: Transaction date

  • Notes: "From statement import"

Withdrawal Entries

For each withdrawal found:

  • Type: Withdrawal

  • Amount: From statement

  • Date: Transaction date

  • Notes: "From statement import"

History Event

A record noting:

  • "Statement imported successfully"

  • Date of import

  • File name

  • Summary of what was extracted

Getting Statements from Your Broker

Most Brokers Offer:

  • Monthly statements (PDF)

  • Transaction history export (CSV)

  • Account history reports

Where to Find Them:

  • MT4/MT5: Account History tab → Right-click → Save as Report

  • Broker website: Statements or Reports section

  • Email: Some brokers send monthly statements

Recommended Format:

CSV is usually cleanest for import. PDF works but may have extraction limitations.

Handling Import Issues

"File not recognized"

The format might not be supported. Try a different export format (CSV vs PDF) or check if your broker has a simpler export option.

"Balance doesn't match what I expected"

Review the statement date. The balance is as of that date, not today.

"Missing transactions"

Not all statement formats include full transaction detail. You may need to supplement with manual entries.

"Duplicate transactions"

If you've already recorded some transactions manually, the import might create duplicates. Review and delete duplicates if necessary.

Regular Import Workflow

For ongoing maintenance:

Monthly workflow:

  1. Download your monthly statement from broker

  2. Import into the platform

  3. Review the extracted data

  4. Confirm and verify

This keeps your records current with minimal effort.

Tips for Clean Imports

Use Consistent Statement Periods

Monthly statements are easiest. Avoid overlapping date ranges that might create duplicates.

Download Soon After Period Ends

Statements are most accurate right after the period closes.

Keep Original Files

Save the original statement files for your records in case you need to reference them.

Spot Check Results

After import, quickly verify a few transactions against the source statement.

Import is a time-saver, not a perfect solution. A quick review after import ensures accuracy.


Next: Understanding Your Balance History