In the Financial Statement Wizard - Column Properties window, you can choose to make a column in your new financial statement a Balance column. This type of column displays the balance amount—net, budget, credit, or debit—of the accounts appearing on the statement. For income statement accounts only, the balance in an account is the same as the year-to-date activity. Follow these steps:
In the Column Properties window, from the drop-down list select Balance as the data type for the column.
Additional options appear in the Column Properties group box at the right side of the window.
In the Time Frame field, use the drop-down list to select the time frame for which you want to show account activity amounts.
You can choose the current period, or you can choose any period in the current year, the previous year, or two years ago. Or, you can choose totals from the current year, pervious year, or two years ago.
If you chose Budget 1 or Budget 2 as the qualifier, you also have the option of choosing Current + 1 through Current + 11 as the time frame. Choosing one of these options will display budget activity for the appropriate month (accounting period) following the current month. For example, Current + 3 will display activity for the month three months after the current one.
In the Round field, use the drop-down list to select how or if you want amounts to be rounded. You can round off amounts to whole dollars or to thousands of dollars.
Any rounding errors are reflected in 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.