Guidelines for Imported Journal Entry Files

To import journal entries from CSV or XML files, or to copy and paste journal entry data for import, use the Import Journal Entries form.

Before you start the import, make sure you have formatted CSV and XML files according to these guidelines:

CSV files must use this format: Date,Account,Unit Code 1,Unit Code 2,Unit Code 3,Unit Code 4,Debit,Credit,Reference,AnalysisAttribute01 ...AnalysisAttribute15

For XML files, each journal entry must start with a journal_entry tag and use date, account, unit codes, debit, Credit, reference, and analysis attribute 01 - 15 tags for grid fields, as shown in the following example.

Note: For this example, analysis attributes 1 - 5 were defined as Employee Name, Customer Number, Hotel Name, Room Type, and City. Analysis attributes that are not defined can be left blank or removed from the XML. 

<?xml version="1.0" 
 encoding="UTF-8" ?> 
<Journal_Entries>
<Journal_Entry> 
<Date>05/15/2014</Date> 
<Account>10000</Account> 
<UnitCode1></UnitCode1> 
<UnitCode2></UnitCode2> 
<UnitCode3></UnitCode3> 
<UnitCode4></UnitCode4> 
<Debit>1000.00000000</Debit> 
<Credit>0.00000000</Credit> 
<Ref>CP  1330</Ref> 
<AnalysisAttribute01>Mark White</AnalysisAttribute01> 
<AnalysisAttribute02>00001</AnalysisAttribute02> 
<AnalysisAttribute03>Grand  Hyatt</AnalysisAttribute03> 
<AnalysisAttribute04>Grand 
 Room - King Bed</AnalysisAttribute04> 
<AnalysisAttribute05>New York</AnalysisAttribute05> 
<AnalysisAttribute06></AnalysisAttribute06> 
<AnalysisAttribute07></AnalysisAttribute07> 
<AnalysisAttribute08></AnalysisAttribute08> 
<AnalysisAttribute09></AnalysisAttribute09> 
<AnalysisAttribute10></AnalysisAttribute10> 
<AnalysisAttribute11></AnalysisAttribute11> 
<AnalysisAttribute12></AnalysisAttribute12> 
<AnalysisAttribute13></AnalysisAttribute13> 
<AnalysisAttribute14></AnalysisAttribute14> 
<AnalysisAttribute15></AnalysisAttribute15> 
</Journal_Entry> 
<Journal_Entry> 
<date>05/15/2014</date> 
<account>10000</account> 
<UnitCode1></UnitCode1> 
<UnitCode2>0007</UnitCode2> 
<UnitCode3></UnitCode3> 
<UnitCode4>01</UnitCode4> 
<Debit>0.00000000</Debit> 
<Credit>1000.00000000</Credit> 
<Ref>CP  1330</Ref> 
<AnalysisAttribute01>Mark White</AnalysisAttribute01> 
<AnalysisAttribute02>00001</AnalysisAttribute02> 
<AnalysisAttribute03>Grand Hyatt</AnalysisAttribute03> 
<AnalysisAttribute04>Grand Room - King Bed</AnalysisAttribute04> 
<AnalysisAttribute05>New 
 York</AnalysisAttribute05>  
<AnalysisAttribute06></AnalysisAttribute06> 
<AnalysisAttribute07></AnalysisAttribute07> 
<AnalysisAttribute08></AnalysisAttribute08> 
<AnalysisAttribute09></AnalysisAttribute09> 
<AnalysisAttribute10></AnalysisAttribute10> 
<AnalysisAttribute11></AnalysisAttribute11> 
<AnalysisAttribute12></AnalysisAttribute12> 
<AnalysisAttribute13></AnalysisAttribute13> 
<AnalysisAttribute14></AnalysisAttribute14> 
<AnalysisAttribute15></AnalysisAttribute15> 
</Journal_Entry></Journal_Entries>

Dates must use the standard format: mm/dd/yyyy.

Reference information can be up to 30 characters in length.

Related topics