How To: Importing a Third-Party Payroll File to General Ledger (15-16)

Overview

This tutorial describes how to import information from a third-party payroll application (via a tab delimited spreadsheet file) into Tyler’s General Ledger.

Step-by-Step

Click image to enlarge.

1. Enter “Y” at the ‘Build Payroll G/L File Now?’ prompt.

2. At the ‘Enter PC File Name’ prompt, enter the full path to the payroll file being imported (e.g. “C:/Tyler/adp.txt”).
   NOTE: Make sure that the file is not open on your computer.

3. At the ‘Enter Payroll Date’ prompt, enter the payroll date for the import.
   NOTE: When the A/P P/R P/O A/R Audit/Update selection (15-10) is run, ‘Dated-MM-DD-YY’ (where MM-DD-YY is the date entered in this field) is written to the ‘Description’ field.

4. Enter “Y” at the ‘Correct?’ prompt.

Click image to enlarge.

5. At the ‘Select Printer’ prompt, enter the ID of a spooler or printer for the exception report.

6. The system attempts to import the file.
1. If the file imports successfully, the selection closes.
2. If there are problems with the import, the following message displays:

   ‘Errors exist in Upload. Check print out. G/L file was NOT built. Enter ‘YES’ to acknowledge this message’.

   Enter “YES” and then check the Exception Report to view the errors. Fix the errors and repeat Steps 1-4.

7. Run the A/P P/R P/O A/R Audit/Update selection (15-10) to verify the imported information and update it to General Ledger.