Do you use other software to calculate payroll data? Would you like to use Peachtree to generate payroll checks without having to manually re-enter payroll data?

Enhancement PIE - Import Exceptions allows Employee ID, Hours and Rates to be imported from a computer generated file. When records are imported, a report will print out detailing errors if any are found.

Notes for Operator:

Backup Payroll before importing.

To import exceptions, select Enter Exceptions from the Payroll Processing Menu, then select Import Exceptions.

+--------------------------------------------------------------------+
|+==================================================================+|
||PRPROC1               Enter Exceptions           COMPANY ID: SP   ||
||10/21/91           Software Professionals Inc.   GENERATION #: 62 ||
|+==================================================================+|
|                                                                    |
|                   +=============================+                  |
|                   |  E - Enter Exceptions       |                  |
|                   |  L - List Transaction File  |                  |
|                   |  I - Import Exceptions      |                  |
|                   +=============================+                  |
|                                                                    |
|                                      F10 - Menu    Shft F10 - Home |
+--------------------------------------------------------------------+

Select the printer for the error report and then enter the file to import. The program will import the exceptions and then tell you how many errors occurred.

After exceptions have been imported, the processing status is set to EE. You can then enter any additional exceptions and proceed with the payroll cycle.

Other enhancements are available for importing into Payroll, see documentation for PMI - Import Miscellaneous Income, PSI - Import Salary Exceptions, PVI - Import Vacation/Sick Hours, and PUR - Update Rate With Import.

Notes for Programmers:

To import exceptions you must first create a comma delimited text file that conforms to the following format:

Field  Description
------ --------------
1  Department
2  Employee ID
3  Number of Hours (to 2 decimal places)
4  Hourly Rate  (to 3 decimal places)
5  Type of Hours  (0=Reg,1=OT1,2=OT2)
6. Shift (1,2, or 3)
7. Actual Rate  (to 3 decimal places)
8. GL Account Number (5 or 6 digits.  Must be valid GL Acct Number)

Enclose any fields in quotes that contain embedded spaces or commas. You may omit the following:

Example of a few lines in an import file:

0,HJG,15,6.50,0,2,,12500
12,HGL,17.25,7.25,0,,25.00
0,AAK,19
8,KKQ,4,10,1
9,KKL,5,,1

The first line is employee HJG in department 0 with 15 regular hours during second shift at a base rate of 6.50/hour posted to GL Acct 12500. The second is 17.25 hours at 7.25/hour base rate with an actual rate of $25 per hour. Next, 19 hours at the rate in the employee file. The fourth is overtime 1 at a base rate of 10/hour. The actual rate is computed using the overtime premium in the options file. The last line shows overtime using the base rate from the employee file.

Additional Notes for Importing Exceptions:

1. To import an exception, the employee must be active and hourly.
2. The employee may not be in "PR" status. If you get the error "Check not posted" you must Post Current Period before you can import exceptions.
3. The actual rate is computed for overtime. You import the base rate.
4. Unless you enter or import exceptions, calculate pay will use the standard hours from the employee file. Use Enter Exceptions to mark an employee for no pay if you don't want a pay check printed.
5. Importing zero hours will not affect payroll processing at all.
6. Imported exceptions are added to any exceptions already in the file. If you import the same exceptions twice, you will get double the number of hours.