Páginas filhas
  • CFGTRIB - Calculation of Taxes Withheld in Service Provision

01. Overview

This documentation aims to exemplify the reproduction of the following scenario: Provision of services with withheld taxes (INSS, Income Tax, ISS, PIS, COFINS, CSLL).
 

02. Example of Configuration

2.1) Files:

Access the Tax Configuration Module using routine FISA170 and add the following files:
 

2.1.1) Taxes

Tax Rules > Files > Tax
 
INSS:


 
 
Income Tax:


 
 
ISS:



  
PIS:

 
 

COFINS:



CSLL:



2.1.2) Service Provision Code Rules:

Tax Rules > Files > Service Provision Code Rules


2.2) Profiles:

Register the profile types:
 

2.2.1) Product Profile:

Tax Rules > Profiles > Product Profile

 
 

2.2.2) Operation Profile:

Tax Rules > Profiles > Operation profile


 
 

2.2.3) Participant Profile:

Tax Rules > Profiles > Participant Profile

 
 

2.2.4) Source/Target Profile:

Tax Rules > Profiles > Source/Target Profile


 
 

2.3) Tax Document Calculation Rules:

2.3.1) Register the calculation base rules:

Tax Rules > Tax Document Calculation Rules > Calculation Base Rule
 

INSS:



ISS:



Income Tax:

Important!

If it is necessary to apply the simplified discount, the configuration of the calculation base can include the discount as stated in the following documentation: CFGTRIB - Income Tax calculation using the progressive table and simplified discount If there is still the need to discount certain taxes from the Calculation Basis, such as discounting the INSS from the Income Tax basis, this can be done while editing the formula. Simply select option 05 - Tax Rules in the "Type of Rules to be consulted" field, select the tax you want to discount from the Calculation Basis that is being configured in the "Tax to filter the query" field, and, finally, select the operand of that tax that must be subtracted, as shown below: 


 


 

PIS:



COFINS:



CSLL:



2.3.2) Rate Rules:

Tax Rules > Tax Document Calculation Rules > Rate Rule
 

INSS:



ISS:



Income Tax:



PIS:



COFINS:



CSLL:



2.3.3) Booking Rules:

Tax Rules > Tax Document Calculation Rules > Booking Rule
First rule: 100001 (Subtract from trade note and invoice total)

 
 
Second rule: 100002 (Subtract from invoice total only)

 
 

2.3.4) Calculation Rule - Tax Documents

Tax Rules > Tax Document Calculation Rules > Calculation Rule – Tax Documents
 

INSS:



ISS:



Income Tax:



PIS:



COFINS:



CSLL:

 
 

03. Example of Use

 
Before issuing the sales order, check the following files:

TIO:

Use a TIO that does not calculate PIS and COFINS:

PIS/COFINS (F4_PISCOF) = Do not consider

PIS/COF Cred. (F4_PISCRED) = Do not calculate


 
Product:

Use a file that does not withhold PIS and COFINS:

Withhold PIS (B1_PIS) = No

Withhold COF (B1_COFINS) = No
 

3.1) Sales Order Issuance (mata410):


Calculation Memory:
 
Value of service provided: 10,000.00

x 11% INSS = 1,100.00

x 1% Income Tax = 100.00

x 2% ISS = 200.00

x 0.65% PIS = 65.00

x 3% COFINS = 300.00

x 1% CSLL = 100.00
 
Invoice Total: Service Provided - Taxes Withheld

= 10,000.00 - 1,100.00 - 100.00 - 200.00 - 65.00 - 300.00 - 100.00

= 8,135.00


Important

To generate the bills for the withheld taxes, it is necessary to have a financial rule linked to these taxes as in the documentation mentioned in Additional Information.

04. Additional Information

Additional reading material: Financial Rules by the Tax Configuration Module (FISA170): https://tdn.totvs.com.br/display/public/PROT/Configurador+de+Tributos+-+Regras+Financeiras