Skip to main content
Report Designer

Use codes and subcodes in a formula

You can't directly combine grouping codes and subcodes in report formulas at this time in the Report Designer.
For this example, you have a list of accounts with the following account grouping codes and subcodes. You want to create a subschedule that excludes the Inventory Account.
GL Acct
Description
Grouping codes
Amount
1000
Cash on hand
CA
500.00
1020
Cash in bank
CA:CASH
13,654.60
1030
Savings
CA:CASH
30,381.11
1200
Inventory
CA:INV
111,000.60
Total: 155,536.31
You can't use
[(CA)-(CA:INV)]
 to exclude inventory from current assets. Instead of subtracting, we'll group the accounts you want to include.
  1. Identify the accounts you want to group together: Cash accounts, excluding inventory.
  2. Assign a common subcode to these accounts:
    1. Select
      Setup
      , then
      Chart of Accounts
      .
    2. For each cash account, add the subcode
      CASH
      :
      • Cash on hand:
        CA:CASH
      • Cash in bank:
        CA:CASH
      • Savings:
        CA:CASH
  3. In Report Designer, use the subcode to group these accounts with the formula
    [(CA:CASH)]
    .
Result
: Your report will now show only the accounts with the CA:CASH grouping, effectively excluding inventory without complex formulas.
Before
: Total Current Assets (CA): $155,536.31
After
: Total Cash Accounts (CA:CASH): $44,535.71
tip
Always double-check your totals after making these changes to ensure accuracy.

This article applies to:

  • Product: Accounting CS,Workpapers CS
  • Subject: Reports