Consolidated Income Statement Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats. If you select a user-defined column for this report, the report does not display subtotals for that column.

Contents

Field Description
Current Amount This column displays the amount of account activity during the current accounting period.
Current Percent This column displays the percentage represented by the amount in Current Amount.

The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s current amount to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the current accounting period.

Year-to-Date Amount This column displays the amount of account activity during the current fiscal year.
Year-to-Date Percent This column displays the percentage represented by the amount in Year-to-Date Amount.

The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s year-to-date amount to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the current year.

Current Budget This column displays the budget for the account for the current period.

You determine the source of all budget amounts on the report when you select one or more budgets for the current fiscal year from the list on the General tab of the Options dialog box. If you do not select a budget, any budget columns on the report will be empty.

Current Budget Variance This column displays the difference between the current period amount and the current period budget for the account.
Current Budget Variance Percent This column displays the current period budget variance divided by the current period budget for the account.
Year-to-date Budget This column displays the budget for this account for the current fiscal year through the current accounting period.

You determine the source of all budget amounts on the report when you select one or more budgets for the current fiscal year from the list on the General tab of the Options dialog box. If you don’t select a budget, any budget columns on the report will be empty.

Year-to-date Budget Variance This column displays the difference between the year-to-date amount and the year-to-date budget for the account.
Year-to-date Budget Variance Percent This column displays the year-to-date budget variance divided by the year-to-date budget for the account.
Prior Period Amount This column displays the amount of account activity during the previous accounting period.
Prior Period Percent This column displays the percentage represented by the amount in Prior Period Amount.

The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s prior period amount to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the prior accounting period.

Prior Period (Year-to-Date) Amount
Prior Period (Year-to-Date) Percent
Prior Year Amount This column displays the amount of account activity during the previous fiscal year.
Prior Year Percent This column displays the percentage represented by the amount in Prior Year Amount.

The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s prior period amount to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the prior fiscal year.

Prior Year (Year-to-Date) Amount This column displays the amount of account activity during the previous fiscal year through the close of the same period in that year that corresponds to your current period. For example, if you generate the Income Statement in March of the current year, this column shows account activity through March of the previous year.
Prior Year (Year-to-Date) Percent This column displays the percentage represented by the amount in Prior Year (Year-to-Date) Amount.

The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s prior year-to-date amount to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the prior year through the close of the period in that year that corresponds to your current period.

Custom Amount 01-13 and Custom Percent 1-13 You can include up to 13 custom amount columns and 13 custom percentage columns on the Income Statement to display account activity for any period or range of periods.

The custom amount columns display the amount of account activity during the periods you specify.

The custom percentage columns display the percentage represented by the amount in the corresponding custom amount column. The percentage depends on your selection in % of on the General tab of the Options dialog box. The column shows the ratio of the account’s amount for the period range to your firm’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the period range.

If you show both a custom amount column and the corresponding custom percentage column, specify the same range of accounting periods for both. For example, if Custom Amount 01 displays account activity for the first quarter of the current year, Custom Percentage 01 must also represent the first quarter of the current year. However, you can add a custom amount column to the report but not the corresponding percentage column, or you can add a custom percentage column without adding the custom amount column.

For each custom column that you include on the report, specify the following on that row of the grid:

  • A column heading of one or two lines in Line 1 Heading and Line 2 Heading.
  • An accounting period range in Period Start and Period End.
Custom Currency Code If you set up custom currency fields for any accounts, this column displays the currency code specified for those fields for each account in the Chart of Accounts Info Center.
Sort/Select 1-3 These columns display the sort and select fields that are assigned to the account.