Alt Account Detail Report (UCSF Health) Job Aid

The Alt Account Detail Report (ADR) displays detail transaction information for all financial transactions and journal entries posted to the PeopleSoft general ledger. This step-by-step guide explains how to filter and run the report.

What Can I Learn from the Alt Account Detail Report?

  • Provides accurate and timely information for researching transactions
  • Facilitates reconciliation to source documents and/or source systems
  • Displays when drilling through for more detail from other reports

Report Date Filter

Choose the date range using the From and To dropdown menus. The default date range is set to the current open accounting period.

Chartstring Filters

  1. Select Business Unit (BU), or multiple BUs – this is a required (*) field .
  2. Enter the Alt Account and/or any other chartfield parameters desired. At least one of the conditionally required fields denoted by an orange triangle (▲) must be selected .

See the Filtering and Running Reports in MyReports job aid for additional information and tips & tricks for using the filters to configure your report criteria.

Report Specific Filters

You can further refine your search with the following filters:

  1. Transaction Type  -choose which transaction type(s) to display.
  2. Choose to display a specific Source Code, Vendor, Journal Preparer, and/or Journal ID .
  3. Report Sort 1 and Report Sort 2 allow you to apply one or two sort criteria to the report output, and will generate subtotals by sort group .
  4. Amounts Displayed  – choose which report columns to display in the report output.
  5. Display Codes and Descriptions  – display Codes Only (default), both Codes and Descriptions, or Descriptions Only.
  6. Display Columns  – select the columns that should be displayed in the report output.

Report Output

  1. In addition to the report output selections of On Screen HTML (default), PDF, and Excel , you can choose Unformatted Data. 
  2. The Unformatted Data output returns an Excel file that has no special formatting and a single row for column headings, making it the best source for pivot tables and other advanced spreadsheet analysis.
  3. Select your desired report output and click the Run Report button .

In both Excel outputs (standard Excel and Unformatted Data), the workbook will contain at least two tabs. The first tab/sheet always displays the entered filter criteria. The second tab/sheet displays the data and differs depending on whether you selected standard Excel or Unformatted Data.

Working in the Report View

  • The ADR returns data in list format without subtotals or groupings. However, you may further refine your report using the Sort 1 and Sort 2 options to group and records accordingly with a subtotal in each grouping.
    1. Click the Sort 1 drop-down and select a value from the list .
    2. If desired, select the second desired grouping from the Sort 2 drop-down .
    3. Click Update :
      Your report is refreshed and now displays data in your chosen groups.
       
  • Click the Refine Display Columns link to redisplay the column picklist filter to update the columns that appear in the output .





     
  • If an employee’s UCSF and UCPath Employee ID display in the Ref/Inv column, users with access to the Labor Productivity Reports will see a hyperlink that drills to the Employee and Position Roster Report .







     
  • PO ID and Voucher ID columns display in hyperlinks drills to the Accounts Payable/Purchase Order Inquiry Report .




     
  • Actuals displayed as a hyperlink drills to the UCSF Health McKesson AP Detail Report .






     
  • Information displayed in the Reference Column (Ref/Inv ID) differs depending on transaction:
    • Invoice number for general vouchers .
    • Subcontract ID for subcontract vouchers .
    • Expense Report Name for MyExpense .
    • Cardholder Name for PCard .

Tips and Tricks

  • Run an ADR for the narrowest criteria applicable:
    • In most cases, running a Monthly Variance report first, then drilling on items needing further research will be more efficient.
    • If you require detailed transaction information, filter your ADR report for the shortest date range and lowest Dept ID. Consider limiting the report by Transaction Type when possible.
  • The ADR only displays transactions for the time period selected.

Additional Information and Assistance

  • More information about MyReports, including how to request access and additional training, can be found in the MyReports section of the Controller’s Office website.
  • If you require help with a technical problem or have a question about a specific report, contact the Controller’s Office Solution Center at [email protected] or 415.476.2126.
  • To stay informed about MyReports news, follow the directions on the MyReports section of the Controller’s Office website to join the MyReports ListServ.

Give Us Your Feedback