Scribd
Upload
3 views3 pages

Civil Construction Payroll Calculator

The document outlines a spreadsheet designed for calculating worker's income and deductions in civil construction, including various components such as Sunday pay, overtime, and family allowances. It details the calculations for worker discounts, employer contributions, and the ability to import data into PDT PLAME and AFPNET. Additionally, it mentions the generation of payroll slips that can be printed or saved in PDF format, customizable with company branding.

Uploaded 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
3 views3 pages

Civil Construction Payroll Calculator

The document outlines a spreadsheet designed for calculating worker's income and deductions in civil construction, including various components such as Sunday pay, overtime, and family allowances. It details the calculations for worker discounts, employer contributions, and the ability to import data into PDT PLAME and AFPNET. Additionally, it mentions the generation of payroll slips that can be printed or saved in PDF format, customizable with company branding.

Uploaded 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

PLAME CIVIL CONSTRUCTION FORM

CALCULATION OF WORKER'S INCOME AND DEDUCTIONS

- Prorating Sunday pay to 1/6 of the wage


- Calculation of Holidays
- Calculation of family allowance per child
- Calculation of overtime at 60% and 100%
- Essalud life (S/ 5.00)

CALCULATION OF WORKER'S INCOME


The spreadsheet is configured with all the necessary concepts for the regime of
civil construction such as:

- Sunday Remuneration
- Overtime at 60%
- Overtime at 100%
- Holidays
- Basic Rem
- BUC
- Extraordinary Bonus
- School Assignment
- Gratifications
- CTS
- Mobility

CALCULATION OF WORKER DISCOUNTS


The spreadsheet performs calculations of:
- Pension system, ONP or AFP, discriminates between fixed or mixed commission by AFP
- Discount for conafovicer

The spreadsheet does not perform the following calculations.

Union dues discount


Funeral installment discount
Calculation of Fifth Income Tax

Calculation of Employer Contributions

- 1% additional AFP
- Essalud
- SCTR
- Essaludlife

THE STRUCTURE IS COMPLETELY CONFIGURABLE AND CAN BE ADAPTED TO ANY TYPE


OF CIVIL CONSTRUCTION ORGANIZATION

IMPORTATION OF DATA INTO PDT PLAME


The Macro PLAME generates flat files to be directly imported by the PDT PLAME.

The generated files are

- .JOR, workday
- .REM, Remunerations
- .TAS, SCTR Rate
- .TOC, Essalud life
PAYROLL SLIPS

The payroll generates payment slips in duplicate.

- The tickets can be sent directly to print or saved in PDF format.


- The ballots can be printed in batches (all the ballots for all the workers)
with a single click).
- The tickets can be configured with the company's logo and information.

AFPNET
The spreadsheet generates the flat file to be imported into AFPNET.

You might also like