Columns for Profit Planning Monitor Report

The following columns are available for this 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 1-13 TBD
Custom Actual/Budget Sum
Custom Amount 01-13 You can include up to 13 custom columns on the Profit Planning Monitor to show the amount of 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 Budget 1-13 You can include up to 13 custom columns on the Profit Planning Monitor to show the budget information of account activity for any period or range of periods. For each custom column that you include on the report, specify the following on the appropriate row in 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 Budget Variance 1-13 You can include up to 13 custom columns on the Profit Planning Monitor to show the difference between the corresponding custom amount and custom budget amount of the 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 Budget Variance Percent 1-13 You can include up to 13 custom columns on the Profit Planning Monitor to show the result of dividing the corresponding custom budget variance by the custom budget of the 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).
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 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 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 total number of detail lines for each group, based on the sorting and grouping selections. If the report groups data at more than one level, this column displays row counts for all grouping levels.
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.
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 Percentage of on the Options tab. The column shows the ratio of the account’s year-to-date amount to your enterprise’s total revenue, revenue less reimbursables, total expenses, total operating expenses, or direct labor for the current year.