Import a Journal

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 :

 

Image 1

 

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

 

Image 2

 

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 window is an "Import from File" button.

 

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

 

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

 

Image 3

 

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