Summary

VRI Groups are user-defined collections of General Ledger accounts. Multiple groups are combined to create VRI Sets, which are then used in the Visual Reporting tool. Visual Reporting allows you to export GL account information into pre-formatted MS Excel GASB 34 spreadsheets, such as statements of net assets or revenues.

Step by Step

1     View the existing VRI Groups.

• Open the VRI Group Maintenance window (GL> Maintenance> VRI Groups).
• The VRI Group Maintenance window will display all of the groups that have been created in the database.
• Highlight a group and press DELETE or click the Delete icon   to delete the selected group.
• Press INSERT or click the Create icon to create a new group. This will add a new line item on the left side of the window.

2     Create a new Group.

• Enter a unique Group Name. This is a required field and can be up to 20 alphanumeric characters long.
  • You may find it useful to create Group Names that correspond to specific cells on the report form. For example, if you are creating groups for the Statement of Net Assets report, you would want the Restricted Cash asset accounts in your Governmental Activities fund to populate cell E18. You could create a group for this cell named Govt Restricted Cash.
• Enter a group Description. This is an optional field and can be up to 60 alphanumeric characters long.
• Enter a Set Name or click the field label to choose one from a list.
• Click the Add icon to open the Add Accounts window.
• Enter the desired search criteria to filter the displayed accounts.
  • The Add Accounts window allows you to attach GL accounts to the new group.
  • Enter a Fiscal Year or use scroll buttons to select a fiscal year.
  • Enter an account in the Account From field or click the field label to choose one from a list.
  • Enter an account in the Account To field or click the field label to choose one from a list.
  • Enter an Account Type or click the field label to choose one from a list.
    • Account types are groupings of general ledger accounts that determine the ALFRE (asset, liability, fund balance, revenue and expense) designation of the account. Account types created in the Account Type Maintenance window (GL> Maintenance> Account Type).
  • Check the ALFRE designation toggles to be included in the search results. By default, all of the toggles will be checked.
  • Click the Refresh icon to filter the displayed accounts by the designated criteria.
  • Each GL account can only be included in the selected set once. Any account that is displayed in red is already part of a group that is associated with the selected set.
• Click the Select All or Deselect All icons to quickly select or deselect all the displayed accounts. By default, all of the displayed accounts will be selected.
• Once you have selected the accounts you would like to associate with the new group, click the Confirm icon  .
• Click the Add icon again to return to the Add Accounts window and add more accounts to the group. For example, select the same Account Type but select a different fiscal year to include additional account history in the group.
  • Once an account has been added to the Accounts data grid, you can click on the account number to open that account in the Chart of Accounts Maintenance window.
• Click the Save icon when complete.