FIF Calculator NZ

Guide

FIF and Interactive Brokers: statements, currencies and your IR3

In short: We found no Interactive Brokers page offering a New Zealand FIF report, so IBKR users usually build their FDR and CV figures from activity statements. Use a 1 April to 31 March custom period, and convert from the original currency at Inland Revenue accepted rates rather than relying on the statement's base currency figures.

Interactive Brokers is built for investors in many countries, and its statements are detailed but not shaped around the New Zealand tax year or the FIF rules. We could not find any IBKR page that offers an NZ FIF report. That means pulling the right statement for the right dates, converting each currency correctly, and doing the FDR and CV arithmetic yourself or with a tool. This guide shows how.

What IBKR gives you

IBKR's Client Portal guide to statements (last updated 8 October 2025, read 12 November 2026) says activity statements can be produced daily, monthly or yearly, and that you can create and save custom statements and set up flex queries for delivery. It gives these limits:

StatementHow far back (IBKR guide)Use for FIF
DailyFour previous calendar years plus the current yearPositions and prices on 31 March and 1 April
Custom date rangeFour previous calendar years plus the current yearTrades, dividends and withholding for 1 April to 31 March
MonthlyFive previous yearsCross-checks
AnnualFive previous years; available "by January 31"Not the NZ tax year (see below)

The guide says older statements can be obtained for a processing fee. That alone is a reason to download each year's statements as the year ends. All of this is from one IBKR page, so check the current guide before relying on the limits.

IBKR's annual statements being available by 31 January suggests they follow the calendar year. That is our inference. The New Zealand income year runs from 1 April to 31 March for most people, so a custom date range is the safer choice.

What we did not find: any IBKR page offering an NZ FIF report or FDR and CV figures. A third party calculator site says IBKR does not provide NZ FIF reporting; that is not IBKR's own statement, so treat it as UNVERIFIED.

Why the base currency figures may not match

Every IBKR account has a base currency. According to IBKR knowledge base and glossary entries we saw only in search summaries (UNVERIFIED), statements translate balances in other currencies into the base currency for reporting, without converting the cash, at the rate at the close of the period. So even with an NZD base currency, the NZ dollar values on an IBKR statement come from IBKR's rates, not Inland Revenue's.

For FIF, Inland Revenue lets you use either the actual rate on the day or the rolling 12-month average, one method for every holding (IR461 p13). Inland Revenue accepts its own mid-month rate as an actual rate for that month (IR461 p13 note). IBKR's close of period rate might be close to an actual rate for a year end valuation, but you cannot easily show that, and it will not match Inland Revenue's published figures. The cleanest record is to take each amount in its original currency from the statement and convert it yourself at an Inland Revenue rate. Our exchange rates tool has the end-of-month, mid-month and rolling rates for 17 currencies.

This is also why people with IBKR and an NZ platform often find that "my IBKR NZD figures don't match". Neither is necessarily wrong; they were converted at different rates.

Worked example: two currencies, two rate methods

Say at 1 April 2025 you held US shares worth US$50,000 and UK shares worth £20,000 at IBKR, your total NZ dollar cost was over $50,000, and you made no trades in 2025/26. FDR income is 5% of the opening value in NZ dollars.

HoldingForeign valueIRD rateNZ$ valueFDR at 5%
US shares, actual rateUS$50,0000.5710 (end of March 2025)87,565.674,378.28
UK shares, actual rate£20,0000.4406 (end of March 2025)45,392.652,269.63
Total, actual rate132,958.326,647.92
US shares, rolling averageUS$50,0000.5929 (to 15 March 2025)84,331.254,216.56

On the actual rate method your FDR income is $6,647.92. With $120,000 of other income, the extra tax is $2,193.51 at 33%, before credits.

The last row shows how much the method matters: the same US$50,000 is worth $3,234.42 less on the rolling average, and FDR income is $161.72 lower. That does not mean you should pick whichever is lower each year. You choose one method for all holdings, and once you use the rolling average you must keep using it (IRD currency page, 4 November 2026). Our calculator applies the opening value of a rolling average year at the previous year's average, which is our reading of ITA s EX 51(5); see the methodology.

From IBKR statements to our calculator

Our calculator does not import IBKR files yet. You type each holding in its own currency:

Calculator fieldWhere in IBKR
Shares and value at 1 AprilOpen positions on a daily statement for 31 March (the start of 1 April), in the security's currency
Value at 31 MarchOpen positions on a daily statement for 31 March of the following year
TradesTrades section of a custom 1 April to 31 March statement, with commissions included in the amounts
Dividends and foreign taxDividends and withholding tax sections of the same statement
Cost for the $50,000 testEach purchase converted to NZ dollars at the time, summed with your other platforms
Exchange rate methodIRD rates or the rolling average, the same for every holding

We have not tested IBKR's section names against a real statement, and IBKR's guide says activity statements can be customised to include or exclude sections, so look for the closest match in yours. If you have a year when nothing was traded, the job is short: two valuations per holding and the dividend list. Save each statement you download with the tax year in the file name, because older ones may cost a fee to retrieve. If you bought and sold the same share within the year, the quick sale adjustment may apply; enter every trade in the FDR calculator and it will apply last in, first out matching across the portfolio as the Act requires (ITA s EX 52(7) to (14)).

Foreign tax, ASX shares and other markets

  • US dividends. The NZ credit is capped at the treaty rate and at the NZ tax on that company's FIF income (IR461 p20). See foreign tax credits.
  • UK dividends. IR461 p20 says tax paid on dividends from the United Kingdom is not eligible for a credit.
  • ASX shares. Qualifying ASX-listed Australian companies are exempt from the FIF rules and their cost stays out of the $50,000 test (IR461 p7). Most ASX ETFs are not covered by that exemption. See the ASX guide.
  • Interest on cash. Bank balances and similar are not FIFs (IR461 p4); interest is reported under the ordinary rules.

Filing your IR3

FIF income from all your platforms goes in box 17B as part of total overseas income, the credit in box 17A, and an IR1261 overseas income summary goes with the return (IR3G pp19 and 22). You can list FIF income by country, or group it all under "overseas" if you keep a supporting report (IRD, Reporting your overseas income, 29 May 2026). Your IBKR statements plus a printed summary of the calculation make that report. Many IBKR users have larger portfolios, so FIF tax often pushes residual income tax over $5,000, which brings in provisional tax for the next year (IR3G p51); see FIF and provisional tax.

This guide is general information, not tax advice; check with your accountant, especially for non-ordinary shares, options, or holdings in a company or trust. Rules checked 12 November 2026.

Questions

Does Interactive Brokers give a New Zealand FIF report?

We found no IBKR page offering one (checked 12 November 2026). Most NZ investors build the figures from activity statements, by hand or with a tool.

Can I use the NZD figures from my IBKR statement?

They are converted at IBKR's rates, not Inland Revenue's. Converting each original currency amount at an Inland Revenue accepted rate is easier to defend and keeps every platform on the same method.

Should I use the IBKR annual statement?

IBKR annual statements appear to follow the calendar year. For the NZ year, run a custom 1 April to 31 March statement and daily statements for the valuation dates.

I hold the same ETF on IBKR and another platform. Can I add their FIF figures?

Only with care. The quick sale adjustment is worked out on totals across your whole portfolio, so if you traded on both, enter all trades together.