Account Balance Inquiry

Account Balance Inquiry - Overview

Use the Account Balance Inquiry to review 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 open click Daily Work from the Menu and then click Account Balance Inquiry.

Tip: Or, use the keyboard shortcut: [ALT] [a] [q] [a].

Account Balance Inquiry Window Example:

Account Balance Inquiry - Detail Window Prompts
Summary Steps	To view the period balances for an account: 1. Enter the Account Number that you want to display. Tip: If you do not know the Account Number, click Search . 2. Select the Source Options for each column. 3. Click Retrieve or press [ENTER]. Keyboard shortcut: [ALT + t]
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
Information	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.