Extract costs and taxes as separate transactions
You can extract specific costs and taxes from transactions into separate transactions. This allows you to:
Create payment instructions based on the extracted costs to transfer brokerage fees or other transaction-related costs.
Create payment instructions based on the extracted taxes to transfer stamp duties or other transaction-related taxes.
Keep track of transaction-related costs in a separate fee portfolio.
Setting up
Define which costs you want to extract and which transaction types to use for the extracted costs.
Go to Tools → Administer → Data aggregation and select the Extraction of costs tab.
Fill in the fields:
- Tax type to transaction type mapping
Mapping for taxes to extract.
To extract taxes of type Stamp Duty (with code STA) as transaction type Cost (with code COST), enter STA=COST.
You can define multiple mappings by separating them with a semi-colon, for example STA=COST;TT=COST.
To map taxes without specified type on the transaction, use code "default", for example default=COST.
- Cost type to transaction type mapping
Mapping for costs to extract.
To extract costs of type Advisory fee (with code ADV) as transaction type Cost (with code COST), enter ADV=COST.
You can define multiple mappings by separating them with a semi-colon, for example, ADV=COST;CUS=COST.
To map costs without specified type on the transaction, use code default, for example, default=COST.
- Portfolio for created transactions
A portfolio to create transactions in. Leave the field empty to save the cost transactions in the same portfolio as the original transaction. Note that the portfolio for created transactions must have an account in the same currency as the source portfolio.
- Tax 1, Tax 2, Cost 1, Cost 2
Fields in Transaction window to consider when extracting costs.
- Create transactions as hidden
An option to hide the extracted cost transactions in reports and in the Overview.
- Tag for created transactions
A tag to add to the created transactions (if needed).
- Tag for processed transactions
A tag to add to the original transactions from which taxes and costs were extracted.
Click Done
Extracting costs from transactions
Once you completed the initial setup, you can create cost transactions automatically by following these steps.
Go to the Transactions view and search for the transaction whose costs you wish to extract.
Click Extract costs as separate transactions at the bottom of the view.
Cost transactions appear in either the same portfolio as the original transaction or in the target portfolio you defined in the settings.