Page History: Payroll/Various Journal Entry Import
Compare Page Revisions
Page Revision: Fri, 28 Jun 2013 15:19
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: Mark 'Y' 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 all wage accounts.
credit:The credit amount of the entry line.
For Payroll entries, credit all cash accounts.
statamt: If using the "Statistics" logic in Adjutant, the Statistic amount for this entry line.
projnum: If this entry is associated with a specific project, this field is used for linking to project.
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.
*NOTE* The Journal Entry Batch Import does not have any mapping. Therefore, the user must import the file in the exact same format and style as the exported template (cannot change any column headings, locations, formats, etc).
