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. It is the clean price for a gilt.
Fees: the asset and quantity of any allowable fees paid.
Transaction tax: the asset and quantity of any transaction tax paid, which can be treated as an allowable cost.
Open/close: The open and close flags indicate whether a trade opens a new position, closes an existing position, or both. These flags help the system track your futures and options positions accurately, since short and long positions in these instruments are treated as separate assets for tax purposes.

For example:
- Opening a new long position: Open
- Closing that position: Close
- Rolling a position (closing one and opening another simultaneously): Open/close
These flags are optional - the system can calculate them automatically if left blank. While they may appear for other asset types (particularly from IBKR imports), they only affect tax calculations for futures and options.
Accrued Income: The accrued income for gilt trades. It can be positive to represent money received and negative to represent money paid. It will be treated as described in the helpsheet. In the step 1 of the helpsheet, HMRC has some examples where there is an amount of accrued income:
- "‘sold’ securities, and an amount has been ‘added’ to the [clean] price" - this is an amount you received so accrued income is positive
- "‘bought’ securities, and an amount has been ‘taken away’ from the clean price" - this is an amount you received so the accrued income is positive
- "‘bought’ securities, and an amount has been ‘added’ to the clean price" - this is an amount you paid so the accrued income is negative
- "‘sold’ securities, and an amount has been ‘taken away’ from the price" - this is an amount you paid so the accrued income is negative

Attributed Income

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

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.

Manufactured dividends and interest are for payments in lieu of a dividend and are treated as if they are real dividends or interest. Manufactured payments are only supported from January 1, 2014.

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

Option Exercise and Assignment

Types: Exercise (when option is bought), Assign (when option is written/granted)

Date: the date the exercise or assignment is made
Option asset: the option being exercised or assigned
Option quantity: the quantity of the option being exercised or assigned
Underlying trade quantity: the quantity of the underlying asset being bought or sold in the underlying trade
Consideration: the consideration for the underlying trade (see Trades)
Fees: the fees for the underlying trade (see Trades)
Transaction tax: the transaction tax for the underlying trade (see Trades)

Option Exercise and Assignment (Cash Settlement)

Types: Cash Exercise, Cash Assign

Date: the date the exercise or assignment is made
Option asset: the option being exercised or assigned
Option quantity: the quantity of the option being exercised or assigned
Consideration: the asset and amount received (by the buyer) or paid (by the writer) for the settlement
Fees: any fees paid as part of the settlement that are allowable costs
Transaction tax: any taxes paid as part of the settlement that are allowable costs (treated as a fee)

Option Expire

Types: Expire

Date: the date the option expires - must match the option asset expiry date
Option asset: the option being expired
Option quantity: the quantity of the option being expired

Bond Maturity

Date: the date of maturity. Must match the expiry date on the asset.
Quantity: the quantity of the bond.
Amount: the amount of currency received from the event

Symbol Change

There is no system type for a symbol change, but you can manually change the symbol on the asset and the system should map it correctly on future imports.