Consolidated Income Statement - 12 Month screen

Use the Consolidated Income Statement - 12 Month screen to create a report of income for a selected month and the 12 months prior, 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.

The income for each month is displayed in a separate column. The columns for the first and last months are displayed adjacent to each other for an easy year-to-year comparison.

To have general ledger accounts from multiple companies combined in the report, the accounts must have the same account code, name, division, account type, and normal balance. For each company selected, ProContractor includes general ledger amounts up to the selected period end date. Note that if a company's fiscal periods are not defined by month end, the columns in the report may contain amounts from multiple fiscal periods.

Note: To open the Consolidated Income Statement - 12 Month screen, click Financial > Reports > Consolidated Financial Statements > Consolidated Income Statement - 12 Monthin the All Tasks pane.

You can control the output of the Consolidated Income Statement - 12 Month 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.

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 without detailed 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.

  • Include Zero Balances - Select the checkbox to show all accounts that have a non-zero beginning balance and/or a non-zero transaction amount 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 - 12 Month Report and fiscal period definitions to determine the report period for the Account Transactions Report. For example, suppose you generate the Consolidated Income Statement - 12 Month Report with a period end date of 1/31/2017 and the first day of the corresponding fiscal period is 1/1/2017. If you drill down to the Account Transactions Report from the Consolidated Income Statement - 12 Month Report, the Account Transactions Report displays entries that fall between 1/1/2017 and 1/31/2017.