Columns for Income Statement Report

You can select the columns to display on your report.

Field Description
Annual Budget This column displays the total budget for the account for the current fiscal year.
Current Amount This column displays the amount of account activity during the current accounting period.
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 Options tab. 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.
Current Percent This column displays the percentage represented by the amount in Current Amount. The percentage depends on your selection in Percentage of on the Options tab. The column shows the ratio of the account’s current amount to your enterprise’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the current accounting period.
Custom Actual/Budget Sum
Custom Amount 01-13 You can include up to 13 custom columns on the Balance Sheet to show account activity for any period or range of periods. 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, as specified on the Accounts form (Settings > General Ledger > Chart of Accounts).
Custom Percent 1-13

You can include up to 13 custom percentage columns on the Income Statement to display account activity for any period or range of periods.

The custom percentage columns display the percentage represented by the amount in the corresponding custom amount column. The percentage depends on your selection in Percentage of on the Options tab. The column shows the ratio of the account’s amount for the period range to your enterprise’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.
Prior Period (Year-to-Date) Amount This column displays the amount of account activity during the previous accounting period through the close of the same period in that year that corresponds to your current period.
Prior Period (Year-to-Date) Percent This column displays the percentage represented by the amount in Prior Period (Year-to-Date) Amount. The percentage depends on your selection in Percentage of on the Options tab. The column shows the ratio of the account’s prior year-to-date amount to your enterprise'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.
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 Percentage of on the Options tab. The column shows the ratio of the account’s prior period amount to your enterprise’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the prior accounting period.
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 Percentage of on the Options tab. The column shows the ratio of the account’s prior year-to-date amount to your enterprise'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.
Prior Year Amount This column displays the amount of account activity during the same period as that of the current period, but for 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 Percentage of on the Options tab. The column shows the ratio of the account’s prior period amount to your enterprise’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the prior fiscal year.
Row Count This column displays the row number of a line item.
Year-to-Date Amount This column displays the amount of account activity during the current fiscal year.
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 Options tab. If you do not 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.