Trial Balance
Search
Search Onvio Support Help and Support.

This article applies to:

  • Product: Onvio
  • Audiences: Staff

Set up grouping schedules

You can use grouping schedules to group similar accounts together for reports and financial statements, and to calculate net income in the trial balance. You can add or modify an unlimited number of grouping schedules for your project.
  1. Open your project
  2. Select the Groupings tab.
  3. Choose a grouping schedule from the drop-down menu or create a new one. We recommend you use the default — Account Classification — which you can modify.
    Code
    Description
    Subcode
    Description
    CA
    Current Assets
    CASH
    Cash and Equivalents
    CA
    Current Assets
    MS
    Marketable Securities
    CA
    Current Assets
    AR
    Accounts Receivable
    CA
    Current Assets
    INV
    Inventory
    CA
    Current Assets
    PE
    Prepaid Expenses
    CA
    Current Assets
    OCA
    Other Current Assets
    NPE
    Net Property and Equipment
    PE
    Property and Equipment
    NPE
    Net Property and Equipment
    NON
    Non-Depreciable Property and Equipment
    NPE
    Net Property and Equipment
    AD
    Accumulated Depreciation
    NCA
    Non Current Assets
    LT
    Long Term Investments
    NCA
    Non Current Assets
    IA
    Intangible Assets
    NCA
    Non Current Assets
    ONCA
    Other Non Current Assets
    CL
    Current Liabilities
    AP
    Accounts Payable
    CL
    Current Liabilities
    CUR
    Current Portion of Long Term Debt
    CL
    Current Liabilities
    NP
    Notes Payable
    CL
    Current Liabilities
    AL
    Accrued Liabilities
    CL
    Current Liabilities
    COMP
    Compensation
    CL
    Current Liabilities
    INT
    Interest Payable
    CL
    Current Liabilities
    TAX
    Income Taxes Payable
    CL
    Current Liabilities
    OCL
    Other Current Liabilities
    LTL
    Long Term Liabilities
    LTD
    Long Term Debt
    LTL
    Long Term Liabilities
    DEF
    Deferred Income Taxes
    LTL
    Long Term Liabilities
    OLTL
    Other Long Term Liabilities
    EQ
    Equity
    CS
    Capital Stock
    EQ
    Equity
    CAPC
    Capital Contributions
    EQ
    Equity
    CAPW
    Capital Withdrawals
    EQ
    Equity
    APIC
    Additional Paid in Capital
    EQ
    Equity
    TS
    Treasury Stock
    EQ
    Equity
    PE
    Partnership Equity
    EQ
    Equity
    RE
    Retained Earnings
    EQ
    Equity
    OE
    Other Equity
    EQ
    Equity
    DIV
    Dividends
    INC
    Income
    SALE
    Sales Revenue
    INC
    Income
    RET
    Returns and Allowances
    COS
    Cost of Sales
    COS
    Cost of Sales
    EXP
    Operating Expenses
    GEN
    General and Administrative Expenses
    EXP
    Operating Expenses
    SE
    Selling Expenses
    EXP
    Operating Expenses
    RM
    Repairs and Maintenance
    EXP
    Operating Expenses
    DEP
    Depreciation Expense
    EXP
    Operating Expenses
    OC
    Owners Compensation
    EXP
    Operating Expenses
    OOE
    Other Operating Expense
    OI
    Other Income
    Gain
    Gain on Sale
    OI
    Other Income
    OI
    Other Income
    OE
    Other Expenses
    LOSS
    Loss on Sale
    OE
    Other Expenses
    OE
    Other Expenses
    INT
    Interest Expense
    INT
    Interest Expense
    TAX
    Provision for Income Taxes
    TAX
    Provision for Income Taxes
    MEMO
    Memo
    MEMO
    Memo
    OTH
    Other Miscellaneous
    N/A
    N/A
  4. If you want to create a new grouping schedule:
    1. Click the Add icon.
    2. Enter a name for the grouping schedule.
    3. Select Add.
    4. Complete the steps below to add codes, subcodes, and assign accounts.
  5. If you want to add codes or subcodes an existing grouping schedule:
    1. If you are adding a subcode, first select the code you want to add the subcode for from the list.
    2. Select
      Add
      .
    3. Choose
      Code
       or
      Subcode
       from the list.
    4. Enter a name for the code.
    5. Enter a description for the code.
    6. Choose a predefined Category and Detail, if applicable.
    7. Select Save & Close
  6. If you want move, rename, recategorize, or delete a code or subcode from an existing grouping schedule:
    1. Select the code or subcode from the light to highlight it.
    2. Use the ungroup, arrow, edit and delete icons from the toolbar to make your changes.
  7. If you want to assign accounts to codes or subcodes in an existing grouping schedule:
    1. Select to highlight one (or more if you press and hold Ctrl on your keyboard) ungrouped account.
    2. Select to highlight the code or subcode you want to group the account to.
    3. Click
      Group
      .
note
  • Each code can have an unlimited number of subcodes.
  • When accounts are grouped to revenue and expense codes or subcodes in the Account Classification grouping schedule, the application calculates the net income and displays the balance in the Net Income row of the trial balance. Currently, the application calculates net income for only the Account Classification grouping schedule.
  • When accounts are grouped to a code or subcode, you can edit that account from this screen.