This routine aims at calculating the taxes that have been calculated by the system, displaying the results on the screen.. As follows:

  • Impuesto General a las ventas (IGV)
  • Impuesto Selectivo al Consumo (ISC)

Each tax is calculated following a distinct rule. But, the presentation is the same for each of them.

For a user-friendlier view and control, each calculation row must follow this rule:


Item Code

Description

Note

Used in tax calculation

001

Outflow with Tax Debt

Value, bill title are not displayed

ISC / IGV

002

Tax on Sales

All tax calculated value in the outflows, considering the credit and debit notes.

ISC / IGV

003

Withholdings

All sales in which customer withheld the calculated tax value

IGV

004

Payment

All sales in which customer paid part of the calculated tax value

IGV

005

Other Debts

Value opened for user typing (only positive values). The note column must be indicated to justify the debit.

ISC / IGV

006

Tax Debt Total

002 - 003 - 004 + 005

ISC / IGV

007

Inflows with Tax Credit

Value, bill title are not displayed

ISC / IGV

008

Taxes in the purchases

All tax value calculated in the inflows, considering the credit and debit notes and deleting the payments, withholdings and detractions that must be displayed in different rows.

ISC / IGV

009

Withholdings

Total of IGV withholdings paid by the taxpayer in the period

IGV

010

Payment

Total of IGV payments paid in the period

IGV

011

Detractions

Total of detractions the taxpayer is entitled to settle the taxes (the customer, to which it was invoiced, detracted part of the tax)

IGV

012

Previous period credit

Credit transported from previous period calculation.

ISC / IGV

013

Other Credits

Value opened for user typing (only positive values). The note column must be indicated to justify the credit.

ISC / IGV

014

Tax Credit Total

008 + 009 + 010 + 011 + 012 + 013

ISC / IGV

015

Debit balance

006 – 014 (if positive, if negative, enter 0 as the it is a credit balance)

ISC / IGV

016

Credit balance to transport

014 – 006 (if positive, if negative, enter 0 as the it is a debit balance)

ISC / IGV

 

After the final result of calculated tax payable, both IGV and ISC:

  • Debit balance (tax payable): a bill payable in the financial in favor of the government is generated, as long as, the routine is set to generate the bill.
  • Credit balance (more credits than debits): credit value must be transported to next period.

It is worth remembering that to calculate a tax, it is necessary to check the existence of a calculation file of the previous period to search for the creditor balance.

 

Calculation result information

You must generate a text file with the calculation result (after generating the bill, if there is any).

Example of file name structure to store information: ADDMMAADDMMAA0101.II, where:

A

Informs that the existing file is for tax calculation purposes.

DDMMAA

Processing start date (day, with two characters; month, with two characters; year, with two characters)

DDMMAA

Processing end date (day, with two characters; month, with two characters; year, with two characters)

01

Code of company performing the calculation.

01

Code of branch performing the calculation.

II

Indicates the calculated tax:

IG = IGV

IS = ISC


File structure to store information, displays 3 types of row:

  • Calculated tax (IMP). The numbering of the calculation item must be followed in order to determine which of the items is being saved.
  • Additional information (INF - at first, only use to display the IPM value)
  • Generated bill (TIT)

Information Type for IMP clause

Size

Format

Blank spaces after information

Clause that indicates the row type

3

XXX

5

Row Code

3

XXX

5

Row Description

50

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

5

Row Value

6

999,999,999,999,999.99

5

Row Note

50

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

5

 

Information Type for INF clause

Size

Format

Blank spaces after information

Clause that indicates the row type

3

XXX

5

Row Description

50

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

5

Row Value

6

999,999,999,999,999.99

5



Information Type for TIT clause

Size

Format

Blank spaces after information

Clause that indicates the row type

3

XXX

5

Prefix

10

XXXXXXXXXX

5

Number

20

XXXXXXXXXXXXXXXXXXXX

5

Installment

5

XXXXX

5

Type

5

XXXXX

5

Supplier

10

XXXXXXXXXX

5

Store

5

XXXXX

5

Tax Value

22

999,999,999,999,999.99

5



Query Sources