Skip to main content
Report Designer

Show total of multiple accounts

In the Report Designer, you are able to display the total amount for a subset of accounts as well as the detail for the other accounts. For example, you can display the total for all of the cash accounts and details for the other current asset accounts in the
Balance Sheet - Current Year
 financial statement.
The first image shows the
Balance Sheet - Current Year
 without any modifications, where there are two cash accounts listed separately.
Balance Sheet showing Current Assets. There are 7 categories of asset: Petty Cash, Checking Account, Marketable Securities, Billed Receivables, Inventory, Deposits and Prepaid Expenses, and Office Equipment. Each category has an amount. A total of assets is shown at the end.
The following screen displays the modified
Balance Sheet - Current Year
 with the two cash accounts shown together as one total.
Balance Sheet showing Current Assets. There are 6 categories of asset: Total of Cash Accounts, Marketable Securities, Billed Receivables, Inventory, Deposits and Prepaid Expenses, and Office Equipment. Each category has an amount. A total of assets is shown at the end. The Total of Cash Accounts is a combination of Petty Cash and Checking Account.
  1. Select
    File
    , then
    Report Designer.
  2. Select
    Financial Statements
     in the Reports frame.
  3. Double-click
    Balance Sheet - Current Year
     financial statement to open it in the design grid.
  4. Add two rows between rows 4 and 5.
  5. Row 5 should not be a repeating row. If you need to ungroup rows 5 and 6, right-click row 5 and select
    Ungroup from Repeating Level
     from the context menu.
  6. Right-click row 5 and select
    Row Height
     from the context menu.
  7. Enter
    0.00
     and select
    OK
    .
  8. Right-click cell A4 and select
    Delete Cell Contents
     from the context menu.
  9. Enter
    Cash Accounts
     in cell A4.
  10. Select cell B4 and in the Cell Properties section of Design Tools:
    1. Change the cell's Grouping content to
      CA : CASH
      .
    2. Mark the
      Print total amount
       checkbox.
  11. Select cell A6 and insert the
    [ChartofAccountsActivity.Core.GLAccountDescription]
     variable.
  12. Select cell B6, and insert the
    [ChartofAccountsActivity.Core.Amount]
     variable.
  13. Select cell B6, and in the Cell Properties section of the Design Tools frame, select the
    Account Classification
     Grouping type.
  14. Select the
    Formula
      button next to Grouping content field, then select
    Clear Formula
    .
  15. Select the following codes in the Account Classifications list and select the
    +
     operator after each:
    1. CA: No subcode (Current Assets: No subcode).
    2. CA: MS (Current Assets: Marketable Securities).
    3. CA: AR (Current Assets: Accounts Receivable).
    4. CA: INV (Current Assets: Inventory).
    5. CA: PE (Current Assets: Prepaid).
    6. CA: OCA (Current Assets: Other Current Accounts) .
  16. Select the appropriate Period, Amount type, and Basis in the Design Tools frame.
    note
    The Adjusted basis is used when the Basis field in the Row Properties section of the Design Tools frame is blank.
  17. Select cell B8. Adjust the formula in this cell to account for the new row. In our example, it should be [B4 + B6].
    note
    You may need to adjust the formatting of the inserted cells.
    The following image displays the applied changes in the appropriate sections of the design grid for the
    Balance Sheet - Current Year
     statement.
    Balance Sheet showing Current Assets. There are two categories of asset: Cash Accounts and a variable [ChartofAccountsActivity.Core.GL AccountDescription]. Instead of amounts there are variables for each of these categories, and the Total Current Assets is shown as [B4 + B6]

This article applies to:

  • Product: Workpapers CS
  • Subject: Reports

Related Content