Introduction: Payroll Interface (15-16)

Overview

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

When the file is successfully imported, it is stored in the G/L Interface file until the A/P P/R P/O A/R Audit/Update selection (15-10) selection is run.

Setup Instructions

Before running this selection, you must obtain or create a spreadsheet file containing the third-party payroll information.

The spreadsheet file being imported to Tyler must meet the following specifications:

• It must have the following five columns (in the order shown):
  Date

  This column must have the date in MM/DD/YYYY format.
  Reference Number / Description

  This column usually has a reference number or description of the account. Since the information in this column is not validated, any entry can be made here.
  First Half of G/L Number

  Enter the first six digits of the G/L number in this column.
  Second Half of G/L Number

  Enter the second six digits of the G/L number in this column.
  Amount

  This column should contain the amount (either positive or negative) being posted to the account.
• It must not have column headings.
• It must be a tab delimited file and have a ‘.txt’ extension (e.g. ‘adp.txt’).
• It must be saved to a folder/directory named ‘Tyler’ on your ‘C:’ drive (e.g. ‘C:/Tyler/adp.txt’).

Special Notes

• If there are errors on the spreadsheet and the file does not import successfully, a warning message appears. An exception report also prints noting the areas of the spreadsheet that need to be fixed.