0
Former Member
Feb 06, 2022 at 09:01 AM

# PY-CA :why no limit check for Quebec Tax Calculation in SAP

125 Views

Hi Experts,

i found that there are differences between SAP system and Manual excel for Quebec tax calculation.

the problem is in SAP there is no "H", i don't know why.

I = Annual taxable income = P × (G – F – H) – J – J1 If the result is negative, enter 0.

where

P = Number of pay periods in the year

G = Gross remuneration subject to source deductions of income tax for the pay period. Do not include gratuities, retroactive pay or similar lump-sum payments

F = Total of the following amounts for the pay period

• the contribution to an RPP;

• the contribution to an RRSP;

• the contribution to a VRSP or to a PRPP; ......

H = Deduction for employment income

= (0.06 × D), up to a maximum of \$1,235 / P

D = Gross salary or wages subject to source deductions of income tax for the pay period. Do not include gratuities, retroactive pay or similar lump-sum payments. P = Number of pay periods in the year

......

the following picture is the one i searched online, obviously H exists

while in my system, there is no H existing

The constants TXQC8 and TXQCH are OK in V_T511K

i don't know how to trigger this....

Federal Tax is align with CRA but Quebec is different from the result from QRA because of the missing of this function.

Could anyone help me with this?

QRA result is 91.74

H: =Min of 1280*6%=76.8 and 1235/26=47.5, so H=47.5

(1280-47.5)*26=32045 32045*15%=4806.75 4806.75-16143*15%=2385.3 2385.3/26=91.74

SAP result is 98.87

1280*26=33280 33280*15%=4992 4992-16143*15%=2570.55 2570.55/26=98.87

Attachments

image.png (237.3 kB)
image.png (67.6 kB)
image.png (71.1 kB)
image.png (269.6 kB)