Calculator ni Juan tools for calculating taxes

sahod kal-kyu-ley-tor

Posted on August 21, 2011

Description: A tool designed for calculating Philippines salary based on Republic Act 9504. Tax table are taken from various private and goverment agencies such as BIR, PhilHealth, SSS, HDMF(Pag-Ibig) and different Health Insurance companies.

nick rasta comic strip

author : Nick Rasta

Note: the program is still under beta test.. please report any bug to father.jonzkie@gmail.com


basic pay :

(Semi-Monthly))

over time :

night diff :

absent : note: 1 = 1day or 0.5 = half day

tardiness :

under time :

REST DAY :

rd ot :

rd ot over 8hrs :

SPECIAL HOLIDAY :

sp holiday :

sp holiday over 8hrs :

sp holiday rd :

sp holiday rd over 8hrs :

LEGAL HOLIDAY

legal hd :

legal hd over 8hrs :

legal hd rd :

legal hd rd over 8hrs :

tax shielded allowance

(Semi-Monthly) - non-taxable

include :

SSS :

philHealth :

PagIbig :

sss loan :

health insurance :

allowance :

Other :

taxable allowance

(Semi-Monthly)

csat :

attendance bonus :

Other :

Summary

(semi-monthly)

Basic Pay : 0.00

Allowance(taxable) :

csat : 0.00

attendance bonus : 0.00

-----------------------

Sub-Total : 0.00


non-taxable income

SSS : 0.00 (Employee contribution(ER))

PagIbig : 0.00 (HDMF)

Phil-Health : 0.00 (EeS)

sss loan : 0.00

health insurance : 0.00


other non-taxable income

allowance : 0.00

-----------------------

sub total : 0.00


Status :

Withholding tax : 0.00


-----------------------

gross pay : 0.00

total non-tax income : 0.00

over all deduction : 0.00

-----------------------

Net Pay : 0.00

-----------------------

Generated Report
edit constant values

Basic Monthly Salary : 0.00

No. of working days in a year : 262 days

Standard working hours per day : 8 hours

over time : 125%

deductions

(Monthly)

SSS : 500.00

PhilHealth : 50.00

Pag-Ibig(HDMF) : 0.00

LEGEND :

Standard Rate :

Yearly Rate : 0.00

Monthly Rate : 0.00

Daily Rate : 0.00

Hourly Rate : 0.00

Over time Rate per hour : 0.00

Night Differential Pay per hour : 0.00

Tax Computation.

Gross pay : 0.00

Taxable Income total : 0.00

Tax Exemption : 0.00

%over : 0.00

Base Tax : 0.00

REST DAY :

rd ot : 0.00 per hour

rd ot over 8hrs : 0.00 per hour

SPECIAL HOLIDAY :

sp holiday : 0.00 additional rate per hour

sp holiday over 8hrs : 0.00 per hour

sp holiday rd : 0.00 per day

sp holiday rd over 8hrs : 0.00 per hour

LEGAL HOLIDAY

legal hd : 0.00 additional rate per hour

legal hd over 8hrs : 0.00 per hour

legal hd rd : 0.00 per hour

legal hd rd over 8hrs : 0.00 per hour


contact me: father.jonzkie@gmail.com
Comments (7) Trackbacks (0)
  1. i like this

  2. ang goleng. :D

  3. How to use :
    1. fill out the basic pay field then hit quick submit.
    2. If you are calculating the first pay out of the month (15th etc… ) get the deductions value (ex. sss, phil health…etc) and fill out the non-taxable fields. If its the 30th etc… you may need to to skip the sss or any other deduction field if consumed on the first pay out.
    3. Fill out the overtime and holiday fields if accrued.
    4. Hit Submit.

    Bug:
    1.> first time visitors may not able to click on the boxes due to some web restrictions. Hit quick submit to resolve the issue.

    Whats Next?
    a.> ITR computation and Sick Leave Conversion.
    b.> Compatibility of the program for different companies.
    c.>An option to change the constant values like night differential rate etc…

    Note : send a copy of your pay slip to father.jonzkie@gmail.com for calibration.

  4. chief, bug fix, paayos ng ME3, pero panalo to pre

  5. Thanks for posting my comic strip! Working on my feature guest Mr. Roscoe Bryant

  6. astig to.. lupet.. alamat!..


Leave a comment

(required)

No trackbacks yet.