How do you batch import ledger entries in Cetec ERP?
Navigate to Accounting, then Chart/Ledger, then Import. These are the required fields for a successful ledger import:
- External ID/key
- Name
- Date (YYYY-MM-DD)
- Account numbers of the accounts to be credited and debited
- Credit/debit values
Choose your file and click Import File. This will take you to the data scrubbing screen. Here you have two major tasks:
- Specifying which rows to import.
- Specifying columns.
Select the rows of data to be included. (For example, you’ll want to uncheck the row containing column titles, if it’s included). Click on the drop-down menu from the top and choose the right column type.
A note on the External ID/Key: Often, when a ledger import fails, it will be due to using an external ID/key that has been used before. Cetec ERP requires a unique external ID/key for each entry that will be imported into the system. A nice way to make sure IDs are unique is to create them using the date youre importing your file. So, for example, your first entry entered on November 16, 2023 would have an ID of 2023-11-16-01. Your second entry would have the same date but end in 02 (2023-11-16-02) instead of 01, and so on.
An additional note: For any entry containing multiple splits, all splits for that same entry must use the same external ID/key.
Before you import the data, finish assigning column types and also be sure that the debit and credit values for your splits net out to zero. Once your import data is ready, scroll down and click Update.
The system will try to validate that data, and if there is an error, it will tell you what went wrong. After all problems have been fixed, click on Finish to finish importing the data. Once you see the message Success: Ledger Imported! then any imported rows will be available on your general ledger immediately.
For additional guidance on how to correctly import ledger data, click into Admin, then APIs & More, then Data Import Documentation. In the box titled “Cetec ERP Is Importing Your Data?” click the blue View Here button. On the next screen, click into the Accounting link at the top of the list on the left. Then choose GL Entries.
Youll see a list of fields to be used in this specific type of data import, the parameters for that data, and whether or not that data is required in your import (required data will display an orange circle with the letter R in the top right corner of the box). Click on a box to see an example of how to format that type of data.