0% found this document useful (0 votes)
3 views15 pages

Payroll Process and Reporting Guide

1. The document describes the payroll processes, including advances, regular payroll, and report generation. 2. It includes instructions for advance calculation, benefits import, regular payroll calculation, bank file generation, and reports. 3. It details the programs, parameters, and files necessary for the correct execution of each step of the payroll process.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
3 views15 pages

Payroll Process and Reporting Guide

1. The document describes the payroll processes, including advances, regular payroll, and report generation. 2. It includes instructions for advance calculation, benefits import, regular payroll calculation, bank file generation, and reports. 3. It details the programs, parameters, and files necessary for the correct execution of each step of the payroll process.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1

PAYROLL PROCESSES

ADVANCE
1.1. FP3000 - Enable the advance calculation, always flag proportional days, type of leaf.
Advance, payment sequence installment "1".

1.2. FP3140 – Advance Payroll Calculation, just run the program, it will generate a report
.txt, with the calculated employees, with alert or with error.
2

1.3. FP3660– Bank deposit relations, part '1', credit date, type of sheet
advance, RTF printing. In the classification folder, mark a option, by
establishment/bank/enrollment.

1.4. FP4061 – Report Generator, extract report '.dig', Amount to Be Paid (event 900), carry out
the conference, about the 40% of the salary, when there is a difference, check if there are vacations in
period or the employee is newly hired.
3

1.5. FP5825 - BB file generator, generate the remittance files for import to BB, one
file for each bank (BB1 "Industry", BB7 "SVS", BB8 "SV").
Bank 1 Industry(UN001)
AG:2414-7
C/C:5881-5

Bank 7 SVS (UN002)


AG:2414-7
C/C:6757-1

Bank 8 SV(UN003)
AG:2414-7
C/C:6755-5

1.6. Fill in the payment controls, with the amounts separated by business unit,
according to the data in report FP4061 (Net Payable), verify totals generated in the file
banking.
1.7. FP3120 - Closing of the Last Calculation, just run the routine to close the calculation of
advance, to subsequently enable the calculation of the 'Normal Payroll'.
4

2. PAYROLL
2.1. FP3000 - Enable payment calculation, type payroll defoliation, sequence of
payment '9'.

2.2. BS3000 - Batch import of benefits, to import the co-payment benefit,


use the spreadsheet for calculation and generation of the standard layout to input the information of the
competence. Save the import files in the '.lst' format.
2.2.1. In the Parameter tab: Batch Number 1, layout type 'Customized', uses company and
Establishment of the 'Flegado' Layout, include the month and year of the competence, reason for the batch
3 (Co-participation), button benefit enter and select option 'yes' for code 92
Intermedical Co-participation.
5

2.2.2. In the Selection tab: Recover button, open the folder where the layout configuration is saved.
(RH/FOPAG/LAYOUT IMPORTATION DE BENEFITS/LAYOUT IMPORTATION
CO-PARTICIPATION), will bring the fields with the following number of characters, Company
(002), Establishment (001), Registration (005) and Value (007), totaling a layout with 15
characters.

[Link] in the Parameter tab: in the input file, select the folder where it was saved
the '.lst' file of the beneficial coparticipation, and click the execute button, in the folder C:/temp will be
generated a report of the imports made, save this file in the movement folder
of your competence.
6

2.3. FP6500 – Imports Movements Reported in Batch, for pharmacy benefits, reimbursements and
other funds that were necessary to include in the payroll.
2.3.1. In the Parameters tab: Layout Type 'custom', it uses company and establishment of
Layout 'Flegado', Sheet 'Normal', month and year of competence, and batch number 1.

2.3.2. In the Selection tab: Retrieve button, open the folder where the layout configuration is saved.
(RH/FOPAG/LAYOUT IMPORTATION OF BENEFITS/LAYOUT IMPORTATION OF PHARMACY), will
bring the fields with the following numbers and characters, Company (002), Establishment
(001), Event Code (003), Registration (006) and Value (007), totaling a layout with 15
characters.
7

[Link] in the Parameter tab: in the input file, select the folder where it was saved
“.lst” file of the pharmacy benefit and/or others, and click the execute button, in the folder
C:/temp a report of the imports made will be generated, save this file in the folder
movement of your competence.
2.4. BS2000–Benefits Generation for Payroll, this routine should only be executed without the
configuration needed, a report of the imports will be generated in the folder C:/temp
completed, save this file in the movement folder of your responsibility.

