Payroll/Various Journal Entry Import

Modified on Mon, 01 Jul 2013 07:53 by hmontgomery — Categorized as: General Ledger, Import- Export Manager


General Information

Default Menu Location Transaction >> General Ledger >> GL Journal Entry >> Import Batch

Screen Name GLJEBATCH

Function The Journal Entry Batch Importer can be used to make payroll adjustments in the Accounting system in Adjutant.

Importing Payroll Entries

Payroll entries, just like any other journal entry, can be imported into Adjutant using the Import Batches Tab

The Import Batches Tab (located on the GL Journal Entry Screen) allows the selection of an Excel file to be imported.

Journal Entry Import Template

Use the 'Export Template' button on the Import Batches Tab to obtain the template used to import payroll entries.

For a sample of the Journal Entry Import Template File, click here

IMPORT TEMPLATE FIELDS

postper: This is the posting period of the Journal Entry.

reference: This is a reference note field.

reverse: Enter a 'Y' in the import file under this column if this is a reverse journal entry

Reversing entries are journal entries made at the beginning of each accounting period. The sole purpose of a reversing entry is to cancel out a specific adjusting entry made at the end of the prior period, but they are optional and not every company uses them. Most often, the entries reverse accrued revenues or expenses for the previous period. Some examples of reversing entries are salary or wages payable and interest payable]

reverseper: The period which the entry will be reversed (if applicable).

glacct: The GL Account is being effected by this entry line.

debit: The debit amount of the entry line.

For Payroll entries, debit associated wage accounts.

credit:The credit amount of the entry line.

For Payroll entries, credit associated cash accounts.

statamt: If using the "Statistics" logic in Adjutant, the Statistic amount for this entry line.

projnum: To link your payroll journal entry to a project, enter the corresponding project number in this column. This is helpful if you need to associate payroll costs to a project for more accurate job costing.

phasename: If this entry is associated with a specific project phase, this field is used for linking to project.

notes: Any notes associated with this entry line.

pdate: Posting date of the Journal Entry.

linenote: This is the header note for the Journal Entry.