ArteyuLabs

S4 · Simple tool

Payslip & Salary Record in Excel

Contributions calculated for you, payslips generated in a click.

KWSP PERKESO EIS Malaysia

The problems this fixes

  • Salaries paid over WhatsApp with no tidy record
  • Working out contributions on a calculator every month
  • A worker asks for a payslip for a loan - there is nothing to give

What you get

  • Employee register: name, IC number, position, basic salary, bank
  • 240-row monthly salary record with allowances, OT, bonus and deductions
  • Employee & employer contributions calculated from the rates in SETUP
  • Payslip generator: pick employee + month, the slip is ready
  • Contribution rates you can update when the official rates change

Sheets in the file

MULA SINIPEKERJAGAJISLIPSETUP

live formulas, audited with zero errors

Included with every purchase

  • Excel file (.xlsx) - a SAMPLE version (with example data) plus a BLANK version ready for your own data
  • MULA SINI sheet: a 15-minute starter guide in Malay
  • Imports into Google Sheets - use it on an Android phone or iPhone
  • Buyer's guide (PDF) plus FAQ
  • Free replacement file if yours breaks, and free version updates

Common questions

Can I use it on a phone?

The files are deliberately built without formulas that break in Google Sheets (no XLOOKUP, LET or spill formulas), so they should import and open in the Microsoft Excel app (Android/iOS) or Google Sheets (File > Import). Being straight with you: we have not yet run the import test on a real phone, so we cannot promise every chart and dropdown survives the import. If anything breaks, WhatsApp us - we fix it or refund you.

Do I need to be good at Excel?

No. You only type in the WHITE cells. GREY cells hold the formulas and calculate themselves.

How do I clear the example data?

Use the included '_KOSONG' (blank) file - it is already empty. Keep the sample file as a reference.

Is there a password?

No. Sheets are protected without a password so formulas cannot be deleted by accident. You can unprotect them yourself (Review > Unprotect Sheet) if you want to modify the file.