9.2 Performing T&E Expense Processing

Purpose:  Use this document as a reference for performing any of nine different travel and expense processes from the same ctcLink process scheduling page.

Audience:  Travel and Expense staff

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.

Use the Expense Processing page to run the jobs described in this QRG. Transaction Processes and Accounting Processes run in parallel as documents move through their life-cycles in T&E. The table below provides a brief description of each job. The table is also organized into jobs intended to be run before payments are picked up and processed in Accounts Payable and after payments are processed in Accounts Payable. 

Expense Process Descriptions

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

BEFORE payments are picked up and processed in Accounts Payable:

TRANSACTION PROCESSES ACCOUNTING PROCESSES
Stage Payments
This process is run after a Cash Advance or Expense Report is fully approved (and budget checked if applicable) to make the payment eligible to be picked up by an AP Pay Cycle.
Post Liabilities
 This process is run after a Cash Advance or Expense Report is fully approved (and budget checked if applicable) to create the accrual accounting entries that establish the payment liability for the CA or ER.
Unstage Payments
This process is run after a payment is staged but before it has been picked up by an AP Pay Cycle to make that payment ineligible to be processed by AP.

AFTER payments are processed in Accounts Payable

TRANSACTION PROCESSES ACCOUNTING PROCESSES
Update Paid Status
This process is run after a payment has been selected, created and paid through AP to mark the payment at "Paid" in T& E tables.
Post Payment
This process is run after a payment has been selected, created and paid through AP to create the payment accounting entries that relieve the liability created by the Post Liabilities process.
Cancel Payments
This process is run after a payment that has been paid in AP is canceled in AP. Depending on how the payment is canceled in AP, this process will return the payment to a Staged status so it can be corrected and/or reprocessed in AP or terminate the payment and not allow it to be reprocessed.
Close Liability
This process is run after a transaction has been marked for close in T&E. Transactions need to be marked for close if they have been paid though AP and the payment is canceled in AP AFTER the Post Payment processes has been run. If the Post Payment process has not been run before a payment is canceled, the Close Liability process does not apply.
Advance Reconciliation
This process is run after a Cash Advance has been reconciled via an Expense Report or through a manual reconciliation entry in T&E to mark those advances as “Reconciled” in T&E tables.

Updating Advance Reconciliation Status

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have completed the AP Pay Cycle Payment Creation step for one or more Expense Reports that had a Cash Advance applied to them.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Advance Reconciliation: Select to update expense tables to indicate that cash advances are reconciled against corresponding expense reports.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Posting Liabilities

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have created and fully approved one or more Expense Reports and/or Cash Advances.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Post Liabilities: Select to create rows in the EX_ACCTG_LINE table for the journal generator to send to PeopleSoft General Ledger to post liabilities. The Post Liabilities process generates accounting entries for expense reports, cash advances, and reconciled cash advances.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Unposting Expense Reports

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have successfully marked an Expense Report for Unposting.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Unpost Expense Report: Select to reverse accounting liability entries for expense reports that are marked for unposting. You can edit and resubmit unposted expense reports.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Closing Expense Liabilities

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Close Liability: Select to reverse Liability entries for cash advances and expense reports that are marked for closure.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Staging Expense Payments

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have created and fully approved one or more Expense Reports and/or Cash Advances that have an amount due to the Traveler.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Stage Payments: Select to move expense transaction data into staging tables for Payables processing.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Updating Expense Transaction Paid Status

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have completed the AP Pay Cycle Payment Creation step for one or more Expense Reports and/or Cash Advances.

The update paid status may go to zero after running the Post Payment Expense process. This is a known issue and was a change by Oracle. We still recommend periodically running the update paid status process to verify all items are cleared.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Update Paid Statuses: Select to change the Status of cash advances or expense reports to Paid. Run this process to mark transactions as Paid prior to posting Payments without generating accounting lines.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Posting Expense Payments

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES:  Must have completed the AP Pay Cycle Payment Creation step for one or more Expense Report and/or Cash Advance payments.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Post Payments: Select to create rows in the EX_ACCTG_LINE table for the journal generator to send to PeopleSoft General Ledger to post payments.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Unstaging Expense Payments

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

PREREQUISITES: Must have one or more Expense Report and/or Cash Advance payments successfully staged.

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Unstage Payments: Select to move expense transaction data out of staging tables that have not been selected by the Payables system.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Section complete.
Canceling Expense Payments

Navigation:  NavBar > Navigator > Travel and Expenses > Process Expenses > Expense Processing

  1. The Expense Transactions run control ID search page displays.
  2. Select the Add a New Value tab.
  3. Enter Run Control ID.
  4. Select Add.
Expense Transactions Add a New Value tab
  1. The Expense Processes tab displays.
  2. Select the Selected Business Units tab.
Expense Processes tab
  1. The Selected Business Units tab displays.
  2. Enter Business Unit.
  3. Select the Expense Processes tab.
Selected Business Units tab
  1. The Expense Processes tab displays.
  2. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
  3. Under the Process Request Parameters, select the boxes next to the Expense processes you want to run when the Run Control is executed.  Select the following processes for this process:
    1. Cancel Payments: Select to reverse accounting entries for payments that you canceled in PeopleSoft Payables.
  4. Select Run.  Please refer to the Process Scheduling QRG for further instructions.
Expense Processes tab
  1. After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
Expense Processes tab
  1. Process complete.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

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