This report provides a full list of all agency and travel card charges that remain unreconciled through an Expense Report in Concur. These outstanding charges represent expenses for both completed and uncompleted trips, including future and canceled travel. The report is used to help identify outstanding charges that require action to reconcile the expense in Concur and charge the operating account in Banner.

We recommend only using this report to identify card charges that are unassigned to an Expense Report. Once they are assigned to a Report, use the "Unsubmitted Expense Reports" report to manage expenses that are ready for reconciliation. It is easier to differentiate between completed, canceled and future travel expenses once they are assigned to a Report.

---

Start by filtering sheet three “Traveler Detail” by card charges with an Approval Status of "unassigned." From there, work through the charges and assign them to their associated Report.

Future Trip Charges

These are charges from a trip still scheduled but not yet completed. Work with the traveler to create an Expense Report for the trip and assign the charges now. This will help with managing expenses during and after travel.

Completed Trip & Other Charges

These are charges that need action now. This includes charges from completed trips and non-travel charges. These require a submitted Expense Report to reconcile the expense in Concur and charge the operating account in Banner.

Work with the traveler to complete their Report with all associated travel expenses and instruct them to submit ASAP.

Note: For non-travel expenses, follow the instructions under “Travel Card Used for Non-Travel Expenses” on the UA Travel website.

Canceled Trip Charges

These are charges from a canceled trip that need reconciliation now unless a credit for the expense remains. This includes fully refunded charges (charge and refund are included on the Expense Report), sunk costs (e.g. non-refundable lodging deposits), agent fees from the original booking and/or reservation cancellations and airfare expenses for which the ticket credit is expired.

Charges that resulted in a credit for future use (e.g. registration for a postponed conference) follow the same process as airfare expenses associated with unused ticket credits.

1. If no credit remains for the charge, instruct the traveler to submit the Report to reconcile the expense in Concur and charge the operating account in Banner (this includes agent fees associated with a cancellation)
2. If a credit remains for the charge, assign the expense to a “Dummy ER” for holding until credit is used
   (Remember: Set the "Business Travel End Date" in the Report Header as the date of expiration on the credit)

This report provides a list of open Travel Requests that have an approved Expense Report (ER). The information is organized by the funding string in the Request Header.

Unless the traveler has additional university expenses to report for the trip, the Request needs to be closed/inactivated. This will remove the Request from the open travel reports. This is a general housekeeping report that we recommend completing on a weekly basis.

This report is used for projecting travel costs. The data on this list is either from the Request or from the Expense Report for a given trip prior to posting to Banner.

The data source is from a Travel Request after the Request has been submitted until a related Expense Report has been submitted. At that point the data source reflects Expense report data until a Report has been approved for payment. It’s important to note that Requests that have not been submitted and Requests that have been canceled or closed will not be listed.

The information is organized by the funding string allocated to an expense (not the default funding for the traveler). Departments can use this information for budgeting projected travel spend and tracking travel that needs action in Concur (e.g. Requests pending online booking, expense reports pending approval and payment).

1. On sheet one “Summary,” select the desired funding from the “Fund-Org” column which drills down to the associated “Individual Detail” sheet
   Or
   On sheet two “Individual Detail,” filter the list by another category such as D-level, department or fund/org
2. Identify Requests or Reports with a “Business Travel End Date” after today’s date
3. Work with the traveler to resolve the open Request
1. Complete and submit a Report for associated trip expenses
2. Close/inactive the Request if no Report is needed

NOTE: If an expense report is returned, the data on the report will revert back to the anticipated amount approved on the Travel Request.

This report provides a list of open Expense Reports that are not pending payment approval. The list includes Reports for upcoming, completed and canceled travel (e.g. holding an airfare expense with an unused ticket credit).

1. Identify Reports with a “Business Travel End Date” after today’s date
2. Work with the traveler to complete and submit the Report for processing

Note: Reports with an Approval Status of “Sent Back to User” should contain a comment from the approver regarding corrections needed. Work with the traveler to resolve the requested changes (or do so on their behalf) before they resubmit.

This report provides a full list of unused ticket credits still available. The information is sent to us by CTM on the first business day of every month. Therefore, the report only includes information as of the last day of the previous month.

The department should use this report to track ticket credits and ensure they are used before their expiration date.

The report is split into three sheets:

1. Unused Tickets_Trvr in Concur – List of credits belonging to a traveler profiled in Concur
2. Unused Tckts_Trvr Not in Concur –List of credits belonging to a traveler not profiled in Concur and includes the name of the traveler on whose Concur account the associated expense is found
3. Unused Tickets – List of all credits regardless of traveler’s profile status in Concur

Travel Projected Spend  (FAR2TPS)

• Source: The FAR2TPS table is populated from a Concur report updated daily at 3:30 AM in the Production database.
• RPTP Update Schedule: FAR2TPS is refreshed in the RPTP on-premises database between 4 AM and 6 AM, ensuring the latest projections from Concur in both PROD and RPTP.
• Data Origin:
  • Requests: Initially, trip data comes from any submitted Request.
  • Expense Reports: Once a Request is linked to a submitted Expense Report, the data reflects the Expense Report.
  • Approval: After final approval of the Expense Report, the data is removed from FAR2TPS and posted as a year-to-date expense in Banner with a Concur JV (starting with CJ).
  • Cancellations/Closures: Cancelled or closed Requests will remove the trip data from FAR2TPS.
  • New Expense Reports: If a new Expense Report is submitted for a previously associated Request, the new data will be available in FAR2TPS.
  • Note: All links download a TSM file.

Travel Projected Spend Summary - similar to FGIBDST

Travel Projected Spend Summary - similar to FRIGITD 

Travel Projected Spend Detail