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
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.
