Account Master Explorer

Use the Account Master Explorer to quickly look at all or specific general ledger account balances and the transaction activity that makes up the balances.  To view general ledger balances, select the account view that you want and then select the type of report format to view.  The Account View allows you to view accounts in predefined, organized groups.  The types of reports that you can select include income statement, balance sheet, trial balance or budget reports.  For example, you can view a trial balance for a specific department by selecting the Account View for the department and then selecting Trial Balance.  When you have a report displayed in the Explorer panel, you can drill-down to view the transaction detail that affected a particular balance by viewing the Activity report and you have the option to print the information or, you can save the information as a Microsoft Excel, Word or a tab delimited file, if desired.

Directions:

To see directions for...

• Opening Account Master Explorer, click More.

   

  To open the Account Master Explorer:

  1. 1.  Click Daily Work from the Menu Bar.

     2.  Click Account Master Explorer.

  Account Master Explorer Window Example:

  

   

• Viewing an Account Master, click More.

   

  To view General Ledger account balances and the transactions that affect the balances:

  1.  Click to select the Account View from the Account View list.
  
  Tip:  To drill-down to a specific department, sub-account, fund or general ledger account for more specific view, click the plus + to the left of the view name or general ledger account.

  2.  Click to select the type of report to view and the general ledger information displays in the Explorer panel as seen in the example below.

   

  

   

• Generating an Account Master Activity Report, click More.

   

  Use the Activity Report feature to view the transactions that affected a particular account so far this year or, you can select another year to view.  This information can also be printed.

  To view the Activity Report:

  1.  Double-click to highlight the specific GL Account to view activity for and the following window displays.  Or, you can click the desired account and then click Activity .

  

   

  3.  To view the GL Account activity for another year, click the desired year tab.

  4.  To print the activity report, click Print .  For directions, see Printing an Account Master Explorer Report.

   

• Printing/Exporting an Account Master Report, click More.

   

  Use the Print command to print the information that has been generated for the specific Account Master Explorer report or Account Master Activity report.  In addition, you have options to save the information in 3 different formats.  You can save it as a Microsoft Word file, Excel file or a tab delimited file so that the information can be used in another program.

  After clicking Print, the following window displays:

   

  

   

  Print Prompts Tip:  To see more information about a field, click the hyperlink for the field name.
  Print Step
  Page Title Narrative Table Title Additional Narrative	You can include additional text to the top and/or bottom of the report. Additional Text options: Page Title – prints at the top of the report page. Narrative – prints on a line below the Page Title. Table Title – prints on a line above the report data. Additional Narrative – prints on a line below the report data.
  Print Landscape	To print the report in landscape orientation (11x8.5), click Landscape. To print the report in a portrait orientation (8.5x11), leave this box unchecked.
  	To print the report, click Print. Note:  Before you click print, you can add additional text and page formatting, if desired.  See below.
  	To print to the Print View window, click Print View .
  	To return to the report or Explorer window, click Close.
  Save As Step
  	There are 3 formats for saving the report information ,if desired: To save the information as a Microsoft Excel file, click Save Excel . To save the information as a Microsoft Word file, click Save Word . To save the information as a tab delimited file, click Save Tab Delimited File .
  Open file after export	To automatically open the file in the appropriate program after it is saved in the desired format, click to check this box. To omit opening the file after saving in the desired format, leave this box unchecked.
  After clicking the desired save as format, the following window displays:
  Save In	Click to select the directory for the destination location to save the file.
  File Name	Enter the file name of the file to be saved.
  Save as type	The default Save as Type is selected for you.  To change, click another choice in the drop-down list.
  	To save the file with the path and file name entered, click Save. Note:  The file is saved as the format you specified.
  	To return to the report or Explorer window without saving, click Cancel.

   

• Report Sample, click More.

   

  To see an example of the report, click Account Master Explorer Report Sample.