Using Your Own Codes
Re-keying data into a series of Excel workbooks is time-consuming and fraught with errors.
All that’s needed with ExcelCube is a text file, which can be retrieved from most databases and general ledger applications.
How Input From a File Works
ExcelCube can take a trial balance text file and load data into hundreds of workbooks in a single operation.
Each application has a mapping spreadsheet that identifies the user’s account and entity codes, and maps them to spreadsheet row numbers and workbook files.
Multiple Account Mapping
Data from more than one input account can go into the same Excel row. All that’s required is that the proprietary account codes get mapped to the appropriate row number. The data get rolled up automatically.
Alphanumeric Codes
Any contiguous code for the entity or an account is recognized by ExcelCube.
One or More Columns of Data
ExcelCube recognizes any number of data columns, and they are assigned to the spreadsheet columns upon input.
Repeating Codes
If there is more than one occurrence of an entity code and an account code combination, the values get rolled up automatically.
Suspense File
When a code in the data file is not present in an application the record is written to a suspense file. After the missing code is added, the suspense file can be entered in directly.