Contents of the Expense Reports Form
Use the fields and options on the Expense Report form to search for expense reports and complete tasks such as creating, copying, and modifying expense reports, uploading receipts, and more.
Fields
Expense Reports Grid
Use this grid to enter the information for the individual expenses. The grid is divided to the left and right sections. You can scroll horizontally in each section, and you can drag the vertical divider that is located between the two sections to resize each side of the grid to suit your needs. While entering values in the grid fields, you can press TAB to move to the next field.
Left and Right Grid Column Selection
You can select the columns that display in the left and right sides of the expense report grid. Click in the upper-right corner of the grid and choose either Left Grid Column Selections or Right Grid Column Selections.
The column selections only apply to you. Another user can choose to display a different set of columns. Your selections are saved and remain in effect until you change them. The columns that display by default in the grid and the columns that are available for selection on the Column Selections dialog boxes are determined by configuration settings in the desktop application.
For information about selecting columns, see Select Columns for a Grid.
Adding, Copying, and Deleting Rows
Click + Add Line below the grid to add a new blank row below the last existing row.
When you select a grid row or hover over a row, this icon appears at the right end of the row. Click and select the action that you want to perform for that row: insert a blank row below it, copy the current row (except for the amounts and expense details) as a new row below it, or delete the row.
Left Grid Columns
Right Grid Columns
Field | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|
Originating Vendor | Enter the vendor number of the vendor from whom the expense item was originally purchased. For example, an employee may have paid for a hotel room and a plane ticket. You can associate the expense items with the specific hotel and airlines vendor.
This field is displayed if the Enable Originating Vendor for Expenses and A/P Vouchers option is set to Yes in . To select an originating consultant for an expense, do one of the following in
Originating Consultant:
Vendors included in this list are those that are marked as approved for use in processing in the Firms hub for your current company and are available based on your security role. You can select active or inactive vendors, but not dormant vendors. |
||||||||
Originating Vendor Name | This field displays the name of the originating vendor. You can also use this field to select an originating consultant name for an expense, do one of the following in
Originating Consultant:
This field is displayed if the Originating Consultant field is displayed. You can display Originating Consultant Name whether or not you choose to display Originating Consultant. if you used this field to select a vendor, the Originating Consultant field is also updated with the matching vendor number for the selected vendor. |
||||||||
Company Paid | This field is displayed if
Allow Company Paid Expenses is set to
Yes in
.
Select this check box if the expense is company paid. Company-paid expenses are reimbursed to the vendor, not the employee. A common example of a company-paid item is when you purchase an airline ticket for business travel, and the airline charges your company instead of you for the expense. Your company pays the airline for the ticket, but you add it to your expense report to create an audit trail and charge it to the appropriate project. If a credit card defined as "company paid" is assigned to the expense line, the Company Paid option is automatically selected, and you cannot clear it. If a credit card defined as "employee paid" is assigned, the Company Paid option is automatically selected, and you cannot clear it. |
||||||||
Credit Card | Use this field to assign a credit card to the expense line. Enter or select a credit card when you click in the field. | ||||||||
Merchant Description | If a credit card is assigned to the expense line, the associated merchant description displays in this column. This is the merchant or description from the credit card statement that helps employees identify a charge. | ||||||||
Currency Code | This field is displayed if you use multiple currencies. Use the
Currency Code field to specify the currency that applies to the amounts in the
Amount,
Total Tax Amount, and
Net Amount fields for the expense item. For example, if you submit an expense report following a business trip to multiple countries, you might enter
USD for one line item,
EUR for another, and
CAD for yet another.
Use this field to select a currency code. To select a currency code, do either of the following:
If you use the Currency Override dialog box to specify a different transaction currency, it will apply to any new expense items that you subsequently add to the grid. If you assign miles/kilometers for the expense report in the Travel Detail dialog box, system checks the Currency Code field to ensure the assigned currency matches the employee's company's functional currency. If they are different, an error message displays, the employee's company functional currency is entered in Currency Code, and you cannot change it. If a "company paid" credit card is assigned to the expense line, the currency code associated with the credit card displays in the Currency Code field for reference. In that case, you cannot select a different currency. If the credit card for an expense line is "employee paid," the Currency Code field behaves as it does when no credit card is involved. |
||||||||
Amount | Use this field to enter the expense amount.
When you enter an amount in this field and tax auditing is enabled, the amount in this field is used to calculate the taxes that prefill the Total Tax field in this grid. If amounts are entered in the Payment Amount and Net Amount fields, any updates that are made to those fields automatically update the amount in this field. If you assign travel detail to the expense, and you make changes to the mileage/kilometer-related entries on the Travel Detail dialog box, Amount automatically updates accordingly. If you use multiple currencies and the assigned transaction currency and functional currency codes are different, the Amount field is used to calculate the amount in Payment Amount as follows: Amount X Payment Exchange Rate. If a credit card is assigned to the expense line, this column displays the amount of the charge in the credit card receipt's currency. |
||||||||
Payment Exchange Rate | If you use multiple currencies, use this field to specify the rate at which one currency is exchanged for another.
The amount in the Amount field multiplied by the rate in this field is the amount in Payment Amount. If you change any of these amounts, the others are automatically updated. You can change the payment exchange rate if the code in Currency Code does not match the functional currency for the employee's company. If you change the assigned Currency Code, the payment exchange rate is automatically updated. The Payment Exchange Rate displays a default rate in the following situations:
If a credit card is assigned to the expense line, the following is considered for the payment exchange rate:
|
||||||||
Payment Amount | If you use multiple currencies, this field displays the amount to be paid to the employee, in their functional currency. This is calculated by multiplying the expense amount in
Amount by the exchange rate in
Payment Exchange Rate after any exchange overrides have been applied. As you change these amounts, the others automatically update and are stored in the functional currency of the employee's company.
If the code in Currency Code does not match the company's functional currency, you can enter or change the payment amount. If the currencies are the same, Payment Amount displays the same amount as Amount and is not editable. If a credit card is assigned to the expense line, the amount in this column is the amount that will be paid to one of the following:
If the payment amount is not in the same currency as the functional currency of the employee's company, the amount displays in a blue font. (A blue diamond also displays next to the column heading as an additional visual indicator that the column contains amounts in more than one currency.) The blue amounts are excluded from the expense report totals. The amount in the Payment Amount field is not increased or decreased by a reverse charge tax amount if a reverse charge tax was applied to an employee expense. |
||||||||
Exchange Override | This field displays the payment exchange override information from the Currency Override dialog box that applies to the expense row:
If the Currency Code, Payment Exchange Rate, and Payment Amount cannot be selected for display, you cannot display this column. |
||||||||
Total Tax Amount | If you use the Tax Auditing feature, this column displays the calculated tax amount for the expense item. Configuration options determine if the
Total Tax Amount prefills in this column and if you will have access to the
icon to open the Taxes dialog box to enter tax code information.
A tax amount prefills in this field if an expense category is assigned and it has default tax codes or if a category is assigned and default tax codes are assigned Amount to calculate the total tax amount. You can change these codes only if Allow User to Edit is set to Yes on the Edit Expense Categories dialog box (in and then click and Edit at the end of a row in the Categories for All Expense Groups grid). . If the selected category has associated default tax codes entered on the Expense Categories dialog box, then the tax rates that are entered for those default tax codes are applied to the amount inWhen no amount prefills in Total Tax Amount and the category's settings allow, click in the column to open the Taxes dialog box. In the dialog box, view, add, or remove tax codes and recalculate the tax amount, or change the tax amount. The amount in the Net Amount column is updated automatically, unless the tax code is a reverse tax charge. The amount in the Total Tax Amount field includes reverse charge tax amounts if a reverse charge tax was applied to an employee expense. If you use the multiple currencies and you entered an expense line that uses a different currency, but you are not allowed to edit tax codes, an error message displays. The error message indicates that the taxes did not generate a default amount because the associated currency for the expense report is different than the currency on the expense line. in this case, when you try to open the Taxes dialog box, a similar message is also displayed and prevents you from accessing the Taxes dialog box. Contact your system administrator. |
||||||||
Net Amount | If you use the Tax Auditing feature, this column displays the net expense amount which is the expense amount in
Amount less the tax amount in the
Total Tax Amount.
The amount in the Net Amount column is not increased or decreased by a reverse charge tax amount if a reverse charge tax was applied to the employee expense. You can change the amount directly in this column. The amounts in the Amount and Payment Amount fields are automatically updated, unless the tax code is a reverse tax charge. |
||||||||
Project and/or Project Name | You can display the
Project column, the
Project Name column, or both.
To select a project, do either of the following in
Project or, if
Project is not displayed, in
Project Name:
These additional settings affect what projects are available for selection:
|
||||||||
Phase and/or Phase Name | You can display the
Phase column, the
Phase Name column, or both. When you select a project for an expense and that project has phases, you also select a phase in the Project/Phase/Task lookup, and it displays in
Phase and/or
Phase Name.
If you need to change the phase, do either of the following in
Phase or, if
Phase is not displayed, in
Phase Name:
If Treat inactive Projects as dormant is set to Yes in , inactive phases are not available for selection. |
||||||||
Task and/or Task Name | Use the
Task field,
Task Name field, or both to identify the task associated with the expense. When you select a phase for an expense and that phase has tasks, you also select a task in the Project/Phase/Task lookup or Phase/Task lookup, and it displays in
Task and/or
Task Name fields.
If you need to change the task, do one of the following in
Task or, if
Task is not displayed, in
Task Name:
If the Treat inactive Projects as dormant option is set to Yes in , inactive tasks are not available for selection. |
||||||||
Bill | This check box is enabled when an expense item's project has a regular charge type. This option indicates whether or not the project's client should be billed for the expense item.
The check box prefills (selected or cleared) based on the Bill by Default settings on the Time & Expense tab in the Projects hub for the expense item's project (at the lowest level of the work breakdown structure).
|
||||||||
Account and/or Account Name | Enter the general ledger debit account for an expense item. An account may prefill in these fields based the on the expense category that you enter for an expense item; the charge type (regular, overhead, or promotional) of the project that you entered for the expense item; and whether or not the expense item is billable to the client (the
Bill check box is selected in the grid). The default account that prefills is specified in
. If no default account is set up for the expense category, you must enter an account in this field. Click
and use the account lookup to select an account, or enter an account directly in the field. Lookup results with a lighter font color are inactive.
The accounts that you can choose from are based on the project's charge type as follows:
In Account option under Display on Expense Report to specify whether accounts or account names display in the grid. , use the |
||||||||
Receipts | Use this field to associate receipts with the expense item.
If you use the DPS on-premises product, this field displays only if Transaction Document Management is configured. For more information about the configuration, see the Configuring Supporting Documents online help topic. Select an expense item and click in the Receipts field. The Expense Line Receipts dialog box lists all receipts that are attached to the expense report. Use this dialog box to upload a new receipt file, or select the Attached to Selected Expense check box to attach one of the listed receipts to the current expense item. When a receipt is already associated with the expense item, the is displayed instead. When you hover over the icon, a tooltip displays that shows the number of attached receipts for the expense item. When you upload receipts in the Expense Line Receipts dialog box, an error message is displayed if the file you are uploading exceeds the file size limit that was set up by your system administrator. |
Totals Fields
TheTotals fields display total amounts for the items in the Expense Reports grid. Some or all of the fields listed below may display, depending on how your system administrator defines expense settings.
If you use multiple currencies, the total amounts display in the currency in which you will be reimbursed, the functional currency for your assigned company. If one or more expense lines have a credit card assigned with a payment amount in a currency other than your functional currency, those payment amounts display in a blue font in the Payment Amount column. Those blue amounts are not included in the total amounts. A blue diamond displayed in the total fields area is a visual indicator that this has occurred.