Sir good pm! It is very informative and was discussed in details. But just for clarifications, the total amt of statutory deductions total of 14+has been added to the gross pay which you reflected on the item 14 which has now become the total amt of compensation? ..pls help me inderstand.thank you
Good pm! Question, how about the employee's Salary is P25k if we compute the tax per month its equal to P513.40, but since the employee started in April 1 the total is only 9 months and not exceeded to P250,000 annual, how will we do this, please help us to clarify on this computation.
Hi sir, may question po ako dun sa item 23, what if biglang nagIncrease yung sahod ni employee from below 20k to let's say 25k pero yung annual income niya is less than 250k subject pa rin po ba siya sa monthly withholding tax? NagIncrease na kasi yung monthly niya ng above 20,833. Thank you po
Hoping mapansin nyo po ito... Pno nyo po narrive yng total compensation is it basic salary -lates+overtimepay +holiday pay? Meaning dipa nadededuct yng mandatory like sss etc...tnx po Hindi ko po kci matally yng gross.base sa schedule ng excel..
If you don't mind sir for another query...about alphalist of employees do wee need to create manually excel formatted list or the system will generate it automatically and just print and submit only?
hi sir! tanong ko lang po san nakuha yung 248k+ sa gross pay? tinotal ko po kasi sa excel pero di po tugma sa akin. nasa 233k+ lang po yung total sa akin. I hope na mabasa niyo po ito. thank youuu po :)
Hi! Thanks for asking. Hindi po sya tlg magtatally mam sa Gross pay if from excel mo sya cocomputin per column kasi naka present po sya paano ifillup ung mga fields s 1601c at dun magtatally sa gross pay after mong mafillupan ung fields. Sa columns 14 and 15, ang totol lng nun ay para sa mga MWE. Hinihiwalay ng report ung mga MWE in terms of basic pay at premium pay like OT,etc then ipapasok un s fields 14 and 15 ng returns.. S field 19 naman total employee share ng mga sss, phealth, etc regardless MWE or not. Then field 23 nmn ung mga sweldo above minimum na hindi na reach ang 20833. Then ung may basic na mataas s 20833, masasubject na sya s tax. All in all if naipasok mo lahat sa fields ng tama, dun magtatally ang lahat ng editable fields sa gross pay.
sinunod ko etong tutorial ni Sir, pero I found out hindi dapat iadd sa Total Amount of compensation yung SSS, Philhealth at Pagibig. Nag aamend ako ngayon. huhuhu
@@babymimiho6800 s gross compensation kasama po dun ung sss, ph at pagibig muna, then i ma minus un as allowable deduction along with other nontaxable income to come up with net taxable income.
Thank you so much po. malinaw na malinaw
Good morning sir, very informative and it's good to all bir first time filers. Sana po gumawa po kayo tutorial sa 1601C with adjustments. Thank you.
thank you sir.. very understandable... GOD BLESS YOU SIR.
hi sir! san po kaya pwede mkuba ang ganyang alphalist? I tried looking sa Playstore wala po pala. Salamat po and Godspeed.
Thank you sir sa tutorial. God bless
a very informative video tutorial, madaling intindihin lalo na sa mga baguhan. can i request po ng excel template.? thank you.
Sir good pm! It is very informative and was discussed in details. But just for clarifications, the total amt of statutory deductions total of 14+has been added to the gross pay which you reflected on the item 14 which has now become the total amt of compensation? ..pls help me inderstand.thank you
Thanks for your video Sir.. Pede bko makahingi ng copy ng excel..
Good pm! Question, how about the employee's Salary is P25k if we compute the tax per month its equal to P513.40, but since the employee started in April 1 the total is only 9 months and not exceeded to P250,000 annual, how will we do this, please help us to clarify on this computation.
Paki send po ng sample template ng salary ng employees
Sir good day po. Yung ilalagay po bang amount ng OT is total OT ni employee for the whole month? Thanks Sir. God bless :)
Thank you for a very informative presentation. Can I request a copy of the excel template?
up
Sir may I also request for a copy of excel file thanks
Hi sir, may question po ako dun sa item 23, what if biglang nagIncrease yung sahod ni employee from below 20k to let's say 25k pero yung annual income niya is less than 250k subject pa rin po ba siya sa monthly withholding tax? NagIncrease na kasi yung monthly niya ng above 20,833. Thank you po
Hoping mapansin nyo po ito...
Pno nyo po narrive yng total compensation is it basic salary -lates+overtimepay +holiday pay?
Meaning dipa nadededuct yng mandatory like sss etc...tnx po
Hindi ko po kci matally yng gross.base sa schedule ng excel..
Hello Sir, paano po nakuha yung 248,490? Thanks
What if po walang entry sa item 25 i mean zero ?
hindi po ba ito individually submission, like per employees fill up
Sabayan po, lahat ng employees
Sir what is your formula for gross pay po? thanks
Thanks for the informative vid sir... pwede po bang makahingi nung excel file mo?🙂
Good day Sir, May I ask a copy of this file too?, My email add is candy.camarillo@gmail.com.Thanks
What if Minimum Wage Earner and with Allowance po?
sir saan pwede makakuwa ng ganyang table thanks in advance
Good day, May I ask a copy of this file, Thanks.
hello po sir pede po hinge ako ng template nyopo?
salamat po
hi sir, nalilito lang ako, dapat ba ilagay yung employee share na sss/phic sa #19 ng MWE?eh diba po included na xa sa basic pay
di po ba 2times na na less yun pag ganun?
Sir I notice SSS,PH & PI is part of Gross Pay...am I right?
Yes sir. Gross compensation includes all. That is the total amount to be received by an employee before any deduction.
@@paneloaccountingfirm8407 so I need to addback and deduct such employees contribution? Thank you sir!
If you don't mind sir for another query...about alphalist of employees do wee need to create manually excel formatted list or the system will generate it automatically and just print and submit only?
Paki send po ng template
sir, can u pls send me copy of ur excel file for my template.
Hi po! Pwede pong makahingi ng template niyo for this? Thank you po
sir pde po pahinge nung excel file para masundan po. tnx po
hi sir! tanong ko lang po san nakuha yung 248k+ sa gross pay? tinotal ko po kasi sa excel pero di po tugma sa akin. nasa 233k+ lang po yung total sa akin. I hope na mabasa niyo po ito. thank youuu po :)
ahh. inadd po pala yung sss/phil/hdmf pero bakit po sila inadd huhu
Hi! Thanks for asking. Hindi po sya tlg magtatally mam sa Gross pay if from excel mo sya cocomputin per column kasi naka present po sya paano ifillup ung mga fields s 1601c at dun magtatally sa gross pay after mong mafillupan ung fields. Sa columns 14 and 15, ang totol lng nun ay para sa mga MWE. Hinihiwalay ng report ung mga MWE in terms of basic pay at premium pay like OT,etc then ipapasok un s fields 14 and 15 ng returns.. S field 19 naman total employee share ng mga sss, phealth, etc regardless MWE or not. Then field 23 nmn ung mga sweldo above minimum na hindi na reach ang 20833. Then ung may basic na mataas s 20833, masasubject na sya s tax. All in all if naipasok mo lahat sa fields ng tama, dun magtatally ang lahat ng editable fields sa gross pay.
sinunod ko etong tutorial ni Sir, pero I found out hindi dapat iadd sa Total Amount of compensation yung SSS, Philhealth at Pagibig. Nag aamend ako ngayon. huhuhu
@@babymimiho6800 sino po nagsabi na ialis ang sss, ph, pagibig sa gross compensation po?
@@babymimiho6800 s gross compensation kasama po dun ung sss, ph at pagibig muna, then i ma minus un as allowable deduction along with other nontaxable income to come up with net taxable income.
Hi sir saan nakakahu nung excel file?
Hi sir. Very informative po. Baka pwede po makahingi po ng excel file niyo po. Salamat po.
catecfcfiber@gmail.com po sir. Salamat po.
Sir pwede po makahinge ng excel file, noemi.cabanglan@yahoo.com
Sir pwede pong makahingi Ng excel file ng template nio please. iemthinbase@gmail.com here's my email po. Salamat. God bless and keep safe po