There are a lot of things we needed to take into account when providing these numbers for you, e.g. the timezone and currency differences between NZ and the US. If you or your accountant needs to understand the nitty-gritty behind the numbers, here’s everything you need:

Corporate Actions

All corporate actions for holdings within the tax year.

Action Date (NZ): Date in NZT that the corporate action occurred

Symbol: The share market ‘code’ for the company or ETF (e.g. AAPL)

Type: Type of corporate action, e.g. 'symbol change', 'spin-off', 'stock split', or 'merger'.

Quantity of Shares: The number of shares affected. Note: It will be 0 for a symbol change.

Share Price (USD): Share price in USD. This may be 0 for some actions.

Notional Value (USD): Total USD value (number of shares * share price) of the affected shares. This may be 0 for some actions.

FX Rate: An inverse of the NZD to USD rate for the corporate action date rounded to 10 decimal places. If a rate is missing from the Reserve Bank spreadsheet (e.g. on weekends), the previous day’s rate is used.

Share Price (NZD): Share Price (USD) * FX Rate

Notional Value (NZD): Notional Value (USD) * FX Rate

Action Description: Description of the action sent through from DriveWealth (they can be a bit ugly!)

Dividends

A list of dividends received during the tax year. This includes dividends from the money market fund and shares.

Date Received (NZ): Date (in NZT) the dividend was paid to your Hatch account

Symbol: The share market ‘code’ for the company or ETF (e.g. AAPL)

Gross Dividend (USD): Pre-tax dividend amount. 

Amount Received (USD): Amount received in your Hatch account

Withholding Tax Paid (USD): Amount of tax that was withheld by DriveWealth to cover your US tax obligations.

FX Rate: An inverse of the NZD to USD rate for the corporate action date rounded to 10 decimal places. If a rate is missing from the Reserve Bank spreadsheet (e.g. on weekends), the previous day’s rate is used.

Gross Dividend (NZD): Gross Dividend (USD) * FX Rate

Amount Received (NZD): Amount Received (USD) * FX Rate

Withholding Tax Paid (NZD): Withholding Tax Paid (USD) * FX Rate

Description:  Description of the dividend sent through from DriveWealth (these can be ugly!)

End Of Year Positions: Holdings in your Hatch account at 31 March 2019

Date (NZ): Last day of the tax year

Symbol: Share market ‘code’ for the company or ETF (e.g. AAPL)

Type: Type of shares, e.g. 'Company', ‘ETF, 'Money Market Fund', 'ADR'

Quantity: The number of shares held when the market closed on the last day of trading in the tax year.

Share Price at 31 March (USD): Closing share price on the last day of trading in the tax year.

Market Value at 31 March (USD): Closing market value (USD) on the last day of trading in the tax year (Quantity * Share Price), at 31 March

Average cost price per share (USD): The average price paid to purchase each share, inclusive of brokerage fees.

Total cost price (USD): The total price paid to buy shares, inclusive of brokerage fees.

FX Rate: An inverse of the NZD to USD rate for the corporate action date rounded to 10 decimal places. If a rate is missing from the Reserve Bank spreadsheet (e.g. on weekends), the previous day’s rate is used.

Price (NZD): Price (USD) * FX Rate

Market Value (NZD): Market Value (USD) * FX Rate

Description: Description of the dividend sent through from DriveWealth (these can be ugly!)

Trades: All your buys and sells of shares made during the tax year.

Date (NZ): The date in NZ that the trade was executed.

Side: Buy or sell.

Symbol: Share market ‘code’ for the company or ETF (e.g. AAPL)

Quantity: The number of shares that were traded

Price (USD): Average price of the shares bought or sold

Notional Value (USD):  Quantity * Price

Brokerage Fees (USD): Brokerage fees paid for the trade

FX Rate: An inverse of the NZD to USD rate for the corporate action date rounded to 10 decimal places. If a rate is missing from the Reserve Bank spreadsheet (e.g. on weekends), the previous day’s rate is used.

Price (NZD): Price (USD) * FX Rate

Notional Value (NZD): Notional Value (USD) * FX Rate

Brokerage Fees (NZD): Brokerage Fees (USD) * FX Rate

Did this answer your question?