Welcome! My Account | Logout

TaxCode

BasicRate
AllowanceRate
DaysAbsent
HoursLate
HoursOvertime

WorkingDays
BasicPay
AllowancePay
OvertimePay
OtherIncome

RegularPay

SupplementaryPay

GrossPay
GrossPayForMonth
SSS
SSSER
SSSEC
PHIC
PHICER
HDMF
HDMFER

NetRegularPay

WTax

L_SSSBB
L_SSSAdj
L_SSS
L_SSSEB

L_HDMFBB
L_HDMFAdj
L_HDMF
L_HDMFEB

L_CashAdvBB
L_CashAdvAdj
L_CashAdv
L_CashAdvEB

LoanDeductions

NonTaxIncome

NetPay

Trace

Payscript

Download Paysheet

Trace of last calculation on Apr 20, 2024  10:32:53 PM
{
    
    [previous amount] BasicRate        
    [previous amount] AllowanceRate    

    
    [number] DaysAbsent = 0.0
    [number] HoursLate = 0.0

    
    [number] HoursOvertime = 0.0
}{
    
    [working days] DefaultWorkingDays( 5, 10, 20 )  
    [number input] WorkingDays = DefaultWorkingDays
    [constant] WorkingHoursPerDay = 8

    
    [constant] DailyBasic = BasicRate / WorkingDays
    [constant] HourlyBasic = DailyBasic / WorkingHoursPerDay
    [amount] BasicPay = BasicRate - ( DaysAbsent * DailyBasic ) - ( HoursLate * HourlyBasic )

    
    [constant] DailyAllowance = AllowanceRate / WorkingDays
    [constant] HourlyAllowance = DailyAllowance / WorkingHoursPerDay
    [amount] AllowancePay = AllowanceRate - ( DaysAbsent * DailyAllowance ) - ( HoursLate * HourlyAllowance )

    
    [constant] OvertimeFactor = 1.25
    [amount] OvertimePay = HoursOvertime * HourlyBasic * OvertimeFactor 
    [amount] OtherIncome = 0.0
}
[amount] RegularPay = BasicPay + AllowancePay
[amount] SupplementaryPay = OvertimePay + OtherIncome

{
    [amount] GrossPay = RegularPay
    [total for month] GrossPayForMonth( GrossPay )

    
    [SSS Vars] SSS( GrossPayForMonth )
    [PHIC Vars] PHIC( GrossPayForMonth )
    [HDMF Vars] HDMF( GrossPayForMonth )
}
[amount] NetRegularPay = GrossPay - SSS - PHIC - HDMF

{
    
    
    
    [WTax Vars] WTax( 
        TaxCode, 
        NetRegularPay, 
        SupplementaryPay, 
        1 )  

    
    [Loan List]
    {
        
        
        
        
        
        [Loan Deduction] SSS
        [Loan Deduction] HDMF
        [Loan Deduction] CashAdv
    }
    
    [Loan List Total] LoanDeductions

    
    [amount] NonTaxIncome = 0.0
}


[amount] NetPay = NetRegularPay + SupplementaryPay - WTax - LoanDeductions + NonTaxIncome

/********************************************************************************
///Payscript: Sample2014-SemiMonthly-Monthly-Or-Weekly-Rate-1.payscript
///Scribe: sweldista.com
///Title:  Sample Payroll Computation using a Semi-monthly, Monthly, or Weekly Rate
///Summary: 
Computes semi-monthly, monthly or weekly pay by deducting absences and late.
1.  Derives basic and allowance pay by deducting absences and late from a periodic rate (semi-monthly, monthly or weekly)
2.  Adds overtime
3.  Computes SSS, PHIC and HDMF based on the grosspay for the month as of the pay period
4.  Computes WTax using the same tax table as the pay period by default
    but WTax is automatically annualized based on the AnnualizationMonth parameter.
    If the AnnualizationMonth parameter is 1 then WTax is annualized from January and onwards.
5.  Deducts periodic loan payments
6.  Adds non-taxable income

Note:  Philippines.201401 makes use of SSS (2014), PHIC (2014), HDMF (2007), and WTax (2009)

///Environment: Philippines.201401
///WorkingPeriods: Semi-monthly, Monthly, Weekly
********************************************************************************/

// Last Updated: January 1, 2016
{
    // rates
    [previous amount] BasicRate        // weekly, semi-monthly or monthly rate
    [previous amount] AllowanceRate    // weekly, semi-monthly or monthly rate

    // attendance info for deducting from basic and allowance rate
    [number] DaysAbsent = 0.0
    [number] HoursLate = 0.0

    // overtime info for overtime pay
    [number] HoursOvertime = 0.0
}

