To import journal entries in Sage Active, you need to enter your data in the import template or a file that follows the same structure. This information helps ensure that you input the data in the format required to reduce the potential for errors.
Before entering any data, you need to ensure your file includes the exact columns and first three rows of information from the import template. These rows provide the following:
- Line 1: Contains the titles of the data that needs to be included.
Asterisks indicate that it is mandatory to include this data in the file. - Line 2: Contains the translations from line 1 in square brackets.
- Line 3: Contains examples of correctly formatted entries in the CSV file.
When you’re ready, you can start entering your data on line 4, where each line that you enter represents a single journal entry. The data that you can include in an import is presented below. To navigate between sections of this page more efficiently, follow the links in the What is on this page section on the right hand side of the page.
- If mandatory data is missing or incorrect, the journal entry will not be imported.
- If data exceeds the maximum length for an optional field, it will be imported and truncated to the maximum length.
- If you are modifying exported data from an accounting or business management application through Excel, do not use a comma as a decimal separator because this can not be imported. You will need to use a period for the decimal separator to be correctly imported.
Journal information
The information about the following columns is available in this section:
| Journal | Journal name | Identifier to group journal entry lines |
| Journal entry date |
Journal
Mandatory: Yes
Format: The unique code up to 20 alphanumeric characters to identify the journal in Sage Active.
Journal name
Mandatory: No
Format: The journal’s name up to 20 alphanumeric characters.
Identifier to group journal entry lines
Mandatory: Yes
Format: Numeric value.
Journal entry date
Mandatory: Yes
Format: DD/MM/YYYY
Entry lines information
The information about the following columns is available in this section:
| Ledger account code | Ledger account name | Third party code |
| Third party business name | Third party country | Third party identification type |
| Third party identification number | Third party EU VAT number |
Ledger account code
Mandatory: Yes
Format: The alphanumeric ledger account code used for the journal entry line.
Ledger account name
Mandatory: No
Format: The ledger account’s name up to 100 alphanumeric characters
Third party code
Mandatory: No
Format: The unique code to identify the third party for the journal entry line.
Third party business name
Mandatory: No
Format: The third party’s name up to 50 alphanumeric characters.
Third party country
Mandatory: No
Format: The ISO Alpha-2 code for the third party’s country of operation entered as 2 alphabetical characters.
Third party identification type
Mandatory: No
Format: Enter a number from the values table.
Values:
| Type | Legislation | Corresponding value |
| Spanish tax identification number (NIF) European tax identification number (NIF) Passport Official document issued by the country of residence Residence certificate Other supporting document |
Only for Spain – – Only for Spain Only for Spain Only for Spain |
1 2 3 4 5 6 |
Third party identification number
Mandatory depending on legislation:
- France: No
- Germany: No
- Spain: Yes
Format: The third party’s alphanumeric identification number.
Third party EU VAT number
Mandatory: No
Format: The third party’s EU VAT number up to 25 alphanumeric characters.
Document information
The information about the following columns is available in this section:
| Document number | Document date | Journal entry description |
Document number
Mandatory depending on legislation:
- France: No
- Germany: Yes
- Spain: No
Format: The number for the journal entry up to 50 alphanumeric characters.
Document date
Mandatory depending on legislation:
- France: No
- Germany: Yes
- Spain: No
Format: DD/MM/YYYY
Journal entry description
Mandatory: No
Format: A description for the journal entry up to 200 alphanumeric characters.
Amounts
The information about the following columns is available in this section:
| Debit | Credit |
Debit
Mandatory: No
Format: The debit amount of the ledger account.
Credit
Mandatory: No
Format: The credit amount of the ledger account.
2 Comments left by users
Bonjour,
J’essaye d’importer un fichier d’écritures où j’ai bien entendu saisi des numéros d’écritures. Mais je lis ici que “ce numéro permet de distinguer les écritures lors de l’import… mais qu’il n’est pas repris mais remplacé par une numérotation séquentielle dans Sage Active”. Pourquoi ?
En l’occurrence, ce sont des écritures de banque que j’ai “confectionnées” dans un ordre chronologique et je ne vois ni ne comprends pourquoi la première écriture que j’avais numéroté “1” se retrouve avec le numéro “69” et que la suivante que j’avais numéroté “2” se retrouve avec le numéro “30”.
D’autre part, quand je vais importer mes écritures d’achat qui ont été préparées sur excel, chacune avec un certain numéro, ce numéro est repris et noté sur les factures pour le classement, en cas de recherche notamment. Mais si ce numéro n’est pas repris systématiquement, je fais comment ? Je dois venir remodifier tous les numéros que j’ai mis sur mes factures et je dois les reclasser ?
Merci pour vos réponses.
Hello,
We advise you to contact our support team.
You can do this by clicking on Help next to your profile in the top right-hand corner and choosing Help Centre. In this menu you can access Get personalised help to see the various ways in which you can contact the team.
Thank you
________________________
Bonjour,
Nous vous conseillons de contacter nos équipes d’assistance.
Pour cela, dans la partie droite du bandeau supérieur de Sage Active, cliquez sur Aide > Centre d’aide afin de demander de l’aide personnalisée. Vous pourrez alors envoyer un message ou téléphoner à notre équipe.
Bonne journée.