Welcome! My Account | Logout

TaxCode

BasicRate
AllowanceRate
DaysWorked
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  03:38:04 PM


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

    
    numeric input var DaysWorked = 6 [default:6];
    numeric input var HoursOvertime = 0 [default:0];
}

{
    
    numeric output var BasicPay = 3000 [Round2(3000 [DaysWorked 6 * BasicRate 500])];
    
    numeric output var OvertimePay = 0 [Round2(0 [HoursOvertime 0 * BasicRate 500 / 8])];
    
    numeric input var OtherIncome = 0 [default:0];
    
    
    numeric output var AllowancePay = 600 [Round2(600 [DaysWorked 6 * AllowanceRate 100])];
}


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


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

    
    vector var SSSBracket = [Bracket 'vi',LLmtAmt 3250,MoSalCr 3500,ERCont 247.3,EECont 116.7,TotalCont 364,EREC 10] [GetSSSTableBracket(RegularPayForMonth 3600)];

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

    
    vector var PHICBracket = [Bracket '1',LLmtAmt 1,SalBase 4000,ERCont 50,EECont 50,TotalCont 100] [GetPHICTableBracket(RegularPayForMonth 3600)];

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

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

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

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

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

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

numeric output var NetRegularPay = 3397.3 [Round2(3397.3 [RegularPay 3600 - SSS 116.7 - PHIC 50 - HDMF 36])];

{
    var TaxTable = PayPeriod.PrdType 'Weekly';

    
    vector var WTaxExemptionBracket = [TabID 'Weekly',ID '020',KeyCode 'S',AmtExempt 0,AmtLvl01 0,AmtLvl02 962,AmtLvl03 1154,AmtLvl04 1538,AmtLvl05 2308,AmtLvl06 3654,AmtLvl07 5769,AmtLvl08 10577,Type 'Data'] [GetWTAXTableExemptionBracket(TaxTable 'Weekly', TaxCode 'S')];
    var TaxExemption = WTaxExemptionBracket.AmtExempt 0;

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

    
    vector var WTaxBracket = [S 2308,WTAX 163.46,PCTOVER 0.2] [GetWTAXTableTaxBracket(TaxTable 'Weekly', TaxCode 'S', TaxableRegPay 3397.3)];
    var TaxOnBracket = WTaxBracket.WTAX 163.46;

    
    var TaxOnExcess = 217.86 [1089.3 [(TaxableRegPay 3397.3 - WTaxBracket[TaxCode 'S'] 2308 + SupplementaryPay 0)] * WTaxBracket.PCTOVER 0.2];
}

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


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

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.

Sample Weekly Net Pay Computation (1st Week)

Ang Unang Sweldista

<<<1 >>>

Ang Unang Sweldista

2009-Feb-09

0 replies

Rating: 0

This is a sample paysheet containing the payroll for the 1st week of the month.

<<<1 >>>

1 message