Overview
Troika can export the results of CGT computations and income records directly into the Digita Personal and Trust tax returns. Some setup steps are required to enable the export and maintain the link via the master chart of accounts within Troika.
Enabling and Setting up the Tax Export to Digita
From the Troika Utilities module, System tab, select the System Settings menu option. Highlight the type ‘Sundry Entries’ and locate the setting ‘TaxFormFormat’. Set this to ‘2’ and close the screen.
From the Troika Wealth Management module, Nominal tab, select the Chart of Accounts menu option. Select a nominal account code from the list for each category listed in the table below. Select the Form Settings tab and select Form, ‘CSV Format File’. From the ‘Box’ drop down list select the appropriate box name from the list.
If a range of nominal account codes in Troika has been used for the same tax return box, check the ‘range’ box and enter the nominal account range. If the list of box names is incomplete, please contact support for assistance. Continue the process of allocating all the income elements of the chart of accounts and Capital Gains accounts to the relevant box names.
Box - Type Name | Type Reference |
Interest and alternative finance receipts, Gross | 1 |
Interest and alternative finance receipts, Net | 2 |
Interest Distributions From UK authorised unit trusts | 3 |
National Savings & Investments (excluding FOB and FRSB) | 4 |
National Savings & Investments, FOB and FRSB | 5 |
Other income from UK savings and investments (excl. dividends), Gross | 6 |
Other income from UK savings and investments (excl. dividends), Net | 7 |
Dividends and other qualifying distributions UK companies (excl. REIT's) | 8 |
Dividend distributions from UK authorised unit trusts | 9 |
Stock dividends from UK companies | 10 |
Non qualifying distributions | 11 |
Loans written off | 12 |
UK Furnished holiday lettings | 13 |
Other UK property income | 14 |
Foreign savings | 15 |
Foreign dividends | 16 |
Foreign property | 17 |
Capital Gains | 42 |
Exporting Tax Data to Digita
From the Troika Wealth Management module, Client tab, select a client and fund and the menu option Tax Form Preparation. Select the tax year to export the data for and click Export.
Additional tax years can be added to the list available to export from the Forms Administration menu option in Troika Utilities.
Make a note of the file name and file path where the export file is created.
From within Digita Personal Tax, select the client you wish to import the data for. Create a new tax return or open an existing tax return. From the File menu option, select Import/Export, and then Import from CSV file. For example:
Lastly browse to the file in the file path exported to by Troika and select the file. Click Import to verify and import the data. The relevant schedules will be created where necessary.
