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

L_SSSBB
L_SSSAdj
L_SSS
L_SSSEB

L_PABB
L_PAAdj
L_PA
L_PAEB

LoanDeductions

NetPay

Trace

Payscript

Trace of last calculation on Sep 08, 2010  03:17:00 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])]];
}
;



var LoanTotal = 0
{
    {
        
        numeric output var L_SSSBB = PreviousPay.L_SSSEB 0;

        
        numeric input var L_SSSAdj = 0 [default:0];

        
        numeric input var L_SSS = 0 [default:PreviousPay.L_SSS 0]
        {
            var EB = 0 [L_SSSBB 0 + L_SSSAdj 0 - L_SSS 0];

            
            if( False [EB 0 < 0] )
                L_SSS = L_SSSBB + L_SSSAdj;
        }

        
        numeric output var L_SSSEB = 0 [L_SSSBB 0 + L_SSSAdj 0 - L_SSS 0];
    }
    LoanTotal = 0 [LoanTotal 0 + L_SSS 0];
    ;
    
    {
        
        numeric output var L_PABB = PreviousPay.L_PAEB 0;

        
        numeric input var L_PAAdj = 0 [default:0];

        
        numeric input var L_PA = 0 [default:PreviousPay.L_PA 0]
        {
            var EB = 0 [L_PABB 0 + L_PAAdj 0 - L_PA 0];

            
            if( False [EB 0 < 0] )
                L_PA = L_PABB + L_PAAdj;
        }

        
        numeric output var L_PAEB = 0 [L_PABB 0 + L_PAAdj 0 - L_PA 0];
    }
    LoanTotal = 0 [LoanTotal 0 + L_PA 0];
    ;
}

numeric output var LoanDeductions = 0 [Round2(LoanTotal 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.

how do i add a column?

ecristill

<<<1 >>>

Leilajoy

2009-Sep-16

0 replies

Rating: 0

paki edit na lang ang payscript

ecristill

2009-Sep-11

1 reply

Rating: 0

how do i add a column?

<<<1 >>>

2 messages