Welcome! My Account | Logout

TaxCode

BasicRate
AllowanceRate
DaysAbsent
HoursLate
HoursOvertime

BasicPay
OvertimePay
OtherIncome
AllowancePay

RegularPay

SupplementaryPay

RegularPayForMonth
SSS
SSSER
SSSEC
PHIC
PHICER
HDMF
HDMFER

NetRegularPay

WTax

NetPay

Trace

Payscript

Trace of last calculation on Sep 08, 2010  02:43:41 PM


{
    
    numeric input var BasicRate = 0 [default:PreviousPay.BasicRate 0];	
    numeric input var AllowanceRate = 0 [default:PreviousPay.AllowanceRate 0];	

    
    numeric input var DaysAbsent = 0 [default:0];
    numeric input var HoursLate = 0 [default:0];
    numeric input var HoursOvertime = 0 [default:0];

    
    var WorkingDays
    {
        WorkingDays = 10;  
        if( True [PayPeriod.PrdType 'Monthly' = 'Monthly'] )
            WorkingDays = 20;  
    }
}

{
    
    numeric output var BasicPay = 0 [Round2(0 [BasicRate 0 - 0 [(DaysAbsent 0 * BasicRate 0 / WorkingDays 20)] - 0 [(HoursLate 0 * BasicRate 0 / 160 [(WorkingDays 20 * 8)])]])];
    
    numeric output var OvertimePay = 0 [Round2(0 [HoursOvertime 0 * BasicRate 0 / 160 [(WorkingDays 20 * 8)]])];
    
    numeric input var OtherIncome = 0 [default:0];
    
    numeric output var AllowancePay = 0 [Round2(0 [AllowanceRate 0 - 0])] ;
}


numeric output var RegularPay = 0 [Round2(0 [BasicPay 0 + AllowancePay 0])];
numeric output var SupplementaryPay = 0 [Round2(0 [OvertimePay 0 + OtherIncome 0])];


{
    
    numeric output var RegularPayForMonth = 0 [MonthPay.RegularPay 0 + RegularPay 0];

    
    vector var SSSBracket = [Bracket '-',LLmtAmt 0,MoSalCr 0,ERCont 0,EECont 0,TotalCont 0,EREC 0] [GetSSSTableBracket(RegularPayForMonth 0)];

    
    
    
    numeric input var SSS
    {
        SSS = 0 [default:0 [SSSBracket.EECont 0 - MonthPay.SSS 0]];
    }
    numeric input var SSSER
    {
        SSSER = 0 [default:0 [SSSBracket.ERCont 0 - MonthPay.SSSER 0]];
    }
    numeric input var SSSEC
    {
        SSSEC = 0 [default:0 [SSSBracket.EREC 0 - MonthPay.SSSEC 0]];
    }

    
    vector var PHICBracket = [Bracket '-',LLmtAmt 0,SalBase 0,ERCont 0,EECont 0,TotalCont 0] [GetPHICTableBracket(RegularPayForMonth 0)];

    
    
    
    numeric input var PHIC
    {
        PHIC = 0 [default:0 [PHICBracket.EECont 0 - MonthPay.PHIC 0]];
    }
    numeric input var PHICER
    {
        PHICER = 0 [default:0 [PHICBracket.ERCont 0 - MonthPay.PHICER 0]];
    }

    
    numeric input var HDMF
    {
      
      HDMF = 0 [default:0 [Round2(0 [0 [RegularPayForMonth 0 * 0.01] - MonthPay.HDMF 0])]];

      
      if( False [RegularPayForMonth 0 >= 5000] )
        HDMF = Round2( RegularPayForMonth * 0.02 - MonthPay.HDMF );
    }

    numeric input var HDMFER
    {
      
      HDMFER = 0 [default:0 [Round2(0 [0 [RegularPayForMonth 0 * 0.01] - MonthPay.HDMFER 0])]];

      
      if( False [RegularPayForMonth 0 >= 5000] )
        HDMFER = Round2( RegularPayForMonth * 0.02 - MonthPay.HDMFER );

      
      if( False [0 [MonthPay.HDMFER 0 + HDMFER 0] > 100] )
        HDMFER = 100 - MonthPay.HDMFER;
    }
}

