(BRA) Setting Up Supplier Withholding

This chapter provides an overview of the setup for processing supplier withholding in Brazil and discusses how to:

See Also

Setting Up UDCs for Supplier Withholding for Brazil

Click to jump to parent topicUnderstanding Set Up for Supplier Withholding for Brazil

Before the JD Edwards EnterpriseOne systems can calculate Brazilian supplier withholding taxes, you must set up the tax tables, UDCs, AAIs, and other information that the system needs to perform the calculations.

You can set up your system to perform calculations for these taxes:

Tax

Explanation

IR (Imposto de Renda)

A federal income tax that is levied on services that are provided by individuals or legal entities.

ISS (Imposto sobre Serviços)

A tax that is defined by the city of origin of the job or service.

INSS (Instituto Nacional do Seguro Social)

The national social security tax. Some types of services are subject to INSS tax. The tax amount is added to the value of the provided service.

FUNRURAL (Fundo de Assistência e Previdência do Trabalhador Rural)

The income tax for agricultural businesses. It is similar to the IR tax for corporations, but the rate at which the income is taxed is different.

PIS/PASEP

A mandatory contribution that is levied as a percentage of monthly billings. The PIS contribution is made to Brazilian social programs by private companies and enterprises. The PASEP contribution is made to Brazilian social programs by public or government entities.

COFINS

A mandatory contribution that is levied as a percentage of monthly billings on merchandise and services.

CSLL

A tax on net gains.

The system calculates IR, PIS/PASEP, COFINS, and CSLL taxes when an automatic or manual payment is created. The system writes the tax information to the F0411 table and Voucher Additional Information Brazil (F76B0411) table after the payments are updated.

Taxes for INSS, ISS, and FUNRURAL are calculated after vouchers are entered, and before payments are made. The system calculates the taxes on both posted and non-posted vouchers.

To set up your system to calculate Brazilian social security and income taxes, you must:

Click to jump to parent topicSetting Up Withholding Tax Codes

This section provides an overview of setting up withholding tax codes, lists a prerequisite, and discusses how to set up withholding tax codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Withholding Tax Code Setup

The Review A/P Tax Code program (P76B0401) enables you to set up tax codes that the system uses to calculate withholding taxes on notas fiscais. For example, you can set up codes for PIS/PASEP, COFINS, CSLL, INSS, and so on.

For social security and income taxes for suppliers, you must set up codes that represent each tax that is being withheld or aggregated. You might have more than one code for each tax type for each supplier. For example, you must set up INSS tax codes for each type of service that is provided by a supplier.

Withholding for PIS/PASEP, COFINS, and CSLL Contributions

When you purchase goods and services for which withholding taxes apply, the system calculates PIS/PASEP, COFINS, and CSLL when you run the Tax Calculation ISS, INSS, FUNRURAL program. Both PIS/PASEP and COFINS contributions are calculated for each line item on the nota fiscal.

CSLL contributions are calculated on the net amount of the nota fiscal. The system stores data about the contributions in the Voucher Additional Information Brazil (F76B0411) table.

Withholding for INSS Taxes

Set up a tax code for INSS retention and a different code for INSS aggregation.

Click to jump to top of pageClick to jump to parent topicPrerequisite

Verify that the tax codes for withholding taxes are set up in the Tax Code A/P (76B/TR) UDC table.

Click to jump to top of pageClick to jump to parent topicForm Used to Set Up Withholding Tax Codes

Form Name

FormID

Navigation

Usage

Tax Information Revisions

W76B0401A

A/P Tax Processing - Brazil (G76B0414), Review A/P Tax Code

Click Add on the Work With Tax Information form.

Set up withholding tax codes.

Click to jump to top of pageClick to jump to parent topicSetting Up Withholding Tax Codes

Access the Tax Information Revisions form.

Brazil Tax Information

Enter up to eight characters to describe the tax.

Tax Type

Enter a code that exists in the Tax Code A/P (76B/TR) UDC table to specify the type of Brazilian income tax. Values are:

01: IRRF

02: ISS

03: INSS

