PT Cantina Mexicana Bali

HR Digital Integrated System

Bilingual PKWT · aligned Pasal / Article · signed PDF export

1 · Setup files -

1

Employee data

Mail-merge workbook (.xlsx / .xls / .csv).
2

Agreement template

Word template (.docx) with «MERGEFIELD» fields.
3

Amendment template

Addendum
Word template (.docx) for the Addendum, with «MERGEFIELD» fields. Data comes from the “Addendum” tab of the Mail Merge sheet.
4

Daily Worker template

PKHL
Word template (.docx) for the Daily Worker Agreement (Perjanjian Kerja Harian Lepas), with «MERGEFIELD» fields. Data comes from the “Daily Worker” tab of the Mail Merge sheet.
4

Company logo

Top centre
5

HRD signature

Placed under “Human Resource”. PNG with transparent background works best.
6

HRD initial (paraf)

Stamped bottom-right on every page.
7

Director signature

Placed under “Director”, above the Director's name.

2 · Overview

3 · Select employees

No.Agreement No.EmployeeContractPeriodStatusCheck
Upload the employee data workbook to list employees.
0 selected ·

Mail Merge Data

4 · e-Meterai (Bea Meterai)

5 · Signing & layout settings

Signatures & output

Signatures are placed in the empty space under the anchor text, centred above the signer's name. They are only visible in Preview and in the generated PDF.

Template field check

Upload both files to see which template fields are matched to data columns.

PT Cantina Mexicana Bali · HR Department - agreements are generated in your browser only; contract monitoring data is shared by HR through this page.