// computation of RegularPay (before sss, phic and hdmf) and SupplementaryPay
{
    // working days and working hours
    [working days] DefaultWorkingDays( 5, 10, 20 )  // weekly, semi-monthly, monthly Days
    [number input] WorkingDays = DefaultWorkingDays
    [constant] WorkingHoursPerDay = 8

    // basic pay
    [constant] DailyBasic = BasicRate / WorkingDays
    [constant] HourlyBasic = DailyBasic / WorkingHoursPerDay
    [amount] BasicPay = BasicRate - ( DaysAbsent * DailyBasic ) - ( HoursLate * HourlyBasic )

    // allowance pay
    [constant] DailyAllowance = AllowanceRate / WorkingDays
    [constant] HourlyAllowance = DailyAllowance / WorkingHoursPerDay
    [amount] AllowancePay = AllowanceRate - ( DaysAbsent * DailyAllowance ) - ( HoursLate * HourlyAllowance )

    // overtime and other income
    [constant] OvertimeFactor = 1.25
    [amount] OvertimePay = HoursOvertime * HourlyBasic * OvertimeFactor // assuming no allowance for overtime
    [amount] OtherIncome = 0.0
}
[amount] RegularPay = BasicPay + AllowancePay
[amount] SupplementaryPay = OvertimePay + OtherIncome

// sss, phic, hdmf, NetRegularPay
{
    [amount] GrossPay = RegularPay
    [total for month] GrossPayForMonth( GrossPay )

    // sss, phic and hdmf are all based on the grosspay for the month as of the pay period
    [SSS Vars] SSS( GrossPayForMonth )
    [PHIC Vars] PHIC( GrossPayForMonth )
    [HDMF Vars] HDMF( GrossPayForMonth )
}
[amount] NetRegularPay = GrossPay - SSS - PHIC - HDMF

// wtax, loans, and non-taxable income
{
    // WTax is computed using the same tax table as the pay period by default
    // but WTax is automatically annualized based on the AnnualizationMonth parameter.
    // If the AnnualizationMonth parameter is 1 then WTax is annualized from January and onwards.
    [WTax Vars] WTax( 
        TaxCode, 
        NetRegularPay, 
        SupplementaryPay, 
        1 )  // Annualization Month (1=January, 12=December)

    // add loans in scope below
    [Loan List]
    {
        // Each loan will have:
        // 1.  BB=Beginning Balance
        // 2.  Adj=Increase/Decrease of Loan
        // 3.  Loan Deduction
        // 4.  EB=Ending Balance
        [Loan Deduction] SSS
        [Loan Deduction] HDMF
        [Loan Deduction] CashAdv
    }
    // total of loans
    [Loan List Total] LoanDeductions

    // non-taxable income
    [amount] NonTaxIncome = 0.0
}

// net pay
[amount] NetPay = NetRegularPay + SupplementaryPay - WTax - LoanDeductions + NonTaxIncome

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.

2014 Sample Semi-monthly Paysheet using SSS (2014), PHIC (2014), HDMF (2007), and WTax (2009)

Ang Unang Sweldista

<<<1 >>>

amiel_desotto

2017-Dec-05

0 replies

Rating: 0

Question why HDMF is base on GrossPayForMOnth? it should be 100 per month, right?

Ang Unang Sweldista

2016-Jan-02

1 reply

Rating: 0

Sample Payroll Computation using a Semi-monthly, Monthly, or Weekly Rate
(Sample paysheet uses semi-monthly mode but it can be used as a template for monthly or weekly pay)

Environment: Philippines.201401
WorkingPeriods: Semi-monthly, Monthly, Weekly

Note: Philippines.201401 makes use of SSS (2014), PHIC (2014), HDMF (2007), and WTax (2009)

Computes semi-monthly, monthly or weekly pay by deducting absences and late.
1. Derives basic and allowance pay by deducting absences and late from a periodic rate (semi-monthly, monthly or weekly)
2. Adds overtime
3. Computes SSS, PHIC and HDMF based on the grosspay for the month as of the pay period
4. Computes WTax using the same tax table as the pay period by default
but WTax is automatically annualized based on the AnnualizationMonth parameter.
If the AnnualizationMonth parameter is 1 then WTax is annualized from January and onwards.
5. Deducts periodic loan payments
6. Adds non-taxable income

<<<1 >>>

2 messages