04: FUNRURAL

05: PIS

06: COFINS

07: CSLL

Retention/Aggregation Rate

Enter the retention or aggregation tax rate that is applied to the service transaction.

Retention/ Aggregation/ Credit

Enter R if the tax code is for retention. Enter A if the tax code is for aggregation. Enter C if the tax code is for PIS/PASEP or COFINS credit.

Reduction IR

Enter the percentage of the reduction of the tax calculation base for an individual.

IR Code

Enter a code that exists in the Recieta Code (76B/IR) UDC table to identify the type of IR tax.

Alternate Payee Address Number

Enter the address number for an alternate payee, such as a tax authority.

Number of Dependents

Enter a code that exists in the Dependence Reduction IR-PF (76B/DP) UDC table to identify a reduction in tax liability based on the number of dependents the taxpayer claims.

Retired

Enter a code from the Retired IR-PF (Income Tax) (76B/AP) UDC table to indicate a reduction in tax liability for retired persons.

Progressive Table

Select this check box to use the progressive tax table when calculating taxes. Use the Progressive Table IR-PF program (P76B0402) to set up the progressive tax table.

ISS Code

Enter a code that exists in the Service Code (76B/IS) UDC table to specify the type of service for a city.

INSS Code

Enter a code that exists in the INSS Code (76B/IN) UDC table to specify the type of social security tax.

Cooperative

Select to indicate that the legal entity is a cooperative.

Click to jump to parent topicSetting Up Purchase Use Codes for PIS/PASEP, COFINS, and CSLL Contributions

This section provides an overview of setting up purchase codes for PIS/PASEP, COFINS, and CSLL contributions and discusses how to set up purchase use codes.

Click to jump to top of pageClick to jump to parent topicUnderstanding Purchase Use Codes for PIS/PASEP, COFINS, and CSLL Contributions

You use the Purchase Use Tax Setup program (P76B003) to create associations between purchase use codes that exist in the Purchase Use (76/PU) UDC table and tax codes that exist in the F76B0401 table.

When you run the Tax Calculation ISS, INSS, FUNRURAL (R76B4310) program, the system accesses the associations between the purchase use codes and tax codes that you set up in the Withholding Information section of the Purchase Use Tax Setup - Brazil program. The system uses the associations to determine whether to calculate PIS/PASEP and COFINS withholding taxes. The system then reads the F76B0401 table to determine the tax rate that applies to an item or service.

Click to jump to top of pageClick to jump to parent topicForm Used to Set Up Purchase Use Codes for PIS/PASEP, COFINS, and CSLL Withholding Taxes

Form Name

FormID

Navigation

Usage

Purchase Use Tax Setup Revisions

W76B003B

Brazil Localization Setup (G76B41B), Purchase Use Tax Setup

Click Add on the Work With Purchase Use Tax Setup form.

Set up purchase use codes. The system enables the Apply xx field only when you complete the corresponding field. You must select this option before the system will calculate the withholding based on the code that you enter in the tax type field.

For example, you can select Apply PIS only when you complete the PIS field.

Click to jump to top of pageClick to jump to parent topicSetting Up Purchase Use Codes for PIS/PASEP, COFINS, and CSLL Withholding Taxes

Access the Purchase Use Tax Setup Revisions form.

Note. Use only the fields in the Withholding section of the Purchase Use Tax Setup Revisions form for PIS/PASEP, COFINS, and CSLL withholding. Use the Taxes Information section for PIS/PASEP and COFINS credits.

Purchase Use

Enter the purchase use code from UDC 76/PU for which you create an association with a tax code.

PIS, COFINS, and CSLL

Enter the code from the F76B0401 table for which you create an association with a purchase use code.

Apply PIS, Apply COFINS, and Apply CSLL

Select the option to enable the tax calculation.

The system enables the option only when you complete the corresponding field. For example, you can select Apply PIS only when you complete the PIS field.

You must select the option before the system will calculate withholding based on the code that you enter in the corresponding tax field.

Click to jump to parent topicSetting Up the Income Tax Schedule for Individuals

