Key takeaways
- Attendance inside the cutoff decides the pay, not memory.
- One contribution table serves every payslip.
- Advances are deducted on the run they are tagged to.
- Balance and status follow the payouts automatically.
Payroll in a small Philippine business is usually a notebook of daily attendance, a calculator, and one long evening every fifteen days. It works until somebody questions a deduction, and then nobody can reconstruct how the figure was reached. SweldoDesk PH keeps the same records a small employer already keeps, but connects them so the payslip is a consequence of the attendance rather than a separate act of arithmetic.
Let the cutoff decide which days count
A payroll run carries its own cutoff start and cutoff end. Every payslip points at a run, and the days, overtime hours and late minutes on that payslip are counted from attendance rows that fall inside those two dates.
That single rule removes the most common payroll dispute in a small company, which is a day being paid twice or not at all because it sat on the boundary between two cutoffs.
Keep one contribution table, not five memories
The employee shares for SSS, PhilHealth and Pag-IBIG live in one table, listed in ascending order of gross pay. The payslip looks up its own gross and takes the share for that bracket.
When a contribution schedule changes, the table is edited once. Every payslip prepared afterwards uses the new figures, and no one has to remember which bracket a particular employee belongs to.
Deduct advances on the run they belong to
A cash advance is recorded with the employee and the run it should be deducted from. The payslip sums only the advances tagged to its own run.
This is what keeps a vale from being deducted twice, or from quietly disappearing because the person who approved it was not the person preparing payroll.
Close the run on the balance, not on a feeling
Net pay is gross pay less total deductions. Paid is the sum of the payouts recorded against that payslip, so the balance is always current and the status reads Unpaid, Partial or Paid without anyone setting it.
The checks count duplicate payslip identifiers, payslips pointing at an employee who is not on file, payouts pointing at a payslip that does not exist, and any payslip paid beyond its own net pay.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
SweldoDesk PH Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.
No BIR alphalist, 2316 or withholding tax computation, no electronic filing or payment to SSS, PhilHealth or Pag-IBIG, no biometric or timeclock hardware connection, no bank payroll file upload, and no 13th month or final pay computation.
Frequently asked questions
Does it compute withholding tax?
No. It computes the SSS, PhilHealth and Pag-IBIG employee shares from your contribution table. Withholding tax, the alphalist and BIR forms are outside the workbook.
Can I pay someone in two instalments?
Yes. Record each payout against the same payslip. Paid accumulates and the balance drops until the status reads Paid.
Do I need a biometric device?
No. Attendance is entered as rows, one per employee per day, from whatever log the shop already keeps.
Does this replace official records?
No. No BIR alphalist, 2316 or withholding tax computation, no electronic filing or payment to SSS, PhilHealth or Pag-IBIG, no biometric or timeclock hardware connection, no bank payroll file upload, and no 13th month or final pay computation.
