Closing Expense Reports

Purpose:  Use the Expense Reports Close page to mark an expense report for close if it has been approved for payment processing but not staged for payments. Also, the expense report post status is posted.

Audience:  Finance/Expenses.

You must have at least one of these local college managed security roles:

  • ZZ Expenses Processing

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

NOTE:   Closing Expense Reports reverses the liability entries and changes the Status field and Post State to Closed.

If there is a Cash Advance applied to the Expense Report you want to Close, you need to remove the Cash Advance (if it will be used on another Expense Report), otherwise, the Cash Advance will be ‘Reconciled’ and entries reversed as part of the Close Expense Report Process. Use the Modify Approved Transactions page to remove the CA from the ER. In order to access the ER from Modify Approved Transactions, it needs to be Unposted. Once the Cash Advance is removed, it will need to be Posted again, to be eligible to be Closed.

Mark Expense Report

Navigation: Travel and Expenses > Process Expenses > Close Expenses > Mark Expense Report for Close

  1. The Mark Expense Report for Close search page displays.  Enter the Report ID or use the "Search by:" criteria to help identify the expense Report ID:
    • Creation Date.
    • Empl ID.
    • Name.
    • Report Description.
    • Report ID.
    • Report Status.
  2. Select the Search button.
  3. The Mark Expense Report for Close page displays.
  4. Select a Reversal Date radio button:
    • Use Current Date (default).
    • Use Specific Date.
  5. If the Expense Report is dated in a closed period, select the checkboxes Override Expense Budget Date and Override Expense Accounting Date to create the Reversals in the current open period.
  6. Select the Close button to close the Expense Report.

You can use the Close Expense Report page to modify the reversal date and verify that the expense report is to be closed.

Mark Expense Report for Close page
  1. The Close Expense Report confirmation page displays. Adjust the Reversal Date if needed.
  2. Select OK to close the confirmation page. To process an expense report that is marked for closing, use the Expense Processes page.
  • After you confirm your selection, the system marks the expense report for closing.
  • Notice that the Close button is no longer available.
Expense Processing

Navigation: Travel and Expenses > Process Expenses > Expense Processing

  1. The Expense Transactions search page displays. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA020_CLOSE_EXPENSES (Business Unit, Process).
  2. The Expense Processes tab displays. You may need to add/verify your college on the Selected Business Units tab page.
  • If the Run Control ID is new, select the Save button and then select the Refresh button to update the transaction counts.
  • If you are using an existing Run Control ID, the transaction counts will update automatically.
  1. Select the Close Liability option.  (When you select the Close Liability option and run the Application Engine process, the system reverses the liability entries for expense reports that are marked for closing and changes the status to "Closed"). Select the Save Button.
  2. Select Refresh.
  3. Select Run.
Expense Processing page
  1. The Process Scheduler Request page displays. Select OK to run the Expense Transaction Processing process (EX_TRAN_PRCS).
  2. The Process Scheduler Request page disappears and the updated Expense Processes tab displays.
  3. Note the Process Instance number. Select Process Monitor. Refer to the QRG Process Scheduler/Process Monitor for instructions.
Select Process Monitor link

Video Tutorial

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial Via Panopto

View the external link to Closing Expense Reports. This link will open in a new tab/window.

You MUST complete the following steps in order to relieve commitment control Expense Accrual Entries.

Reverse Commitment Control Entries

Navigation: Travel and Expenses > Manage Accounting > Request Budget Checking

  1. The Budget Check Transactions run control ID search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA010_CANCEL_ERS (College, Process).

A Run Control ID is an identifier that, when paired with your User ID, uniquely identifies the process you are running. The Run Control ID defines parameters that are used when a process is run. This ensures that when a process runs in the background, the system does not prompt you for additional values.

You can run this process by searching for an existing Run Control ID or you can add a new value. Creating a Run Control ID that is relevant to the process may help you remember it for future use.

Use different Run Control IDs for the budget checking processes such as Budget Check Request, Cancel Travel Authorization, and Rollover Travel Authorizations. You must use a unique run control ID for each of these processes.

  1. The Request Budget Check page displays. Use it to run the budget checking process for Cancelled Expense Reports.
  2. Enter or lookup the Business Unit.
  3. Enter a Description.
  4. Select Cancel Void Expense Reports from the Transaction Type drop down menu.
  5. Select the View Transaction Details link.
Request Budget Check process parameters page
  1. The Transaction Details tab displays.  
  2. The Select Option field defaults to "Some". Update to "All" as needed.

Use the Select Option list to determine what transactions will be selected for processing. The following options are provided:

  • "All": Every eligible transaction will be selected for Budget Checking. The Date From and Date To fields will be 'grayed' out.
  • "Some": Enables the use of the Transaction section to select the specific transactions that you want to be budget-checked. Use the Date To and Date From fields to refine the Transaction section list and use the Transaction, Budget, and Dates tabs to display different information related to the listed transactions. Use the Select column to mark the transactions that should be budget-checked.
  1. If the Select Option = Some, optional to select the check box next to individual transaction(s) for the Budget Check process.
  2. Select the Run button. Please refer to the Process Schedule Request steps for further instructions. Or for additional information, see the QRG Process Scheduler/Process Monitor.
Transaction details tab page
  1. When the Process Monitor shows the Run Status = "Success" and Distribution Status = "Posted", the batch budget-checking process has finished successfully.  
  2. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.