The system calculates IR taxes for individuals according to the schedule that you set up in the IR Progressive Table program (P76B0402). When you set up the schedule, you specify the income range, the percentage of funds that are being withheld, and the amount of the deduction.

This section discusses how to set up the income tax schedule for individuals.

Click to jump to top of pageClick to jump to parent topicForms Used to Set Up Income Tax Schedules for Individuals

Form Name

FormID

Navigation

Usage

Work With Income Tax Progressive Table

W76B0402A

A/P Tax Processing - Brazil (G76B0414), Progressive Table IR-PF

Locate income tax schedules.

Delete income tax schedules.

Income Tax Progressive Table Revisions

W76B0402B

Click Add on the Work With Income Tax Progressive Table form.

Set up an income tax schedule for an individual.

Click to jump to top of pageClick to jump to parent topicSetting Up Income Tax Schedules for Individuals

Access the Income Tax Progressive Table Revisions form.

Amount From

Enter the beginning monetary amount for the range of the tax rate.

Amount Thru

Enter the ending monetary amount for the range of the tax rate.

Retention Rate

Enter the retention or aggregation tax rate applied to the service transaction.

Amount Deduction

Enter the amount of the deduction.

Click to jump to parent topicSetting Up Payment Due Dates for Taxes

Before you can use JD Edwards EnterpriseOne software to calculate tax payments and payment due dates, you must set up the Advanced Payment Terms module in the JD Edwards EnterpriseOne Accounts Payable system. Income and social security taxes are due at different times, so you must set up a schedule for the payment due date for each tax type.

See Setting Up Advanced Payment Terms.

This table describes the payment due dates:

Tax

Due Dates

IR

The due date is the Wednesday of the week after the date of payment of the nota fiscal for individuals and the Wednesday of the week after the GL date of the nota fiscal for corporate entities.

For example, if you paid an invoice to a corporation on a Monday, the tax payment would be due in nine days. The system uses the payment terms and the Cross Reference - Due Date Tax UDC (76B/VE) when calculating the due date.

PIS/PASEP

COFINS

CSLL

Tax due dates for withholding from the 1st through the 15th of a month, and for withholdings from the 16th through the end of a month are due on the Friday of the week following the end of the payment period. If the Friday is a holiday, then the tax is due on Thursday.

For example, if the 15th of the month is a Monday, the taxes for the period of the 1st through the 15th are due on the 26th, which is the Friday of the following week.

ISS

The due date is the seventh business day of the month after the date when the nota fiscal is entered into the system. If the seventh day is a nonworking day, the due date is the next working day. The system uses payment terms when calculating the due date.

INSS

The due date is the second business day of the month after the date when the nota fiscal is entered into the system. The system uses payment terms when calculating the due date.

FUNRURAL

The due date is the second day of the month after the date when the nota fiscal is entered into the system. If the second day is a nonworking day, the due date is the next working day. The system uses payment terms when calculating the due date.

When you set up your system to calculate payment due dates, you must set up:

See Setting Up Standard Payment Terms.

Date Ranges for ISS, INSS, and FUNRURAL Taxes

You set up date ranges so that the system can calculate when tax payments are due. After you set up date ranges, you associate the date ranges to due date rules.

The number of days that elapse between the date when a nota fiscal is processed and the date when the tax is due varies, depending on how many days are in a month and whether the statutory due date falls on a working or nonworking day. For example, if you process a nota fiscal on February 25, 2005, then the ISS tax is due on Monday, March 7, 2005, which is ten days later. If you process a nota fiscal on April 25, 2005, then the ISS tax is due on Monday, May 9, 2005, which is 14 days later. The tax is due on May 9 instead of May 7 because May 7 is a Saturday. When you set up date ranges for ISS, INSS, and FUNRURAL taxes, you set up a schedule that specifies how many days that the system adds to the GL date to calculate the tax due date.

Example of Date Range for ISS Tax

Suppose you want to set up date ranges for invoices that are processed in March 2005. March 1,2005, is a Tuesday.

