Payroll/Various Journal Entry Import

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

{TOC}


===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 [^http://www.abiscorp.com/AdjWiki/GLJEBATCH.ashx#Import_Batches_Tab_4|Import Batches Tab]


The Import Batches Tab (located on the [^http://www.abiscorp.com/AdjWiki/GLJEBATCH.ashx|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 [^http://www.abiscorp.com/AdjWiki/GLJEBATCH.ashx#Import_Batches_Tab_4|Import Batches Tab] to obtain the template used to import payroll entries.  


{s:yellow
| text = For a sample of the Journal Entry Import Template File, [^{UP}%2fGLBATCH%20TEMPLATE%20FILE.XLS|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 


{s:yellow
| text = 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. 

 {s:yellow
| text = For Payroll entries, debit associated wage accounts.  
}


'''credit:'''The credit amount of the entry line.

{s:yellow
| text = 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.

Meta Keywords:
Meta Description:
Change Comment:

Desktop Adjutant

Navigation¶

Payroll/Various Journal Entry Import