Financial Statement Wizard - Column Properties: Set Up a Formula Column

In the Financial Statement Wizard - Column Properties window, you can choose to make a column in your new financial statement a Formula column. This type of column displays a calculation based on amounts that appear in two other columns of the statement, or the amount from one other column and a constant value.

Examples of when you might want to use such a formula are the following:

To set up a Formula column, follow these steps:

  1. In the Column Properties window, from the drop-down list select Formula as the data type for the column.

    Additional options appear in the Column Properties group box at the right side of the window.

  2. In the first Column field, use the drop-down list to select the column whose amount you want to have as the first element in the calculation.
  3. In the next field, use the drop-down list to choose an operator. You can choose to add, subtract, multiply, or divide the two elements of the calculation.
  4. In the second Column field, use the drop-down list to do one of the following:
  5. Choose one of the following alignment options:
  6. In the Round field, use the drop-down list to select how or if you want amounts to be rounded off. You can round off amounts to whole dollars or to thousands of dollars.

    Any rounding errors are dumped into the account you specify for rounding errors (in General Ledger Defaults).

  7. When finished setting up this column, do one of the following:
What do you want to do next?