Show TOC

Object documentationBalance Sheet - Selection Criteria

 

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

To open the window, choose Start of the navigation path Financials Next navigation step Financial Reports Next navigation step Financial Next navigation step Balance Sheet End of the navigation path. 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:Start of the navigation path Financials Next navigation step Financial Report Template End of the navigation path. 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.
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.

More Information

Balance Sheet Revaluation