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

Related topics

Design a financial statement

Filter a report, form, or financial statement

Print a report or financial statement

Copy a financial statement format from one company to another

Set up a rounding account for financial statements

Perform other report or form tasks

Learn more about the Financial Statement Design window and object tools

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:

  1. 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.

  2. In the Qualifier field, use the drop-down list to select a way in which to limit the amounts shown for the column: net, budget, revised budget, only debits, or only credits.
    • Net: This is the net amount (credits minus debits) for the account or accounts specified in all lines that define the column.
    • Budget: This is the amount set in Maintain Budgets for the account or accounts specified in all lines that define the column. The amount displayed is based on the time frame chosen from the Time Frame drop-down list.
    • Revised budget: This is the amount set in Maintain Budgets for the account or accounts specified in all lines that define the column. The amount displayed is based on the time frame chosen from the Time Frame drop-down list.
    • Only debits: This displays only debit amounts for the account or accounts specified in all lines that define the column.
    • Only credits: This displays only credit amounts for the account or accounts specified in all lines that define the column.

  3. 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.

    4. 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.

  4. 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).

  5. Choose one of the following alignment options:
    • If you want the data and the totals for that data to align in the column, select the Align data option button.
    • If you want to indent the totals for the data appearing in the column, select the Indent totals option button.
  6. When finished setting up this column, do one of the following:
    • Add the next column you want to appear in the statement

    • If you are finished adding columns, select Next to continue designing the statement.

      Sage 50 displays the Financial Statement Wizard - Column Options window.