1) Adapted from response
by Gerald on Tue, 7 May 2002
Use SM31 to access
table T512W. This contains the wage type info. View V_512W_T contains the wage
type text.
2) Adapted from response by Vivian on Tue, 7 May 2002
The last two digits
of the /3, /4, /5, /6, /7 wage types represent the tax types. Table T5UTT
contains all of the SAP tax types. For example if you look in T5UTT you will
see that tax type 10 = Employer Unemployment Tax. /4 represents employee tax
taken; therefore, /410 represents employer unemployment tax taken. I've
outlined a description of common tax types below.
*********************************
- /3XX - Total gross
wages. Does not reduce wages by any pre-tax deduction wage types. For example,
if salary is $1,000 and the 401(k) deduction is $200, /3xx will be $1,000.
(/CXX - Tip income processing).
- /4XX - EE Tax
calculated and returned by BSI (/DXX - Tip income processing.
/401 01 = EE Federal
taxes taken
/401 02 = EE state
taxes taken; Subtype 02 usually represents state taxes for /401
/401 03 = EE Local
taxes taken; Subtype 03 usually represents local taxes for /401
/403 = EE Social
Security taken
/404 = ER Social
Security taken
/405 = EE Medicare
taken
/406 = ER Medicare
taken
/410 = ER
Unemployment taken
- /6XX - Gross wages
less pre-tax deduction. For example, if salary is $1,000 and the 401(k)
deduction is $200,/6xx will be $800. SAP passes this amount to BSI for tax
calculation. (/EXX - Tip income processing)
- /7XX - Reportable
taxable amount calculated by BSI. If ceilings on taxable amounts exist and are
exceeded, BSI will return a reportable taxable amount of zero. (/FXX - tip
income processing).
- /NXX - Tax
calculated, but not taken. (/HXX - Tip income processing) :
Example: Wagetype /N01 : This wage type represents the
withholding tax calculated by BSI, but not
taken due to insufficient funds.
- /IXX - Deduction
from a previous period that was not reduced.
Example : Wagetype /I01: This wage type represents a withholding tax deduction not
reduced from a
previous period(s). The deduction
amount is stored in this wage type to
be collected from future employee
wages.
- /QXX - Wages that are taxable but not subject to
withholding. (/UXX - Tip income processing).
Example: Wagetype /Q01
This wage type represents the amount
subject to withholding tax, but is not taxed. For example, if an employer
chooses not to withhold taxes on a given benefit from employee wages, then
the taxable amount is stored in this wage type for year-end reporting.
Net payments/Deductions
/110
Wage type /110 (Net payments/deductions) is a secondary wage
type. This wage type includes all net payments and deductions, i.e. what are
termed transitory items, such as travel expenses reimbursement, rent for a
company-owned flat etc
Here is some information on the /551, /552, /553, /561 and /563
wage types. This includes how these wage types are created and also
handled during a retro situation.
/551 - Retrocalc Difference
This wage type is formed based on values from the ORT (original
results table). This wage type stores the difference between the
ORT (original results table) /560 (amount paid) and the newly calculated /560
(amount paid). This difference is stored in the payroll period for which
the retro was run. The sign is reversed.
/551 is the total retro amount for the period. This is
because it is calculated from /560 (amount paid) for the original and new
periods.
*The first time a period has a retro, /551 will equal
/553. The second time and all subsequent times, /551 can be different
than /553. Calculation of /551 in retro periods: /551 is stored in the DT
(difference table) to allow /552 to be processed in the current period (see
/552 for details). /551 only appears in retro periods. It
does not appear in original periods. Rule X042 processes the ORT
(original results table) and subtracts /560 (amount paid) and /564
(advance payment) from /551. Rule X043 processes the input
table and adds the current /560 (amount paid) to/551. Rule X060 will
reverse the sign of /551.
/551 is stored in table DT (differences table) for each retro
period. This allows /551 to be accumulated without storing the
accumulated amount in each retro period.
Table DT (differences table) is not stored at the end of a
calculation run. It only exists during the retro run. The amount in table
DT is the retro difference between the most recently calculated amount and the
one before.
Rules = X041, X042, X043 and X060.
/552 - Retro From Prev Period:
/552 is the total retro amount from the retro calculated
periods. Calculation of /552: during retro periods, /551#s are cumulated in the
DT (differences table). Rule X042 processes the ORT (original results
table) and does the following: any /551 in the ORT is added to table DT.
Any /560 (amount paid) or /564 (advance payment) is subtracted from table
DT. Rule X043 processes the input table adds the calculated /560 (amount paid)
amount to the DT. The summation of the results from the prior 2 steps are
stored in the DT (differences table) for
that period. Note that the ORT (original results table) is the
results table from the prior run of the period being calculated. It is
not the results table from the original run of the period being recalculated.
/552 is calculated in an original period from rule X041.
Rule X041 processes the DT (difference table) that was created in the retro
periods.
Formula for /552: sum of each retro (Current IT /560 + ORT /552
+ ORT /551 - ORT /560 - ORT /564). Note that the current IT /560 is the
calculated amount which will be overwritten by the /560 from the original
period later in the schema. Note: /552 calculation is from
the prior period perspective. Each #sum of retro# is based on
the period it is derived from.
Note that /552 does not change in recalculated periods.
The amount from the original calculation for the period is passed through to
the results table.
Rules - X041, X042 and X060.
/553 - Recalc difference to last payroll
/553 compares net for the period for which payroll is currently
being run with the previous result for the same period. /553 is the latest
retro amount for the period. This is because the /560 in the ORT will
always equal the original period /560 and the /551 from the prior period is
calculated in to create /553.
The first time a period has a retro, /551 will equal /553.
The second time and all subsequent times a period retros, /551 can be different
from /553. Calculation of /553: /553 will only appear in a retro period.
It does not appear in original periods. Rule X042 processes the ORT
and adds /551 (retrocalc difference) to /553. Then, it
subtracts /560 (amount paid) and /564 (advance payment) from /553. Rule
X043 processes the input table and adds the current /560 (amount paid) to
/553. Rule X060 will reverse the sign of /553.
/560 - Amount Paid
Wage type /560 is the sum of /550 (statutory net) and /110
(employee deductions).
Wage type /560 does not change in retro periods. It is
recalculated in a retro period but then set back to its original value. The new
/560 calculation is utilized to calculate other technical
wage types. Rule X040 is processed in original and retro periods.
This rule adds /550 (statutory net) to /560. It subtracts /110
(deductions) from /560.
Rule X04A is processed in original and retro periods. It
adds /565 (carry over for subsequent month) to /560. It subtracts /561
(claim) from /560. The /565 amount and /561 amount are retrieved from the
last results table of the prior period. (Ex: period 6 if calculating period 7).
Rule X041 runs in the current period but not in retro periods.
Differences from table DT for wage type /551 (retrocalc difference) are added
to /560. The differences could either increase or
decrease /560. Rule X042 runs in retro periods. This rule
imports the prior run of the period being processed. (Ex: Period 4 in 5 if
running period 4 in 6. /552 (retro from previous period) is added to
/560. /560 (reversal of /557), /570 (reversal of /558) and /571 (reversal
of /559) are added to /560. The /560 amount from the prior run of this
period is added to the results table.
Rule X050 utilizes wage type /560 for calculating infotype 0009
percent amounts. If a percentage direct deposit is entered on infotype
0009, this percent is multiplied by /560 and processed to be taken. Rule X060
processes /560 to determine 3 things. If /560 is negative,
it is deleted and a /561 (claim) wage type is created for the
same amount. If the payroll run is a retro, the newly calculated
/560 is ignored. If this is an original period, the /560 is written
to the results table.
Rules = UM40, X040, X04A, X041, X042, U042, X047, X043, X060.
/561 & /563
Example: One employee
is having Earning for that employee is Rs. 32500/-. Deduction is Rs.
2459/- (2400 PF, 59 Tax). But take home is coming Rs. 18062/- instead of Rs.
30041/-. That Extra amount (Rs. 11979/-)is coming under WT /563 in RT
Wage type /563 (Claim from previous month) contains a
claim which affects the employee.
Combination of secondary wage types /561 and /563 for
'Claim'
If the amount for wage type /560 (Net pay) is negative at
the end of the payroll run, a claim is made against the employee. This
may, for
example, be the case if the employee was accidentally
paid more than twice his salary in the previous month. It is not
possible to clear the
difference in the current payroll period by deducting it
from his salary. In this case, the amount for wage type /560 (Net pay)
is marked
as negative and the +/- sign is reversed in wage type
/561 (Claim) in the payroll results.
In the following payroll period, the amount for wage type
/561 (Claim) is read from the old payroll results, transferred to wage
type /563
(Claim from previous month) and deducted from the current
amounts for wage types /560 (Net pay) and /562 (Remaining net pay).
Wage type /561 (Claim) represents an offsetting entry for
expenses which are posted to credits. It is always preceded by a plus
sign and is
always posted to debits. In the same way, wage type /563
(Claim from previous month), which also always has a plus sign, is
posted to
credits.
Overpayment Balance (/580)
Wage type /580 (Overpayment Balance) is a secondary wage type that
shows the amount that is yet to be recovered from the employee.
Payroll function USCLM populates this wage type with the amount to
be recovered.
In an Overpayment Recovery scenario, where the employee owes the
employer a certain amount, wage type /580 contains the exact balance that is
yet to be recovered from the employee.
Posting: These wage types should not need to be posted since the
original wage type causing the overpayment would be posted.
Amount Recovered (/581)
Wage type /581 (Amount Recovered) is a secondary wage type that
indicates, in an Overpayment Recovery scenario, the amount that has been
recovered from the employee.
Payroll function USCLM populates this wage type with the amount
that has been recovered.
In an Overpayment Recovery scenario, the amount will be either:
· The amount
deducted from employee gross earnings in accordance either with the
configuration that has been defined rules framework, or
· The amount
determined by the entries in employee records of the infotype (0909).
The total amount deducted for an employee via Overpayment Recovery
is populated in wage type /581.
Posting: These wage types should not need to be posted since the
original wage type causing the overpayment would be posted to the same account
as Overpayments with the same taxability (assuming same tax year). This ensures
that the Overpayment recovered is recovered and posted according to where the
overpayment occurred and posted when recovered. Payroll Overpayments Recovery Secondary Wage Types and Infotypes Error! Reference source not found.
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 13
Prior-Year
Overpayments (/582)
Wage type /582 (Prior-Year Overpayments) is a secondary wage type
that indicates, in an Overpayment Recovery scenario, the total balance of the
overpayment amount that has crossed tax years and that the employee still owes
to the employer.
Payroll function USCLM populates this wage type with the
corresponding amount.
In an Overpayment Recovery scenario where the overpayment balance
has crossed tax years (that is, the overpayment occurred in a prior year and
the overpayment balance is brought forward), the entirety of the remaining
balance is cumulated within this wage type, which is processed as a non-taxable
deduction wage type.
Posting: These wage types should be posted according to the
business rules of recovering prior year overpayments.
Amount Forgiven (/583)
Wage type /583 (Amount Forgiven) is a secondary wage type that
indicates, in an Overpayment Recovery scenario, the total overpayment amount
that the employer has forgiven.
The amount recorded in this wage type does not necessarily
correspond to the overpayment amount, because the employer may forgive either
the entire overpayment, or only a portion thereof.
Posting: These wage types should not need to be posted since the
original wage type causing the overpayment has been posted and not recovered.
Amount Overpaid (/584)
Wage type /584 (Amount Overpaid) is a secondary wage type that
indicates, in an Overpayment Recovery scenario, the total amount that the
system detected to have been overpaid to the employee in the payroll period
where the overpayment occurred.
In the majority of Overpayment Recovery scenarios, amounts in wage
type /584 are present in retroactive payroll runs, because the overpayment is
always detected to have occurred in the retroactive payroll period.
Posting: These wage types should not need to be posted since the
original wage type causing the overpayment has been posted and adjustments will
be made in accounting based on recovery.
Previous Period Overpaid Balance (/585)
Wage type /585 (Previous Period Overpaid Balance) is a secondary
wage type that indicates, in an Overpayment Recovery scenario, the balance of
the overpayment in the previous payroll run. The remainder of the overpayment
amount that the employee has yet to repay, as of the previous payroll period,
is recorded within wage type /585. During any payroll period, the difference
between the present wage type and wage type /580 represents the precise amount
of the overpayment that was recovered.
Posting: These wage types should not need to be posted since the
original wage type causing the overpayment has been posted and adjustments will
be made in accounting based on recovery.
No comments:
Post a Comment