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):

CSV column	Maps to	Notes
Holding name / Ticker	Holding name	One row per ETF/share
Opening market value (NZD)	Opening Market Value (1 April)	Already converted to NZD
Closing market value (NZD)	Closing Market Value (31 March)	Already in NZD
Dividends received (NZD)	Gross Dividends Received	Gross of US 15% withholding
Purchases during year (NZD)	Purchases During Year	All buy-side cash flows
Sales during year (NZD)	Sales Proceeds During Year	All sell-side proceeds (gross)
Quick-sale adjustment (NZD)	Quick-Sale Adjustment	Pre-computed when buys and sells in same holding occurred — leave 0 if Sharesies didn’t compute one
Original cost (NZD)	Cost Basis (NZD)	Sum of all historical purchase costs in NZD

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:

Hatch CSV column	Maps to	Notes
Symbol / Description	Holding name
Market Value Start of Year (NZD)	Opening Market Value
Market Value End of Year (NZD)	Closing Market Value
Total Distributions (NZD)	Gross Dividends Received	Includes ETF distributions, not just dividends
Total Buys (NZD)	Purchases During Year
Total Sells (NZD)	Sales Proceeds During Year
Cost Basis (NZD)	Cost Basis	Used for de minimis test
QSA (NZD)	Quick-Sale Adjustment	Hatch computes this when same-year buys + sells occur

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 — Calculating your FIF income or loss (FDR, CV, cost, DRR)
• IRD — IR461 Foreign Investment Fund Return (QSA worksheet)
• IRD — Foreign currency conversion rates