This chapter provides an overview of how to prepare expense reports, lists common elements, and discusses how to:
Create expense reports.
Enter expense report information and transaction lines.
Copy or add expense lines.
View or modify accounting information.
Apply cash advances to expense reports.
Correct expense report transaction line errors.
Split receipts on expense reports.
Itemize hotel bills using Hotel Wizard.
View and modify expense reports.
Delete expense reports.
Manage My Wallet transactions.
Expenses makes it easy to transform a handful of receipts into a final expense reimbursement. This chapter discusses how to convert expense transactions into expense reports that meet your auditing standards, approval policies, and tax reporting requirements. Expenses supports a variety of features designed to streamline your entry from defaults to importing credit card transactions. The way in which you set up your expense system determines what data is required and how your accounting system processes it. For example, if an employee takes a business trip that different departments within your organization fund, the expense report can reflect this so that the appropriate departments share the expenses.
Expenses provides functionality to decrease the time that you spend entering expense reports. You can:
Create expense reports populated with information from user defaults.
Populate information from My Wallet to expense reports.
Apply cash advances to expense reports.
Copy multiple expense lines at one time on an expense report.
Insert multiple rows at one time on the Expense Report Entry page.
Save an expense report with errors or missing information.
Status |
Depending on your organization's approval and audit policies, Expenses may assign these values to expense report transactions:
|
This section provides an overview of expense report creation options and discusses how to create expense reports.
When you create an expense report, you have several options on which to base the new document, and the selection that you make triggers other choices that prompt you for details about the report. You can start with a blank expense report or populate one with data from another source.
Page Name |
Object Name |
Navigation |
Usage |
EX_SHEET_ENTRY |
|
Create expense reports. |
|
TE_POP_SHT_FROM_TA |
|
Create new expense reports that contain information from approved travel authorizations, and modify the data. |
|
TE_COPY_SHEET |
|
Create new expense reports that contain similar information as existing ones, and modify the data as necessary. |
|
TE_TEMPLATE_SELECT |
|
Select a template from which to create new expense reports. |
|
TE_TEMPLATE2 |
Select a template on the Select a Template page. |
Select expense types to populate expense reports. |
There are two navigation paths used to access the expense report entry pages. The navigation through Employee Self-Service incorporates special security for authorized users, whereas the navigation through the main Travel and Expense menu uses standard permission list security and may be used for centralized or delegated entry of expense reports. When you use the Employee Self Service, Travel and Expense Center, Expense Reports, Create navigation, Expenses checks for a default creation method. Depending on what your default creation method is set to on the Employee Profile - User Defaults page, Expenses displays the next page based on the user defaults and prepopulates fields according to user defaults. The creation methods are:
Open a Blank Report: Expenses displays the Expense Report Entry page.
Copy From a Travel Auth. (copy from a travel authorization): Expenses displays the Populate From A Travel Authorization page.
Select a date range to display approved travel authorizations from a specified period.
Click Search.
Expenses displays travel authorizations for the dates that you specified.
(Optional) Click the link in the Travel Auth Description (travel authorization description) column to access the View Selected Travel Authorization page and view travel authorization details to decide whether to use the travel authorization as the basis for a new expense report.
Click Select to select the travel authorization to use as a basis for the expense report.
Expenses displays the Expense Report Entry page and populates the fields with data from the travel authorization that you copied from.
Copy an Existing Report: Expenses displays the Copy From an Existing Report page.
Select a date range to display expense reports from a specified period.
Click Search.
Expenses displays expense reports for the dates that you specified.
(Optional) Click the link in the Report ID column to access the View Selected Expense Report page and view an expense report before selecting it.
Click Select to select the expense report to use as a basis for the new expense report.
After you select an expense report to copy, the Expense Report Entry page appears. You must then update the relevant information, such as the transaction date, amount, and so on.
Copy From a Template: Expenses displays the Select a Template page.
Select a template to use for the expense report.
After you select a template, Expenses displays the Add Expenses to Report page.
Select a date range for the expense report.
Select One Day for Expenses to add one transaction line of the expense type to the expense report. The transaction date for the line will be the From date.
Select All Days for Expenses to add one expense transaction line for each day in the date range for that particular expense type.
Click OK when you have finished entering a date range and selecting expense types.
Expenses displays the Expense Report Entry page and populates rows with expense transaction lines that the system created for the dates that you specified. You can then continue completing the remaining information for the expense types.
This section provides an overview of expense report entry and discusses how to:
Prepare expense reports.
Enter expense lines (occasional user).
The Expense Report Entry page enables you to easily add expense lines and provide general information as well as other details that are specific for expense types. You may use the Employee Profile to set up default values for location, purpose, description, payment method, and distributions. These defaults are used to populate the expense report automatically when the expense report is initially created, but you may override these defaults during entry. Expense transactions may be directly entered or may be imported into your expense report from My Wallet if your organization is using a credit card feed or if you are using mobile Time and Expenses. Expense transactions that are uploaded to the online system from a personal digital assistance (PDA) will show up in My Wallet ready for use in an expense report.
Expenses also enables you to choose an expense report entry method: Frequent User or Occasional User. Employees and system administrators use the Employee Profile - User Defaults page or system administrators use the Installation Options - Expenses page to choose the entry method. The expense report entry method determines how Expenses displays the Details grid on the Expense Report Entry page. Frequent users navigate from left to right on an expense transaction line within the Details grid; however, after entering general information about an expense type, the occasional user clicks the *Detail link to access the Expense Detail for [expense type] page and enter additional information for the expense transaction.
Note. Expenses uses the entry method (frequent user or occasional user) that is designated for the person who prepares the expense report; however, Expenses uses all other employee user defaults for whom the report is created. For example, if Employee A prepares an expense report for Employee B, Expenses uses the entry method that is designated for Employee A and uses all the other user defaults (such as expense type and project defaults) that are set up for Employee B.
Report Information
The General Information section on the Expense Report Entry page defines general information about the expenses incurred for the report. Expenses populates most of these fields with information that you set up on the employee's user defaults page. This section appears the same for the occasional user and the frequent user.
|
Click the Missing or invalid information was found button to access the Expense Detail for [expense type] page and view and correct missing or invalid information pertaining to the expense transaction line. This button appears only after you check for errors and a transaction line contains missing or invalid information. |
|
Click to view or modify comments for the expense transaction:
|
|
Click the View Additional Fields For This Expense button to access the next field that is applicable for the expense type. This button appears if the expense transaction default entry method is set to Frequent User and is repeated on each tab in the Details grid. This button does not appear in the Details grid if the expense transaction default entry method is set to Occasional User. |
|
Click the Add Multiple New Rows button to insert one or more blank lines into the Details grid. |
Page Name |
Object Name |
Navigation |
Usage |
EX_SHEET_ENTRY |
|
Create expense reports. |
|
EX_SHEET_ERRORS |
Click the Detail link on the Expense Report Entry page. |
Enter details about the expense type. Note. This link is available only if the expense entry type is set to Occasional User on either the Installation Options - Expenses or User Profile - User Defaults page. |
|
TE_SHEET_ATT |
Click the Add Additional Attendees button on the Expense Report Entry page on the Overview tab. |
Add, view, or modify attendees for the expense transaction. |
|
EX_NORCPT_COMMENT |
Click the No Receipt Comment button on the Expense Report Entry page on the Detail tab. |
Add, view, or modify comments about why a receipt for an expense is not included with the expense report. |
|
EX_SH_PRFMRCH_CMNT |
Click the Non-Preferred Merchant Comment button on the Expense Report Entry page on the Merchant tab. |
Add, view, or modify comments about why a preferred merchant was not used. |
|
TE_CC_LOOKUP |
Click the Credit Card Selection button on the Expense Report Entry page on the Detail tab. |
Select a credit card to use for the expense item. |
|
Exchange Rate Detail |
EXCH_RT_DTL |
Click the Rate Detail button on the Expense Report Entry page on the Currency tab. |
View the exchange rate information that the system used for an expense. |
TE_PROJ_SUMMARY |
Select Expense Report Project Summary from the More Options drop-down list box on the Expense Report Entry page. |
View summary of expense line items. |
Access the Expense Report Entry page.
User Defaults |
Select to access the Employee Profile - User Defaults page to view or edit your defaults or preferences. |
Quick Start |
Select from these values:
Note. Expenses hides the Quick Start field after you select a creation method or enter your first expense type in the Details grid. |
Description |
Enter a description to identify the expense report. |
Comment |
Enter additional information about the expense report. |
Business Purpose |
Select a purpose from a predefined list that was created when you implemented the expense system. Because tax laws require a business purpose for business expenses, this field is required. |
Reference |
Enter characters for tracking or identification. |
Default Location |
Enter a city, country, or geographical area where the expenses were generally incurred (which you establish during system setup). This location appears on each expense line where applicable, and you can change it throughout the expense report entry process. If you change the default location, Expenses applies the new location to newly added expenses; the change does not impact existing expense lines. Note. If value-added tax (VAT) is enabled, you must enter a default location so that Expenses can determine the VAT treatment. |
Authorization ID |
Displays the travel authorization number with which you created the expense report. Click the link to access the Travel Authorization Details page to view information about the travel authorization. |
Accounting Defaults |
Click to access the Accounting Defaults page and view or modify the default accounting ChartFields and the distribution split. The default accounting is implemented at the expense report level, and each expense that you add to the report inherits it. Note. The Accounting Defaults link is not available through the Employee Self-Service navigation if the Accounting Display option for the business unit or the employee's role is set to Hide. Employees cannot edit the distribution or ChartFields if this option is set to Display Only. |
Apply Cash Advance(s) |
Click to access the Apply Cash Advance(s) page and select and apply part or all of a cash advance to the expense report. |
More Options: |
Options are:
|
Details - Overview Tab
The elements on this tab are similar for both frequent users and occasional users.
Details - Detail Tab
Location |
Select the location where you incurred the expense. Expenses prepopulates this field if you enter a default location in the General Information group box or if you enter a previous line with a location. |
Originating Location |
Select the location (which you establish during system setup) from where you began your business travel. Expenses prepopulates this field if you enter an originating location on the Employee Profile - User Defaults page. |
Ticket Number |
Enter the unique airline ticket number. Expenses verifies that the ticket number is unique and prompts you (when you check for errors) if it detects that the ticket number has previously been used. |
Nbr of Nights (number of nights) |
Enter the number of nights that the expense covers. |
|
Click the Itemize Hotel Bill button to access the Itemize Hotel Bill page and itemize the hotel receipt into more specific charges, such as room and telephone charges. Once itemized, Expenses populates the main expense grid with each itemized charge. You may itemize the entire bill or only part of it if some expenses are non-reimbursable. Expenses supports the ability to itemize lodgings with different room rates. |
Transportation ID |
Select a transportation ID. This field is active if the distance rate for expense type Auto Mileage is Varied. This field does not appear if the distance rate for expense type Auto Mileage is Standard. |
Rate |
Displays the rate that it uses to calculate the reimbursement for the distance traveled. |
|
Click the Calculate Mileage Rate button to automatically calculate the mileage reimbursement amount. Expenses displays this button only when variable rates apply. |
Passengers |
Enter the number of passengers in the automobile. |
Originating Location |
Enter the originating location. |
Per Diem Range |
Select a per diem range that defines the number of days at a specific location. Expenses uses this information for per diem calculations. Expenses looks at the employee's base country to determine whether to display the Per Diem Range field or the Start Time and End Time fields. |
Start Time and End Time |
Enter the start and end time for the day. Expenses looks at the employee's base country to determine whether to display the Per Diem Range field or the Start Time and End Time fields. |
Amount Spent |
Displays the calculated per diem amount based on the location and other per diem setup rules. You can override the Amount Spent field if you are authorized to do so. |
Currency |
Displays the employee's base currency. |
|
Click the Refresh Per Diem Amounts button to calculate the amount. |
|
Click the Per Diem Deductions button to access the Per Diem Deductions page and deduct qualified expense types from the per diem amount. |
The VAT tab and corresponding fields appear only if you enable the Record Foreign VAT option on the VAT Options page or if the employee's business unit is associated with a VAT entity.
Calculated VAT (calculated value-added tax) |
Expenses displays the calculated VAT unless the option has been set to hide for your organization. |
|
Click the Calculate VAT button to have Expenses calculate the VAT. |
Override VAT (override value-added tax) |
Select to override the calculated VAT. |
No VAT Receipt (no value-added tax receipt) |
Select if the employee did not submit a receipt for a VAT expense item that requires a receipt. You can set up approval and audit rules so that expenses with VAT but without receipts require approval and auditing because in many countries you cannot claim tax credits for the VAT without a receipt. When you select this option, Expenses sets the recovery percentage and rebate amount fields to zero. |
|
Click the VAT Information button to access the VAT Information page for the expense item. |
See Processing Value Added Tax (VAT) Transactions in Expenses.
Exchange Rate |
If the currency code for the transaction amount differs from the base currency of the employee's business unit, Expenses populates this field with the current market rate that is defined in the system rate tables. You can override the system-supplied exchange rate. |
Dflt (default) |
Indicates if system rate exchange tables or user-defined exchange rates are being used. If selected, Expenses is using the current market exchange rate that is defined in the system rate tables. If not selected, Expenses is using a user-defined exchange rate. |
|
Click the Reset Rate button to change a user-defined exchange rate to the system-defined exchange rate. |
|
Click the Rate Detail button to access the Exchange Rate Detail page and view the exchange rate information that the system used. |
Reimburse Amt (reimbursement amount) |
Displays the amount in the employee's base currency, which may be reimbursed to the employee. |
Copy Selected |
Click to access the Expense Report - Copy Selected Expenses page to enter details about copying expense lines that you selected in the Enter Expense Lines grid. |
Delete Selected |
Click to delete expense lines that you selected in the Enter Expense Lines grid. |
Add: |
Select Expenses from My Wallet... to access the My Wallet page and select expense transactions to add to the expense report. Select Multiple Expenses... to access the Add Multiple Expenses page and select several expense types to add to the expense report. Select New Expense and add one blank line to the Details grid. You may then select the expense type on the line. |
Check For Errors |
Click to check the expense transaction lines for missing or invalid information. Lines flagged with errors display an error icon. You can click the icon to go to the Expense Report - Expense Detail for [expense type] page, which displays all the errors associated with the expense line. |
Totals
Update Totals |
Click to refresh your report totals. |
Save For Later |
Save the expense report without submitting it for approval. You can save the report with or without errors and you can modify it later. |
Submit |
Save the expense report and submit it for approval. If errors exist, Expenses displays the Expense Detail for [expense type] page, where you can correct the errors. After you submit the expense report, you cannot modify it. |
Expense Report Project Summary |
Select to access the Expense Report Project Summary page to view a summary of expense line items. Expenses displays this link if Project Costing is installed. |
Printable View |
Select to print a copy of the expense report. You must save the report before printing it to have the changes appear in the printed document. |
For occasional users only, access the Expense Detail for [expense type] page.
Note. Fields on the Expense Detail for [expense type] page are the same as the fields on the Expense Report Entry page and are defined in the Preparing Expense Reports section of this PeopleBook chapter.
See Preparing Expense Reports.
Return to Expense Report |
Click to return to the Expense Report Entry page. |
This section provides overviews of how to copy expenses lines and add multiple expense lines, and discusses how to:
Copy expense lines.
Add multiple expense lines.
Expenses enables you to copy one or more selected expense lines for a single day or a range of dates. You can also indicate whether you want to include holidays and weekends and whether to copy attendees. The functionality associated with the Copy Selected Expenses page is for all expense types, including per diem expense types. When you copy an expense line to create new expense lines, Expenses automatically populates the new expense lines with the same ChartFields as the original line item.
Copy Expense Type Functionality Exceptions
After you enter data on the Copy Selected Expenses page and click OK, Expenses copies all of the data to each new line that it creates. The following table describes the expense types that have exceptions:
Expense Type |
Copy Functionality |
Airfare |
Expenses copies all of the data except the ticket number to each new line that it creates. |
Auto Mileage |
Expenses copies the distance rate to each line. If the rate calculation type is Variable, Expenses recalculates the actual distance rate. |
Per Diem |
For per diem expense types that are set up for a daily range, Expenses copies the daily range amount on the original line to each new line that it creates. For per diem expense types that are set to an hourly range, Expenses creates new lines within your date range with a start time of 12:00 a.m. and an end time of 11:59 p.m. except for the last line, which displays the end time that you enter on the Copy Selected Expense(s) page. Expenses retrieves the appropriate rate from the Location Amount (EX_LOC_AMT_DTL) or Per Diem Amount (EX_PER_DIEM_AMT) table for the 24-hour period because the original line from which Expenses copied from may not be equal to 24 hours. For the last day, Expenses retrieves the appropriate rate from the table based on the per diem range of hours that the user specifies. |
Per Diem Lodging |
No exceptions exist for this expense type. Expenses copies all of the data to each new line that it creates. |
The expense line from which you copy may have been created from sources such as a credit card feed or by using the Hotel Wizard. In some cases, the expense line that you copy may have exception comments. The following table describes the copy functionality for these types of expense lines:
Exception Type |
Copy Functionality |
Credit card feed |
If you copy a line that came from a credit card feed, Expenses copies data based on the copy functionality for the expense type. Expenses also clears the card number, resets the credit card feed flag to Nand clears the payment type. |
Hotel Wizard |
If you copy an expense that was created using Hotel Wizard, Expenses copies data based on the copy functionality for the expense type. Expenses also deletes the Hotel Wizard receipt number so that the new lines are not linked to the Hotel Wizard transactions. |
Receipt split |
If you copy a line that was created using the receipt split functionality, Expenses copies data based on the copy functionality for the expense type. Expenses does not copy the original receipt number for any of the new lines that it creates. |
Exception comments |
If you copy a line that already includes exception comments, Expenses copies the comments for each new line that it creates. |
Expenses enables you to select multiple expense types to add to an expense report. You can also select whether to add one occurrence or a daily occurrence of the expense types for a date range that you specify. Expenses adds the multiple expense lines to your expense reports, and you enter the remaining information that pertains to each expense type.
Page Name |
Object Name |
Navigation |
Usage |
TE_COPY_LINE_SEC |
|
Copy selected expense lines on an expense report. |
|
TE_ADD_MULT_EXP |
Select Multiple Expenses... from the Add drop-down list box on the Expense Report Entry page. |
Select expense types to add to expense reports and whether you want to add one instance of the expense type or have an entry of that expense type for each day within a date range. |
Access the Copy Selected Expenses page.
Copy to One Date |
Select to copy each selected line only once using the To Date as the new expense date. |
Copy Attendees |
Select to copy the attendee information to the new expense lines. If not selected, Expenses populates each line that it creates with only the employee's name in the attendees list. Expenses displays the Copy Attendees check box only if any of the selected expense types requires attendees. |
Copy to Range of Dates |
Select to copy each line multiple times with the expense date for the new lines set to each day within the specified date range. |
From Date and To Date |
Enter a date or a date range for Expenses to calculate the number of rows to create. If you are copying a per diem expense type, you cannot enter a date prior to the copied per diem line. Note. You cannot enter future dates. |
End Time |
Enter the ending time that Expenses uses to calculate the per diem on the last line that it copies. For all other lines that the system creates within your date range, it enters a start time of 12:00 a.m. and end time of 11:59 p.m. Note. Expenses displays this field only for per diem expense types that are set for hours. |
Include Weekends and Include Holidays |
Select to copy the expense type for the entire date range. If you do not select to include weekends, Expenses checks the day of the week and does not copy expense lines for Saturdays or Sundays. If you do not select to include holidays, Expenses checks the holiday calendar for the employee's business unit. Expenses does not copy expense lines for days that the calendar designates as holidays. |
Access the Add Multiple Expenses page.
Date Range |
Select a date range for Expenses to use to add expense lines to the expense report. This range is used to generate a line for the expense type for each day if the All Days check box is selected. |
One Dayand All Days |
Select to specify whether to add one instance of the expense type to the expense report or whether to add one for each day in the date range for that particular expense type. |
Continue |
Click to return to the expense report, where the selected expense items appear. |
Return to Expense Report Entry |
Click to return to the Expense Report Entry page without adding expense lines. If you selected any expense items, Expenses does not add them to the expense report. |
This section provides overviews of Expenses accounting and discusses how to:
Apply accounting defaults to expense reports.
View or modify default accounting.
View or modify accounting details.
When you create new expense reports, Expenses populates the expense report with accounting defaults for the cost distributions based on the default ChartField values that you set up on the Employee Profile - Organizational Data page. The minimum information that Expenses requires is the general ledger business unit. If you are using Approver List routing for your approvals workflow, the ChartField(s) that you select for routing must be populated in the expense transactions. For example, if you are routing by department, then this ChartField must be populated in the expense transactions. If other accounting distribution fields are in the employee profile, they appear by default in the expense reports.
Note. If employees have more than one profile in PeopleSoft Expenses, the system uses the profile that you select as the default.
See Also
Understanding Accounting in Expenses
Maintaining Employee Organizational Data
Expenses uses the ChartField defaults that you set up on the Employee Profile. These defaults are used as part of the distribution created by Expenses when you enter an expense report. In addition to the primary ChartFields, if Project Costing is installed, you may also establish project defaults for Expense Reports and Project defaults for Time Reports in the User Defaults tab. Expenses uses the project defaults, which includes PC Business Unit, Project ID, and Activity, for expense reports that you set up on the Employee Profile - User Defaults page. Expenses creates one distribution line at 100 percent unless you define project defaults with multiple percentage split lines.
Project defaults are used if Project Costing is installed (defined in Installation Options); otherwise, Expenses uses project defaults only for time reporting. If Project Costing is not installed, but you use the Project ChartField, the field is presented in the same grid as the Department and other ChartFields. In all cases, the full distribution for an expense is created from a combination of the employee's GL Business, GL ChartField defaults defined in the Organization tab of the profile, the Account ChartField associated with the expense type for each line, and any project default defined in the profile for expense reports.
The Accounting Defaults page displays the distribution of ChartFields for the expense report, which you may view or edit, depending on how you set up Expenses. This page is not available if the Accounting Display option for the business unit or the employee's role is set to Hide. You cannot edit the distribution or ChartFields if this option is set to Display Only.
See Also
Understanding Accounting in Expenses
Page Name |
Object Name |
Navigation |
Usage |
TE_SHEET_SPLIT |
Click Accounting Defaultslink on the Expense Report Entry page. |
View or modify the default accounting ChartFields. Redistribute the percentages of expenses to different ChartFields. |
|
TE_SHEET_DIST |
|
View or modify the accounting ChartFields for the expense line item. |
Access the Accounting Defaults page.
This page displays the default accounting for an employee. You can:
Change the ChartFields.
Add rows and redistribute percentages.
Delete rows that do not apply to the expense report.
% (percentage) |
Enter the percentage of expense to charge to the ChartFields that you select when you add a new row. The accounting split must equal 100 percent for the set of default ChartFields. |
Add ChartField Line |
Click to add new accounting lines. |
Load Defaults |
Click to reload the accounting defaults from the Employee Profile - Organizational Data and Employee Profile - User Defaults pages. |
User Defaults |
Click to access the Employee Profile - User Defaults page. |
OK |
Click to return to the Expense Report Entry page. If you made changes, the changes apply only to new lines and to existing lines that you had not previously changed the ChartField values. |
Access the Accounting Detail page.
Restore Defaults |
Click to reset the default accounting values. |
VAT Amounts Tab
Expenses displays the VAT Amounts tab only if VAT is enabled for the employee.
|
Click the VAT Accounting Detail button to access the VAT Accounting Detail page and view accounting details for the distribution line. |
Add |
Click to add new accounting detail lines. |
Refresh |
Click for Expenses to recalculate the distribution amounts. |
OK |
Click for Expenses to accept your accounting changes and return to expense entry. |
This section provides an overview of applying cash advances to expense reports and discusses how to apply cash advances to expense reports.
You can apply part or all of a cash advance to an expense report. You can apply a cash advance to more than one expense report, and you can apply more than one cash advance to an expense report. When a cash advance is applied, Expenses updates the cash advance balance accordingly. If the expense report is denied, the balance of the cash advance is restored and available for use on another expense report.
Page Name |
Object Name |
Navigation |
Usage |
TE_ADD_ADVANCES |
Click Apply Cash Advance(s) on the Expense Report Entry page and click Go. |
Select cash advances to apply to expense reports. |
Access the Apply Cash Advance(s) page.
Advance ID |
Select the cash advance ID that you want to apply to the expense report. You can apply more than one cash advance to an expense report. |
Total Applied |
Enter the amount of the cash advance that you want to apply to this expense report. You can apply part of the advance or the entire balance. |
Add Cash Advance |
Click to add another line to select an additional cash advance to apply to the expense report. |
Total Advance Applied |
Displays the sum of the cash advance amounts that you have applied to the expense report. |
Total Employee Expenses |
Displays the total amount accrued on the expense report. |
Total Due Employee or Total Due Company |
Indicates the amount due to either the employee or the company after applying the total cash advance amounts. |
Update Totals |
If you change the cash advance applied amount, then click to update the Total Advance Applied and Total Due Employee fields. |
OK |
Click to apply the cash advance amounts to the expense report and return to the Expense Report Entry page. |
This section provides an overview of expense report line errors and discusses how to correct expense report transaction line errors.
After you enter expense lines on the Expense Report Entry page, click Check For Errors for Expenses to immediately validate the data. Expenses displays visual indicators next to expense lines that have missing or invalid information. Frequent Users can correct errors on the expense line grid. Frequent Users and Occasional Users can click the Missing or invalid information button to access the Expense Detail for [expense type] page. The Expense Detail for [expense type] page displays each expense line with an explanation of the problem and highlights each expense line field that has missing or invalid information. When you correct the errors, the messages and visual indicators disappear after you check for errors. If you neglect to check for errors and elect to Save for Later or Submit, Expenses will still execute the validations. If there is any error associated with any expense line, Expenses will let you save the report but will not let you submit it.
Page Name |
Object Name |
Navigation |
Usage |
EX_SHEET_ERRORS |
Click Check For Errors on the Expense Report Entry page. If errors exist, click the Missing or invalid information button next to the expense type. |
View and correct missing or invalid information on expense transaction lines. |
Access the Expense Detail for [expense type] page.
Note. Fields on the Expense Detail for [expense type] page are the same as the fields on the Expense Report Entry page and are defined in that section of this PeopleBook chapter.
See Preparing Expense Reports.
Check Expense For Errors |
Click to recheck the current expense line for errors. |
Previous Expense and Next Expense |
Click to move to the previous or next expense line that contains errors. Note. Both buttons are available for frequent users only if there is more than one expense line in error. Only the Next Expense button is available for occasional users in the process of submitting the expense report when there is more than one expense line in error. |
Comments
If you are required to enter exception comments, you may enter or modify the comments on the Expense Detail for [expense type] page.
This section provides an overview of how to split receipts and discusses how to split receipts.
Receipt splitting enables you to divide a receipt into multiple expense lines. Expenses supports two utilities for itemizing receipts: Receipt Split and Hotel Wizard. For example, a hotel bill may enter Expenses through a credit card feed as one expense transaction; however, the bill may include charges for telephone calls, laundry service, room service, and parking. You can track, report, and book these items individually if your organization requires it. You may have a receipt for several purchases, one of which is a personal expense. You can then split out the individual purchases in order to mark the personal expense as non-reimbursable.
You can:
Split an expense on a receipt into small, detailed expenses.
Add more expenses to a receipt.
Edit an expense on the receipt.
Change the receipt total amount.
Note. If you split a receipt that came from a credit card vendor feed, Expenses prevents you from changing some fields on the Receipt Detail For Expense page, such as exchange rate and currency code. Also, if the receipt came from a credit card vendor feed, the sum of all the split lines must equal the original receipt total amount.
Page Name |
Object Name |
Navigation |
Usage |
TE_RCPT_SPLIT |
|
Itemize receipts into multiple expense lines. |
Access the Receipt Detail for Expense [expense type] page.
Current Expenses on Receipt
Each item that is associated with the receipt appears with the transaction date, expense type, and amount. Click an expense type to edit the information for that receipt item. Expenses updates this group box when you perform an add or split action.
Current Total |
Displays the total of all receipt items, including those that you add to the original receipt total. |
Receipt Total |
Displays the total of the original receipt amount. The expense system does not change this field when you add new items, but you can enter a new total if the transaction did not originate from a credit card feed. |
Balance |
Displays the current total minus the receipt total. |
Split with Another Expense
To split an item with another expense:
Select an expense type.
Click Split.
Expenses refreshes the page, clears the expense information fields, and adds the selected expense type to the Current Expenses on Receipt group box.
Edit the new receipt item to enter an amount.
Tab out of the Amount field.
Expenses subtracts the amount from the highlighted expense item in the Expense Information section, but the receipt total remains the same.
Note. You can split a receipt into more than two expense types. Expenses displays a message directly under the Expense Information section title that advises you which expense item that you are splitting. If you want to split a different expense item, click the expense item link in the Current Expenses on Receipt section.
Add Another Expense to a Receipt
To add an expense to a receipt:
Select an expense type.
Click Split.
This refreshes the page, clears the Expense Information fields, and adds the expense type to the Current Expenses on Receipt group box.
Edit the new receipt item.
Tab out of the Amount field.
Expenses adds the amount to the current total, which may result in an out of balance receipt total. To correct the out of balance situation, you can adjust the receipt total or adjust one of the expense line entries for the receipt. If you do not adjust the out of balance total and click Done, Expenses displays a message stating that the total of the items entered exceed the receipt amount and asks if you want to update the receipt total amount.
This section provides an overview of hotel bill itemization using Hotel Wizard and discusses how to split a hotel bill using Hotel Wizard.
Expenses provides Hotel Wizard for you to quickly split a Hotel/Lodging expense type into multiple expense lines. For example, a hotel bill may enter your expenses system through a credit card feed as one expense transaction. Use Hotel Wizard to create expense lines for room charges for each day of a business trip and to separate charges for telephone calls, laundry service, room service, and parking. You can track, report, and book these items individually and daily. If you must make any adjustments after you complete Hotel Wizard, you may use the receipt split functionality to reconcile the bill later.
Page Name |
Object Name |
Navigation |
Usage |
TE_WIZARD_MAIN |
|
Split hotel bills into itemized expenses. |
|
TE_WIZARD_RC |
Select the Room Charge check box on the Itemize Hotel Bill page or click the Room Charge button for the expense item. |
Record room charges. |
|
TE_WIZARD_RS |
Select the Room Service check box on the Itemize Hotel Bill page or click the Room Service button for the expense item. |
Record room service. |
|
TE_WIZARD_PHN |
Select the Telephone check box on the Itemize Hotel Bill page or click the Telephone button for the expense item. |
Record telephone charges. |
|
TE_WIZARD_PRK |
Select the Parking check box on the Itemize Hotel Bill page or click the Parking button for the expense item. |
Record parking expenses. |
|
TE_WIZARD_LDY |
Select the Laundry check box on the Itemize Hotel Bill page or click the Laundry button for the expense item. |
Record laundry expenses. |
|
TE_WIZARD_MISC |
Select the Misc Charges (miscellaneous charges) check box on the Itemize Hotel Bill page or click the Miscellaneous button for the expense item. |
Record miscellaneous expenses. |
|
TE_WIZARD_FINISH |
Click the Continue button on the last Itemize Hotel Bill - Expense Item page. |
Complete itemization of hotel bills. |
Access the Itemize Hotel Bill page.
General Hotel Bill Information
The data in this section comes from the information that you entered on the Expense Report Entry page. You can modify fields just as you did when you originally added the expense item.
Checkout Date |
Select to indicate that the value in the Transaction Date field is the last day of the hotel stay. If selected, Expenses starts from the transaction date and creates expense lines moving backward in time. Clear the check box to indicate that the value in the Transaction Date field is the first day of the hotel stay. If not selected, Expenses starts from the transaction date and creates expense lines moving forward in time. If the hotel transaction is from a credit card fee, Expenses automatically selects the Checkout Date check box. If you manually entered the Hotel/Lodging expense type on the expense report, Expenses clears this check box. In either case, you can override the default for the check box as necessary. |
Charges Incurred on This Bill
Select hotel charges to itemize, then click Continue to begin itemizing the bill by entering expense information on the various Hotel Wizard pages.
Remaining |
Displays the remaining balance. |
Done |
Click to return to the Expense Report Entry page, which displays all the itemized expense items. Note. If you return to the main expense report grid without clicking Done, you will lose your itemized expenses. |
This section discusses how to:
View expense reports.
Modify expense reports.
Page Name |
Object Name |
Navigation |
Usage |
Expense Report Detail |
EX_SHEET_ENTRY |
|
View an expense report. |
Expense Report Entry |
EX_SHEET_ENTRY |
|
Modify an unsubmitted expense report or an expense report that was submitted and returned by an approver. |
View Approver Comments |
EX_COMMENTS_RJCT |
|
View approver's comments as to why they denied or returned the expense report. |
Access the Expense Report Detail page.
When you access the Expense Report Detail page using the view navigation, Expenses displays the page in read-only mode. After you submit an expense report for approval, you can only view it. You can view expense reports with these statuses: Approved, Closed, Denied, In Process, Paid, Pending, Submitted, and On Hold.
Note. Fields on the Expense Report Detail page are the same as the fields on the Expense Report Entry page and are defined in the Entering Expense Report Information and Transaction Lines section of this chapter. Fields and functionality that are unique to the Expense Report Detail page in view or modify mode are discussed in this section.
View Approver Comments |
When an employee views an expense report that an approver denied or returned to the employee for revisions, Expenses displays the first 30 characters of the approver's comments as a red link at the top of the Expense Report Detail page. Click the View Approver Comments link to access the View Approver Comments page to view all of the approver's comments. |
General Information
Post State |
Displays whether accounting entries for the expense report have been posted to the general ledger. |
Pending Actions
This section appears after you save an expense report and there are actions pending, such as approvals.
Action History
This section appears after you save an expense report.
Profile and Name |
Displays the name of the originator and approver, and their role. |
Action |
Displays the completed steps in the expense report approval process. |
Date/Time |
Displays the date and time on which the approval status was assigned. |
Access the Expense Report Entry page.
Note. Fields on the Expense Report Entry page using the Modify navigation are the same as the fields on the Expense Report Entry page using the Create navigation and are defined in the Entering Expense Report Information and Transaction Lines section of this chapter. Fields and functionality that are unique to the Expense Report Entry page in modify mode are discussed in this section.
When you access the Expense Report Entry page using the modify navigation, Expenses enables you to edit all of the fields. You can modify an expense report if you have previously saved it but not submitted it for approval or if an approver sent it back for revision or correction.
View Approver Comments |
When an employee modifies an expense report that an approver returned to the employee for revisions, Expenses displays the first 30 characters of the approver's comments as a red link at the top of the Expense Report Entry page. Click the View Approver Comments link to access the View Approver Comments page to view all of the approver's comments. |
This section provides an overview of deleting expense reports and discusses how to delete expense transaction lines.
You can delete an expense report if you have not submitted it for approval. If it has been submitted, you can still delete it if the approver returns it for modifications or if the status is Denied.
Page Name |
Object Name |
Navigation |
Usage |
TE_DEL_SHEET |
|
Select expense reports to delete. |
Access the Delete an Expense Report page.
Expenses displays unsubmitted and denied expense reports for the employee ID that you entered on the search page. The system excludes submitted expense reports. You can delete denied expense reports even if a cash advance was applied to it. Expenses reinstates the cash advance when the approver denies the expense report.
Select expense reports to delete and click the Delete Selected Report(s) button.
This section provides an overview of My Wallet transactions, lists common elements, and discusses how to:
Apply My Wallet transactions to expense reports.
View My Wallet transaction details.
Review, add, and delete receipts in My Wallet.
Add transactions to My Wallet.
My Wallet stores corporate credit card and user-entered expense transactions that you can apply to expense reports, thus saving data entry time. If you are using a PDA with Mobile Time and Expense to track your receipts, these charges are loaded into My Wallet when you sync your PDA with the online system. Credit card feeds from a credit card company (such as Visa International, American Express, and US Bank) send corporate credit card transactions in a file that is loaded into your system directly to My Wallet in Expenses. You cannot modify these expense transaction details that come from a credit card feed:
Expense date.
Credit card number.
Payment type.
Transaction amount.
Transaction currency.
Exchange rate.
Cardmember Number |
Displays the employee's corporate credit card number. |
Expense Location |
Displays the location where the expense was incurred. |
Expense Type |
Indicates the category of expense item. |
Merchant |
Indicates the transaction vendor. |
Payment Type |
Indicates the method of payment. |
Transaction Amount |
Displays the expense transaction amount in the currency that the transaction occurred. |
Reimbursement Amt |
Displays the transaction amount in the employee's base currency. |
Transaction Date |
Indicates the date of the transaction. |
Page Name |
Object Name |
Navigation |
Usage |
TE_EXP_WALLET |
|
Select unassigned credit card transactions and manually entered expense transactions to add to expense reports. |
|
EX_TRANS3 |
Click the Expense Type link on the My Wallet page. |
Review My Wallet transaction details. |
|
TE_MY_WALLET |
|
Review, add, or delete receipts in My Wallet. |
|
EX_POP_WALLET1 |
|
|
Select All |
Click to select all items in the list to add to an expense report. |
Deselect All |
Click to remove all check marks. |
Select |
Select to add a transaction to an expense report. |
Expense Type |
Click to access the My Wallet Detail page and view My Wallet transaction details. |
Personal Expense |
Select transactions that are personal expenses that will be transferred to an expense report as non-reimbursable expense items. |
Access the Expense Report - My Wallet Detail page.
Airfare Receipt Number |
Displays the airline ticket number. Note. This field appears only for Air Travel expense types. |
Number of Nights |
Displays the number of nights that the expense covers. Note. This field appears only for Hotel/Lodging expense types. |
Transaction Amount |
Displays the expense transaction amount in the currency that the transaction occurred. |
Exchange Rate |
Displays the currency exchange rate. |
Description |
Enter additional transaction details. |
Access the Review My Wallet Receipts page.
Search Criteria
Receipt Data Source |
Select a source, such as Visa, American Express, or User Input. |
Select a transaction status. Values are:
|
|
Select to delete a transaction from My Wallet. For example, you can delete personal expense transactions that come from a credit card feed because your organization would not reimburse you for those expenses. When you delete a transaction using this check box, Expenses no longer displays the transaction in My Wallet; however, the transaction remains in the EX_TRANS table for audit purposes. |
|
Date |
Click to access the My Wallet Detail page to view details of the transaction. |
Doc Type (document type) |
Displays, if the transaction is assigned, the kind of expense document to which it is assigned. |
ID |
Click to view detailed expense report or cash advance information. |
Expense Type |
Select an expense type and click Add to access the My Wallet Detail page to add an expense item to the Wallet. For example, you might use this feature if you charge to your personal credit card or paid cash for a business expense. |
Access the My Wallet - My Wallet Detail page.
Note. The page elements on the My Wallet Detail page vary, depending on how you set up your expenses system and which expense types you select.
Mark for Delete |
Select to delete a transaction from My Wallet. This check box is available only for transactions that you manually entered into My Wallet, not for transactions from a credit card feed. When you delete a transaction using this button, the transaction is removed permanently from the EX_TRANS table. |
Transaction Amount and Currency |
Enter the amount in the expense transaction currency and select the appropriate currency code. |
Exchange Rate |
If the currency code for the transaction amount differs from the base currency of the employee's business unit, Expenses populates this field with the current market rate that is defined in the system rate tables. If your invoice reflects an exchange rate that is different from the system-supplied rate, you can override the system-supplied exchange rate. |
|
Click the Reset Exchange Rate button to change a user-defined exchange rate to the system-defined exchange rate. |
|
Click the Exchange Rate Detail button to access the Exchange Rate Detail page to view or change exchange rate information. |
Default Rate |
Indicates if system rate exchange tables or user-defined exchange rates are being used. If selected, Expenses is using the current market exchange rate that is defined in the system rate tables. If not selected, Expenses is using a user-defined exchange rate. |
Update |
If you changed the transaction amount or the exchange rate, click to update the Reimbursement Amt field. |