Reconciling the General Ledger for PIS/PASEP and COFINS Taxes

After you update the general ledger by running the Taxes Netting Process program, you can manually reconcile your accounts to determine whether you must send funds to the government for the amounts that you collected for PIS/PASEP and COFINS taxes, or whether you have a credit amount that you can apply to the amounts that are due the following month.

Note: For purchase order transactions, the records for PIS/PASEP and COFINS taxes are updated when you run the Nota Fiscal Check & Close Program (P76B900). The Taxes Netting Process program updates records for only sales transactions.

For example, if you paid more in PIS/PASEP and COFINS taxes through your procurement transactions than the amount of PIS/PASEP and COFINS taxes that you collected through your sales transactions, you have a credit amount that you can apply toward PIS/PASEP taxes for the following month.

For example, if the PIS/COFINS on purchases is 1000 BRL and the PIS/COFINS on sales is 800 BRL, the credit for the following month is 200 BRL.

If you collected more through your sales transactions than you paid through your procurement transactions, you must remit to the government the difference between the amounts collected and paid, minus any credit from the previous month.

For example, if the PIS/COFINS on sales is 1300 BRL, the PIS/COFINS on purchases is 800 BRL, and the credit from the previous month is 200 BRL, then 300 BRL is due to the government.

The system does not store information about the total amounts paid on procurement transactions and the total amounts that were collected through sales transactions. It also does not store information about credits from previous months. You must manually reconcile your accounts to determine the difference between the amounts paid and collected each month. If you must generate a payment to the government for PIS/COFINS taxes, you must manually process the payment.

When you run the Generate ICMS Magnetic Files - Sintegra program (R76B201), you create a flat file that contains tax information. The system creates record type 54 records in the flat file for PIS and COFINS taxes that lists the amounts of PIS/COFINS taxes from the notas fiscais that were processed.