Consolidated Ledger > Consolidation Reports > Consolidated Balance Sheet

The Consolidated Balance Sheet report displays the consolidation company’s consolidated assets, liabilities and owner’s/stockholder’s equity balances of the subsidiaries. The presentation of the Consolidated Balance Sheet depends upon the definition of account categories, account groups setup and how you assign the GL Account IDs to these account groups. The Consolidated Balance Sheet is designed to company with US generally accepted accounting principles.

This report has the following uses:

•To aid in assessing the financial condition of the consolidated companies as of a certain period.

•For reference when evaluating various financial ratios.

Notes:

•For a non-profit organization, the Consolidated Balance Sheet is replaced with the Consolidated Fund Statement.

•If the IFRS feature is activated for the company, the Consolidated Balance Sheet is replaced with the Consolidated Statement of Financial Position.

To print the Consolidated Balance Sheet, follow these steps:

1.Access the Consolidated Balance Sheet function from the Financial Statements group in the Reports main menu.

2.Select the report configuration that you want to use by clicking the List box button beside the Configuration field.

3.Click the List box button next to the Sort By field and select one of the following sorting options:

•Account ID

•Specific segment type such as Account #, Division or Department

Note: If you choose any of the minor segments as a sorting option, AccountMate will automatically enable the lower Sort By field for you to choose another minor segment sorting option. Choices for the second sorting option are limited to the minor segments.

4.In the Layout field click the List box button and select the desired layout for the report. You can select from the following options:

oSingle Period

Select this option to display a Consolidated Balance Sheet report for a single period. If you choose this option, the first Year and Period fields in the Filters area will be enabled. You may click the List box button beside the Period field to choose either the Default Period option or the Specific Period option to enter your desired period in the Year and Period fields.

oPeriod Comparison

Select this option to display a Consolidated Balance Sheet that calculates account balance variances between periods. These periods may belong to the same fiscal year or to different fiscal years. Click the Year and Period fields in the Filters area to choose the two periods that will be compared in the Consolidated Balance Sheet.

oRange of Period

Select this option to display a Consolidated Balance Sheet report for a range of periods. These periods should belong to the same fiscal year. Click the Year and Period fields in the Filters area to choose the range of periods in the same fiscal year that will be displayed in the Balance Sheet.

o2-yr Comparison (YTD)

Select this option to display a Consolidated Balance Sheet that calculates the year-to-date balances between two years. Click the Year and Period fields in the Filters area to choose the year and period that will be compared with the same period in the prior year. For example, if the consolidation company is using a calendar year as its fiscal year and you choose “2023” and “August 2023” as the specific period, the Consolidated Balance Sheet will show a comparison of balances for January through August 2023 and January through August 2022.

o3-yr Comparison (YTD)

Select this option to display a Consolidated Balance Sheet that calculates the year-to-date balances for three years. Click the Year and Period fields in the Filters area to choose the year and period that will be compared with the same period in the prior year and the historical year. For example, if the consolidation company is using a calendar year as its fiscal year and you choose “2023” and “August 2023” as the specific period, the Consolidated Balance Sheet will show a comparison of the balances for January through August 2023, January through August 2022, and January through August 2021.

5.In the Type area select whether you want the report to be displayed in Detail, Subtotal or Grand Total.

6.Mark the applicable checkboxes in the Report Header area if you want to Include Time or Include Printed By information in the report header.

7.In the Report Configuration area, define the desired report filters. You may mark the Individual checkbox if you want to generate the report for a single record and enter the appropriate value in the adjacent field; otherwise, select in the Filters area the desired criteria in generating the report.

Note: The available fields in the Filters area may vary when you select a different sorting option.

8.Choose one of the following options:

oCombined

Select this option if you want the report to display individual GL Account ID balances assigned to all selected segments.

oCons. Group

This option will only be enabled if you choose a minor segment value such as Department or Division as the sorting option. Select this option if you want the report to display a total balance for each similar account group regardless of segments.

oCons. Segment

This option will only be enabled if you choose a major segment value such as Account # as the sorting option. Select this option if you want the report to display a total balance for each account number or major segment.

oIndividual

This option will only be enabled if you choose a minor segment value such as Division or Department as the sorting option. Select this option if you want AccountMate to generate a Consolidated Balance Sheet for each minor segment you specified.

Note: If you select the Individual option and unmark the Generate Report for All Segments checkbox and then you click the Preview button in the Report toolbar, AccountMate will display a message requesting your confirmation to generate the next minor segment depending upon the chosen sorting option.

9.Click the List box button in the Rounding Level field, and choose whether you want to present in the report the amounts down to the decimal or rounded off to whole numbers, in hundreds, in ten thousands, in hundred thousands, or in millions.

10.Mark any of the following check boxes:

oShow Account ID

This option is enabled if you choose the Detail option in the Type area. Mark this checkbox if you want the report to display the GL Account IDs.

oInclude Zero Balance Accounts

This option is enabled if you choose the Detail or Subtotal option in the Type area. Mark this checkbox if you want the report to display the GL accounts with zero balances.

oShow Decimals

Mark this checkbox if you want the report to display the decimal values for each amount displayed in the report. This checkbox is disabled when an option other than “No Rounding” is chosen in the Rounding Level field.

oInclude [xxx] with no Activity

This option is enabled if you choose the Individual option. Mark this checkbox if you want the report to display GL accounts with zero balances from each of your chosen minor segment in the sorting option.

oGenerate Report for all Segments

This option is enabled if you choose the Individual option. Mark this checkbox if you want to generate separate reports for each minor segment (depending upon the sorting option chosen) consolidated into a single report file.

oShow Liabilities and Equity on New Page

Mark this checkbox if you want to show the Liabilities and Equity sections on a page that is separate from the Assets section. This checkbox is inaccessible when either the Subtotal or Grand Total type is chosen in the report interface.

11.Click the Preview or Print button to preview or print the consolidated report. Click the Configure tab to return to the report configuration page.

Drill-Down Capability

•When you choose to run the Consolidated Balance Sheet selecting the Detail Type option and Single Period option, AccountMate allows you to drill down on GL account balance details.

•To view the journal entries that compose a certain transaction amount in the Consolidated Balance Sheet, click an amount in colored font. AccountMate will display the Consolidated Ledger Listing report showing the source transaction.

•You can also drill down on the GL Account ID in colored font to display the Chart of Accounts Maintenance, which provides detailed information about the GL Account ID.

The Consolidated Balance Sheet function also provides you with flexibility to perform the following:

Consolidated Balance Sheet

Consolidated Balance Sheet

Drill-Down Capability

See Also