Before you begin: Note that permissions to your access profile may be required to perform the following steps. We invite you to validate your access with your software administrator.
In addition, the functionality must be part of your subscription to JurisFinance.
Finance tab / Accounting family / General journal / New transaction (+)
When creating a manual entry of type JG in the general accounting journal, importing an entry into JurisÉvolution is possible from an Excel file (.xlsx) or from a tab-separated encoded file (.txt) only.
This way of quickly creating a new entry is in addition to the existing way of using an entry template.
There are several ways to import. Please note that depending on the method chosen, the import criteria and the configuration of the file to be used may vary.
-1-
Clipboard mode: Copy/paste the file contents into the dedicated window
The easiest way to import information.
From an Excel file (.xlsx) with the correct column naming, copy the content (the entry) directly into the file and paste it into the dedicated window.
Accept the import with the black check mark.
-2-
Clipboard mode: Drag the file into the dedicated window
Drag the tab-separated encoded file (.txt) with the correct column naming into the dedicated clipboard window
Accept the import with the black check mark.
-3-
Clipboard mode: Drag the file directly into the postings window
Drag the tab-separated encoded file (.txt) with the correct column naming into the postings window (the default window for making a post).
-4-
File Import Mode: Selecting the file on the computer
Select the tab-delimited encoded file (.txt) with the correct column naming on the computer.
What to know
If the GL account used in the entry does not exist in the software, it is still imported into the transaction window. It is when the purchase is saved that it is validated.
The description is imported as defined in the file (or clipboard), it may differ from the account description.
If the Description column is not in the import, the account description is used.
If the Description column is in the import, but is empty for a row, the description is imported empty in the assignments for the account.
All decimal symbols and number groupings possible in the office preferences are interpreted in the file, and displayed according to the chosen preference.
Exemple : 1200.50 or 1200,50 or 1 200.50 or 1 200,50
1,200.50 is not considered. If the amount is entered as such, the entry imports 0.
Both negative number formats -600 or (600) are supported.
The data in the optional column "Office" must correspond to the ID of the offices in the software. Otherwise, the Office field is empty in the assignments.
Column naming of the file
Exemple 1
Positive amount = Debit
Negative amount = Credit
or
Exemple 2
Tab separated encoded file (.txt)
(Here are the basic elements for obtaining this type of file. If you need more information or help, you should refer to your computer technician).
From an existing Excel file, it is possible to save (Save As) in a *.txt format separated by tabs.
