Show TOC

Object documentationBalance Sheet Comparison Locate this document in the navigation structure

 

This report compares the balance sheet reports of two companies, or of two periods of the same company, with the same chart of accounts. Use this window to specify selection criteria for the Balance Sheet Comparison report.

To open the window, choose   Financials   Financial Reports   Comparison   Balance Sheet Comparison  . Alternatively, open it from the Reports module.

After defining the report, you can view it in the Balance Sheet Comparison window.

Selection Criteria
Company Name

Name of the company to which you are currently logged on.
Database Name

Name of the database to which you are currently logged on.
Posting Date/Document Date

Specify whether to generate the report according to a posting or a document date range.
From...To

Specify the dates of the first and last day to be included in the report.
Company Name

Name of the company to which the figures of the current company should be compared. By default, the name of the current company is displayed.
Database Name

Name of the database to which the figures of the current company should be compared. By default, the database of the current company is displayed.
Change

Opens a window in which you can choose the company to which the figures of the current company should be compared.

Note Note

You can only select companies that are located on the same database server as the current company.

End of the note.
Posting Date/Document Date

Specify whether to generate the report according to a posting or a document date range.
From...To

Specify the dates of the first and last day in the comparison company to be included in the report.
Display in Report

  • Accounts with Balance of Zero – Report displays accounts with zero balance.

  • Differences in % – Adds a column displaying the differences between the compared companies or posting periods, as a percentage.

  • Amount Differences – Adds a column displaying the differences between the compared companies or posting periods, as a percentage.

  • Foreign Name – Displays only foreign names defined for G/L accounts.

    Note Note

    Accounts for which a foreign name was not defined are not displayed in the report.

    End of the note.

  • External Code - Displays external codes defined for G/L accounts in   Financials   Chart of Accounts   External Code  .

  • Local Currency – Displays the results in local currency.

  • System Currency – Displays the results in system currency.

  • Foreign Currency – Displays the results in foreign currency.
Template

Specify the template to be used for the report.

Add Journal Vouchers

Includes in the report transactions that are recorded in Open journal vouchers, but are not yet saved in the database.

Add Closing Balances

Includes period-end closing journal entries, for the chosen posting period only, in the report. As such, the Profit Period shows a zero balance for a closed posting period.

Add Closing Balances is not selected: period-end closing journal entries are not included in the report, and the Profit Period shows the balance prior to the period-end closing process.
Ignore Adjustments

Report excludes adjustment journal entries from its balance calculation.
Choose Segments

Opens the Find G/L Accounts window where you can choose the accounts to include in the report, according to segments.

Note Note

End of the note.

Only available if the company maintains a chart of accounts based on segments.
Revaluation

Opens the Balance Sheet Revaluation window where you can make additional selection criteria for revaluation.