Example 1: Exclude zero-balance accounts (all or no activity)

Account Groupings report

To exclude all zero-balance accounts, clear the Print zeros checkbox in the Row Properties for the account detail row.

Use the following steps to exclude only zero-balance accounts without activity.

1. Select row 8 in the Account Groupings report and create the following expression shown in the following example.

   Show me

   
2. Select row 6 in the Account Groupings report and insert the following conditional expression to exclude the account group heading when there is no activity.

   Show me

   

3. Repeat step 2 and select the following rows in the Account Groupings report to prevent the remaining headers, footers, and blank rows from printing when there is no activity in the account detail row.

   Row number	Condition to test	Action
   7	RowCount(8) > 0	If true, print: 7 through 7
   18	RowCount(8) > 0	If true, print: 18 through 19
   19	RowCount(8) > 0	If true, print: 18 through 19
   20	RowCount(18) > 0	If true, print: 20 through 21
   21	RowCount(18) > 0	If true, print: 20 through 21

Example 2: Exclude account detail and display balances in subcode row

Account Groupings report

To exclude account detail and show balances in the subcode row instead of with each account, use the Report Designer to modify the report as follows.

Example 3: Separate debit and credit columns (using total balance)

Trial Balance (Condensed, Detailed, and Segmented) reports or Trial Balance Worksheet report

Use the following procedure to separate debit/credit columns using a conditional expression.

1. Copy and paste an existing balance column to add other applicable balance columns.
2. Create conditional expressions for the amount cells to print only if the amount variable is >= 0 (for the debit amount cell) and to print only if the amount variable is < 0 (for the credit amount cell).

   Show me

   

   Note: To display the credit amounts as positive values, place the mouse pointer in the credit amount cell and choose Format > Cells, click the Format tab (Amount category), and then mark the Multiply by -1 checkbox.

3. Update *OUT OF BALANCE* conditional expression to print when a variance exists between debit and credit column totals.

   Show me

   

4. Update the applicable column heading text, as needed.

Example 4: Separate the P&L and B/S columns

Trial Balance Worksheet report

Use the following procedure to separate the P&L and B/S columns using conditional expressions.

1. Copy and paste an existing balance column to add more balance columns in the Trial Balance Worksheet report.
2. Create a conditional expression in the report that prints the amount variable in the P&L column only if ChartofAccounts.Accounts.TypeCode = "R" Or ChartofAccounts.Accounts.TypeCode = "E".

   Show me

   

3. Create a conditional expression in the report that prints the amount variable in the B/S column only if ChartofAccounts.Accounts.TypeCode = "A" Or ChartofAccounts.Accounts.TypeCode = "L" Or ChartofAccounts.Accounts.TypeCode = "Q".
4. Update the *OUT OF BALANCE* conditional expression to print when a variance exists between debit and credit column totals.

   Show me

   

5. Update applicable column heading text as desired.

Example 5: Include items that meet a specific threshold

Trial Balance Variance - Two Year or Five Year Comparison reports

To include items that meet a specific threshold, use the Report Designer to modify the report and set up conditional expressions to print only the applicable rows based on a specific change in dollar amount and/or percentage.

For example, for a $500 threshold in the By Account Number region, create a conditional expression in the report that prints the account detail row (row 4) only if I4 <= -500 Or I4 >= 500.

Show me