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:

Expand or collapse content Expense Type List with GL Account Number
Expense TypeGeneral Ledger Account Number
Hawaii Airline5080060
Hawaii Hotel Misc5080050
Hawaii Hotel OverPerDiem5080050
Hawaii Hotel Per Diem5080050
Hawaii Hotel Tax5080050
Hawaii Meal Breakfast5080050
Hawaii Meal Dinner5080050
Hawaii Meal Lunch5080050
In State Airline5080020
In State Hotel Misc5080010
In State Hotel OverPerDiem5080010
In State Hotel Per Diem5080010
In State Hotel Stu Group5080010
In State Hotel Tax5080010
In State Meal Breakfast5080010
In State Meal Dinner5080010
In State Meal Lunch5080010
In State Meals Stu Group5080010
International Airline5080060
International Hotel5080050
International Meals5080050
Miscellaneous Communication5081260
Miscellaneous Travel5080040
Out of State Airline5080060
Out of State Hotel Misc5080050
Out of State Hotel OverPerDiem5080050
Out of State Hotel Per Diem5080050
Out of State Hotel Stu Group5080050
Out of State Hotel Tax5080050
Meal Outside State Meal Breakfast5080050
Out of State Meal Dinner5080050
Out of State Meal Lunch5080050
Out of State Meals Stu Group5080050
Registration5081102
Supplies5030010
Transportation Auto Rental5080040
Transportation Mileage5080030
Transportation Other5080040
Transportation Parking5080040
Transportation Toll5080040
Expand or collapse content EX Roles with Access

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

Expand or collapse content Common EX Queries
Query NameDescription
QFS_EX_CA_ALL_STATUSCash Advances All Status.
QFS_EX_ER_ALL_STATUSExpense Reports All Status.
QFS_EX_TRAVEL_AUTH_ALL_STATUSTravel Auth All Status.
QFS_EX_CA_NOT_CLOSEDCash Advances Not Closed.
QFS_EX_ER_NOT_CLOSEDExpense Reports Not Closed.
QFS_EX_ER_ALL_STATUS_CFExpense Reports All Status with Chartfield Values.
QFS_EX_TRAVEL_AUTH_ALL_STAT_CFTravel Auth All Status with Chartfield Values.
QFS_EX_TRAVEL_AUTH_NOT_CLOSEDTravel Auth Not Closed.
QFS_EX_NOT_CLOSEDExpense Reports Not Closed.
QFS_EX_SUPRVSR_EMPL_STATUSHR Supervisor Listing with the Employee they Supervise.
QFS_EX_NO_DEFAULT_PROFILEThis 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_CFEX Profile Default Chartfield Values, Default Banking and 'Default' profile listing. Only employees that have a 'default' profile set to your BU will be included in this Query. Security Role ZD_DS_QRY_ACCTPAY_HIGHSENS or ZD_DS_QRY_EXPENSES_HIGHSENS is required. 
QFS_EX_NO_EMPL_TRAV_DEFAULTS_CFDisplays 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_ACCTEX Profile with no Bank Account.
QFS_EX_STAGE_PYMNT_PRENOTEEX Staged Payment with Banking Prenote Info.
QFS_GL_EX_ACCTG_LINEEX Accounting Line Detail.
QFS_SEC_OPR_EXP_APPRVRExpenses AWE Approver Assignment Report.
QFS_GL_JRNL_ACCT_ANALYSIS_POSTJournal GL Acct Analysis Posted.
QFS_SEC_USER_ROLES_BY_UNITJob,  Company, with Unit Prompt user list with Roles.
QFS_EX_TRANS_IN_PROCESSExpenses Transactions in Process. Running the Expenses Transactions in Process Query QRG.
BFS_EXPN_RPTExpense Report Detail 'print' query that contains items necessary for auditors.
Expand or collapse content Initial Setup
Expand or collapse content 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.

Expand or collapse content Canceling EX 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.

Expand or collapse content Cash Advance Reconciliation
Expand or collapse content Paying Out Expenses
Expand or collapse content Unposting & Reposting Expense Reports

Make sure all steps are completed within the same period!

Expand or collapse content 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.