Account Balance Inquiry - Overview

Use the Account Balance Inquiry to display Period Balances for a selected G/L Account Number and compare it to actual, history and budget period amounts if desired.  The Inquiry includes three comparison columns that you select with each column row representing a Period.  This allows you to compare up to three different data sources at a time to the Account Number's period balances.  

Tip:  The comparison of data sources is also available in a similar format during Budget Maintenance.

Directions:

To see directions for...

• Opening the Account Balance Inquiry, click More.

  1.  Click Daily Work from the Menu Bar.

  2.  Click Account Balance Inquiry.
  
  Tip:  Or, use the keyboard shortcut:  [ALT] [a] [q] [a].
   
  Note:  You may also be able to access the General Ledger menu while in another INVISION module.  To activate the General Ledger menu in another module, the G/L Application Control must be set up for the module during installation.

   

  Account Balance Inquiry Window Example:

  

   

• Viewing the Account Balances for each Period within an account, click More.

   

  To view the Period Balances for a specific account:

  1.  Open the Account Balances Inquiry to display the Detail window.

  2.  Enter the Account Number that you want to display.
  Tip:  If you do not know the Account Number, click Search .

  3.  Select the Source Options for each column.

  4.  Click Retrieve or press [ENTER].
  Keyboard shortcut:  [ALT + t]

   

  Account Balance Inquiry - Detail Window Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  Account	Enter the Account Number that you want to display.  (format varies) Tip:  To Search for the Account, click Search . Keyboard shortcut:  [CTRL + f]
  Account Description	Displays the Account Description for your reference.
  Use the Columns Source 1-3 to specify the source data to display in the columns for comparison.  For each column, you can specify one of three sources of data including actuals, history, or a budget.  You can mix and match the sources as desired; for example, you can display three different budgets in the comparison columns.
  Column 1 Source	In the drop-down list, click the option for the data source that you want to display in the first comparison column.  (predefined) Options: None Actuals Budget Tip:  When you click Budget, you are prompted to enter the Budget Name. History Tip:  When you click History, you are prompted to enter the Fiscal Year. Tip:  The description of the column displays next to the Column Option.
  Column 2 Source	In the drop-down list, click the option for the data source that you want to display in the second comparison column.  (predefined) Tip:  The description of the column displays next to the Column Option.
  Column 3 Source	In the drop-down list, click the option for the data source that you want to display in the third comparison column.  (predefined) Tip:  The description of the column displays next to the Column Option.
  History Year	If you specify History for a Column Option, at the prompt you must enter the Fiscal Year that you want to display and then press [ENTER].  (CCYY)
  Budget	If you specify Budget for a Column Option, at the prompt you must enter the Budget Name that you want to display and then press [ENTER].  (up to 5 characters) Tip:  If you do not know the Budget Name, click Search or press [CTRL + f].
  Show YTD Balances	To specify if you want to display YTD Balances for actuals: Select the box to show accumulated YTD balances in the actuals column. De-select the box to show Period Balances in the actuals column.
  	To load the source data for the specified Account Number, click Retrieve. Keyboard shortcut:  [ALT + t]
  Account Inquiry Display
  Period	The Period column displays the Period Number and Period Description in each row.
  Column 1	Displays the amounts for the source data selected above. Tip:  You can compare data sources including actuals, history, and other budgets.
  Column 2	Displays the amounts for the source data selected above.
  Column 3	Displays the amounts for the source data selected above.
  Beginning Balance	Each column displays the Beginning Balance for the account.
  Ending Balance	Each column displays the Ending Balance for the account.