About Importing G/L Entries from a Spreadsheet
You can import G/L entries for non-permanent batches from an Excel® spreadsheet. This feature allows you to do the following:
Import beginning balances
Import monthly entries from an outside accounting firm
Make monthly reversing entries in Excel and then import them into the system.
For your import to work properly, you must set up your Excel spreadsheet using the following criteria:
Your column names must be the same as the template provided. The column names do not have to be in the same order but must exist. A sample spreadsheet is included in the software installation and is saved in the DDMS\Client\Data\Templates folder. On DDMSPLUS, a sample spreadsheet is included in the software installation and is saved in C:\Program Files (x86)\ECi\DDMSPlus Client\Data\Templates.
If there are several worksheets in the spreadsheet, the system pulls information from the worksheet with the lowest value. For example, Worksheet A is imported before Worksheet B.
The number of lines in your spreadsheet affects the import time.
The spreadsheet can be created on a client or server. You can import/export from a computer that does not have Excel installed. However, if you are using Excel version 2008 or later, you must have Excel software installed on the machine that you are using. If you are using an earlier version of Excel, you do not have to have Excel installed on the machine to use this feature.
The first eight rows determine the data type for the columns. This helps the system determine the type of information being imported, numeric and alpha-numeric characters, for example. When importing, your columns of data may be defined as General by default. You must decide if the columns should be defined as General or Text. ECI recommends that you only change the columns if necessary. If your data cells contain leading zeros and you define the columns as General, your leading zeros are removed. If your data cells contain leading zeros and you define the columns as Text, your leading zeros remain intact. For example, if you are importing account numbers, general ledger numbers, or item numbers, do not define your columns as General because you need the leading zeros.
If you need to open an Excel 2007 document on a computer that does not have Microsoft® Excel installed, you can download and install Microsoft data connectivity components. Doing so lets you acquire the Microsoft.ACE.OLEDB.12.0 provider so the document can be opened. For instructions, see http://www.microsoft.com/downloads.
Return to: