Importing Fringe Benefit Information from a Spreadsheet

Access the Fringe Benefit Detail form.

To import fringe benefit information from a spreadsheet:

1. Press the Tab key to access the first row of the detail area.

2. Right-click and select Import from the menu.

3. Select the application that you used to create the spreadsheet.

4. Locate the spreadsheet that you created and double-click it.

5. Enter the data range that coincides with the data that you entered in the spreadsheet, and then click OK.

   The data range should be (A1:Cx) where x is the number of the last row in the spreadsheet. For example, if you entered 450 lines in the spreadsheet, the data range would be (A1:C450).

   The system populates the detail area of the Fringe Benefit Details form, and then edits the data that you import from the spreadsheet to ensure against duplicate records and to ensure that you are not importing information for an employee who is not included in the batch.

6. On Fringe Benefit Details, click OK to save the imported information.

7. On Work With Payment Summary Extract, click Close to exit.