Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
UT Tracker Guides
Note that descriptions and account numbers have been obscured to protect the privacy of departments.
The best browser to view this report is Google Chrome.
To enlarge screenshots, use your document viewer controls to zoom in.
Table of Contents
Expand | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Reconciliation Report
The Reconciliation Report is a Tableau Visualization developed by Technology Resources (TRecs). This data “viz” pulls information entered and held within the UT Tracker database, returning IDT and Letter Bill information using a variety of filter and search mechanisms. This report is useful for pulling internal account reports, assisting with reconciliation, and exporting data to a spreadsheet file in a variety of formats.
Overview
Default Filter Collapsed View
The default view of the Reconciliation Report shows a drop-down, labeled “Filters.” To view the full report, in the upper right-hand corner, click the triangle pointing to the right.
Expanded View
Here you see the expanded view containing all filters and search fields available. Select one or more choices for each of the settings; the bar graph and report at the bottom of the page will be updated to reflect your criteria.
Reset Filters
The Reset Filter option in the lower right-hand corner below the Search notes or comments field resets the page to its default settings.
Interactive Bar Graph
Beneath the filter options, you will see Totals for each of the status categories and a bar graph based on your filter selections.
Image RemovedImage Added
Report
Beneath the Bar Graph, you will see the report details in a spreadsheet layout.
Image RemovedImage Added
Search Process
When searching within any of the drop-down filters with search functionality, note that you must first uncheck the (All) box prior to entering your data in order for the search to function as intended.
All items selected | All Items unselected |
Within each drop-down filter, after you make a selection using the checkbox(es), you must click the Apply button for the selection(s) to be recognized.
To update the Status totals, the graph, and the report table at the bottom of the view to reflect your selected filters, click the orange Search Button in the lower left-hand corner of the Filters pane. You can tell when a filter is active by noting the grey filter icon with the red X.
Depending on the number of filters you selected, it may take a moment for the system to load your view as specified. If you add more filter specifications at this point, they will be in addition to prior filters. To reset filters, click on the Revert Image Removed button at the top Reset Filters button at the lower right below the Search notes or comments field. left above the Filters pane.
Special Circumstances
If the Search button disappears, this means that either your selections do not meet the requirements for search criteria, or your search criteria do not return any records.
Image AddedIf the Search button turns blue, you currently have other filters in place.
Image RemovedImage AddedIf you click the blue Search button, this indicates an acknowledgement that those prior filters will be removed, and your more recent filters applied. Click the blue Search button to acknowledge this update. The button will turn orange again. Click the orange Search button to search using your more recent filter criteria.
Filter Functionality
Drop-Downs
All categories with a drop-down option can use either the check box or search method to locate information. Both methods require clicking the downward-pointing triangle on the right side of the drop-down bar.
Check Box | Search |
---|---|
By default, the view will show the various accounts visible to you based on your UT Tracker login Permissions. Scroll up and down within the account number list to find your specific account number(s). Check the box for the account(s) that you wish to filter your data by and click the Apply button. | To further refine your search, type in the account number of your choice and then place your cursor in the top blank row of the expanded list. Enter the first few characters or digits of the desired search result. For a specific item, enter the entire account number, description, etc. Check the appropriate box and click the Apply button to filter your results by a particular result. |
Check Box Selection | Search Field |
Clearing Filters and Selections
To clear any checkbox filters in your view, click the All option at the top of your options list and click the Apply button. To clear drop-down filters, you can also click the filter icon with the red X to show all values. To clear search field filters in your view, click the X on the right side of the search bar. A grey filter icon shows that all options are selected and that no filters are in place.
Clearing Filters | Clearing Searches |
---|---|
Drop Downs Date Slider, No Filter Date Slider, Filter Active |
|
Include and Exclude
Each of the drop-down and search options have additional functionality to either include or exclude the items selected. Note that the drop-downs will show a filter icon just to the left of the appearing drop-down arrow while search fields will only show the appearing drop-down arrow.
Enable Hover Drop-Down | Select Include/Exclude Option |
---|---|
To enable the include/exclude for search options, hover your cursor over the upper right of the option title. This will enable the Include/Exclude arrow to appear. Click the arrow. For drop-downs, the steps are the same. Note that a filter icon will also appear to the left of the arrow. | When the pop-up menu opens, make your selection. By default, all options select the Include Values option. Note that the Single Values/Multiple Values options will combine with the Include Values/Exclude Values for the Status Letterbill or IDT Menu. |
Search Drop Down: | Search Option View: |
Drop Down View (Not Filtered) | Select Option View: |
Making Selections
Credit or Debit Account
Select from the options that show in your drop-down menu, or search by typing in your account number in the top blank field. Note that account numbers are 10 digits, including dashes, and have trailing descriptions. The dashes (-) in the account number are required in the search function. You must first select a Credit account before the Debit accounts will load for selection.
Drop-Down Check Box | Drop-Down Search |
---|---|
To expand from the drop-down bar, click the triangle pointing down just under the Credit or Debit Account Label. This will show the various accounts visible to you based on your UT Tracker login Permissions. Scroll up and down within the account number list to find your specific account number(s). Check the box for the account(s) that you wish to filter your data by and click the Apply button. To enlarge screenshots, use your document viewer controls to zoom in. | To type in the account number of your choice, click that same triangle and place your cursor in the top blank row of the expanded list. If you are searching for a range of account numbers with the same prefix, you can do a partial search using the first few numbers of the account. For an exact account number, enter the entire account number. Check the appropriate box and click the Apply button to filter your results by a particular account number. |
Checkbox Selection | Search Field |
Status
Definitions:
Completed: Document has been routed forward to AP and final approved and completed in APDefine.
Unpaid: Pending; letter billings/outstanding; processing in DEFINE but Document is pending resolution in Define. Letter Bill payment has not been completedreceived.
Declined: Document has been rejectedBilling was rejected and will not be processed.
Submitted: Document Billing has been submitted into Trefoil but has not been processed into DEFINE. The bill will be processed Tracker and will run through the bill over the weekend.
Select single or multiple values by checking your preferred option to narrow your reporting results.
Status SelectionImage Removed
Report Date
Slides and Fields
To select a specific date range, you can either use the sliders (controls that let you slide a button from side to side to select values) or enter in specific dates.
Slider Date Selection | Start/End Date Field |
---|---|
To use the sliders, click and hold the left slide button to indicate the start date, and then click and hold the right slide button to indicate the end date. | To enter specific dates, select the start or end date shown to highlight the date. You can either type the date directly in this field or select the date using the pop-up calendar. |
Begin Dates | Date Field, Highlighted |
End Dates | Date Field, Contents Deleted |
Calendar Selector
Specific Date | Today |
---|---|
To select a date from the pop-up calendar, use the left arrow to go back by month and the right arrow to go forward by month. When you arrive at your preferred month, select the appropriate day by clicking on the day number. | To select today’s date, click the option at the bottom of the pop-up calendar noted as Today: |
Calendar Navigation | Select Today |
Letter Bill Invoice Number
If you know the Letter Bill number, you can enter it here in the format LBNNNNNN. This will filter to the exact record entered.
Search - Letter Bill |
---|
DEFINE Document ID
This search includes both Letter Bills and IDTs. Make sure you are entering a zero (0) for G0VT documents.
Drop-Down Check Box | Drop-Down Search |
---|---|
Letter Bill or IDT
Filter by IDT, Letter Bill, or both in your search results.
Select IDT/Letter Bill Inclusion |
---|
Department
Select the department that you would like to filter by. Click the down arrow to open the drop-down list, then remove the check from (All). Select your preferred account(s). Note that this search is not case sensitive.
Drop-Down Check Box | Drop-Down Search |
---|---|
General | |
Specific | |
Letter Bill Notes or IDT Comments Search
Search for keywords in the Letter Bill notes and IDT comments.
Search |
---|
Bar Graph Visualization
The bar graph showing in the Reconciliation report is interactive and responds to end user clicks within the filters panel, the bar graph and the report table.
Tooltips
Tooltips are boxes of information that pop up when you hover over particular sections of legends, charts or report tables.
Image RemovedImage Added
To get totals by Status and Month, hover your cursor over the specific status color for a particular month. Doing so will display the tooltip box including the total of all IDTs and Letterbills submitted for that Status and Month.
By Status Group | By Month of Recon Report Date |
Bar Chart Filter
Clicking a particular Status category in the graph legend will highlight the related portions of the bar graph while washing out the remaining statuses. Note that this does not update the report table at the bottom of the view.
Clicking the graph itself in the colored bar sections will highlight that status category in the bar graph and display a tooltip showing that group’s status, the month reported, and the full amount processed. At the same time, this action filters the report table at the bottom of the view to show the corresponding list of reports. To remove these filters, click in the white space of the bar graph to return to the default view.
Image RemovedImage Added
Bar Chart Views
Hover over the lower left-hand corner of the chart between the X and Y axis. This will reveal a minus sign (-) and a plus sign (+). Click the minus sign to zoom in to a narrower range of dates. Click the plus sign to zoom out and see a broader range of dates. During testing, pressing the Revert option in the upper left-hand corner above the Filters Pane resets the page to its default settings. Once embedded in Tracker, this will appear as a Reset button as part of the Filter View.
Narrow View (flipped)
Broader View
Report Table
Sorting
You can sort the data in each column in the report alphabetically, by date, or by amount, depending on the column’s data format. You can sort in ascending order for dates and amounts, and in both ascending and descending order for Department or Status. To sort, hover over your preferred column and the sort all or sort alphabetically icon will appear. By default, items will in order of the Department- Credit Account-StatusDepartment-Debit Account Number-Letterbill or IDT - Status-Submitted Date-Amount.
Alphabetical | Numerical |
Ascending Alphabetical Order
| Ascending Numerical Order
|
Descending Alphabetical Order
| Descending Numerical Order |
You can also hover over your preferred column and a drop-down arrow will appear.
Click this drop-down arrow to activate a pop-up menu with various options. Sort by your chosen column in alphabetical order, data source order, sum total or submitted date.
Sort Alphabetically |
Sort by Data Source |
Sort by Sum Total |
Sort by Nested Submitted Date |
Hiding/Revealing Columns
To hide columns, hover over the column header to the left of the column to be hidden. A minus sign (-) will appear. Click the minus (-) icon to hide allcolumns between the currently selected column and the amount column. To bring the hidden columns back into view, hover over the initial column. A plus (+) sign will appear. Click the plus (+) icon to reveal the adjacent column to the right. Repeat this step for each hidden column until you are back at the default view with all columns visible.
Hide Columns | Reveal Columns |
Hiding Report Table Columns (Video)
Enlarge the window prior to playing
Addendum 21a - Column Remove Sequence.movHiding Report Table Columns.MOV
Revealing Report Table Columns (Video)
Enlarge the window prior to playing
Addendum 21b - Column Add SequenceRevealing Report Table Columns.MOC.mov
Summary Views and Drilldowns
Summary views are available for each column entry field and provide drilldowns or links to additional information about that entry.
Clicking an item in the Department, Credit Account, or Letter Bill ID/Debit Account Number data fields will group items together with the same Credit/Debit account or IDT number, provide, in a pop-up, the total number of items grouped together and a sum of all items.
Grouped by Department
| Grouped by Credit
| Grouped by LB or IDT
|
In cases where items are grouped within the report by department or account, clicking the department or account field will summarize items within that group. These summaries contain the total of items selected, the total amount of all items, and a link to the first UT Tracker entry.
For the Amount column in the report section, you can hover or click the dollar amount to see the pop-up box with the UT Tracker link. Clicking the link takes you to the selected entry in UT Tracker. If you are not logged into UT Tracker when you click the link, you will need to enter your UT EID and password to view the entry.
You can also click the Amount column header to view totals for all amounts in the report. Clicking the amount column will highlight the header and all amount rows in blue and show a pop-up box showing the number of transactions and their combined total.
Exporting Reports
To export a report, review the Crosstab and PDF options below.
Crosstab
Export Crosstab |
---|
Select Preferred Sheet and Format. |
Click Download to save the Excel or CSV file to your computer. |
Export PDF |
---|
Overview |
Select View |
For specific sheets from the dashboard, make additional selections individually or by clicking the Select All button. |
Select Scaling |
Select Page Size |
Select Orientation |
Click Download to open the PDF in a separate browser tab. |
IDT Report
The IDT Report pulls information from the UT Tracker app to search for IDT information using filters and search fields. It is useful for pulling internal account reports, assisting with reconciliation, and downloading data to a spreadsheet file. See below for guidance on how to use these features. Note that descriptions and account numbers have been obscured to protect the privacy of departments.
Overview
Default View
The default view of the report shows the report in the main body with the filter options on the right-hand menu.
Column Headers
The report column headers include the following: Month of Service Date, Description, Submitted User, Day of Processed Date, Credit Account, Debit Account, Status, DEFINE Document Id, DEFINE Code DTN, and Amount.
Functionality
Drop-Downs
All categories with a drop-down option can use either the check box or search method to locate information. Both methods require clicking the downward-pointing triangle on the right side of the drop-down bar.
Check Box | Search |
---|---|
By default, the view will show the various accounts visible to you based on your UT Tracker login Permissions. Scroll up and down within the account number list to find your specific account number(s). Check the box for the account(s) that you wish to filter your data by and click the Apply button. | To further refine your search, type in the account number of your choice and then place your cursor in the top blank row of the expanded list. Enter the first few characters or digits of the desired search result. For a specific item, enter the entire account number, description, etc. Check the appropriate box and click the Apply button to filter your results by a particular result. |
Checkbox Selection | Search Field |
Clearing Selections
In order to clear any checkbox filters in your view, click the filter icon with the red X. To clear search filters in your view, click the Grey X on the right side of the search bar.
Clearing Filters | Clearing Searches |
---|---|
Include and Exclude
For search fields, there is an option to either include or exclude the items selected.
Enable Hover Drop-Down | Select Include/Exclude Option |
---|---|
To enable the include/exclude for search options, hover your mouse/cursor over search section. This will enable the Include/Exclude arrow to appear. Click the arrow. ***For drop-downs, you must first check your selections and apply. Once the filter has been applied to the table, you can then hover over the field and the arrow for the include/exclude will appear. | When the pop-up menu opens, make your selection. By default, all options select the Include Values option. Note that the Single Values/Multiple Values options will combine with the Include Values/Exclude Values for the Status Menu. |
Check Box Option (filtered): | Search Option View: |
Making Selections
Year and Month of Processed Date
Select your Year or Month of Processed Date by checking or unchecking the boxes shown in the drop-down bars. You can alternatively search for specific data by entering a year and month in the blank row just above the check boxes. The options will automatically filter to your search item.
Year Check Box | Month Check Box |
---|---|
Year Search | Month Search |
Credit and Debit Accounts
Select from the options that show in your drop-down menu, or search by typing in your account number in the top blank field. Note that account numbers are 10 digits and do not include dashes. You must first select a Credit account before the Debit accounts will load for selection.
After your Debit account is selected, the data will update in the view at the bottom of the report.
Drop-Down Check Box | Drop-Down Search |
---|---|
To expand from the drop-down bar, click the triangle pointing down just under the Credit or Debit Account Label. This will show the various accounts visible to you based on your UT Tracker login Permissions. Scroll up and down within the account number list to find your specific account number(s). Check the box for the account(s) that you wish to filter your data by and click the Apply button. To enlarge screenshots, use your document viewer controls to zoom in. | To type in the account number of your choice, click that same triangle, and place your cursor in the top blank row of the expanded list. If you are searching for a range of account numbers with the same prefix, you can do a partial search using the first few characters of the account number. For an exact account number, enter the entire account number. Check the appropriate box and click the Apply button to filter your results by a particular account number. |
Credit Check Box | Credit Search |
Debit Check Box | Debit Search |
Status
Definitions:
Completed: Document has been final approved and completed in AP.
Unpaid: Pending; letter billings/outstanding; processing in DEFINE but has not been completed.
Declined: Document has been rejected.
Submitted: Document has been submitted into Trefoil but has not been processed into DEFINE. The bill will be processed over the weekend.
.
Select Single or Multiple | Select All |
---|---|
Submitted User
To select the Submitted User, scroll to view and choose options by checking or unchecking the appropriate boxes. You can also type a specific user ID in the top blank bar to view results.
Select Single or Multiple | Search |
---|---|
Search Description
Enter a description of your choice in the blank field to search and press enter to filter the table.
Search |
---|
Search Document ID
Enter the Document ID of your choice in the blank field to search.
Search |
---|
Search DTN
Enter the DTN of your choice in the blank field to search.
Search |
---|
Downloading Data
To download your current view in spreadsheet format, click the Download Data button.
Make your format selections choosing from csv or excel and click the Download Button.
Download Crosstab |
---|
Download Button Download Crosstab Box |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Page Tree | ||||||
---|---|---|---|---|---|---|
|
Multiexcerpt include macro | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|