Skip to main content

How to import data from Model 200 to Model 220

In Form 220 it is possible to import certain data from Form 200 on some pages of the return.This is possible if you have the telematic filing file with the format BOE and extension .200 of each of the member entities of the group.

When the option "Import from 200" is used, the program stores file .200 tax returns for group entities but data is not automatically transferred;to do this, you need to go to the pages from which you can retrieve the data.

We explain the steps of the import procedure:

  1. Once the tax return has been created, click on the "Import from 200" button on the toolbar at the bottom of the form.

    Import from 200

  2. Select the .200 file stored on your computer to incorporate it into the model 220.Note that you must repeat this process for all the .200 files you need to incorporate for each group company.

    Select file

  3. Once you have selected the .200 files for each company, you will see the message "No errors".

    There are no errors

    However, even if you have read the files, the data will not yet have been incorporated into form 220.

  4. You then go to the pages where you import data, e.g. page 2 where the programme will allow you to import your company names.

    Pages into which data is imported

    Click on the icon next to the NIF box to choose the file, the pop-up window will show the .200 files you have previously imported, choose the .200 file of the subsidiary you need and click "Apply".

    Import files

    Apply

    You will need to repeat the process adding new records (for the remaining companies) by choosing files one at a time.

  5. On page 7A repeat the same process.

    Page 7A

    Click on the icon next to the NIF box to choose the file.The pop-up window will display the .200 files you have previously imported, choose the .200 file of the company you need and click "Apply".

    New record

    Apply

    The data to be incorporated from models 200 to page 7A are:

    • The company name

    • The NIF

    • Turnover .The amounts in boxes 00255 on page 7 of Form 200 filed by group entities shall be imported into the net turnover column on page 7A of Form 220.

      If any of the following characters 003, 004, 024 or 025 have been ticked in Forms 200, the amounts in boxes 00989 on page 21 of Forms 200 filed by group entities shall be imported into the net turnover column on page 7A of Form 220.

      If 036 has been marked, the amount in box 00166 on page 51 of form 200.

    • Result for the financial year:Box 00500 on page 12 of form 200, result of the profit and loss account.

    • Net adjustment for corporate income tax:In the 200 of each entity this information will be obtained by carrying out the following operation:box 00301 minus box 00302, on page 12 of Form 200.

    • Other net adjustments to the accounting result:In the 200 of each entity this information will be obtained by carrying out the following operation:box 01230 + box 00417 - box 01231 - box 00418, on pages 12 and 13 of Form 200.

    • Cooperative Groups:Taxable income for cooperative results.Box 00553 on page 14 of Form 200.

    • Cooperative Groups:Taxable income from extra-cooperative results.Box 00554 on page 14 of Form 200.

    • Special regime for shipping companies:B.I. determined by the objective estimation method. Box 00579 on page 13 of Form 200.