Páginas filhas
  • TIO File for VAT - Ecuador (MATA080 - SIGAFIS)

equ

TIO previous File for VAT Calculation

It is mandatory the previous registration of data related to the tax, in Variable Taxes. Check the following procedures for TIO registration that shall rule tax application in the invoicing:

  1. In Types of Inflow and Outflow, click Add.
  2. Fill out the data according to the field help instructions.


Exempt Operations and Rate 0%


There are exempt operations and also those with 0% rate. It's a distinct situation, as in VAT calculation, the proportionality concept must be applied: credits from operations where the applied rate is 12%, value subtracted when rate is 0%.


The field Calc. VAT, from TIO File, presents the following actions:

    • 1=Calculated;
    • 2=Not Calculated;
    • 3=Exempt. Tax calculation base value must be saved in field Exempt, in Tax Records, and not saved in any other fields: BASIMP, VALIMP and ALQIMP;
    • 4= Zero Rate. Tax calculation base value must be saved in field BASIMP and the fields VALIMP and ALQIMP will be zeroed.


Help_buttonImportant:

Pay attention to tables division in groups, related to Outflows (invoicing and return - credit and debit notes) and Inflows (purchase and return - credit and debit invoices), in groups: 1- Outflow Operations and 2- Inflow Operations.

The first line of the following tables presents the fields TIO file and filling standard for each type of Inflow and Outflow. 


  • GROUP 1 - Outflow Operations


Inflow or Outflow Code

TIO Type

Generate duplicate invoice

Update Inventory

Operation Tax Code

Standard Text

Gener. book?

Return TIO

Calculate VAT?

Outflows (invoicing and return – debit/credit notes)

501

O

Y

Y

511

Venta IVA

Y


1

502

O

Y

Y

512

Venta IVA Exenta 

Y


3

503

O

Y

Y

521

Venta IVA 0%

Y


4

504

O

Y

Y

522

NCC IVA

Y

004

1

505

O

Y

Y

523

NCC IVA Exenta

Y

005

3

506

O

Y

Y

524

NCC IVA 0%

Y

006

4

507

O

Y

Y

531

NCE IVA

Y

007

1

508

O

Y

Y

532

NCE IVA Exenta

Y

008

3

509

O

Y

Y

533

NCE IVA 0%

Y

009

4

510

O

Y

Y

534

NDC IVA

Y

010

1

511

O

Y

Y

541

NDC IVA Exenta

Y

011

3

512

O

Y

Y

543

NDC IVA 0%

Y

012

4

513

O

Y

Y

543

NDE IVA

Y

013

1

514

O

Y

Y

544

NDE IVA Exenta

Y

014

3

515

O

Y

Y

545

NDE IVA 0%

Y

015

4

516

O

Y

Y

511

Venta IVC

Y


1

517

O

Y

Y

512

Venta IVC Exenta 

Y


3

518

O

Y

Y

521

Venta IVC 0%

Y


4

519

O

Y

Y

522

NCC IVC

Y

019

1

520

O

Y

Y

523

NCC IVC Exenta

Y

020

3

521

O

Y

Y

524

NCC IVC 0%

Y

021

4

522

O

Y

Y

531

NCE IVC

Y

022

1

523

O

Y

Y

532

NCE IVC Exenta

Y

023

3

524

O

Y

Y

533

NCE IVC 0%

Y

024

4

525

O

Y

Y

534

NDC IVC

Y

025

1

526

O

Y

Y

541

NDC IVC Exenta

Y

026

3

527

O

Y

Y

543

NDC IVC 0%

Y

027

4

528

O

Y

Y

543

NDE IVC

Y

028

1

529

O

Y

Y

544

NDE IVC Exenta

Y

029

3

530

O

Y

Y

545

NDE IVC 0%

Y

030

4


  • GROUP 2 - Inflow Operations


Inflow or Outflow Code

TIO Type

Gener. duplicate invoice

Update Invent.

Operation Tax Code

