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 :
The nominal code and amount are the minimum required.
Line 2 onwards : Journal Lines
Each line thereafter has the journal details for that line.
The nominal code needs to be prefixed by the company no - ie 01.0.0.60.6 NOT 0.0.60.6
In Excel, to save this file as CSV, choose the option to "Save As..." and then select file type of "CSV" eg :
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:-
The journal can then be edited, added to or posted as normal.