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:
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.
Select Constant. The field to the right of the second Column becomes active. Enter a desired constant value in this field, such as .33.
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).
If you are finished adding columns, select Next to continue designing the statement.
Sage 50 displays the Financial Statement Wizard - Column Options window.