ISS taxes are due on the 7th business day of each month, so the time that elapsed between each date that you process notas fiscais and the due date varies. For each date that you might process invoices, you must count the number of days between the GL date and the 7th day of the month following the GL date. When you set up the ranges for this month, you specify the date when the tax is due in the Fixed Days field on the Date Range Revision form, and you enter the date in the From Day and in the To Day fields. You also complete the Days To Add field with the number of days between the GL date of the nota fiscal and the due date.

This table includes the entry that you would make for ISS taxes for invoices that are processed in March 2005:

From Days

To Days

Days to Add

Fixed Days

Months to Add

1

1

37

7

0

Date Ranges for IR Taxes

You set up date ranges so that the system can calculate when tax payments are due. After you set up date ranges, you associate the date ranges to due date rules.

For IR taxes, specify the range of dates for tax payments that are due on a specific date. For example, these taxes are due on Wednesday unless Wednesday is a nonworking day. When you set up a date range for taxes that are due on March 16, 2005, specify that the tax for notas fiscais that are processed between the 6th and the 12th is due on the 16th.

Example of Date Range for IR Tax

Suppose you want to set up date ranges for invoices that are processed in March 2005. March 1, 2005, is a Tuesday. IR taxes are due on Wednesday, so invoices processed in March of 2005 will have IR tax due on the 9th, 16th, 23rd, or 30th of the month. All invoices that are processed the first week of March (from Tuesday the 1st through Saturday the 5th) have IR tax due on the Wednesday of the following week, which is March 9. All invoices that are processed the second week of March (from Sunday the 6th through Saturday the 12th) have IR tax due on the Wednesday of the following week, which is January 16. When you set up the ranges for these weeks, you specify the date when the tax is due in the Fixed Days field on the Date Range Revision form, and you enter the first day of the week in the From Day and the last day of the week in the To Day fields.

Invoices that are processed during the last week of March 2005 have IR tax due on the first Wednesday of April, which is April 6. When you set up the date range for that week, you specify that the tax is due on the sixth day of the following month by specifying that the system adds a month to the due date that is specified in the Fixed Days field.

This table shows the entry that you would make for IR taxes for invoices that are processed in March 2005:

From Day

To Day

Days to Add

Fixed Days

Months to Add

1

5

0

9

0

6

12

0

16

0

13

19

0

23

0

20

26

0

30

0

27

31

0

6

1

Due Date Rules for IR Taxes

You set up due date rules for IR for each month that begins on a different day of the week or that has a different number of days. For example, February and March of 2005 both begin on a Tuesday, but you must set up a different due date rule for February and for March because they have a different number of days.

The due date rule is a four-digit code. To make it easier to recognize what the code represents, you can set up due date rules that follow a recognizable pattern. For example, you might set up codes for the year 2005 according to this schedule:

Identity Tax

Month, Day, Day of the Week

Day of the Week

Due Date Rule Code

R = IR tax

Jan = 31, begins on Saturday

Feb = 28, begins on Tuesday

Mar = 31, begins on Tuesday

April = 30, begins on Friday

Sunday = 1

Monday = 2

Tuesday = 3

and so on

R731 = IR code for January

R328 = IR code for February

R331 = IR code for March

R630 = IR code for April

Due Date Calculation for PIS/PASEP, COFINS, and CSLL Withholdings

Create a payment term specifically for PIS/COFINS and CSLL withholding. Associate the payment term with a date rule for which a calendar exists in the Advanced Payment Terms module. Indicate the payment due dates as working dates, and specify that all other dates are holidays.

For PIS/PASEP, COFINS, and CSLL contributions, specify the range of dates for tax payments that are due on a specific day of the week. For example, these taxes are due on Friday unless Friday is a nonworking day. When you set up a date range for taxes that are processed between the 1st and the 15th, specify the Friday of the following week as the due date.

Payment Terms

When you set up payment terms, you create a code that associates due date rules with discount percentages. The system uses the codes that you create for calculating when a tax payment is due. The system also uses the payment term code in the Cross Reference - Due Date Tax UDC (76B/VE). After you set up payment terms, you can specify the payment terms for each supplier in the F0401 table.