-- How Do I? --

Creating Custom Balances in the Working Trial Balance

Custom balances can be created in the Working Trial Balance to accommodate a wide variety of business needs, such as including amended budgets.

  1. On the Tools tab, click Options and select Custom Balances.
  2. Click New. The New Custom Balances Item dialog box opens.
  3. In Balance Identifier, type a two character identifier. This is displayed in the BL database.
  4. In Name, type a full name to describe the custom balances.
  5. In Abbreviated Heading, type an identifier to be used as the column heading in the Working Trial Balance.
  6. In Years, select whether the custom balance represents balances in the past (for example, a budget balance), or balances in the future (for example, a forecast balance).
  7. Click OK to add and save the custom balance.

Custom balances are created. By default, only the current year of the new custom balance is displayed in the Working Trial Balance. To show additional years, right-click any column in the Working Trial Balance interface and select Reorder Columns.

  • To drill-down details, double-click a custom balance column.
  • Custom balances can be removed by clicking the Delete button. If a custom identifier is deleted, then a warning will display indicating that all balances associated with this identifier will be deleted.
  • You can make edit the Balance Identifier Name, Abbreviated Heading, and Years. If you change the name of one identifier it is changed for all 5 columns.
  • Each custom balance appears on the Split-up Accounts screen (current year only, as with budgets). Custom split-up balance amounts will be rolled forward.

Related Topics