Download Template File for MTD ITSA Layout

Integrate with spreadsheet - Sample Template

Andica MTD ITSA Excel Spreadsheet Bridging software has a spreadsheet mapping screen from where you can map/link MTD ITSA Values from your spreadsheet to the software. You can then link your transactions for Self-Employment, UK Property and Foreign Property Excel spreadsheet and map MTD ITSA values from your spreadsheet into the software into the respective heads.

Once you have registered with HMRC for MTD ITSA and successfully retrieved the Quarters (Obligations) from HMRC, you can follow the steps below to integrate with excel spreadsheet and submit the quarterly updates

1. Click on ‘Submit’ button under 'Action' column.

2. Once done, it will navigate you to the Mapping Screen. Download the template using ‘Download Template’ option. Enter the values as appropriate in the relevant boxes in the sample file and save it.

3. Click on ‘Click to upload or drag and drop’ button.

4. This will open the Windows Explorer on your screen. Locate your Microsoft Excel Sample file on your computer. This excel file must contain your data ready to be retrieved into the software.

5. Select your ‘Excel Spreadsheet’ that contains the values for that quarter and click ‘Next’.

6. You will have all the boxes and the values on your screen.

7. Software has already performed the default mapping. If you want to make any changes in the mapping, then you can select the appropriate head from the dropdown.

Once done, click on ‘Next’ button at the bottom of the screen and it will navigate you to 'Preview & Submit screen. Verify all the values and provide the confirmation by ticking the check box at the bottom of the screen and click on ‘Submit’ button.

*** As stated in our terms and conditions, support is not provided free within the software price. However, where possible - in case of a technical issue with the software - we are happy to respond to email and telephone queries, we will endeavour to respond as soon as we can but we cannot guarantee response time. Software is supplied subject to our terms and conditions and software licence terms. We reserve the rights to refuse support.. ***