2.4.1. BS2020 - Eliminate Benefit Generation, if there is a need for any elimination,
individual or collective execute in this program.
8

2.5. FP2220 - Maintenance of Batch Movements, for executing any changes, of the
imported movements in the FP6500 Routine, whether exclusion, inclusion, or alteration, can be
done in this program, selecting the Lot number or creating a new Lot for case of
inclusion of information.

2.6. BS1000 – Updates Movement by Employee, this program will handle the imports
carried out in the BS3000 routine, if there is a need for any change, inclusion and
exclusion, the respective employee must be selected for such changes.
9

2.7. FP2540–Maintenance Workload Shift, for the shift0025 (08:00 to 15:00), must be
Created copy, for the current competency, must have 120 hours a month, accounting for the event
080 (Scholarship Internship).

2.8. FP3020 – Normal Sheet Calculation, this routine is for the calculation that should be executed after
all releases and integrations of time and benefits. There is no need to
configure nothing, just execute, except when performing maintenance on one or more
specific employees, being able to use the selection or typing tab to apply filters
necessary. A report of the calculations made will be generated in the folder C:/temp, save this
file in the folder of your competence. When analyzing the file, check the
messages if there was any calculation with an error.
10

2.8.1.FP3100 –Eliminate Calculation by Employee, this program can be used for


maintenance of any employee, where there is a need for elimination calculation.

2.9. FP4061–Report Generator, in this program all reports must be generated.


conference, two values, as well as Liquid to Pay, Salary Balance, Benefits, Union
Fines, night hours, etc. The reports are saved, just click the recover button and go to
folder where ‘.dig’ extension files are saved

2.10. FP4000 –Tax Sheet Listing, the tax sheet report must be saved in the folder of
competence, in the printing tab, check RTF and Print CSV Movements (save the spreadsheet
in the e-Social folder).
11

2.11. FP3660–Relationship of Bank Deposits, to generate the values to be imported to BB, separate
by Establishment/Bank/Registration, in the selection tab check RTF, and save the generated report
in the competence folder.

2.12. FP5825–Bank Liquid, in this report the file for importation into the portal will be generated.
BB, should generate 1 file for each bank code (1, 7, 8).
Bank 1 Industry (UN001)
AG:2414-7
C/C:5881-5

Bank 7 SVS (UN002)


AG:2414-7
C/C:6757-1

Bank 8 SV(UN003)
AG:2414-7
C/C:6755-5
12

[Link] the parameter tab:INSTALLMENT '9', month and year of reference, credit date always
last business day of the month, company checking account according to bank code (1-
5881.5,7-6757.1,8-6755.5), agency prefix always 2414-7, contract number 1223,
always flegar Validate CPF/Account. In the field where to put the name of the generated file, for
standard to put "BB [bank code] + [type of payment, payroll, advance, vacation, etc]"
+ credit date in account.

[Link] the selection tab: change only the bank, always generating one at a time, between 1, 7 and
8.

2.12.3. Bank Import: to import payment remittances on the BB portal, access


the financial manager area, with the key J and already registered password, upon logging in, follow the
path–File Exchange/Shipment–click on the " + " symbol and select the source where
The files were generated; after the import, the transmission report should be saved.
as proof of the transaction made. Note: the bank file takes around
40 minutes to 1 hour to be validated by the bank.
13

[Link]. To query any file already imported into the database, follow the path –
file exchange/payments to third parties - and select only the date of
payment and click on 'OK', the payment list for that will appear
determined date.
2.13.FP5860–Issuance of Online DOC Bank, for generating Receipt files
Payment, where employees will be able to check their earnings through the routine of
pay slips made available in the InternetBank access:
[Link] the Parameter tab: normal sheet type, installment "9", month and year of reference, date of
crédito sempre último dia útil do mês, *importante marcar no quadroIdentificador do
Employee Uses CPF, for this flag the employee will have access to their
payroll. In checking account company 5881, agency prefix 2414, bank contract number
1223, shipment number, always the sequence of the previous month. It is important to emphasize that
The account and agency numbers for the company do not include the verification digit.
2.14.FP6111–Pension Report, to generate the list of pension payments, from the sheets of
Férias, Rescisão e Normal, com esse relatório é possível avaliar se há pensões em aberto, e
extract the information to be paid in the payroll for the period.
2.14.1. In the Selection tab: put the month/year of the payroll responsibility.
[Link] the Print tab: check the RTF print option so that the file is generated.
in Word format.
2.15.FR0240–IR of Holidays, in the classification folder generate the IR separated by
establishment/business unit/enrollment and in the folder parameter check the option
only with retention. In the print folder, check the 'RTF' option to generate the file.
14

