The Journal Import consists of two stages; completing an excel sheet, and the journal import via DPS FD, Nominal Ledger, Journals.
Open an excel workbook and sheet.
For column A, enter the journal heading NominalRef column B, enter Journal Ref. column C, enter Debit and column D, enter Credit.
Ensure the columns NominalRef, Journal Ref and Description are all formatted as General.
Ensure the columns Debit and Credit are formatted as Number. To check this, click on the letter A for column A, this selects the whole column, then right click, select Format Cells in the category box select General or Number, click OK.
Enter the Nominal Code in the NominalRef column. If the code starts with a zero, either omit the zero or place an apostrophe before the zero, like this '0123.
In the Journal Ref column, enter J** for each row and enter the Values in the Debit and Credit columns. The total of the debit and credit values should be the same.
When complete, name and save the excel workbook as an .xlsx file, to your desktop or other location.
To import the journals go to DPS FD and select Nominal Ledger, Journals, click the IMPORT button, locate the saved excel workbook and click OPEN, click POST, to post the journals.
If you are still having issues, please raise a new case online and reference the title of this article.