Skip to main content

How to Enter Betashares Direct Annual Tax Statement Components in Navexa

Learn how to request Betashares Direct tax components by ETF and manually enter the relevant annual totals into Navexa's AMIT Statement form.

This guide is specifically for Betashares Direct
Betashares Direct provides tax data differently from a standard ETF issuer AMIT statement. If you hold ETFs through Betashares Direct, use the process in this guide rather than the general AMIT statement instructions.

If your AMIT statement came directly from an ETF provider such as Vanguard, Betashares, Global X or another fund manager, use our standard AMIT statement guide instead.

Betashares Direct provides one consolidated Annual Tax Statement covering the investments in your account.

However Navexa records AMIT tax components against each individual ETF or managed fund holding. This means you cannot enter the consolidated Betashares Direct totals against a single holding.

You will need to request Betashares Direct's detailed CSV, calculate the annual totals for each ETF symbol separately, then enter those totals into the matching holding in Navexa.


Before You Start

You will need:

  • Your Betashares Direct Annual Tax Statement for the relevant financial year.

  • The detailed Betashares Direct tax-component CSV broken down by symbol and ex-date.

  • Your Betashares Direct trades already recorded in Navexa.

Important: The detailed Betashares CSV cannot be uploaded through Navexa's AMIT PDF importer. You use the CSV to calculate the figures, then enter them manually.


Step 1: Request the Detailed CSV From Betashares Direct

Your normal Betashares Direct Annual Tax Statement combines the tax components for all applicable investments in your account.

On the Betashares Direct Annual Tax Statement go to Part C. Betashares Direct notes that detailed tax components are available on request.

You need to contact Betashares Direct through its in-app support and request:

Tax components broken down by symbol and ex-date.

Betashares Direct will provide this as a CSV file.

Their CSV normally contains one row for each distribution, followed by a large number of tax-component columns.


Step 2: Work on One ETF Symbol at a Time

Each ETF needs its own annual totals in Navexa.

For example, if your CSV contains:

  • A200

  • BGBL

  • ARIA

you must calculate one set of totals for A200, another for BGBL, and another for ARIA.

Do not combine all the different ETFs together. Do each ETF separately.

Tips to make this easier

Filter by symbol

In the CSV, filter the symbol column so that only the ETF you are working on is visible.

For example:

ARIA

Use the ex-date to determine the financial year

Use the distribution's ex-date, not its payment date, when deciding which financial year it belongs to.

This is important around 30 June.

A distribution may have an ex-date in June but not be paid until July. For tax reporting, it still belongs to the financial year containing the ex-date.

Be careful when totalling filtered rows

When you filter the CSV to one ETF, make sure your totals include only the visible rows for that ETF.

In Excel, a normal SUM formula can still include rows hidden by a filter. This could accidentally include tax components from your other ETFs.

Excel tip: If you are totalling a filtered column, use SUBTOTAL rather than SUM, for example:

=SUBTOTAL(9, range)

Alternatively, copy the rows for the ETF you are working on into a separate worksheet before calculating the totals.

Before entering anything in Navexa, check that every row included in your calculation belongs to the same ETF symbol and financial year.

Do not use the account TOTAL row for an individual ETF.
If your CSV contains a TOTAL row, it combines data across your Betashares Direct account. Navexa needs the totals for each ETF separately.


Step 3: Open the AMIT Statement Form in Navexa

Once you have calculated the annual totals for one ETF:

  1. Open Tax Reporting.

  2. Select Taxable Income.

  3. Choose the relevant financial year.

  4. Scroll to Trust Income.

  5. Find the ETF you are working on.

  6. Select Enter AMIT Statement or Update AMIT Statement.

  7. Select Enter manually.

Navexa will open the Add AMIT Statement Data form.

Your Betashares Direct CSV contains the source figures. In the next steps, we’ll show you exactly which CSV fields correspond to each row in this form.

The key thing to remember: you are entering the annual total for this ETF into the Net Amount column. You do not enter the individual distribution amounts shown to the right.

Visual mapping guide

Use the guide below as a quick reference while entering your figures. It shows:

  • which Betashares CSV field maps directly to each Navexa row

  • which CSV fields need to be added together

  • which values Navexa calculates automatically

  • which Navexa fields should be left blank

📎 Download the Betashares Direct CSV → Navexa AMIT fields quick reference (PDF): betashares-direct-csv-to-navexa-amit-fields.pdf


Step 4: Enter the Trust Income Components

Betashares CSV column

CSV heading

Navexa field

What to enter

O

part_a_13u

Share of non-primary production income (13U)

Total column O for this ETF

P

part_a_13c

Franked distributions from trusts (13C)

Total column P for this ETF

Q

part_a_13q

Share of franking credits from franked dividends (13Q)

Total column Q for this ETF

R

part_a_13r

Share of credit for TFN amounts withheld (13R)

Total column R for this ETF

Use the total for the individual ETF only.

Do not use the consolidated Betashares Direct account total.


Step 5: Enter the Capital Gains Components

This is the part most likely to cause confusion.

The Betashares CSV spreads the capital-gain information across several columns.

Navexa requires you to combine those columns into three entry fields.


Capital Gains - Discounted Method

Add:

tap_discounted_capital_gains_trusts

plus

ntap_discounted_capital_gains_trusts

These are columns AM + AN.

Enter the result into: Capital Gains - Discounted Method


Capital Gains - Other Method

Add all six columns from AO through AT:

CSV heading

tap_other_capital_gains_trusts

ntap_other_capital_gains_trusts

tap_indexed_capital_gains_trusts

ntap_indexed_capital_gains_trusts

ncmi_capital_gains_trusts

exncmi_capital_gains_trusts