numeric output var NetRegularPay = 0 [Round2(0 [RegularPay 0 - SSS 0 - PHIC 0 - HDMF 0])];

{
    var TaxTable = PayPeriod.PrdType 'Monthly';

    
    vector var WTaxExemptionBracket = [TabID 'Monthly',ID '010',KeyCode 'Z',AmtExempt 0,AmtLvl01 0,AmtLvl02 0,AmtLvl03 833,AmtLvl04 2500,AmtLvl05 5833,AmtLvl06 11667,AmtLvl07 20833,AmtLvl08 41667,Type 'Data'] [GetWTAXTableExemptionBracket(TaxTable 'Monthly', TaxCode 'Z')];
    var TaxExemption = WTaxExemptionBracket.AmtExempt 0;

    
    var TaxableRegPay = 0 [NetRegularPay 0 - TaxExemption 0]
    {
      if( False [TaxableRegPay 0 < 0] )
        TaxableRegPay = 0;
    }

    
    vector var WTaxBracket = [Z 0,WTAX 0,PCTOVER 0.05] [GetWTAXTableTaxBracket(TaxTable 'Monthly', TaxCode 'Z', TaxableRegPay 0)];
    var TaxOnBracket = WTaxBracket.WTAX 0;

    
    var TaxOnExcess = 0 [0 [(TaxableRegPay 0 - WTaxBracket[TaxCode 'Z'] 0 + SupplementaryPay 0)] * WTaxBracket.PCTOVER 0.05];
}

numeric input var WTax
{
    WTax = 0 [default:0 [Round2(0 [TaxOnBracket 0 + TaxOnExcess 0])]];
}
;


numeric output var NetPay = 0 [Round2(0 [NetRegularPay 0 + SupplementaryPay 0 - WTax 0])];
return NetPay 0;

Note: The sample paysheets and payscripts are meant for illustration purposes only.
It is the user's responsibility to verify compliance with government regulations and company policies.

Can you help me on the formula for the computation of sss, ssser, phic, phicer, hdmf, hdmfer, wherein the basis is the amount in the BASIC PAY.. thanks. . .

jdelacruz

<<<1 >>>

Leilajoy

2010-Aug-04

0 replies

Rating: 0

may bagong memo pag ibig per RA 9679 which is 2% employees share and 2 % employer share na or see www.pagibig.gov.ph

fernando

2010-Aug-03

1 reply

Rating: 0

did pag-ibig issued memo regarding as to how much would be the premium? at present kasi we deduct and remit 100 for employee and 100 for employer, is it right? regarding Philhealth, i've read that the basis is basic salary and not gross? i need your comment, tks.

greatdad_me2

2010-Jul-26

0 replies

Rating: 0

miss joy ask ko lang po nabasa ko po kasi from the RA 9679 that 2% nga if employee is receiving a salary more than Php 1,500.00 but then there is a caption stating "the maximum monthly compensation to be used in computing employee and employer contributions shall not be more than five thousand pesos (Php 5,000)" thus it mean ceiling pa rin ang Php 100 (2% x 5000) contribution each employee and employer kahit an employee is receiving more than 5,000 na monthly compensation? just confused. Thanks

Leilajoy

2010-Jun-22

1 reply

Rating: 0

you are taking to hdmf. no as per latest memo
employee and aemployer contributions are now the same 2 %.

greatdad_me2

2010-Jun-18

1 reply

Rating: 0

hello po, yun po bang computation na 2%sa regular pay madatory or pwede pa rin po yung flat 100 sa employer at employee?

Ang Unang Sweldista

2009-Mar-18

2 replies

Rating: 0

Hello jdelacruz,

In the payscript you are using, SSS, SSSER (Employer share), PHIC and PHICER (Employer share) are all based on the SSS/PhilHealth Tables.

On the other hand, HDMF and HDMFER are either 1% or 2% of regular pay. 2% is used when regular pay is 5000 or more.

jdelacruz

2009-Mar-17

1 reply

Rating: 0

Can you help me on the formula for the computation of sss, ssser, phic, phicer, hdmf, hdmfer, wherein the basis is the amount in the BASIC PAY.. thanks. . .

<<<1 >>>

7 messages