Custom Balance settings
When importing Chart of Accounts and General Ledger balances, use this dialog to specify the destination of the balances being imported.
Field Information
| Option | Description |
|---|---|
| Debit & Credit Field | Select this option if the data in this column contains both debits and credits. |
| Debit Field |
Select this option if the data in this column contains only debits. Note: When this option is selected, if there are no credit columns specified, the field will change the setting to debit & credit. |
| Credit Field |
Select this option if the data in this column contains only credits. Positive Imports as credits: Select this check box when there are balances in the separate credit column that contain positive or mixed (negatives and positives) values. Conversely, clear this check box if the credits are all negative. |
Select a custom balance identifier
Custom balances can be created in the Working Trial Balance to accommodate a wide variety of business needs, such as including amended budgets. Custom balances can represent balances in the past (for example, a budget balance), or balances in the future (for example, a forecast balance). Custom balances are very flexible and can accommodate up to five years of data. In Working Papers, you can create and name as many columns for custom balances as needed.
This feature also supports the use of custom balances in during an ASCII import. The custom balance identifier must first be created using the Custom Balances tab found under Tools | Options. When identifying these columns during import, choose the Custom Balance Rates menu and then identify the period that the column applies to. After you have imported your custom balances column, these values will be available for reporting in automatic documents that report based on the custom balances columns in Working Papers.
