How a three-person virtual assistance firm in Batangas moved its payroll and leave workbook into Tropa

Small teams feel payroll mistakes the most. This virtual assistance firm in Batangas has three people, and one of them is also the person who runs payroll. Before switching, she kept the numbers in her own payslips and a paid-time-off workbook, one sheet per employee.
The challenge
Nothing about their setup was standard. SSS is deducted as a fixed ₱1,000 on the first cutoff. PhilHealth is split across both cutoffs. Pag-IBIG comes off the first. One employee's pay is a basic wage plus monthly medical, rice, laundry and load or internet allowances. Leave doesn't follow a simple monthly formula either: each person accrues on their own day of the month, a nine-day grant arrives at the six-month mark, and one employee carried over a balance from a previous employer.
A new system had to land on the same numbers before it could replace her own.
What they switched on
- A salary plan built from their payslips. The default plan reproduces the SSS, PhilHealth and Pag-IBIG timing above, and contracts carry the actual wage and allowance figures from the payslips.
- A side-by-side check. Their June cutoffs were run in Tropa and compared line by line with the real payslips. Gross pay, SSS and Pag-IBIG matched exactly. The remaining differences were written down and settled before any live run.
- Leave from the workbook. A Paid Time Off type was created and every balance rebuilt from the workbook, sheet by sheet, until the running balances matched.
- Self-service with tight access. The payroll lead holds the administrator tools. The other two see only their own attendance, leave and payslips.
- Clock-in with a photo. Staff clock in and out from their own devices with a selfie.
Where they are now
- Three semi-monthly payroll runs released in Tropa, covering 16 August to 30 September
- Selfie clock-ins every working day since early September, 175 photo punches so far
- 13 approved leave requests, with balances that match the workbook
- All three employees signed in during the last 30 days
What's next
Because each person accrues leave on a different day of the month, monthly leave credits are still posted by hand. Automating those credits is the open item.
