The most difficult way to load data into Excel is to copy & paste or re-key data already in another application.
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 workbook files in a single operation. Here's how:
- Multiple Account Mapping —Accounts can be rolled up automatically upon input. All that’s required is that account codes get mapped to the appropriate row number.
- Alphanumeric Codes —Any contiguous alphanumeric code for the entity or an account is recognized by ExcelCube.
- One or More Columns of Data —ExcelCube can recognize 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 directly.