Welcome! My Account | Logout

TaxCode

BasicRate
AllowanceRate
DaysWorked
HoursLate
HoursOvertime
Holidays

BasicPay
AllowancePay
OvertimePay
HolidayPay
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 Oct 10, 2024  12:22:03 AM
{
    
    [previous amount] BasicRate        
    [previous amount] AllowanceRate    

    
    [number] DaysWorked = 0.0
    [number] HoursLate = 0.0

    
    [number] HoursOvertime = 0.0

    
    [number] Holidays = 0.0
}{
    
    [constant] WorkingHoursPerDay = 8

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

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

    
    [constant] OvertimeFactor = 1.25
    [amount] OvertimePay = HoursOvertime * HourlyBasic * OvertimeFactor 
    [amount] HolidayPay = Holidays * DailyBasic  
    [amount] OtherIncome = 0.0
}
[amount] RegularPay = BasicPay + AllowancePay + HolidayPay
[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: Sample2013-Daily-Rate-1.payscript
///Scribe: sweldista.com
///Title:  Sample Payroll Computation using a Daily Rate
///Summary: 
Accumulates weekly, semi-monthly or monthly pay based on a daily rate.
1.  Computes (weekly, semi-monthly or monthly) basic and allowance pay from a daily rate based on number of days worked and hours late
2.  Adds overtime and holidays
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.201301 makes use of SSS (2007), PHIC (2013), HDMF (2007), and WTax (2009)

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

// Last Updated: January 30, 2013
{
    // rates
    [previous amount] BasicRate        // daily rate
    [previous amount] AllowanceRate    // daily rate

    // attendance info for computing basic and allowance rate
    [number] DaysWorked = 0.0
    [number] HoursLate = 0.0

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

    // holidays
    [number] Holidays = 0.0
}

// computation of RegularPay (before sss, phic and hdmf) and SupplementaryPay
{
    // working hours
    [constant] WorkingHoursPerDay = 8

    // basic pay
    [constant] DailyBasic = BasicRate    // daily rate
    [constant] HourlyBasic = DailyBasic / WorkingHoursPerDay
    [amount] BasicPay = ( DaysWorked * DailyBasic ) - ( HoursLate * HourlyBasic )

    // allowance pay
    [constant] DailyAllowance = AllowanceRate    // daily rate
    [constant] HourlyAllowance = DailyAllowance / WorkingHoursPerDay
    [amount] AllowancePay = ( DaysWorked * DailyAllowance ) - ( HoursLate * HourlyAllowance )

    // overtime, holiday and other income
    [constant] OvertimeFactor = 1.25
    [amount] OvertimePay = HoursOvertime * HourlyBasic * OvertimeFactor // assuming no allowance for overtime
    [amount] HolidayPay = Holidays * DailyBasic  // assuming no allowance for holidays
    [amount] OtherIncome = 0.0
}
[amount] RegularPay = BasicPay + AllowancePay + HolidayPay
[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.

2013 Sample Weekly Paysheet using SSS (2007), PHIC (2013), HDMF (2007), and WTax (2009)

Ang Unang Sweldista

<<<1 >>>

Ang Unang Sweldista

2013-Jan-22

0 replies

Rating: 0

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

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

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

Accumulates weekly, semi-monthly or monthly pay based on a daily rate.
1. Computes (weekly, semi-monthly or monthly) basic and allowance pay from a daily rate based on number of days worked and hours late
2. Adds overtime and holidays
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 >>>

1 message