Expenses Checklist & Process Steps Guide

Purpose:  Use this document as a reference to assist in the standard Finance processes in chronological order for a specific Module.

Audience:  Finance Staff, Local Security, Travel & Expense Administrators

The following spreadsheet below provides the standard key processes to Travel and Expenses, such as:

Expense Type w/Account numbers, Expense Roles by Nav path, Expense Queries, Checklists for: Initial setup, Budget checking Expense Documents, Canceling EX Payments, Cash Advance Reconciliation, Paying out Expenses, Unposting Expense Reports, and On and Offboarding Employees for Expenses.

Or for better accessibility, use the following drop-down checklist style for the Expense Checklist & Process Steps Guide:

Expense Type List with GL Account Number
Expense Type General Ledger Account Number
Airline in State of Washington 5080020
Airline International 5080060
Airline Outside State of Washington 5080060
Automobile Rental 5080040
Communication Miscellaneous 5081260
Hotel in State of Washington 5080010
Hotel International 5080050
Hotel Outside State of Washington 5080050
Hotel Room Tax (IN STATE) 5080010
Hotel Room Tax (OUT OF STATE) 5080050
Hotels Misc no per diem 5080010
Meal in State of Washington Breakfast 5080010
Meal in State of Washington Dinner
5080010
Meal in State of Washington Lunch
5080010
Meal Outside State of Washington Breakfast
5080050
Meal Outside State of Washington Dinner
5080050
Meal Outside State of Washington Lunch
5080050
Meals International 5080050
Meals no per diem 5080010
Miscellaneous 5080040
Registration 5081102
Supplies 5030010
Transportation Mileage 5080030
Transportation Other 5080040
Transportation Parking 5080040
Transportation Toll 5080040
EX Roles with Access

Please the Expenses Checklist and Process Steps Guide for EX Roles information.

Common EX Queries

Query Name Description
QFS_EX_CA_ALL_STATUS Cash Advances All Status.
QFS_EX_ER_ALL_STATUS Expense Reports All Status.
QFS_EX_TRAVEL_AUTH_ALL_STATUS
Travel Auth All Status.
QFS_EX_CA_NOT_CLOSED Cash Advances Not Closed.
QFS_EX_ER_NOT_CLOSED Expense Reports Not Closed.
QFS_EX_ER_ALL_STATUS_CF Expense Reports All Status with Chartfield Values.
QFS_EX_TRAVEL_AUTH_ALL_STAT_CF Travel Auth All Status with Chartfield Values.
QFS_EX_TRAVEL_AUTH_NOT_CLOSED
Travel Auth Not Closed.
QFS_EX_NOT_CLOSED Expense Reports Not Closed.
QFS_EX_SUPRVSR_EMPL_STATUS
HR Supervisor Listing with the Employee they Supervise.
QFS_EX_NO_DEFAULT_PROFILE This is a NEW Query that you run by BU. It will ONLY display those employees that have an EX profile with your BU (that is NOT Retired, Terminated, Deceased or suspended), AND their default EX profile is set to a DIFFERENT BU. Travel Admins can use this query to help manage 'default' profiles for their employees that have multiple EX profiles. 
QFS_EX_EMPL_TRAV_DEFAULTS_CF EX Profile Default Chartfield Values and 'Default' profile listing. Only employees that have a 'default' profile set to your BU will be included in this Query.
QFS_EX_NO_EMPL_TRAV_DEFAULTS_CF It will display Employees that have a Default profile with your BU, that do NOT have the following chartfield values set in the default profile: Oper Unit, Fund and Class.
QFS_EX_NO_PROFILE_BANK_ACCT EX Profile with no Bank Account.
QFS_EX_STAGE_PYMNT_PRENOTE EX Staged Payment with Banking Prenote Info.
QFS_GL_EX_ACCTG_LINE EX Accounting Line Detail.
QFS_SEC_OPR_EXP_APPRVR Expenses AWE Approver Assignment Report.
QFS_GL_JRNL_ACCT_ANALYSIS_POST Journal GL Acct Analysis Posted.
QFS_SEC_USER_ROLES_BY_UNIT Job,  Company, with Unit Prompt user list with Roles.
BFS_EXPN_RPT Expense Report Detail 'print' query that contains items necessary for auditors.
Initial Setup
Budget Checking EX Documents

Budget Checking can be done either ways - Depending on your set up, budget checking will need to either be done by the first "approver", or before EX documents can be staged for payment OR, must have Travel Authorizations or Expense Reports that have a budget status of "Not Checked" or "Error" to be eligible for budget checking.

Related QRG(s)

EX documents must pass budget checking in order to be eligible to be "staged" for payment.

Budget Checking - Provide a list of the common budget exceptions and corrective actions to take.

Canceling AP Payments

Before canceling any EX payments, run ALL_STATUS query(s) for the transaction type you want to cancel to verify that the profile number used to create the transaction is the current default profile number. If there is a mismatch, the EX transaction will update to a Closed Status and not allow a payment to be reissued. Close Journals will not be create and you will need to submit a SBCTC ticket for assistance in closing journals created.

If you need to modify or close a travel document in 'Paid' status, first you will need to Cancel payment, then you will need to Unstage it. Then it can be Closed. If you need to modify the document, you will need to run the Unpost process after Unstaging it.

Cash Advance Reconciliation
Paying Out Expenses
Unposting & Reposting Expense Reports

Make sure all steps are completed within the same period!

On and Offboarding Employees for Expenses

To view inserted information, select the down facing arrow on the right of the checklist title. 

You are done. Great job!

0 Comments

Add your comment

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