Show TOC

Object documentationBalance Sheet - Selection Criteria Locate this document in the navigation structure

 

Use this window to specify selection criteria for the Balance Sheet report.

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

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

Selection Criteria
Date From... To...

Specify:

  • Whether to create the balance sheet according to posting date or document date

  • The date up to which the report should be created.
Template

Select the template to be used for the report. The options available in this dropdown list are the financial report templates of type Balance Sheet that defined in:  Financials   Financial Report Template  . If you have not defined any financial report template, the default option is Chart of Accounts.
Display in Report

Choose one of the following:

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

  • Foreign Name – report displays the foreign names defined for G/L accounts.

    Nothing is displayed for accounts for which a foreign name was not defined.

  • External Code – report displays external codes defined for G/L accounts.
Annual/Quarterly/Monthly/Periodic Report

Specify whether to calculate the balance sheet for the entire year, or distributed according to months, quarters, or posting periods.

Note Note

These fields are not available for Brazil, China, India, Japan, Korea, and Singapore.

End of the note.
Display in First Column

Specify whether to display figures in local currency or system currency in the first column of the report.

Note Note

This field is not available for Brazil, China, India, Japan, Korea, and Singapore.

End of the note.
Display in Second Column

Select one of the following to be displayed in the second column of the report:

  • System Currency – figures in system currency

    Not available if you chose to display system currency in the first column.

  • Foreign Currency – figures in foreign currency

  • Relative Percentage – all figures in the first column are expressed as percentage

Note Note

This field is not available for Brazil, China, India, Japan, Korea, and Singapore.

End of the note.
Add Journal Vouchers

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

Add Closing Balances

The report includes period-end closing journal entries, for the chosen posting period only; as such, Profit Period shows a zero balance for a closed posting period.

If you do not select this option, the Profit Period shows the balance prior to the period-end closing process.

The balance of previously closed periods is displayed in the Retained Earnings G/L account, whether this field is selected or not.

Example Example

The company has two closed posting periods: 2003 and 2004.

  • Add Closing Balances is not selected, and you run the report to 2004.

    • The report displays the balance of the Profit Period from the beginning of 2004.

    • The balance of the previous periods (2003) is displayed in the Retained Earnings G/L account.

  • Add Closing Balances is selected, and you run the report to the last day of the posting period (December 31, 2004).

    • The report displays a zero balance for the Profit Period.

    • The balance of the previous posting periods (2003) is displayed in the Retained Earnings G/L account.

    • The balance of the profit and loss accounts of 2004 is displayed in the Period-End Closing G/L account.

  • Add Closing Balances is selected, and you run the report to the next posting period (2005). The balance of the previous posting periods is displayed in the Retained Earnings G/L account.

End of the example.
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 balance sheet, according to segments.

Note Note

Available only if the company maintains a chart of accounts based on segments.

End of the note.
Revaluation

Opens the Balance Sheet Revaluation window.
Country-Specific Fields: Brazil, China, India, Japan, Korea, and Singapore
Display LC

Displays local currency.
Display SC

Displays system currency.
Display LC and SC

Displays both local and system currency.

More Information

Balance Sheet Revaluation