Journals Import

Created by Melvin Xuereb, Modified on Mon, 16 Oct 2023 at 01:31 PM by Melvin Xuereb

The journal import function is used to import Nominal Journals directly into Experience.

Menu Path: Nominal → Processing → Import Journals

Field NameDescription
YearDefault year as set under Company Controls.  This value can't be changed.
PeriodPeriod to which the Journal should be posted.
DateThe date of the journal.
DescriptionA description of the journal being imported.

Preparing your Data to Import

Prepare an Excel file with the following fields. Ensure the fields are in the same order.

Journal Line, Account Number, Line Description, Debit (Base), Credit (Base)

Once complete, copy the data from Excel (by selecting the whole rows). 



Then select the record where you wish to paste it by clicking on the record indicator and paste the information.

Importing the Journal

Once data is pasted into Experience, click on the 'Check Errors' button.

The system will check if the data is correct and update the 'Check Status' and 'Check Reason' fields accordingly.

Fix any issues (e.g. inexistent nominal account or journal imbalance).

Finally click on the 'Import Journal' button to post the Journal in Experience. 

Note: Only Journals in base values can be imported.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article