Standard Text

Gener. book?

Return TIO

Calculate VAT?

Inflows (purchase and return - debit/credit notes)

001

I

Y

Y

111

Compra IVA

Y


1

002

I

Y

Y

112

Compra IVA Exenta

Y


3

003

I

Y

Y

113

Compra IVA 0%

Y


4

004

I

Y

Y

114

NCP IVA

Y

504

1

005

I

Y

Y

121

NCP IVA Exenta

Y

505

3

006

I

Y

Y

122

NCP IVA 0%

Y

506

4

007

I

Y

Y

123

NCI IVA

Y

507

1

008

I

Y

Y

124

NCI IVA Exenta

Y

508

3

009

I

Y

Y

131

NCI IVA 0%

Y

509

4

010

I

Y

Y

132

NDP IVA

Y

510

1

011

I

Y

Y

133

NDP IVA Exenta

Y

511

3

012

I

Y

Y

134

NDP IVA 0%

Y

512

4

013

I

Y

Y

141

NDI IVA

Y

513

1

014

I

Y

Y

142

NDI IVA Exenta

Y

514

3

015

I

Y

Y

143

NDI IVA 0%

Y

515

4

016

I

Y

Y

111

Compra IVC

Y


1

017

I

Y

Y

112

Compra IVC Exenta

Y


3

018

I

Y

Y

113

Compra IVC 0%

Y


4

019

I

Y

Y

114

NCP IVC

Y

519

1

020

I

Y

Y

121

NCP IVC Exenta

Y

520

3

021

I

Y

Y

122

NCP IVC 0%

Y

521

4

022

I

Y

Y

123

NCI IVC

Y

522

1

023

I

Y

Y

124

NCI IVC Exenta

Y

523

3

024

I

Y

Y

131

NCI IVC 0%

Y

524

4

025

I

Y

Y

132

NDP IVC

Y

525

1

026

I

Y

Y

133

NDP IVC Exenta

Y

526

3

027

I

Y

Y

134

NDP IVC 0%

Y

527

4

028

I

Y

Y

141

NDI IVC

Y

528

1

029

I

Y

Y

142

NDI IVC Exenta

Y

529

3

030

I

Y

Y

143

NDI IVC 0%

Y

530

4


Files - Binding TIO x Variable Taxes

  1. Register all binding information between TIO and Variable Taxes.
  2. Click TIO Update.
  3. At the end of the page Adm./ Fin./ Cost, select the folder Variable Taxes.
  4. Fill out the fields, based on listing and in the following instructions:


- GROUP 1 - Outflow Operations


TIO Code

Calculation Sequence

Tax to be calculated cd

Add in duplicate invoice

Add in invoice total

Add in cost

Tax applied in calculation

Calculate on (Items or Total)

Outflow (invoicing and return – debit/credit notes)

501

01

VAT

1

1

3

Do not inform

I – Invoice Items

502

01

VAT

1

1

3

Do not inform

I – Invoice Items

503

01

VAT

1

1

3

Do not inform

I – Invoice Items

504

01

VAT

1

1

3

Do not inform

I – Invoice Items

505

01

VAT

1

1

3

Do not inform

I – Invoice Items

506

01

VAT

1

1

3

Do not inform

I – Invoice Items

507

01

VAT

1

1

3

Do not inform

I – Invoice Items

508

01

VAT

1

1

3

Do not inform

I – Invoice Items

509

01

VAT

1

1

3

Do not inform

I – Invoice Items

510

01

VAT

1

1

3

Do not inform

I – Invoice Items

511

01

VAT

1

1

3

Do not inform

I – Invoice Items

512

01

VAT

1

1

3

Do not inform

I – Invoice Items

513

01

VAT

1

1

3

Do not inform

I – Invoice Items

514

01

VAT

1

1

3

Do not inform

I – Invoice Items

515

01

VAT

1

1

3

Do not inform

I – Invoice Items

516

01

IVC

3

3

3

Do not inform

I – Invoice Items

