Consolidated Income Statement - Actual vs. Budget screen

Use the Consolidated Income Statement - Actual vs. Budget screen to create a report of actual income compared to a budget for a selected period and the year-to-date consolidated for multiple companies. You can print or save this report. You can also drill down from summary level amounts in the report to view the corresponding transaction detail. See Working with Drill-Down Reportsin the ProContractor Help for general information about drill-down functionality.

For general ledger accounts to be combined for multiple companies they must have the same account code, name, division, account type, and normal balance. If the companies do not have the same fiscal period dates, the Consolidated Income Statement - Actual vs. Budget may include amounts from different date ranges. For each company selected, ProContractor includes general ledger amounts for each company's fiscal period that ends on the selected period end date.

Note: To open the Consolidated Income Statement - Actual vs. Budget screen, click Financial > Reports > Consolidated Financial Statements > Consolidated Income Statement - Actual vs. Budget in the All Tasks pane.

You can control the output of the Consolidated Income Statement - Actual vs. Budget report by entering details in one or more of the following fields on the Options tab:

  • Select Format - If you have modified the format and layout of this report on the Modify Reports screen, click to select the version to use for this report. If you haven't modified the report, this field doesn't appear.

  • Company - Click to select one or more companies for the report. This field is required.

Consolidation Name - Enter the consolidation name to appear in the report header.

Division - Click to select one or more divisions for the report. If no divisions are selected, all divisions appear in the report.

Period End Date - Click to select the fiscal period and year for the report from a filtered list. If you know the period end date you want for the report, you can enter it, click to select the date from a Date Picker, or click to enter a Date Formulas. If you want to save the information in the date field when you save the report options, you must use a date formula. If you enter or select a date that is not a period end date, ProContractor clears the field. This field is required.

  • Budget Revision - Enter the number of the budget revision for the report. If you do not enter a revision number, budget amounts will not appear on the report.

Accounting Basis - Select Accrual to show posted transactions with an accrual accounting basis. Select Cash to show posted transactions with a cash accounting basis.

  • Include Pending Amounts - Select the checkbox to show both pending and posted activities in the report. Deselect the checkbox to show only posted activities in the report.

  • Print By - Click to select the account information to include in the report. Select Account Type to show each account type in the report, but not show account information. Select Account to show each account in the report, but not show divisions. Select Division to show each account and its division in the report.

  • Print Subaccounts - Select the checkbox to group and sort the report by subaccount instead of account.

  • Print Account Number - Select the checkbox to show the account numbers in the report.

    Tip: You can use the Modify Reports screen to customize the format and layout of this report.

For more information on running this report, see Run and Print Reports.

Note: ProContractor uses the period end date of the Consolidated Income Statement - Actual vs. Budget Report and fiscal period definitions to determine the report period for the Account Transactions Report. For example, suppose you generate the Consolidated Income Statement - Actual vs. Budget Report with a period end date of 1/31/2017. In this example, assume that the first day of the corresponding fiscal period is 1/1/2017 and the first day of the corresponding fiscal year is 10/1/2016. If you drill down from the Month to Date Actual column in the Consolidated Income Statement - Actual vs. Budget Report, the Account Transactions Report displays entries that fall between 1/1/2017 and 1/31/2017. If you drill down from the Year to Date Actual column, the Account Transactions Report displays entries that fall between 10/1/2016 and 1/31/2017.