Importing Journal from file

Top  Previous  Next

It is possible to prepare a nominal journal from a text file.

 

These text files are typically created using Microsoft Excel and are saved in Comma Seperated Value (csv) format.

 

The file should have the following structure:

 

Line 1 : column headings

 

The available column headings are :

 

Nominal Code        

Amount

Qty

Note

Stock No

Account No

Job No

 

The nominal code and amount are the minimum required.

 

Line 2 onwards : Journal Lines

 

Each line thereafter has the journal details for that line.

 

 

Notes

 

The nominal code needs to be prefixed by the company no - ie 01.0.0.60.6 NOT 0.0.60.6

 

Example :

 

Nominal Ledger 26

 

In Excel, to save this file as CSV, choose the option to "Save As..." and then select file type of "CSV" eg :

 

Nominal Ledger 27

 

 

 

Importing Journal

 

 

To import the journal, in the nominal ledger, click on the "Post Journal" button.

 

Make sure the nominal ledger date is set for the posting BEFORE you import the file (you can't change it afterwards!).

 

On the right hand side of the screen is an "Import from File" button.

 

Click this, and then search for the CSV file that has been prepared.

 

The journal should appear on screen as if you had typed it in:-

 

Nominal Ledger 28

 

 

The journal can then be edited, added to or posted as normal.