The Rows menu allows you to determine the rows that display in the Trial Balance statement. You can show or hide the current year earnings, and accounts that had activity (or not).
show or hide the accounts with activity, determining which rows are displayed in the financial statement and giving you a simple way to identify active accounts. In a Trail Balance statement, you can also show or hide the Current Year Earnings row.
The behavior of the Rows menu is consistent with the Analytics nested grid, as it shows the result for the first dimension, which in Financial Statements is the Statement Group category.
Use the activity filter
A simple way to identify active accounts is to use the activity filter.
Click Use the Rows menu , then select one of the activity optionsas an activity filter to switch between viewing rows with Activity, No Activity, and All (accounts with both activity and no activity)*.
Activity - Displays items : Only the accounts for which there have been transactions in a the selected period and where the result is not zero. Usually Typically, this is the default view.
No Activity - Displays only items that had : Only the accounts with no transactions in a period. All items with no transactions are highlighted in green. Results the selected period. These rows have a white background. The results depend on how up-to-date your source data is. For example, you might see accounts that have been discontinued.
All - : Combines the other two options ; displays to show all itemsaccounts, regardless of whether a transaction has occurred. For example, in the second image below, there’s a statement group called Right of Use Asset Depreciation, which would previously not have shown in the selected period, as the transaction values are nil.
| Info |
|---|
*Depending on the database you are analyzing, the options might be different, as your administrator can customize the option labels in Designer to meet your business ' requirements. The labels are usually in the context of Activity, No Activity, or All. |
Hide the current year earnings in a Balance Sheet
By default, the current year earnings row displays on the Trial Balance statement, but you can hide it from view.
Click the Rows menu and clear the Current Year Earnings checkbox. Your selection persists in favorites and dashboards.
On this page
| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|