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  03:16:14 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 [(DaysAbsent 0 * AllowanceRate 0 / WorkingDays 20)] - 0 [(HoursLate 0 * AllowanceRate 0 / 160 [(WorkingDays 20 * 8)])]])];
}


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.

additional table

alan@gaffcomnl.com

<<<1 >>>

Leilajoy

2009-Oct-12

0 replies

Rating: 0

what do you mean?

alan@gaffcomnl.com

2009-Oct-07

1 reply

Rating: 0

additional table

<<<1 >>>

2 messages