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.
Navigation: 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. |
Navigation: 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.
- The Expense Transactions run control ID 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., WA010_UPDATING_ADV_RECON_STATUS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- Advance Reconciliation: Select to update expense tables to indicate that cash advances are reconciled against corresponding expense reports.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: Travel and Expenses > Process Expenses > Expense Processing
PREREQUISITES: Must have created and fully approved one or more Expense Reports and/or Cash Advances.
- The Expense Transactions run control ID 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., WA010_POSTING_LIABILITIES (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- 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.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: Travel and Expenses > Process Expenses > Expense Processing
PREREQUISITES: Must have successfully marked an Expense Report for Unposting.
- The Expense Transactions run control ID 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., WA010_UNPOSTING_EX_REPORTS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- 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.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: Travel and Expenses > Process Expenses > Expense Processing
- The Expense Transactions run control ID 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., WA010_CLOSING_EX_LIABILITIES (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- Close Liability: Select to reverse Liability entries for cash advances and expense reports that are marked for closure.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: 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.
- The Expense Transactions run control ID 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., WA010_STAGING_EX_PMTS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- Stage Payments: Select to move expense transaction data into staging tables for Payables processing.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: 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.
- The Expense Transactions run control ID 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., WA010_UPDATING_EX_TRANS_PAID_STATUS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- 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.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: 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.
- The Expense Transactions run control ID 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., WA010_POSTING_EX_PMTS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- 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.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: Travel and Expenses > Process Expenses > Expense Processing
PREREQUISITES: Must have one or more Expense Report and/or Cash Advance payments successfully staged.
- The Expense Transactions run control ID 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., WA010_UNSTAGING_EX_PMTS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- Unstage Payments: Select to move expense transaction data out of staging tables that have not been selected by the Payables system.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Section complete.
Navigation: Travel and Expenses > Process Expenses > Expense Processing
- The Expense Transactions run control ID 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., WA010_CANCEL_EXP_PMTS (College, Process).
- The Expense Processes tab displays.
- Select the Selected Business Units tab.
- The Selected Business Units tab displays. Enter Business Unit.
- Select the Expense Processes tab.
- The Expense Processes tab displays. If the Run Control ID is new, select Save, then select Refresh to update the transaction counts.
- 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:
- Cancel Payments: Select to reverse accounting entries for payments that you canceled in PeopleSoft Payables.
- Select Run. Please refer to the Process Scheduling QRG for further instructions.
- After the Process Monitor shows a Run Status = "Success" and a Distribution Status = "Posted", select Refresh to update your transaction record counts.
- Process complete.
0 Comments
Add your comment