This routine aims at calculating the taxes that have been calculated by the system, displaying the results on the screen.. As follows:
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:
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:
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