Transactions

Transactions represent the events that can occur while owning shares. Most of these relate to tax, but can also include other events that can occur in your brokerage account, such as fees and withdrawals, so that balances can be calculated for debugging and understanding the data.

Common Fields

All transactions share some common fields:

Type: the type of transaction
Account: the account the transaction was made in
Note: a note about the transaction
Tax exempt: whether the transaction is tax exempt. Note that when a transaction is marked as tax exempt it is ignored completely and no derivative transactions are created.

Transaction Types

Transactions are grouped into a few different categories:

Trades

Types: Buy Trade, Sell Trade

Date: the date the transaction was made
Base asset and quantity: The asset and quantity being sold for a sell and the asset being bought for a buy.
Consideration: The asset and quantity received for a sell and paid for a buy.
Fees: the asset and quantity of any allowable fees paid.
Transaction tax: the asset and quantity of any transaction tax paid.

Attributed Income

Types: Dividend, Notional Dividend, Interest, Interest Paid, Notional Interest, Interest Paid

Attributed income is all income paid to you by an underlying asset. Notional interest and dividends should be used for the income you are treated as being received by accumulating funds. Interest paid is treated in the same way as a fee and is not deducted from taxable income. Notional dividends will increase the cost basis of the underlying asset.

Date: the date the distribution is treated as taxed, e.g. pay date
Ex-date: the date which before the investor is entitled to a distribution. It does not impact Dividends or Interest, but impacts at what point any notional distribution is accounted for in a disposal.
Underlying asset: the source of the distribution
Distribution: the asset and quantity of the distribution received or treated as received
Fees: the asset and quantity of any allowable fees paid
Withholding tax: the asset, quantity, and country of any withholding tax paid or treated as paid

Unattributed Income

Types: Broker Interest, Broker Interest Paid

The broker interest types represent interest received or paid when there is no underlying asset. Interest paid is treated in the same way as a fee and is not deducted from taxable income.

Date: the date the interest is received or paid
Interest: the asset and quantity of the interest received or paid
Withholding tax: the asset and quantity of any withholding tax paid
Source Country: the country in which the interest arises and which withheld any tax paid

Equalisation

Equalisation is a return of capital that you paid for any accrued, but not distributed income at the time you purchased the asset. The equalisation 'transaction' is an attribution of income that you received or are treated as received. For any equalisation event, there needs to exist an income event (ERI, dividend, interest - notional or real) with matching dates as described below.

The system does not automatically apportion or calculate equalisation and the manner you can control how it's apportioned is by creating events that match the income or ERI events that you want to offset.

Date: the date of the equalisation. For equalisation for an income event, this is the same as the income event date. For equalisation for an ERI event, this is the distribution date.
Ex-date: the date that matches the income event ex-date or for ERI, the period end date.
Equalisation: the asset and quantity of the equalisation. The asset must be the same as the income or ERI the equalisation is apportioned to.

Types: Split, Reverse Split, Bonus Issue

The share reorganisations types are for share reorganisations that do not trigger a taxable event (save for any cash distributed as part of the reorganisation). Any cash you received due to fractional shares needs to be added as a separate capital distribution transaction.

You may enter a share reorganisation as multiple transactions and ShareCalc will aggregate the quantity changes. For example in a 2 for 1 split:

Broker Account 1: Net long 100 shares, add a split with a quantity of 100 (100 shares are split into 200)
Broker Account 2: Net short 50 shares, add a split with a quantity of -50 (50 short shares are split into 100)

Your net position before the split is 50 shares and after the split is 100 shares, reflecting the sum of 50 aggregated across the Split events.

Fields:

Date: the date the reorganisation is made and is treated as made at the beginning of the day, prior to any trades.
Underlying Asset: The asset being reorganised
Quantity Change: The change in quantity of the asset held as a result of the reorganisation. For a split and bonus issue it is the increase in shares and for a reverse split it is the decrease in shares. This is a positive number when you are net long and a negative number when you are net short.
Ratio: The ratio of the reorganisation in the form "out shares:in shares". The numbers can be decimals and can represent the headline ratio or the ratio of the actual change in your shares. For example: "2:1" for a 2 for 1 split, and "1:5" for a 1 for every 5 reverse split.

Capital Distribution

The capital distribution represents a return of capital and will be treated as a part disposal of the underlying asset. Where the distribution qualifies, it will be treated as a small disposal.

Date: the date the distribution is treated as taxed, e.g. pay date
Underlying asset: the source of the distribution
Distribution: the asset and quantity of the distribution received or treated as received

Withdrawal and Deposits

The withdrawal and deposit types are for any withdrawals and deposits from your brokerage account and generally are only there for balance purposes. The one exception is when you hold currency as a debt and deposit or withdraw from your account, then it will be treated as a disposal or acquisition of that currency debt. If this is not the correct behaviour, for example if you are moving assets between accounts at the same financial institution, then marking the transaction as tax exempt will prevent the disposal or acquisition from being created.

Date: the date the withdrawal or deposit is made
Amount: the asset and quantity of the withdrawal or deposit
Fees: the asset and quantity of any fees paid. These are not included in any generated disposals or acquisitions.

Fee

Fees are used to ensure balances are correct and where a chargeable asset is used to pay the fee, then it will be treated as a disposal of that asset.

Date: the date the fee is paid
Fee: the asset and quantity of the fee paid

Symbol Change

There is no system type for a symbol change, but you can manually change the symbol on the asset and add the old assets as an alias if you want to make it easier to import data with both the old and new symbols or ISINs.