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

Download Payscript

Trace of last calculation on Oct 05, 2024  10:55:28 AM
{
    
    numeric input var BasicRate = null [default:null PreviousPay.BasicRate];	
    numeric input var AllowanceRate = null [default:null PreviousPay.AllowanceRate];	

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


numeric output var RegularPay = [...] [Round2([...] [null BasicPay + null AllowancePay])];
numeric output var SupplementaryPay = [...] [Round2([...] [null OvertimePay + null OtherIncome])];{
    
    numeric output var RegularPayForMonth = [...] [0 MonthPay.RegularPay + null RegularPay];

    
    vector var SSSBracket = null [GetSSSTableBracket()];

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

    
    vector var PHICBracket = null [GetPHICTableBracket()];

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

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

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

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

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

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

numeric output var NetRegularPay = [...] [Round2([...] [null RegularPay - null SSS - null PHIC - null HDMF])];{
    var TaxTable = 'Weekly' PayPeriod.PrdType;

    
    vector var WTaxExemptionBracket = ['Weekly' TabID,'010' ID,'Z' KeyCode,0 AmtExempt,0 AmtLvl01,0 AmtLvl02,192 AmtLvl03,577 AmtLvl04,1346 AmtLvl05,2692 AmtLvl06,4808 AmtLvl07,9615 AmtLvl08,'Data' Type] [GetWTAXTableExemptionBracket(, )];
    var TaxExemption = 0 WTaxExemptionBracket.AmtExempt;

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

    
    vector var WTaxBracket = null [GetWTAXTableTaxBracket(, , )];
    var TaxOnBracket = null WTaxBracket.WTAX;

    
    var TaxOnExcess = [...] [[...] [(null TaxableRegPay - null WTaxBracket[] + null SupplementaryPay)] * null WTaxBracket.PCTOVER];
}

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


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

/********************************************************************************
///Payscript: SampleWeeklyComputation1.payscript
///Scribe: sweldista.com
///Title:  Sample Weekly Net Pay Computation
///Summary: 
Computes NetPay based on a payscript that works on Weekly periods.

///Environment: Philippines.200901
///WorkingPeriods: Weekly
********************************************************************************/

{
    // rates
    numeric input var BasicRate = PreviousPay.BasicRate;	// daily basic rate
    numeric input var AllowanceRate = PreviousPay.AllowanceRate;	// daily allowance rate

    // attendance
    numeric input var DaysWorked = 6.0;
    numeric input var HoursOvertime = 0.0;
}

{
    // basic pay
    numeric output var BasicPay = Round2( DaysWorked * BasicRate);
    // overtime
    numeric output var OvertimePay = Round2( HoursOvertime * BasicRate / 8 );
    // other income
    numeric input var OtherIncome = 0.0;
    
    // allowance
    numeric output var AllowancePay = Round2( DaysWorked * AllowanceRate );
}

//
numeric output var RegularPay = Round2( BasicPay + AllowancePay );
numeric output var SupplementaryPay = Round2( OvertimePay + OtherIncome );

// sss, phic, hdmf
{
    // MonthPay.RegularPay gets the RegularPay for the month (excludes the current period)
    numeric output var RegularPayForMonth = MonthPay.RegularPay + RegularPay;

    // Get the SSSBracket based on RegularPayForMonth
    vector var SSSBracket = GetSSSTableBracket( RegularPayForMonth );

    // MonthPay.SSS and MonthPay.SSSER/MonthPay.SSSEC are the employee and employer contributions for the month (excludes the current period).
    // So, the contribution for the period should be derived from the difference of what the contribution of the month should be
    // and what has been deducted on the previous periods within the month.
    numeric input var SSS
    {
        SSS = SSSBracket.EECont - MonthPay.SSS;
    }
    numeric input var SSSER
    {
        SSSER = SSSBracket.ERCont - MonthPay.SSSER;
    }
    numeric input var SSSEC
    {
        SSSEC = SSSBracket.EREC - MonthPay.SSSEC;
    }

    // Get the PHICBracket based on RegularPayForMonth
    vector var PHICBracket = GetPHICTableBracket( RegularPayForMonth );

    // MonthPay.PHIC and MonthPay.PHICER are the employee and employer contributions for the month (excludes the current period).
    // So, the contribution for the period should be derived from the difference of what the contribution of the month should be
    // and what has been deducted on the previous periods within the month.
    numeric input var PHIC
    {
        PHIC = PHICBracket.EECont - MonthPay.PHIC;
    }
    numeric input var PHICER
    {
        PHICER = PHICBracket.ERCont - MonthPay.PHICER;
    }

    //
    numeric input var HDMF
    {
      // HDMF is 1% of regular pay
      HDMF = Round2( RegularPayForMonth * 0.01 - MonthPay.HDMF );

      // HDMF is 2% of regular pay when regular pay is 5000 or more
      if( RegularPayForMonth >= 5000 )
        HDMF = Round2( RegularPayForMonth * 0.02 - MonthPay.HDMF );
    }

    numeric input var HDMFER
    {
      // HDMF is 1% of regular pay
      HDMFER = Round2( RegularPayForMonth * 0.01 - MonthPay.HDMFER );

      // HDMF is 2% of regular pay when regular pay is 5000 or more
      if( RegularPayForMonth >= 5000 )
        HDMFER = Round2( RegularPayForMonth * 0.02 - MonthPay.HDMFER );

      // check that the total for the month will not exceed 100
      if( MonthPay.HDMFER + HDMFER > 100 )
        HDMFER = 100 - MonthPay.HDMFER;
    }
}
// basis for withholding tax
numeric output var NetRegularPay = Round2( RegularPay - SSS - PHIC - HDMF );

{
    var TaxTable = PayPeriod.PrdType;

    // TaxExemption depends on the TaxCode of the Employee
    vector var WTaxExemptionBracket = GetWTAXTableExemptionBracket( TaxTable, TaxCode );
    var TaxExemption = WTaxExemptionBracket.AmtExempt;

    // Compute TaxableRegPay by deducting TaxExemption from NetRegularPay
    var TaxableRegPay = NetRegularPay - TaxExemption
    {
      if( TaxableRegPay < 0 )
        TaxableRegPay = 0;
    }

    // TaxOnBracket and WTaxBracket are based on TaxableRegPay only (without SupplementaryPay)
    vector var WTaxBracket = GetWTAXTableTaxBracket( TaxTable, TaxCode, TaxableRegPay );
    var TaxOnBracket = WTaxBracket.WTAX;

    // TaxOnExcess is based on TaxableRegPay and SupplementaryPay minus the WTaxBracket of the TaxCode
    var TaxOnExcess = ( TaxableRegPay - WTaxBracket[ TaxCode ] + SupplementaryPay ) * WTaxBracket.PCTOVER;
}
// WTax is the sum of TaxOnBracket and TaxOnExcess
numeric input var WTax
{
    WTax = Round2( TaxOnBracket + TaxOnExcess );
}
;

// net pay
numeric output var NetPay = Round2( NetRegularPay + SupplementaryPay - WTax );
return NetPay;

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.

Daily Wages

Blackmask

<<<1 >>>

Ang Unang Sweldista

2015-Feb-09

0 replies

Rating: 0

I recommend you use the latest samples because they are simpler. You can put a formula such as "[numeric] SSS=308" to put a fixed amount. You can add other lines of formulas for loans. Please see the 2013 or 2014 samples.

The new SSS and PHIC tables for 2014 are now available.

To use it in your paysheet:
1. Make sure you are using the latest Sweldista 0.9.7 released on January 26, 2014. Download and install if you don't have the latest version.
2. Make sure you have downloaded the latest paysheet samples for 2013 (or you are using a paysheet that is using payroll environment Philippines.201301).
3. In Sweldista Payroll, click on Sweldista.com Services and open the Edit Payscript menu.
4. Edit the line stating the payroll environment to Philippines.201401 (from Philippines.201301).
5. Make sure you put a check on Update Environment and then click on Save to Paysheet.
6. In Sweldista Payroll, click Recalculate All from the Edit menu. This will recalculate any previously saved calculations to the latest SSS and PHIC 2014 tables. (Make sure you are using the latest Sweldista 0.9.7 for the recalculate all menu to work)

Blackmask

2015-Feb-06

1 reply

Rating: 0

Hi Everyone,

Can somebody help me with the codes, i am trying to have a fixed deduction on goverment premiums.
SSS = 308
HDMF = 100
PHIC = 100

also i would like to add column for SSS , HDMF and company loans. Is this possible?

Hoping for your good insights.

Regards,
Bill

<<<1 >>>

2 messages