
Originally Posted by
boypahak
Hello, IT ko. Gadevelop mi karon ug payroll system, problem namo is unsaon pag compute sa SSS contribution ug withholding tax sa isa ka employee.
SSS: naa mi SSS contribution table diri and I don't know exactly how to compute for an employee's deduction. unsay formula?
withholding tax: kabalo ko mag compute sa employee's withholding tax kung given na ang iyang annual income. that would be less the personal exemption and dependents then look up sa tax table. what if kung per month nga income ang basehan sa tax, di nako kabalo. there are two paydates in 1 month diri nga company but ang deduction is didto i charge sa first paydate of the month. so unsa formula sa withholding tax sa employee based sa iyang monthly incom?
Master Boy,
...i think naa na sa wrong section. Mas maay man siguro ni adto sa "Programming" subsection, kay daghan pod mga masters didto. Patabang lang sa mga Modz nato.
On the question itself, ako ika-share ra is this:
For
SSS deductions, makuha man na nimo from the "table". Here's what i suggest:
1) for those paid weekly, ang ilang gross income per week for the first 3 weeks will be "monthlytized"

. Meaning ang first week will be times 4, ang 2nd week will be times 4, ang 3rd week will be times 4. On the 4th week, just sum-up all the gross income for the whole month and recompute the SSS contribution. If kulang, then another deductions will be reflected. If sobra, a refund must be reflected.
2) for semi-monthly paid, same procedure. I-monthlitize lang ilang income and then compute. Deduct ang kulang or refund ang sobra.
3) for monthly paid, mas dali na siguro nimo.
For
W/Holding Taxes, naa man na sila'y
Monthly Witholding Tax Table. Kana nalang basihe. Then "monthlitize" dayon.
I believe you know how to use "if-then" notations or syntax. Im not a programmer, but i think gamit kaayo ni. I can do the automatic calculations in excel using this.
Ang importante ra man siguro is ma-adjust ang total contributions on the last payroll of the month. Then another round of adjustment at the end of the year (yearly tax refunds), if naa man gani.
Hope this helps.