Word format. Save the generated report in the folder C:\tem, in the Reports folder of the sheet
your competence.
2.16.FR5360–Rescission IR, in the classification folder generate the IR separated by
establishment/business unit/enrollment and in the parameter folder check the option
somente com retençã[Link] pasta impressão marcar a opção “RTF”, para gerar o arquivo
Word format. Save the generated report in the C:\tem folder, in the Reports folder of the sheet.
your competence.
2.17.FP3580–IR of Normal Sheet, in the classification folder generate the IR separated by
establishment/business unit/enrollment and in the folder parameter check the option
only with retention. In the print folder, check the option "RTF" to generate the file
Word format. Save the generated report in the folder C:\tem, in the Reports folder of the sheet
your competence.
2.18.FP4020 – Union Deductions, in the classification folder, select the report separated by
"establishment/business unit/enrollment", and in the print folder check the option
"RTF", to generate the Word format file. Save the generated report in the folder C:\tem, in the
Reports folder of your responsibility.
2.19.FP4120– Appropriation of Events, to generate the loan relationship of the events '098'
(CEF) and "150" (BB), in the selection tab place the event code to generate, in the print tab check
the option 'RTF' and click on execute. Save the generated report in the folder C:\tem, in the folder of
Reports of your competence.
2.20.FP3560–FGTS to Collect, in the classification tab select the report separated by
establishment/business unit/registration, and in the printing folder check the option
"RTF", to generate the Word format file.
The generated Word report must be transferred to a spreadsheet, with its totals separated.
by business unit with a pivot table, for proper verification with the guide
generated in the SEFIP program.
2.21. FP4150 - Allocation by Service Provider, in the print folder select the option 'RTF', to
generate the Word format file. Save the generated report in the C:\tem folder, in the Reports folder
from the scope of your competence.
2.22. FP4250– Installment Movement List by Borrower, in the print folder select the 'RTF' option.
to generate the Word format file. Save the generated report in the C:\tem folder, in the folder of
Reports from your area of responsibility.
2.23. FR4150–Termination Distribution by Recipient, in the print folder select the 'RTF' option to generate
the file in Word format. Save the generated report in the folder C:\tem, in the Reports folder.
leaf of your competence.
2.24. FR4250–Termination Distribution Listing by Borrower, in the Parameter folder, CSV File field
Directory, mark the path C:\temp\, so that a spreadsheet with the delegates is generated.
and its funds.
2.25. FP3720 – GPS Guide Listing, to generate the INSS guide values, keep the settings
as it is, in the print folder select the option 'RTF', to generate the file format
Word.
2.26. FP3060–Calculation of Provisions, this routine is only to execute and save the generated file.
in the folder C:\temp, in the Reports folder of the payroll's competence.
2.27. FP4080–Provision 13th Salary, generation of the provision report, in the print folder mark
the option 'RTF', to generate the file in Word format. Save the generated report in the folder C:\tem,
in the Reports folder of your competence sheet.
15

2.28. FP4100–Vacation Provision, generating the provisions report, in the printing folder mark the
option 'RTF', to generate the file in Word format. Save the generated report in the folder C:\tem,
in the Reports folder of your responsibility.
2.29. FP4050–Gera Distribution by Cost Center, this routine should only be executed so that
the generation of the accounting should be done accordingly. Save the generated report in the folder C:\tem,
in the Reports folder of your responsibility.
2.30. FP4051–Accounting Demonstration by CC, this routine should only be executed in the folder
Print, select the option 'RTF' to generate the Word format file and save the report.
generated in the C:\temp folder, in the Reports folder of your competence.
2.31. FP3310 – Payroll Accounting Integration, this routine will integrate all payroll components and
provisions in the accounting module, to be executed only.
2.32. FP3640 – List of Admitted and Discharged, this routine will generate a report, for
CAGED file conference, save the generated report in the C:\tem folder, in the Reports folder
from the sheet of your competence.
2.33. FP5560–
2.34. FP6010 - Magnetic file SEFIP, to generate import file in the Caixa program
federal economic SEFIP.
2.35. FP3120 - Closing of the Last Calculation, only run the routine to close the calculation of
SHEET, to subsequently enable the calculation of 'Advance'
2.36. FP3200–Monthly Closure, this routine must be executed to close the month, a
once completed, it will not be possible to reopen the competency, nor even make adjustments in
any calculation.

You might also like