Sharesies & Hatch FIF Reports: How to Read the CSV for Your IR3 (2025-26)

If you hold US-listed shares or ETFs through Sharesies or Hatch and your total cost basis exceeds NZ$50,000, you cross into the Foreign Investment Fund (FIF) regime and need to file an IR3. Both platforms provide end-of-year reports that map directly into the IR3 FIF schedule — but the field names and CSV layouts differ. This guide walks through both.

Step 1: Confirm you actually need FIF

Before downloading anything, check whether FIF even applies. The de minimis rule means:

• Total cost basis (NZD) of all your FIF interests ≤ $50,000 → FIF does not apply. You pay tax on dividends actually received as normal overseas income on your IR3 — that’s it.
• Cost basis > $50,000 → FIF applies. You must pick FDR or CV for the year and report deemed income.

The threshold uses historical purchase cost in NZD, not current market value. A $40k portfolio that’s grown to $90k is still under the threshold.

ASX-listed Australian-resident shares are usually exempt from FIF (see ASX Shares FIF Exemption) and don’t count toward the $50k threshold either.

Step 2: Download the Sharesies end-of-year report

In the Sharesies web app:

1. Go to Profile → Tax (or Investing → Tax depending on app version)
2. Select the relevant tax year (1 April YYYY – 31 March YYYY+1)
3. Download the “Investor tax certificate” PDF and the “FIF report” CSV

The Sharesies FIF CSV typically contains these columns (names may vary by report version):

Drop these directly into the FIF Tax Calculator — one row per holding.

Step 3: Download the Hatch tax report

In Hatch:

1. Go to Reports → Tax
2. Pick the NZ tax year (1 April – 31 March)
3. Download the “FIF / Foreign Investment Fund Report” PDF + CSV

Hatch’s CSV columns are similar but use slightly different names:

If you traded actively (buying and selling the same ticker in one tax year), pay particular attention to the QSA — it can add 5% of cost basis to your FDR income that you’d otherwise miss.

Step 4: Worked example — Apple (AAPL) via Hatch

Suppose you held AAPL via Hatch all year:

• Opening 1 April market value: NZ$25,000
• Bought another NZ$5,000 in August
• Closing 31 March: NZ$34,000
• Dividends received: NZ$300
• No sales

This single holding’s cost basis is NZ$22,000 (your original purchase) + NZ$5,000 (August) = NZ$27,000.

If this is your only FIF holding, you’re under the $50,000 de minimis. You pay NZ tax on the $300 dividend at your marginal rate. FIF doesn’t apply. Done.

If AAPL is one of several FIF holdings totalling $60,000 cost basis combined:

• FDR: 5% × $25,000 opening = $1,250 deemed income. Plus QSA if any same-year sales occurred (none here, so QSA = 0).
• CV: $34,000 closing − $25,000 opening − $5,000 purchases + $300 dividends + 0 sales = $4,300 deemed income.

FDR wins by $3,050. At a 33% marginal rate that’s $1,007 tax saved by electing FDR for the year — across all your holdings, since the election is portfolio-wide for the year.

Step 5: Watch for these common mistakes

• Using market value for the de minimis test. The threshold is historical NZD cost, not current value.
• Forgetting Hatch → Sharesies transfers. When you transfer in-kind, the cost basis is preserved — don’t reset it to the transfer-date market value.
• Mixing FDR and CV across holdings. Individuals must apply the same method to all FIF holdings within a year. You can switch between years, not within.
• Skipping the QSA. If you bought and sold the same ticker in the same year, the QSA can materially change FDR — both Sharesies and Hatch usually pre-compute it; if the field is missing, ask the platform.
• Using gross USD figures instead of NZD. Both Sharesies and Hatch convert to NZD. If you do your own FX (e.g. spreadsheet aggregation), use IRD-published rates for consistency.
• Including Australian-resident exempt shares. CBA, BHP, CSL etc. on ASX are usually exempt and should NOT appear in the FIF schedule. Check the ASX exemption checker first.

Step 6: Drop it into the calculator

Once you have the Sharesies + Hatch CSV rows for each FIF holding, paste each one into a separate row in the FIF Tax Calculator. The calculator will:

• Sum cost basis across all holdings to test the $50,000 de minimis
• Compute FDR and CV for each holding plus the portfolio total
• Pick the lower-tax method (FDR or CV) for individuals/trusts
• Force FDR if you select “Company” entity type
• Show estimated tax assuming you specify other annual income

For a deeper dive into when each method wins, see FDR vs CV FIF Method Comparison.

Sources

• IRD — Foreign Investment Funds
• IRD — Calculate FIF income or loss
• IRD — IR461 Foreign Investment Fund Return (QSA worksheet)
• IRD — Foreign currency conversion to NZ dollars