Field Details
The Field Details screen of the ASCII Text File Import Wizard and Excel File Import Wizard allows you to specify the column headings of the data being imported into Working Papers and also allows you to modify the field information.
Tip: Hold SHIFT while clicking to select multiple columns. Once the first column is assigned for example as a period balance, all subsequent columns will automatically be filled in with period balance 2, 3, etc.
Define Columns
To specify the details for the import, you must first define the columns of the import. To define a column, see Defining a column in an ASCII or Excel text file import. The column headings are labeled Ignore by default.
For minimum field details, see the table below.
| At minimum, you must define the... | If importing... |
|---|---|
| Account number |
Chart of Accounts & General Ledger Balances or General Ledger Details Note: General Ledger Details imports require you to select the period to import to. |
|
Account number and at least one of:
|
Adjusting Journal Entries |
Settings Specifications
When defining columns with the following headings, additional fields are displayed in the lower portion of the screen for you to complete. The column headings available are different depending on whether you are importing the chart of accounts and general ledger balances (trial balance data) or the general ledger detail (transaction data). Click a field link below to see what additional information is required to be entered. For more information on the relevant options for your import, see the links below:
Note: Fields that are not listed here do not require additional specifications.
Notes
-
If the import layout contains an Abbrev. entity column, but the user does not set the options in this tab and is not using a format setting file, Working Papers opens up the Entity assignment box. This feature prevents any automatic creation of entities during the import.
If a format file is used, selecting "Assign entity through divisional profile" will take the user to the Entity Profile Set-up dialog screen to select the entity branch for the import.
- If there is no consolidation structure set for the file, when the import begins the Consolidation dialog opens to allow the creation of the consolidation structure. The import can then proceed on the whole or on any branch of the consolidation structure using the split up.
