Uniform Staff Payroll System (USPS)
User
Guide
Chapter 27
Refunding Deductions
A refund of deduction is necessary in the event an employee has a
deduction withheld during a payroll when it should not have been
deducted.
There are two methods for processing a refund of deduction.
If the employee is to be reimbursed for the deduction withheld in error
during the course of a normal payroll, proceed as follows:
- Access the deduction withheld in error in USPSCN/DEDSCN.
- Using the modify option, enter the amount withheld in error as a
negative figure in the Error Adjustment field. This is the amount the
deduction check will be reduced by and the amount to be refunded to the
employee. Be sure there is no stop date on the deduction and that there
is no maximum amount in effect for the deduction that would prevent it
from being processed.
- Process the payroll to completion in the normal manner. Check the
PAYRPT for this employee carefully to insure the deduction is refunded
for the correct amount.
If the employee will not be included in a future payroll or the
district prefers to refund the deduction immediately, a separate check
for the refund amount may be processed as follows:
- Access the deduction withheld in error in USPSCN/DEDSCN.
- Using the modify option, enter the amount withheld in error as a
negative figure in the Error Adjustment field. This is the amount the
deduction check will be reduced by and the amount to be refunded to the
employee. Be sure there is no stop date on the deduction and that there
is no maximum amount in effect for the deduction that would prevent it
from being processed.
- Run the INICAL program. Enter a pay of the month that corresponds
to the deduction's pay cycle and select the special payroll option.
- Access the USPSCN/REFSCN module. Using the Add function, add the
employee in the REFSCN program. Once added the employee's ID and name
will appear on the screen.
---------------------------------------------------------------------------
| Find: _________ ______________ __________ |
| SSN/ID Last Name First Name |
| |
| ID Name |
| 222222222 JONES, JOHN |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| REFSCN Refund of Deductions |
| XX Top XX Find |
| XX Help XX Add |
| XX Exit XX Delete |
| XX Next XX Lockmode |
---------------------------------------------------------------------------
|
NOTE: Do not access this employee using USPSCN/UPDCAL_CUR
at this time. This may cause incorrect amounts to be paid to the
employee.
- Complete the special payroll process by running CALCPAY, CHKPRT,
and CHKUPD.
During CALCPAY, the amount in the error adjustment
field of the applicable deduction is placed in the net pay amount. No
other records are processed for this type of check and there will be no
gross pay.
- During CHKUPD, the deduction accumulators are reduced by the amount
in the error adjustment field. This reduction includes YTD and QTD
amounts. No adjustments are made to the gross accumulators. You will
need to update these fields manually.
CHKUPD requires a USAS check
number before it will process. Even though this payroll has no need of
a USAS check, the number entered should be the next available number on
file. This check number will not actually be used on the USAS side. It
acts as a dummy value to allow CHKUPD to run. Once CHKUPD has been
completed, the USAS check number can be re-used.
- The employee will receive a check for the amount of the error
adjustment. Direct deposit employees will receive a physical check
rather than a direct deposit check. This same amount will be withheld
from the next deduction check processed for that particular deduction
company.
Chapter 28
Renumbering Overlapping and Jammed Checks
Situations may occur where the check numbers preprinted on check forms
do not match what is recorded on the system. This may result from a
data entry error where an incorrect chek number is used when generating
checks or problems created when a printer becomes jammed with checks.
In these situations it may be necessary to renumber the checks through
the program CHKNUM.
- Physical Checks are the preprinted forms on which
the checks are printed. These forms often have a check number
preprinted on them.
- System Checks refer to the information which is
stored on the system concerning each check that is written. The check
number in this case is taken from the start number that is entered in
the program that creates the check. Programs that create checks are
like CHKPRT, PAYDED, etc.
It is important that the physical and system checks match for reporting
and check reconciling purposes.
The CHKNUM program referred to in Examples 1, 2 and 3 is used to
renumber or move system checks. More information on how CHKNUM works
can be found in in the USPS Reference Manual.
Example 1, The physical check number entered is less
than the system's highest check number on file and the physical and
system check numbers overlap.
|
Starting System Check Number
|
30477
|
|
Starting Physical Check Number
|
30476
|
- Using CHKNUM renumber the system checks to a check number outside
of possible use (i.e. 900000). This step frees-up the correct system
check numbers. In CHKNUM it would look like this,
Revision 4.0a
This program renumbers the Payroll checks
Do you have the correct program? (Y/N <Y>): _
<CR>
Enter old starting check no. ______
30476
Enter old ending check no. ______
30478
Enter new starting check no. ______
900000
Enter new ending check no. ______
900002
Old New
Starting check number: 030476 900000
Ending check number : 030478 900002
Is this correct? (Y/N <Y>) _
<CR>
*** Output report is CHKNUM.TXT ***
*** Total no. of checks changed ** 3
|
- CHKNUM can then be used to renumber the system checks into the
correct sequence where 30477 is the starting check number. In CHKNUM it
would look like this,
Revision 4.0a
This program renumbers the Payroll checks
Do you have the correct program? (Y/N <Y>): _
<CR>
Enter old starting check no. ______
900000
Enter old ending check no. ______
900002
Enter new starting check no. ______
30477
Enter new ending check no. ______
30479
Old New
Starting check number: 900000 30477
Ending check number : 900002 30479
Is this correct? (Y/N <Y>) _
<CR>
*** Output report is CHKNUM.TXT ***
*** Total no. of checks changed ** 3
|
Example 2, The physical check number is greater than
the system's highest check number on file and the physical and system
check numbers overlap.
|
Starting System Check Number
|
30477
|
|
Starting Physical Check Number
|
30478
|
- Using CHKNUM renumber the system checks to a check number outside
of possible use (i.e. 900000). This step frees-up the correct system
check numbers.
- CHKNUM can then be used to renumber the system checks into the
correct sequence where 30478 is the starting check number.
- Check number 30477 is open at this point. It can be put on the
system as a dummy alignment check through the HANDCK program.
Example 3, The first three payroll checks were jammed
in the printer. The rest of the checks printed correctly.
|
Starting System Check Number
|
30477
|
|
Starting Physical Check Number
|
30477
|
- Using CHKNUM, renumber the jammed checks (30477 - 30479) to the
next highest system/physical checks on file.
- Type the correct checks.
Chapter 29
Reporting Taxable Amount of Life Insurance Premiums
According to the Internal Revenue Service, the cost of group-term life
insurance an employer provides to an employee for coverage over $50,000
is to be included in the wages reported for the employee. This amount
is subject to withholding for Social Security and Medicare, but not
income tax. The cost is generally determined by using the uniform
premium rates provided by the IRS. These rates set the cost of each
$1000 of group-term life insurance for each month, according to the
employee's age.
The following steps will ensure that the proper amounts will be taxed
and placed on the W2 forms.
- Calculate the taxable amount for each employee involved.
Example
A 35 year old principal receives $250,000.00 of board paid group
term life insurance for an entire calendar year.
The amount of
excess coverage over $50,000.00 is used to determine the taxable
coverage. In this example the amount of taxable coverage would be
$200,000.00.
$250,000.00 - $50,000 = $200,000.00
|
Using this same figure, it must be determined how many thousands of
dollars are involved.
$200,000 / $1,000.00 = 200
|
This figure will be used later to determine the annual cost.
IRS Publication 15-A gives the cost per $1000.00 of protection for
a 1 month period. The cost for this 35 year old is .09 per month. This
must be multiplied by the number of months the coverage was in effect.
The non-cash earnings amount is calculated by taking the number of
thousands and multiplying it by the factor calculated in the previous
step.
- Using the USPSCN/UPDCAL_CUR or USPSCN/UPDCAL_FUT program, the
amount should be entered using a pay type of NC1. This pay type
represents one kind of non-cash earnings for the employee.
This pay
type will be treated differently for taxation purposes. Using this
non-cash earnings amount, the tax amounts for Medicare and Social
Security will be calculated during the CALCPAY and UPDCAL_CUR programs.
No Federal, Ohio, or OSDI tax amounts will be calculated. All of these
will be treated according to the federal rules. The software provides
the ability to withhold city tax on non-cash earnings. This can be
activated by setting the "Tax non-cash earnings" flag to Y (yes) on the
city tax record in the USPSDAT/DEDNAM program.
- Complete the payroll.
The non-cash earnings amount will not be
included in the gross pay amount, nor in the gross totals found on
PAYRPT or PAYSUM. However, the non-cash earnings amount is being
included in the adjusted gross figure because the amount is considered
part of the taxable gross even though no tax is being withheld on it.
Both the PAYRPT and PAYSUM reports will provide a total figure of all
non-cash earnings in the total section. This extra total will help in
balancing purposes.
During the CHKUPD program, the total payment
showing for NC1, will be added to the total and taxable gross figures
on all the tax records including those for which no tax was withheld.
The JOBSCN to-date figures (screen 3 of 3) will also be updated in the
Non-cash earnings fields.
If the NC1 pay not was not used prior to the last pay
of the calendar year, the following manual procedure must be used in
order for the NC1 pay to show correctly on the W2 form and to insure
that the QRTRPT balances. Follow these procedures prior to generating
W2 forms.
- Increase the YTD gross and the YTD taxable gross figures on the
federal tax record by the amount of the taxable premium.
- Increase the YTD gross and YTD taxable gross figures on the state
tax deduction record to reflect the taxable premium.
- Increase the YTD gross and the YTD taxable gross figures on the
municipality tax deduction record IF required by the municipality. It
may be necessary to contact the city tax department to determine if the
premiums on life insurance over $50,000 are considered taxable or not.
- Increase the YTD gross and YTD taxable gross figures on the FICA
and/or Medicare deduction records to reflect the taxable premium.
- Obtain payment from the employee for the FICA (6.2% of the taxable
premium) and/or Medicare (1.45% of the taxable premium) withholding
amounts. Include this amount on the YTD Deduct Total field of the
FICA/Medicare Deduction record(s). The board of education must match
these same amounts calculated in this step (process as a USAS
transaction).
- Enter the taxable premium of life insurance on the federal tax
deduction record in DEDSCN on the "Life Insurance Cost" line.
- Enter the taxable premium of life insuance on the to-date fields
for Non-cash earnings on JOBSCN (3 of 3). This will insure that the
QRTRPT non-cash earnings will balance.
Chapter 30
Retirement Correction Scenarios
This chapter contains scenarios that provide situations and procedures
for correcting retirement system information in the event that errors
occur.
The scenarios relate to situations that occur in the same fiscal year
and are documented for both SERS and STRS retirement systems.
SCENARIO 1
An employee has money withheld for the wrong retirement system
and will be working for the district in the future.
SERS withheld in error and information not reported to
SERS
Corrective action Option 1:
- On the 590 record for the employee, enter a stop date.
- On the 400 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to STRS.
- Add the 591 record.
- Add the 450 record.
- Manually calculate the amount of STRS that should have been
withheld and wasn't.
- Calculate the difference between what was withheld for SERS and
what should have been withheld for STRS and enter this amount as a
positive error adjustment on the 591 record.
- Using the 590 record, manually update the withholding figures on
the 591 to include that from the pays where SERS was withheld in error.
- Manually adjust the retirement gross figures on the 450 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 450 record if necessary or
desired.
- Once all information has been transferred to the STRS records, the
SERS records can be cleared or deleted.
Corrective action Option 2:
- On the 590 record for the employee, enter a negative error
adjustment.
- Process a refund of deduction payroll for this employee. This will
get the money withheld in error, back to the employee.
- On the 590 record for the employee, enter a stop date.
- On the 400 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to STRS.
- Add the 591 record.
- Add the 450 record.
- Manually calculate the amount of STRS that should have been
withheld and wasn't.
- Enter this amount as a positive error adjustment on the 591 record
to withhold the extra from the employee.
- Manually adjust the retirement gross figures on the 450 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 450 record if necessary or
desired.
- Once all information has been transferred to the STRS records, the
SERS records can be cleared or deleted.
SERS withheld in error and information reported to SERS
Corrective action:
- On the 590 record for the employee, enter a stop date.
- On the 400 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to STRS.
- Add the 591 record.
- Add the 450 record.
- Manually calculate the amount of STRS that should have been
withheld and wasn't.
- Enter the amount of STRS that should have been withheld as a
positive error adjustment on the 591 record.
- Manually adjust the retirement gross figures on the 450 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 450 record if necessary or
desired.
- On the next SERS monthly report filed, submit the correction form
for this.
- Contact SERS and request a refund of the overpayment for both
employee and employer shares. Upon receipt of the money, deposit the
employee portion into the payroll clearance account.
- Run HANDCK to create a check to get this amount to the employee.
- Once all information has been transferred to the STRS records, the
SERS records can be cleared or deleted.
STRS withheld in error and information not reported to
STRS
Corrective action Option 1:
- On the 591 record for the employee, enter a stop date.
- On the 450 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to SERS.
- Add the 590 record.
- Add the 400 record.
- Manually calculate the amount of SERS that should have been
withheld and wasn't.
- Calculate the difference between what was withheld for STRS and
what should have been withheld for SERS and enter this amount as a
negative figure on the 591 record.
- Using the 591 record, manually update the withholding figures on
the 590 to include that from the pays where STRS was withheld in error.
- Manually adjust the retirement gross figures on the 400 to include
the wages from the pays where SERS was not withheld.
- Manually update the board amounts on the 400 record if necessary or
desired.
- Once all information has been transferred to the SERS records, the
STRS records can be cleared or deleted.
Corrective action Option 2:
- On the 591 record for the employee, enter a negative error
adjustment.
- Process a refund of deduction payroll for this employee. This will
get the money withheld in error, back to the employee.
- On the 591 record for the employee, enter a stop date.
- On the 450 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to SERS.
- Add the 590 record.
- Add the 400 record.
- Manually calculate the amount of SERS that should have been
withheld and wasn't.
- Enter this amount as a positive error adjustment on the 590 record
to withhold the extra from the employee.
- Manually adjust the retirement gross figures on the 400 to include
the wages from the pays where SERS was not withheld.
- Manually update the board amounts on the 400 record if necessary or
desired.
- Once all information has been transferred to the SERS records, the
STRS records can be cleared or deleted.
STRS withheld in error and information reported to STRS
Corrective action:
- Contact STRS for a correction procedure.
- Contact the SSDT if necessary to implement the correction
recommended by STRS staff.
- Contact SERS for a correction procedure.
- Contact the SSDT if necessary to implement the correction
recommended by SERS staff.
SCENARIO 2
An employee has money withheld for the wrong retirement system
and will not be working for the district in the future.
SERS withheld in error and information not reported to
SERS
Corrective action:
- On the 590 record for the employee, enter a stop date.
- On the 400 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to STRS.
- Add the 591 record.
- Add the 450 record.
- Manually calculate the amount of STRS that should have been
withheld and wasn't.
- Contact the employee to get the difference in the amount withheld.
- Using the 590 record, manually update the withholding figures on
the 591 to include that from the pays where SERS was withheld in error.
Include the amount the employee gives the district with a personal
check.
- Manually reduce the taxable gross figures on all tax records by the
amount obtained from the employee.
- Deposit the personal check from the employee into the payroll
clearance account.
- Manually adjust the retirement gross figures on the 450 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 450 record if necessary or
desired.
- Once all information has been transferred to the STRS records, the
SERS records can be cleared or deleted.
SERS withheld in error and information reported to SERS
Corrective action:
- Contact SERS for a refund of the amount paid to them in error.
- On the next SERS monthly report filed, enter the correction for
this employee.
After the refund has been received:
- On the 590 record for the employee, enter a stop date.
- On the 400 record for the employee, enter a stop date.
- Add the 591 record.
- Add the 450 record.
- Manually calculate the amount of STRS that should have been
withheld and wasn't.
- Calculate the difference between what was withheld for SERS and
what should have been withheld for STRS.
- Contact the employee to get the difference in the amount withheld.
- Using the 590 record, manually update the withholding figures on
the 591 to include that from the pays where SERS was withheld in error.
Include the amount the employee gives the district with a personal
check.
- Manually reduce the taxable gross figures on all tax records by the
amount obtained from the employee.
- Deposit the personal check from the employee into the payroll
clearance account.
- Manually adjust the retirement gross figures on the 450 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 450 record if necessary or
desired.
- Once all information has been transferred to the STRS records, the
SERS records can be cleared or deleted.
STRS withheld in error and information not reported to
STRS
Corrective action:
- On the 591 record for the employee, enter a stop date.
- On the 450 record for the employee, enter a stop date.
- On the JOBSCN record, change the retirement type to STRS.
- Add the 590 record.
- Add the 400 record.
- Manually calculate the amount of SERS that should have been
withheld and wasn't.
- Manually update the withholding figures on the 590 to include all
the amounts withheld from the pays where STRS was withheld in error.
- On the error adjustment line, enter the difference in the
withholding between SERS and STRS as a negative amount.
- Process a refund of deduction payroll to get this amount back to
the employee. This will ensure the adjusted gross figures on the tax
records are accurate.
- Manually adjust the retirement gross figures on the 400 to include
the wages from the pays where STRS was not withheld.
- Manually update the board amounts on the 400 record if necessary or
desired.
- Once all information has been transferred to the SERS records, the
STRS records can be cleared or deleted.
STRS withheld in error and information reported to STRS
Corrective action:
- Contact STRS for a correction procedure.
- Contact the SSDT if necessary to implement the correction
recommended by STRS staff.
- Contact SERS for a correction procedure.
- Contact the SSDT if necessary to implement the correction
recommended by SERS staff.
SCENARIO 3
An employee has no retirement withheld and should have and will
be working for the district in the future.
SERS not withheld and information not reported to SERS
Corrective action:
- On the JOBSCN record, set the retirement type to SERS.
- Add the 590 record.
- Add the 400 record.
- Manually calculate the amount of SERS that should have been
withheld and wasn't.
- Enter the amount as a positive error adjustment on the 590 record.
- Manually adjust the retirement gross figures on the 400 to include
the wages from the pays where SERS was not withheld.
- Manually update the board amounts on the 400 record if necessary or
desired.