Import Journal Entry using a CSV

File>General Ledger>View Journal>Import 

1.  Click the import icon   brings up the Import Journal screen.  

2.  Create an Empty File by clicking the checkbox and selecting where the file should be saved.

3.  Enter Data into the Empty file. 

4.  Save and Close File.

5.  Click the import icon   brings up the Import Journal screen.   Make sure Create Empty File is unchecked.

6.  Pull in the correct file and click OK.

Some Tips about the CSV.

• Column A if left blank will assume a blank store code
• Column B (ActCode) needs to EXACTLY like the Chart of Accounts.  This includes any zeros in the front of the number.  To make column B accept the zeros in the front, change the format of the column to text. This is a required field. 
• Columns E and F (Description and Comment) has a limit of 75 characters.
• If columns G and H have decimals, they must be exactly two. Example 100.20 not 100.2

Possible errors that may show up after clicking OK.

• Column D Transaction date is required and must be formatted as mm/dd/yyyy
• Credits and debits must balance 
• .csv file must be closed
• Multiple periods cannot be used.  The month/year must match for all entries to import.

7.  The following message will appear once when the file is imported.  To view the Entries, click Yes.