Page History: Payroll/Various Journal Entry Import
Compare Page Revisions
Page Revision: Fri, 28 Jun 2013 15:13
General Information
Default Menu Location Transaction >> General Ledger >> GL Journal Entry
Screen Name GLJEBATCH
Function The General Ledger module is completely integrated with all modules and is the key to maximizing the efficiency and accuracy of your financial data.
Importing Payroll Entries
Payroll entries, just like any other journal entry, can be imported into Adjutant using the
Import Batches TabThe 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 FIELDSpostper: 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: What GL Account is being effected by this entry line?
debit: The debit amount of the entry line.
credit:The credit amount of the entry line.
statamt: If using the "Statistics" logic in Adjutant, what is the Statistic amount?
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.
FORMATTER ERROR (Malformed List)