Skip to Knowledge Base content

Account Analysis Report

This guide will cover:

  • How to navigate to and schedule the account analysis report.
  • How to format the report for use using the account analysis pivot macro.
  • Reading the Account Analysis Report.

Note: This report includes all transactions which have processed in WyoCloud including:

  • Requisitions/Purchase Orders/Invoices/Non-PO Invoices
  • Journal Entries, including IDTs (which have been posted by Accounting)
  • Reconciled Expense Reports (including p-card expenses)
  • Payroll and Fringe Benefits
  • Summary level integrations from Banner (including cashier’s/marketplace transactions), postal, telecom/IT Billing

Step One

To log into WyoCloud and navigate to the Reports and Analytics area.

  • Navigate to the WyoWeb website and select Financial Management from the WyoCloud area.  The WyoCloud Home page is displayed.

  • From the WyoCloud Home page, click Navigator then Reports and Analytics.

  • The Reports and Analytics page is displayed.


Step Two

Navigate to Account Analysis Scheduling:

  • Click Shared Folders > Financials > Fusion Accounting Hub > Account Analysis Report

  • Click on Schedule after clicking on Account Analysis Report.


Step Three:

Schedule the account analysis report.

  • In the pop up window, complete the following fields:
    • Subledger dropdown: blank
    • From Accounting Period: Jun-17
    • To Accouting Period: Most recent closed accounting period.
    • Budget Type: Actual
  • In the same window, click on the blue filter icon next to Account Filter Conditions Defined.

  • In the new pop up window, select Add Fields then Organization.
    • Although you can filter by additional fields it is recommended to just filter your Organization or range of Organizations at this step.  Please note that the other chart of accounts segments will also pull in when you run this report using this filter. 
    • Note: At least one filter must be entered.

  • Complete the fields per the Organization data you’d like returned. Click OK.

  • Click Advanced.

  • Click Output, then the plus sign.

  • In the Format drop down, CSV must be selected.
  • Click Submit.

  • In the confirmation window, click OK.


Step Four:

Retrieve and download the report.

  • Return to the file path on the left, click on Account Analysis Report again.  Click History.

  • The Report Job History screen will display. In the Report Job Histories area every time you’ve run the report will display.  The top result is the most recent running.
  • Always check to confirm the status is Success.  If it is not, click the refresh icon at the top of the page until the Success Column changes to Success.

  • When the report shows to status Success, open the report by clicking on the numerical Report Job Name.

  • Scroll down to the Output & Delivery area, then click on the Output Name.

  • Select Open with then confirm Microsoft Excel is showing in the drop down. Click Ok.

Note: If Microsoft Excel doesn’t show as an option in the Open with field, you will need to change your computer’s default settings for opening .csv files. For details on doing this see this Knowledge Base article.

  • Once the file is open in Excel on your computer, click File then Save As
  • Save the file to your desktop. Be sure to select CSV (Comma delimited) (*.csv) from the Save as type dropdown.
    • Note: This is just a temporary save and can be discarded after the macro is run in step five.

  • Be sure to close the file prior to proceeding to step five.


Step Five:

In this step you will download and run the Account Analysis Pivot Macro to properly format the report for use.

  • Download the Account Analysis Pivot Macro located in the files section on the right side of this webpage (link).
    • As a best practice, always download the macro file directly from the Knowledge Base each time you use it to ensure you are utilizing the most current version.

Note: The macro is written to be compatible with Office 2016.  If you are operating with an older version, contact the UW Help Desk for assistance in upgrading.  Help Desk: or 307-766-4357

  • Upon opening the Account Analysis Pivot Macro, you will first need to select Enable Content in the yellow ribbon at the top.  Then click the grey Generate Pivot Account Analysis Report – 1 button (located in the Process tab).

  • In the Instructions pop up window, click OK.

  • Navigate to where you saved the exported Account Analysis Report from WyoCloud Financial Management Reports and Anyalytics on your desktop (obtained in step 1-4). Select it then click Open.

Note: It will likely take several moments for the macro to process.

  • Once complete, the report will look similar to this:

  • Use Save As to rename and save the report to your desired location for future reference.


Reading the Report:

After running the macro, the report opens to the Pivot Summary tab.  From this tab you can filter to specific segments of the chart string by using the filters at the top.

From the Pivot Summary tab, you can also drill in to see the details of specific amounts by expanding the small plus sign in the corner of individual cells.

Once a period is expanded, you can click on any number in columns: Accounted DR, Accounted CR or Account Balance and the full details of what makes up that number will open into a new tab.

Either in the full expanded details tab (see directions above) or the CombinedData tab. The following columns are included:

Column Name

Data Included


Reflects the starting month of the report (as input when scheduled).


Reflects the ending month of the report (as input when scheduled).


Notes that all items are accounted actuals.


Full accounting chart string.


Written version of the accounting chart string.


Year of the period.


Corresponds with the month of the fiscal year (ie: July = 1, August = 2).


Name of the period (month).


First day of the period.


Last day of the period.




Natural Account




Written version of Entity.


Written version of Natural Account.


Written version of Organization.


Written description of the Natural Account.

Segment 1


Segment 2

Natural Account

Segment 3

Fund Class

Segment 4

Fund Source

Segment 5


Segment 6

Expense Class

Segment 7


Segment 8


Segment 9



The date the transaction was posted to the General Ledger (GL).


Who entered into the GL. Note if this column shows serviceuw.integration this is a feeder file such as Banner, Telecom, Copier, Postal or Payroll.


When the transaction was initially entered into the system.


When the transaction was last updated.


This is a system generated number.


Description which was entered at the header level when the user entered the transaction.  The exception is those that say Journal Import indicate integrations or journal entries.


Type of entry the transaction was given when it was entered.


The source of the journal entry.


This is the name of the batch in the GL which can be utilized to search for more details within the system.


The date the transaction first occurred within the system.


This is the kind of journal entry.


Journal line number.


The line number of the journal entry.


Original journal or subledger line number.


Description which was entered at the line level when the user entered the transaction.


A debit posted to the General Ledger (GL).


A credit posted to the General Ledger (GL).


Balance of Debits minus Credits.


Date when the journal entry is transferred to the GL.


Subledger journal entry completion date.


The number of the transaction.


Indicates the application in the system which was used to process the transaction.  Ie: Payables: Invoices, Purchasing: Reqs and POs, Project Costing: PPM (grants).


This is system generated information.


This is system generated information.


The accounting event that originated the journal entry (ie: credit memo, period end accrual).


The action taken relating to the accounting event that originated the journal entry (ie: credit memo validated, invoice cancelled, invoice validated).


Accounting class assigned to the subledger journal entry line.


Supplier Number.


Supplier Name.


Number assigned to the supplier’s address.


Supplier’s address. Note: this appears as Order / Remit for transactions paid electronically.


This are the filter options you selected when you scheduled the report.


This are the filter options you selected when you scheduled the report.


This are the filter options you selected when you scheduled the report.


This are the filter options you selected when you scheduled the report.


Note: For better understanding on how to utilize pivot tables such as this one, UWIT offers useful trainings.  To see offerings visit the UWIT Catalog on WyoLearn. For Excel/Pivot table questions you may also email


You have now run the Account Analysis Report.

Was this helpful?
0 reviews


Article ID: 47811
Mon 2/5/18 3:40 PM
Tue 2/13/18 10:21 AM