Enter the combined result into: Capital Gains - Other Method


CGT Concession (AMIT CGT gross up)

For this Betashares Direct CSV workflow, enter the same total that you entered under Capital Gains - Discounted Method.

You can also check this amount by calculating: 18H − 18A


Do not enter 18A or 18H yourself

You do not manually enter:

  • Net Capital Gain (18A)

  • Total Current Year Capital Gain (18H)

Navexa calculates these from the capital-gain components above.

Use the Betashares CSV values as a reconciliation check:

Betashares CSV column

CSV heading

What it should match

S

part_a_18a

Navexa's calculated Net Capital Gain (18A)

T

part_a_18h

Navexa's calculated Total Current Year Capital Gain (18H)

Capital gains reconciliation

Once you have entered the three capital-gain fields:

Navexa 18A should match Betashares column S.

Navexa 18H should match Betashares column T.

If they do not match, stop and check your calculations before saving.

The most common causes are:

  • Other ETF symbols were accidentally included in your totals.

  • A normal Excel SUM formula included filtered-out rows.

  • One or more of columns AM through AT were missed.

  • The discounted capital-gain amount was not also entered as the CGT Concession.

  • The wrong financial-year rows were included.


Step 6: Enter Foreign Income

Betashares CSV column

CSV heading

Navexa field

U

part_a_20e

Assessable foreign source income (20E)

V

part_a_20m

Other net foreign source income (20M)

X

part_a_20o

Foreign income tax offset (20O)

Be careful with column W

Column W is:

part_a_20f

It is not the Foreign Income Tax Offset.

Always check the CSV heading instead of relying only on the spreadsheet column position.

If part_a_20f contains an amount, see What to Do if Your AMIT Statement Includes 20F before entering your statement.


Step 7: Enter the AMIT Cost-Base Adjustments

Betashares CSV column

CSV heading

Navexa field

BH

cost_base_increase_amount

AMIT Increase (AMIT Shortfall)

BI

cost_base_decrease_amount

AMIT Decrease (AMIT Excess)

Enter the annual total belonging to that ETF only.

These amounts may be small, but they are important. They adjust the holding's cost base and can affect the capital gain calculated when you eventually sell the investment.

Do not estimate or apportion a consolidated Betashares amount between ETFs.


Step 8: Leave These Three Navexa Fields Blank

The Betashares Direct CSV may contain values under:

Betashares CSV column

CSV heading

Navexa field

What to do

BK

tax_deferred_amount

Tax Deferred

Leave blank

BG

non_assessable

Non Assessable

Leave blank

AC

interest_trusts

Interest

Leave blank

Do not enter these values separately for this Betashares Direct CSV workflow.

Although the CSV column names look similar to fields in Navexa, these amounts are already represented elsewhere in the components you have entered.

Why is interest_trusts left blank?

The trust interest amount is already included in the trust income reported through:

part_a_13u which you entered as: Share of non-primary production income (13U)

Entering interest_trusts again into Navexa's Interest field would count that income twice.

Why are tax_deferred_amount and non_assessable left blank?

The relevant cost-base movements are already captured through:

cost_base_increase_amount

and

cost_base_decrease_amount

which you entered under: AMIT Increase and AMIT Decrease.

Entering the tax-deferred or non-assessable figures again into similarly named Navexa fields can double-count the same adjustment.

For this Betashares Direct workflow: leave Tax Deferred, Non Assessable and Interest blank even if the CSV contains amounts in those columns.


Step 9: Save and Check the Holding

Before selecting Save Updated Distributions, check the annual totals for the ETF.

In particular:

18A in Navexa = column S part_a_18a for that symbol

and

18H in Navexa = column T part_a_18h for that symbol

If both match, your capital-gain mapping is a strong indication that you have entered the components correctly.

Then select Save Updated Distributions.

Repeat the process separately for every applicable ETF in your Betashares Direct account.


Why Individual Distribution Rows May Look Different

Navexa takes the annual totals you enter and allocates those tax components across the distributions already recorded against that ETF for the financial year.

Because of this, the amounts shown against an individual distribution row in Navexa may not exactly match an individual row in the Betashares CSV.

That is not necessarily a problem.

The important comparison is the annual total for the individual ETF.

Compare:

Navexa's annual total for GARP

with

the total of the GARP rows in the Betashares CSV

Do not compare one ETF against the consolidated total from the original Betashares Direct Annual Tax Statement.


Example: Capital Gains

Suppose the detailed CSV for one ETF contains two distribution rows.

After adding the relevant columns, you calculate:

Discounted capital gains

$2.62 + $47.98 = $50.60

Other capital gains

$15.92 + $291.94 = $307.86

You would enter:

Navexa field

Amount

Capital Gains - Discounted Method

$50.60

Capital Gains - Other Method

$307.86

CGT Concession (AMIT CGT gross up)

$50.60

Navexa should then calculate:

18A

$50.60 + $307.86 = $358.46

and:

18H

$358.46 + $50.60 = $409.06

You can compare those calculated figures against:

  • Column S part_a_18a

  • Column T part_a_18h

If the Betashares CSV also reports $358.46 and $409.06, the capital-gain section reconciles.


What Not to Enter in the AMIT Form

The AMIT form is for ETF, managed fund and trust distribution tax components.

Do not use it to record:

  • Dividends from individual company shares held through Betashares Direct.

  • Interest paid on your Betashares Direct Cash Wallet.

  • Capital gains or losses from selling ETF or share units.

Those are recorded separately in Navexa.

This information explains how to record data in Navexa. It is general information and does not constitute personal taxation or financial advice. If you are unsure how the Betashares statement applies to your tax position, contact Betashares Direct, the ATO or a registered tax adviser.

Did this answer your question?