Statements2Excel

Interactive Brokers → QuickBooks

Convert a Interactive Brokers activity statement PDF to QuickBooks

IBKR activity statements are dense and multi-section by design. The dated activity converts to clean rows; the sections that aren't a ledger are left where they are rather than mangled into one. Every row is checked against the running balance before you get the file, so the figures reconcile instead of just looking plausible.

3 pages free· then $3 an activity statement· no account, no card

All pricing →

Convert your Interactive Brokers activity statement

3 pages free. No account, no card.

Your file is deleted after processing — we keep no copy. What we do with it.

What you get

Your statement, already reconciled

Left, the text as it comes out of a statement PDF. Right, the sheet you download — same figures, in columns, each one checked against the balance the bank printed.

december-statement.pdf
STATEMENT OF ACCOUNT    Page 1 of 3
BALANCE BROUGHT FORWARD    1,250.50
03DEC25 TESCO STORES 4821 GB
               42.10-      1,208.40
05DEC25 ACME LTD SALARY
            2,400.00       3,608.40
09DEC25 BRITISH GAS   DD
              118.62-      3,489.78
14DEC25 TFL TRAVEL CH
               38.40-      3,451.38
21DEC25 CARD PAYMENT REF 90
              560.00-      2,891.38
31DEC25 INTEREST PAID
                1.24       2,892.62
BALANCE CARRIED FORWARD    2,892.62
statement.xlsx
datedescriptionamount balancechecked
2025-12-03Tesco Stores 4821-42.101,208.40
2025-12-05Acme Ltd salary+2,400.003,608.40
2025-12-09British Gas DD-118.623,489.78
2025-12-14TfL travel charge-38.403,451.38
2025-12-21Card payment ref 90-560.002,891.38
2025-12-31Interest paid+1.242,892.62
6 rows checked against the running balance · closing variance 0.00

Get the PDF

Where Interactive Brokers keeps your activity statement PDF

The exact path through Interactive Brokers.

  1. 1Log in to the IBKR Client Portal.
  2. 2Select Performance & Reports along the top, then Statements.
  3. 3Choose the account, the period and the statement type (Activity is the one with the dated transactions).
  4. 4Set the format to PDF and select Download. Very large statements are queued under Batch Reports.

Convert it

Turning that PDF into QuickBooks

  1. 1Download the PDF Take the Interactive Brokers activity statement using the steps above.
  2. 2Upload it here One statement or a multi-page month — the first 3 pages convert free, with no account.
  3. 3Check the rows, then download You see the extracted rows and the balance check before paying for anything. An ofx file you can import straight into quickbooks, with date, description, amount and balance.

Then import it

Getting the Interactive Brokers rows into QuickBooks

The conversion is half the job. This is the other half.

  1. 1In QuickBooks Online, open Transactions, then Bank transactions.
  2. 2Select the account, then 'Link account' → 'Upload from file' (on an already-connected account, use the dropdown beside 'Update').
  3. 3Upload the .ofx file you downloaded here and pick the account it belongs to.
  4. 4Review the imported rows in For Review, then accept them. QuickBooks matches anything it already knows about, so previously-recorded transactions won't double up.

Your file

What happens to the activity statement you upload

You're handing a financial document to a website you found through a search result. Here is exactly what it does with it.

Retention
60 minutes. Your PDF and the spreadsheet built from it are deleted on a timer, whether you download or not.
Accounts
None. No signup, no password, no email required to convert or to pay.
Where it runs
One server in London. PDFs are parsed there; the text isn't handed to an outside service.
If it's wrong
14 days, refunded. And you see the extracted rows before you're asked for money.

Questions

Interactive Brokers activity statements, specifically

How do I convert a Interactive Brokers activity statement to QuickBooks?

Upload your Interactive Brokers activity statement PDF, and LedgerLift returns an OFX file you can import straight into QuickBooks with date, description, amount and balance columns — usually in seconds.

Can I export my Interactive Brokers activity statement to QuickBooks?

Yes. Interactive Brokers doesn't export to QuickBooks directly, so download the activity statement as a PDF and convert it here — no manual copying.

How do I download my Interactive Brokers activity statement as a PDF?

Log in to the IBKR Client Portal. Select Performance & Reports along the top, then Statements. Choose the account, the period and the statement type (Activity is the one with the dated transactions). Set the format to PDF and select Download. Very large statements are queued under Batch Reports. Then upload it here.

What does it cost to convert a Interactive Brokers activity statement?

The first 3 pages are free and need no account. Past that it's $3 to unlock the statement you just converted, which also leaves you credit towards the next one. Full pricing.

Is it accurate?

The extracted rows are re-added and compared against the running balance printed on the activity statement. If the two agree, the figures are arithmetically sound; any row that can't be resolved confidently is flagged in the preview rather than quietly guessed at.

Is my data secure?

Your PDF is deleted automatically after processing and we keep no copy. There's no account to create, and we never sell, share or train on financial data.

Which Interactive Brokers accounts are supported?

Interactive Brokers activity statements for any account type. The dated activity converts; position and summary sections are left alone. Multi-page documents are fine.