Financial Statement Wizard - Column Properties: Set Up a Year-to-Date Column

In the Financial Statement Wizard - Column Properties window, you can choose to make a column in your new financial statement a Year-to-Date column. This type of column displays the amount of year-to-date activity for the accounts appearing on the statement. Follow these steps:

  1. In the Column Properties window, from the drop-down list select Year to Date 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.
  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 or Revised Budget 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.

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

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