517

01

IVC

3

3

3

Do not inform

I – Invoice Items

518

01

IVC

3

3

3

Do not inform

I – Invoice Items

519

01

IVC

3

3

3

Do not inform

I – Invoice Items

520

01

IVC

3

3

3

Do not inform

I – Invoice Items

521

01

IVC

3

3

3

Do not inform

I – Invoice Items

522

01

IVC

3

3

3

Do not inform

I – Invoice Items

523

01

IVC

3

3

3

Do not inform

I – Invoice Items

524

01

IVC

3

3

3

Do not inform

I – Invoice Items

525

01

IVC

3

3

3

Do not inform

I – Invoice Items

526

01

IVC

3

3

3

Do not inform

I – Invoice Items

527

01

IVC

3

3

3

Do not inform

I – Invoice Items

528

01

IVC

3

3

3

Do not inform

I – Invoice Items

529

01

IVC

3

3

3

Do not inform

I – Invoice Items

530

01

IVC

3

3

3

Do not inform

I – Invoice Items


- GROUP 2 -Inflow Operations


TIO Code

Group Sequence

Tax to be Calc. Cd

Add in duplicate invoice

Add in invoice total

Ass to cost

Tax applied in calculation

Calculate on (Items or Total)

Inflow (purchase and return – debit/credit notes)

001

01

VAT

1

1

3

Do not inform

I – Invoice Items

002

01

VAT

1

1

3

Do not inform

I – Invoice Items

003

01

VAT

1

1

3

Do not inform

I – Invoice Items

004

01

VAT

1

1

3

Do not inform

I – Invoice Items

005

01

VAT

1

1

3

Do not inform

I – Invoice Items

006

01

VAT

1

1

3

Do not inform

I – Invoice Items

007

01

VAT

1

1

3

Do not inform

I – Invoice Items

008

01

VAT

1

1

3

Do not inform

I – Invoice Items

009

01

VAT

1

1

3

Do not inform

I – Invoice Items

010

01

VAT

1

1

3

Do not inform

I – Invoice Items

011

01

VAT

1

1

3

Do not inform

I – Invoice Items

012

01

VAT

1

1

3

Do not inform

I – Invoice Items

013

01

VAT

1

1

3

Do not inform

I – Invoice Items

014

01

VAT

1

1

3

Do not inform

I – Invoice Items

015

01

VAT

1

1

3

Do not inform

I – Invoice Items

016

01

IVC

3

3

3

Do not inform

I – Invoice Items

017

01

IVC

3

3

3

Do not inform

I – Invoice Items

018

01

IVC

3

3

3

Do not inform

I – Invoice Items

019

01

IVC

3

3

3

Do not inform

I – Invoice Items

020

01

IVC

3

3

3

Do not inform

I – Invoice Items

021

01

IVC

3

3

3

Do not inform

I – Invoice Items

022

01

IVC

3

3

3

Do not inform

I – Invoice Items

023

01

IVC

3

3

3

Do not inform

I – Invoice Items

024

01

IVC

3

3

3

Do not inform

I – Invoice Items

025

01

IVC

3

3

3

Do not inform

I – Invoice Items

026

01

IVC

3

3

3

Do not inform

I – Invoice Items

027

01

IVC

3

3

3

Do not inform

I – Invoice Items

028

01

IVC

3

3

3

Do not inform

I – Invoice Items

029

01

IVC

3

3

3

Do not inform

I – Invoice Items

030

01

IVC

3

3

3

Do not inform

I – Itens da NF


Chack VAT particularities for the fields listed below:

  • Add in duplicate invoice: VAT calculated value to be added to the bill amount generated in the financial module.
  • Add to Invoice Total: Vat calculated value must be added to document amount.

For IVc these options are not considered, as it is applied in good value.

  • Add in cost: tax value shall not comprise the cost.
  • Tax applied on calculation: this TIO must not present another tax added to its calculation base.
  • Calculate on: tax calculation is always per items.