Skip to content

PRTAXMNT Payroll State/City Tax Code File Maintenance 2

Entry Field Descriptions

First Screen

 

Name

Type and Description

1.  State Or City?

1 alphabetic character.

 

Valid values are:

 

S   =  State

C   =  City

2.  Tax Code

2 alphanumeric characters.

 

For a state, this should correspond to the usual postal code for the state (though this is not required).

 

For a city, it should be some two‑character abbreviation of the city name.

 

Press the F7 key to search for tax code.

3.  Description

30 alphanumeric characters.

 

This would be the full state or city name.

4.  Tax Rpt Id No

15 alphanumeric characters.

 

This is the number assigned to the employer by the state or city for purposes of identification on remittances and tax returns.

5.  Tax Liab Acct

An account number in the standard account number format.

 

This account is the state (SWT) or city (CWT) taxes payable account to which posting of the amount withheld occurs.

 

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

6.  Supp Earn W/H %

5 numeric digits with 3 decimal places (99.999).

 

Some states and cities allow an alternative method of calculating withholding tax on supplemental earnings (such as bonuses, commissions, etc.), which is a flat percentage of the supplemental earnings amount.  If this is the case, enter the percent here.  If zero is entered, then all supplemental earnings will be taxed in the same way as regular wages.

7.  Tax Ot/Spec Wage As

     Suppl Earn?

Y or N.

 

If your state requires that Ot and special pay, without regular pay, be taxed by the supplemental pay percentage, answer Yes to this question. If answered Yes and there is no regular pay, the supplemental, overtime, and special pay will be added together and the flat percentage rate will be taken.

 


NOTE:  Fields 8 through 17 are requested for state codes only.

 

Name

Type and Description

8.  Sui Percent

5 numeric digits with 3 decimal places (99.999).

 

This is the State Unemployment Insurance (SUI) percent of taxable wages that the employer is required to pay.  It is not withheld from the employee's salary.

9.  Sui Maximum $

8 numeric digits with 2 decimal places (999,999.99).

 

This is the maximum amount of places of an employee's wages to which the percent in 7 above applies.

10.  Sui Exp Acct

An account number in the standard account number format.

 

This should be the main account number for the SUI expense account.  When payroll checks are posted, the SUI amount for each employee is calculated and this amount is posted as a debit to an expense account and as a credit to a liability account.  The expense account number is obtained by using this SUI main account number and using the subaccount number from the for the SUI expense and using the subaccount number of the employee's wage account, which has been defined in the Employee File.

 

If you do not wish this automatic posting to occur, then leave this field blank.

 

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

11.  Sui Liab Acct

An account number in the standard account number format.

 

This is the liability account that counterbalances the expense account of the previous field.  If no entry was made for field 9 above, then this field will be skipped.

 

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

12.  Ost Percent

5 numeric digits with 3 decimal places (99.999).

 

Enter the current percent of taxable gross pay that is required to be withheld from the employee for other state tax, if any.  (An example of this would be State Disability Insurance.)

13.  Ost Maximum $

8 numeric digits with 2 decimal places (999,999.99).

 

This is the maximum amount of an employee's taxable wages to which the percent in 11 above applies.

14.  Ost Liab Acct

An account number in the standard account number format.

 

This is the liability account to which all amounts withheld for OST are posted automatically, during the posting of payroll checks or manual payroll transactions.


14.  Ost Liab Acct (continued)

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

15.  Ost Max Per Pay

6 numeric digits with 3 decimal places (999.999).

 

This is the maximum that can be deducted from the employee's pay in a given period.  If your state does not have a maximum limit, leave the field blank.

16.  Minimum Wage

5 numeric digits with 3 decimal places (99.999).

 

This field is used for information purposes only and applies only to states.  It is not necessarily the same as the federal minimum wage that is stored in Payroll Setup.

17.  L and I Code

6 alphanumeric characters.

 

Enter the Labor and Industry code to be used during calculation of this state tax.  If your state does not use L and I codes, leave the field blank.

Second Screen

 

This screen is only displayed for state codes and applies solely to worker's compensation for the state.

 

Name

Type and Description

1.  Calculation Method

1 alphabetic character.

 

Valid values are:

 

H   =  Hourly Rates

P   =  Percent of Wages

 

This is the method by which the worker's compensation premium is calculated on an employee‑by‑employee basis.  Each employee record contains a rate field for worker's compensation.  If the current field is H, this rate represents a certain number of dollars per hour (or part) worked.  If the current field is P, this rate represents a percentage of the employee's taxable earnings.

2.  Anniversary Date

A date in the standard date format.

 

This is the anniversary, or start date, of the Worker's Compensation Insurance policy for this state.

3.  Maximum Amount

8 numeric digits with 2 decimal places (999,999.99).

 

Some states only require that the worker's compensation premium be paid on an individual employee's wages or hours up to a maximum.  If this is the case, enter the maximum wages or hours here.

 

NOTE:  Each employee must be specified individually as being eligible or subject to this amount cut‑off.  If an employee is not so specified, then the premium will be calculated on all wages or hours anyway.

 

You specify whether or not an employee is eligible for this maximum cut‑off in field 43 on screen 1 of the Employee File application.

 

NOTE:  The period covered by this maximum amount is the same as the accumulation period defined in the next field. 

4.  Accumulation Period

1 alphabetic character.

 

Valid values are:

 

P   =  Period (as defined in this package‑usually a month)

Q   =  Quarter

Y   =  Calendar Year

A   =  Anniversary Year

 

The wages or hours subject to worker's compensation will be accumulated for each employee in an accumulator in the Employee File. The current field specifies when and how this accumulator is to be cleared.  If this field is P, Q or Y, then the accumulator will be cleared whenever the Clear PTD Totals, Clear QTD Totals, or Clear YTD Totalsapplications (respectively) are run.  If this field is A, then the user will be allowed to clear the accumulator when the Worker's Compensation Report is printed, but only if the current date is on or after the anniversary date, (which is defined in field 2) and only if the date the accumulators were last cleared was before the anniversary date in the current year.

4.  Accumulation Period (continued)

The Worker's Compensation Report calculates the premium based on the accumulated wages or hours in the Employee File application.

5.  Experience Modifier

5 numeric digits with 2 decimal places (999.99).

 

This is a state‑assigned number and represents a percentage to multiply the calculated worker compensation premium by, based on past experience of claims by employees, in order to get the final value of the premium due.  This defaults to 100% on initial entry. 

6.  Expense Account

Up to 5 alphanumeric characters.

 

This field has the same significance as the SUI Expense Account.  This should be the main account number for the Worker's Compensation expense account.

 

If it is blank, no automatic posting of the worker's compensation premium will be done during payroll check posting.  Otherwise, the calculated premium amounts will automatically be posted to the G/L Distribution file.

 

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

7.  Liability Account

An account number in the standard account number format.

 

This is the credit (liability) account corresponding to the debit (expense) account in the previous field.

 

Pressing the F7 key will allow you to search for an account by number or pressing the F8 key will allow you to search for an account by description.

8.  Calculate On

    Reg/Base/All Pay

1 alphabetic character.

 

This field determines if the tax code calculation will be based on regular pay, all pay at the base rate, or all pay.

 

Valid entries are:

 

B   =  All Pay Using Base Rate

R   =  Regular Pay Only

A   =  All Pay(Default)

 

Feedback and Knowledge Base