FIFtax
Calculator

Interactive Brokers (IBKR) & NZ FIF Tax: Export Guide

If you invest through Interactive Brokers and hold overseas stocks or ETFs above the NZ$50,000 cost threshold, this guide shows the report to export and how to import it into the FIFtax calculator.

Use this report

Report:
Activity Statement CSV

Dates:
Full NZ income year, 1 April to 31 March

Import:
Choose IBKR in the calculator and apply the file

Broker UI last checked: May 2026. If IBKR changes labels, use the report name, CSV format, and date-range rules on this page rather than the exact menu wording.

Is FIF tax new to you?

Start with the FIF responsibility check and the NZ$50,000 threshold guide. FIF rules apply once your total cost of overseas shares and ETFs exceeds that threshold in an income year.

Which IBKR report do you need?

The FIFtax calculator needs opening values (1 April), closing values (31 March), and all transactions (buys, sells, dividends) for the income year. IBKR's Activity Statement CSV covers all of this in a single file.

Activity Statement CSV

IBKR's standard activity statement in CSV format. It includes your open positions for opening and closing values, trades, and cash transactions including dividends. Export one covering your full income year, 1 April to 31 March.

Step 1: Navigate to Activity Statement

  1. 1 Log in through Interactive Brokers at https://www.interactivebrokers.com/.
  2. 2 In the top navigation bar, click Performance and Reports.
  3. 3 Click Statements in the dropdown.
  4. 4 Click Activity Statement. A dialog appears with Period, Date, and download options.

Step 2: Set the period and download as CSV

  1. 1 The dialog opens with Period set to "Daily". Change it to Annual or Custom, whichever gives you a date range picker. You need the full NZ income year: 1 April to 31 March.
  2. 2 Set the date range to 1 April 2025 to 31 March 2026 for the 2025 to 2026 income year (or the equivalent dates for another year).
  3. 3 Click Download CSV. IBKR downloads a file named something like U1234567_20250401_20260331.csv.
Note: If you see a single Date field rather than a date range, the selected Period only covers one day. Switch Period to Annual or Custom first. The date fields will update to show a from/to range.

Step 3: Import into the FIFtax calculator

  1. 1 Go to the FIFtax calculator and select the correct income year.
  2. 2 Under How do you want to add data?, choose Import broker file, then choose Interactive Brokers (IBKR).
  3. 3 Click Choose File and select the Activity Statement CSV you downloaded.
  4. 4 A preview summary appears showing what was found: transactions, opening values, and closing values. Review the counts and any warnings.
  5. 5 Click Apply and add to calculator to populate the sections below. Review the rows, then click Calculate FIF Income.

What the calculator does with your data

Asset filtering: Only stock and ETF rows are imported. Futures, options, forex, and other non-equity positions are excluded because these are not ordinary FIF interests.

Opening values: The calculator reads the Mark-to-Market Performance Summary section of the Activity Statement. Positions held at the start of the statement period (prior quantity greater than zero) are imported as opening values, using the prior closing price per unit. If you had no holdings before 1 April, opening values will be empty. Add them manually in the calculator.

Closing values: Open Positions as of the statement's end date (31 March) are imported as closing values, in each position's local trading currency.

Transactions: All buys and sells from the Trades section are imported. Dividends are read from the Cash Transactions section. The calculator matches them to holdings by the ticker symbol at the start of the description field.

Currency: Values are imported in each position's local trading currency (e.g. USD for US stocks, GBP for UK stocks). The calculator fetches daily exchange rates from the Frankfurter API and converts everything to NZD. Supported currencies are USD, AUD, GBP, EUR, and CAD. Positions in other currencies will fall back to your account's base currency.

Multi-currency and multi-account notes

If you have multiple IBKR accounts (e.g. a personal account and a joint account), export and import each account's Activity Statement separately. Apply the first file, review the rows, then apply the second file. The calculator will merge the data.

IBKR reports positions in the currency of each individual stock (USD for US stocks, GBP for UK stocks, etc.), not your account's base currency. The FIFtax calculator handles multi-currency automatically.

Your data never leaves your browser

When you select an IBKR Activity Statement CSV, it is read and processed entirely within your browser using JavaScript. The file is never uploaded to FIFtax servers or any third-party service. Your account numbers, positions, transaction history, and values stay on your device. Exchange rate requests go to the Frankfurter API and contain only dates and currency codes, with no personal data.

Common issues

No opening values after import
Opening values come from the Mark-to-Market section's "Prior Quantity" field. If all your positions were opened during the statement period (i.e. you had no holdings before 1 April), prior quantity will be zero and no opening values are imported. Enter opening values manually in the calculator.
Dividends are missing or zero
IBKR dividend rows in the Cash Transactions section are matched to holdings by the first word of the description field (usually the ticker). If a dividend description is unusual, the row may be skipped. Check the warnings list in the import preview and add missing dividends manually.
"Could not recognise this file"
Make sure you are uploading the Activity Statement, not a performance report, tax report, or other statement type. Check that the "Source format" dropdown is set to Interactive Brokers (IBKR) before selecting the file.
Options, futures, or forex positions appear
The calculator filters to stocks only and excludes options, futures, and forex. If you see unexpected positions in the calculator after import, check that the holding names match stocks you actually hold.

Ready to calculate?

The calculator is free. No account required. Your data stays in your browser.

Open the FIFtax calculator
Disclaimer: This guide is for general information only. FIF tax treatment depends on your individual facts. Verify your results against the current IR461 guide or speak with a qualified tax adviser before filing.