Importing Journal Entries from External Sources

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 begin, make sure you have formatted CSV and XML files according to these guidelines:

CSV

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

XML

Each journal entry must start with a journal_entry tag and use date, account, unit codes, debit, credit, and reference tags for grid fields, as shown in this example:

<?xml version="1.0" 
 encoding="UTF-8" ?> <Journal_Entry> <Date>15/05/2011</Date> 
 <Account>10000</Account>

<UnitCode1></UnitCode1>

<UnitCode2></UnitCode2>

<UnitCode3></UnitCode3>

<UnitCode4>01</UnitCode4> 
 <Debit>1000</Debit> <Credit>1000</Credit> <Ref>Sample 
 10000 Journal Entry</Ref> </Journal_Entry>

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

Reference information can be up to 30 characters in length.

For rules regarding unit codes, refer the field topic: Unit Code (1-4), Import Journal Entries.

To import journal entries:

Open the Import Journal Entries form.
Perform one of these tasks:
- If you are importing data from a CSV or an XML file, select the file type and then click Load Journal Entries.
- If you are importing data by copying and pasting it from a spreadsheet, open the spreadsheet to work with and paste the needed data into the grid. See Pasting the Contents of a Single Cell from a Spreadsheet and Pasting Selected Records (Rows) from a Spreadsheet.
Select the journal in which to enter the grid data.
Perform one of these tasks:
- To edit the date, account, or reference information for individual grid entries, click in the grid cells and make changes as necessary.
- To change the date and/or reference information and apply it to all grid entries, specify the date and/or reference at the bottom of the form.
Click Process. The data is validated and, if accurate, saved to the selected journal. If errors are found, the data remains in the grid so you can make necessary changes.

Importing Journal Entries from External Sources

Related Topics