# Import Payroll Data to G/L (PAYROLL.P2)

Read Time: 1 minute(s)

Form Details
Form Details

Purpose
The purpose of payroll.p2 is to create a journal (gltrans record) for payroll charges from a file. Typically this file is generated from the software/service that your company is using to process payroll. The file can be a text (comma or tab delimited) or an Excel file.

Below is the layout of the file.

1. Column 1 - G/L account number
2. Column 2 - Date
3. Column 3 - Debit Amount
4. Column 4 - Credit Amount

If the g/l account numbers do not exist in the database or have been inactivated, they will not be added to the journal. You can use GLTRANS.E to update the information on the record.

Please note that this journal entry will not autumatically post to the general ledger. The status will be set to hold. However, you will we be given an option to open GLTRANS.E to view the journal. If you have set the post status to "P" in GL.CONTROL , when you save the record in GLTRANS.E , the journal will be posted.

Frequency of Use
As required.

Prerequisites
The general ledger account numbers that will be referenced on the file that will be used in this process need to be defined in the system. Use glchart.e to enter account numbers.

Version 8.10.57