Show TOC

Object documentationTrial Balance Comparison Locate this document in the navigation structure


This report compares the trial balances of two different companies or two different posting periods. Use this window to define selection criteria for the Trial Balance Comparison Report.

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

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

Note Note

This topic documents fields and other elements in this window that either are not self-explanatory or require additional information.

End of the note.
Selection Criteria
Business Partner

Select to include business partners in the report.


Open the Properties window and use the business partner properties as selection criteria.

G/L Accounts

Report includes G/L accounts.


To find a special account, choose this button and specify the account code. SAP Business One automatically displays an X next to this account.


Choose the level of the account display in the table. If you choose Level 1 here, the table displays the highest level titles for the accounts. If you select a row in the table, you actually select all the accounts that appear under this title.

Company Name

Displays the company and database names of the current company and the comparison company.


In this section, define the periods to be compared by the report:

  • Current, Comparison – Click Dropdown List (Dropdown List) and select whether to generate the report according to posting date, due date, or document date.

  • From, To, – Define the current period and comparison period by entering the required date ranges. Click Choose from List (Choose from List) to define the date ranges according to posting periods.

Display in Report

You can select the following options to display in the report:

  • Hide Zero Balanced Acct – Select this checkbox to exclude zero balanced accounts from the report.

  • Hide Acct with No Postings – Select this checkbox to exclude accounts with no postings. This checkbox is only available if Hide Zero Balanced Acct is deselected.

  • Differences in % - select to display the differences between the compared companies / periods as percentages.

  • Amount Differences - select to display the differences between the compared companies/periods in amounts.

  • Foreign Name – to display the foreign names defined for G/L accounts in   Financials   Chart of Accounts   Account Details   Foreign Name  .

    When this checkbox is selected, only foreign names are displayed. Nothing is displayed for accounts lacking a foreign name.

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

  • Opening Balance for Period - Select this checkbox when you need to differentiate between the balance of the selected posting period and the balance of the previous periods.

    As default, the checkbox is deselected. When a date range of a current posting period is selected, you can select this checkbox to display the bookkeeping balance prior to the selected date range in a separate column, O. B. This opening balance includes:

    • Bookkeeping balance prior to the selected date range.

    • Journal entries created in the selected posting period through   Administration   System Initialization   Opening Balances   (Origin = O.B, Transaction Type = -2).

    • Period-end closing journal entries of posting periods prior to the selected period.

  • Local Currency – displays the report in the local currency.

  • System Currency – displays amounts in the system currency only.

  • Foreign Currency – displays the report in a foreign currency.


Choose Dropdown List (Dropdown List) and select a template for displaying the balance sheet.

Add Journal Vouchers

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

Ignore Adjustments

Report excludes adjustment journal entries from its balance calculation.

Add Closing Balance

Includes closing balances in the report.


Opens the Trial Balance Revaluation window. After the revaluation is made, the option next to this button is selected.


Opens the Expanded Selection Criteria window, where you can use a project range and a distribution rule range as selection criteria for this report.