Taxes Bordereau (FINA241 - SIGAFIN)

Note

This routine was adjusted to comply with the General Personal Data Protection Law (Statute No. 13.70) so that some fields containing data regarded as sensitive and/or personal are blurred, becoming illegible.

01. OVERVIEW

This routine groups bills payable in bordereaux to send them to the bank along with instructions on the payment term.

You can print the bordereau or create a TXT file with its data. The TXT file layout uses the same mechanisms that create the CNAB remittance file.

After the payment bordereau is generated, bills are automatically posted. Use the option Automatic Posting Payable to check the bordereau number.

Important:

Once you generate the bordereau, prepare the File to Send to the bank, if you use Bank Communication - CNAB. You can only send the file after registering CNAB Parameters.
When you enter Yes in question Select Branches? you can select the branches to be included in the bordereau generation.
You can generate the payment bordereau with the Payment Method through routine Suppliers and Accounts Payable. To do this, fill out the field Paymt Method.

Note - TOTVS Connect Bank (TCB)

By internal settings, the integration with TOTVS Connect Bank is unavailable, and, at this time, it does not have an activation forecast. Selecting the "Transmit Bordereau through TCB" option will not affect the system.

02. OPERATIONS

Bordereau

To generate the Taxes Bordereau:

In Taxes Bordereau, press [F12] and follow field help instructions to set routine parameters.

Note:

The parameter Check Bills Aut.? defines whether bills are displayed pre-checked. If configured as Yes, bills are displayed pre-checked. If configured as No, bills are displayed unchecked.
Parameter Consider Scheduling? schedules the clearing of Bills Payable, regardless of actual due dates.

2. Check the information and confirm.

3. Then, select the option Bordereau.

4. The system displays the Bordereau Payment screen.

5. Fill in the requested information according to the field's help instructions.

6. Check the information and confirm.

If the parameter Check Bills Aut.? is set to Yes, the bills that match the fields filled out are displayed on another screen, checked with a green X.

7. To select an unchecked bill or to deselect it, place the cursor on it and press [Enter] or double-click it.

Use filters to search for information, ordering it in accordance with a given characteristic.

Example:

branch+prefix+bill no.+installment+type.

When you activate this option, fill in the information that should be filtered to consider the cancelation of the bordereau, such as your number. Then, confirm the procedure.

Note

It is not possible to cancel a bordereau with a date before its generation.

For example, if the bordereau has a generation date on August 26, 2022, it is only possible to cancel with a date equal to or greater than August 26, 2022.

This option indicates the types of bills available through colors.

This option allows you to query tax posting and withholding transactions of the withholdings engine related to the bills.

03. EXAMPLES OF USE

Settings for displaying Advance Payment (PA)-type bills in the Tax Bordereau routine (FINA241):

In the routine of creating the Bill Payable (FINA050), the parameters Bank Trans. w/out check and Generate check for advance must be set to No.
2. In Tax Bordereau (FINA241), the parameter Consider bills? must be set to Both or Advance.

If the parameter Generate check for Advance is set to Yes, the Advance Payment bill is not displayed on the selection screen for the creation of the Tax Bordereau, so this bill is not generated in duplicity, as the check has already been generated. However, if it is necessary to include advance payment-type bills in the bordereau, entry point FA240PA must be used as in the documentation: FA240PA - Select PA with banking transaction.

04. PARAMETERS

For more parameters and information, see Financial Parameters.

05. ACCOUNTING FOR POSTINGS BY TAX GENERATION

To account, in the generation of the tax bordereau, if partial postings related to the generation of taxes occur, the following sequences must be configured:

Using table SE5 (Bank Transactions)

Cod Stand Entry	Description	Entry Type	Vl. Currency 1
530	POSTINGS BY TAX BORDEREAU PCC	3	IIF(SE5->E5_MOTBX='PCC',SE5->E5_VALOR,0)
530	POSTINGS BY TAX BORDEREAU INC. TAX	3	IIF(SE5->E5_MOTBX='IRF',SE5->E5_VALOR,0)
530	POSTING BY TAXES BORDEREAU ISS	3	IIF(SE5->E5_MOTBX='ISS',SE5->E5_VALOR,0)

Using table FK2 - Postings Payable

Cod Stand Entry	Description	Entry Type	Vl. Currency 1
530	POSTINGS BY TAXES BORDEREAU PCC FK2	3	IIF(FK2->FK2_MOTBX="PCC",FK2->FK2_VALOR,0)
530	POSTINGS BY TAXES BORDEREAU INC. TAX FK2	3	IIF(FK2->FK2_MOTBX="IRF",FK2->FK2_VALOR,0)
530	POSTINGS BY TAXES BORDEREAU ISS FK2	3	IIF(FK2->FK2_MOTBX="ISS",FK2->FK2_VALOR,0)

To account, in the cancelation of the tax bordereau, if partial postings related to the generation of taxes occur, the following sequences must be configured:

Using table SE5 (Bank Transactions)

Cod Stand Entry	Description	Entry Type	Vl. Currency 1
531	CANCEL. OF POSTINGS BY TAX BORDEREAU PCC	3	IIF(SE5->E5_MOTBX='PCC',SE5->E5_VALOR,0)
531	CANCEL. OF POSTINGS BY TAX BORDEREAU INC. TAX	3	IIF(SE5->E5_MOTBX='IRF',SE5->E5_VALOR,0)
531	CANCEL. OF POSTING BY TAXES BORDEREAU ISS	3	IIF(SE5->E5_MOTBX='ISS',SE5->E5_VALOR,0)

Using table FK2 - Postings Payable

Cod Stand Entry	Description	Entry Type	Vl. Currency 1
531	CANCEL. OF POSTINGS BY TAXES BORDEREAU PCC FK2	3	IIF(FK2->FK2_MOTBX="PCC",FK2->FK2_VALOR,0)
531	CANCEL. OF POSTINGS BY TAXES BORDEREAU INC. TAX FK2	3	IIF(FK2->FK2_MOTBX="IRF",FK2->FK2_VALOR,0)
531	CANCEL. OF POSTINGS BY TAXES BORDEREAU ISS FK2	3	IIF(FK2->FK2_MOTBX="ISS",FK2->FK2_VALOR,0)