The Lodging Wizard Type is the one of seven types of wizards that you can use to record individual expenses on an expense report. When this Wizard is called depends on how you set up your expense report types. Wizards are highly flexible and user configurable according to the expense type and expense report type.
Wizards consist of individual pages on which you provide information. When you complete one page, select the Next button to go to next page of questions. Depending on the configuration settings for the expense being recorded, the flow from one Wizard page to the next may differ.
The following diagram illustrates the logic used.
Start the Wizard by either clicking on an icon to add a new expense or clicking on an existing expense amount to edit/view it.
Whether an existing expense can be edited depends on the status of the expense report and your modification rights. If you are looking at your own expense report, you cannot edit it if any of the following are true:
The expense report has a "Voided" or "Processed" Status.
The expense report is in the process of being exported.
You have read-only rights to the screen.
If your role allows you to look at another employee's expense report, the rules that determine whether or not you can modify the expense report are the same. In addition, your functional role must have the appropriate rights.
To add a new expense for lodging, click either the Add hyperlink or the name of the category that was set up for the expense report type for lodging. You will be taken to the first page of the Lodging Wizard.
The Expense Type page of the Wizard will be available only if there is more than one expense type for lodging linked to the category that you selected for the expense report type selected.
Select an expense type from the drop-down box. The default is the expense type selected as the default in the Expense Report Types screen. This expense type determines which fields are required on the proceeding pages.
Select this button to move to the previous page of the Wizard.
Select this button to move to the next page of the Lodging Wizard.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Wizard.
If you have lodging expenses that were imported from a credit card feed, you can select one of those items to expense on this expense report. You can view details regarding this expense by clicking the Details hyperlink on the right side of the screen. If you choose to select an outstanding expense, some of the required fields will populate with information retrieved from the credit card interface. The list is made up of expenses that have a source of "Lodging" or "Other."
You are not required to select an outstanding expense if it exists. You can bypass this screen by selecting the Next button and manually entering a "Lodging" expense.
The Outstanding Expenses table consists of the following information:
Source - This field displays the wizard type for each outstanding expense. The valid values are "Car Rental" and "Other."
Transaction ID - This field displays the transaction ID that was imported or entered on the Maintain Expenses screen for this expense.
Merchant Name - This field displays the merchant name used for this expense. If the field is blank, the merchant name was not known at the time the outstanding expense was posted.
Date - This field displays the expense date that was imported or entered on the Maintain Expenses screen for this expense.
Amount - This field displays the amount of the outstanding expense.
Currency - This field displays the currency in which the expense was imported or entered on the Maintain Expenses screen for this expense.
Provider - This field displays the provider used for this expense. If the field is blank, the provider was not known at the time the outstanding expense was posted.
The information you need to enter in the Expense Details page depends on the expense type selected. If a field is available, it will be required.
If you are allowed to correct processed expense reports, but are not allowed to enter to corrections that would change the Expense Incurred amount, the following fields or buttons on the Expense Details page are disabled:
Location
Check In Date
Check Out Date
Late Check Out
Conference
Clear Location
Country
State
City
County
Delete Expense
Currency (correcting this field would reset the Expense Amount to zero)
Expense Incurred
Use Calendar Lookup to select a date for the expense. This field is required regardless of the expense type selected.
Use the drop-down box to select the provider that was used for this lodging expense. This field will display only if the Provider check box is selected in the Required Fields group box in the Input Options tab of the Expense Types screen.
Use the drop-down box to select the user-defined value that was set up in the Expense Types screen and was used for this lodging expense. This field is required, if displayed. It will be available only if the expense type has been configured to require it.
Use the drop-down box to select the user-defined value that was set up in the Expense Types screen and was used for this lodging expense. This field is required, if displayed. It will be available only if the expense type has been configured to require it.
Use the drop-down box to select the user-defined value that was set up in the Expense Types screen and was used for this lodging expense. This field is required, if displayed. It will be available only if the expense type has been configured to require it.
Use Calendar Lookup to select the date on which you checked into the hotel. This field is required regardless of the expense type selected.
Use Calendar Lookup to select the date on which you checked out of the hotel. This field is required regardless of the expense type selected.
The system calculates this field by subtracting the Check-In Date from the Check-Out Date. It uses this value to determine the "not to exceed" ceiling amount.
Select this check box if you checked out of the hotel after the required checkout time and were charged an extra night's stay. If you select this check box, the ceiling amount on the next page will be increased by one day.
This field will default a description of the expense type. It will be used in the Description field of the AP Voucher and the information displayed in the field is determined by the configuration of the expense type. This field is non-editable and is displayed regardless of the expense type selected.
Use this optional field to enter any comments regarding this lodging expense.
Use the drop-down box to select the country where this lodging expense occurred. The default is the country you entered when filling out the General portion of the expense report. This field will be displayed only if the expense type is a per diem expense and the Country check box was selected for the appropriate per diem schedule in the Input Requirements group box in the Per Diem Schedules screen.
Use the drop-down box to select the state/province where this lodging expense occurred. The drop-down box contains those states or provinces in the country selected. If a country is not required or has not been selected, all states/provinces will be listed. The default is the State/Province you entered when you filled out the General portion of the expense report. This field will be displayed only if the expense type is a per diem expense and the State/Province check box was selected for the appropriate per diem schedule in the Input Requirements group box in the Per Diem Schedules screen.
Use the drop-down box to select the city where this lodging expense occurred. The drop-down box contains those cities in the Country and State/Province selections. If the Country and/or State/Province are not required or have not been selected, all cities will be listed. The default will be the City you entered when filling out the General portion of the expense report. This field will be displayed only if the expense type is a per diem expense and the City check box was selected for the appropriate per diem schedule in the Input Requirements group box in the Per Diem Schedules screen.
Use the drop-down box to select the county where this lodging expense occurred. The drop-down box contains those counties located in the City selected. If the Country, State/Province, and/or City are not required or have not been selected, all counties will be listed. The default is the County you entered when filling out the General portion of the expense report. This field will be displayed only if the expense type is a per diem expense and the County check box was selected for the appropriate per diem schedule in the Input Requirements group box in the Per Diem Schedules screen.
To clear the contents of all location fields, select the Clear button above the Country drop-down box.
To view the details that make up the per diem amount for the location entered, select the Details button above the Country drop-down box.
Select this button to return to the previous screen.
Select this button to move forward to the next page of the Lodging Wizard.
Select this button to return to the main Expense Report screen. If you select this button when entering a new expense, no information regarding this expense will be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Lodging Wizard.
The Expense Amount page of the Lodging Wizard contains information regarding how much was spent, how payment was made, and ceiling information. This page will be available only if the expense type is configured to be either non-per diem or per diem ceiling (where the actual amount spent is entered). Depending on the configuration of the expense type, some fields will be hidden.
If you are allowed to correct processed expense reports, but are not allowed to enter to corrections that would change the Expense Incurred amount, the following fields or buttons on the Expense Amounts page are disabled:
Location
Check In Date
Check Out Date
Late Check Out
Conference
Clear Location
Country
State
City
County
Delete Expense
Currency (correcting this field would reset the Expense Amount to zero)
Expense Incurred
Use the drop-down box to select the method that was used to pay for this expense. The default pay method is determined by the expense type selected and how it was configured. The list of valid payment methods is determined by those set up in the employees' Expense Classes screen.
Use the drop-down box to select the currency that was used to pay for this expense.
This field displays the exchange rate for the selected transaction currency and the user's pay currency. You can change this rate if the Modify Exchange Rate check box is selected in the Expense Classes screen.
Enter the full amount of the expense.
Enter the amount that is deemed "unallowable." This amount will be reimbursed.
Enter the amount spent per day for the room amount of this lodging expense.
Enter the amount spent per day on taxes for this lodging expense.
The system calculates this field by adding the daily room tax to the daily room rate. It then multiplies the total by the number of nights.
This field is used only for per diem lodging expenses.
Enter the amount of the expense that is personal.
This amount will not be reimbursed.
The system calculates this value. If the amount over the ceiling amount is NOT reimbursed, that amount displays in this field.
If the amount is under the ceiling amount or if the over ceiling amounts are reimbursed, this field will be zero.
The system calculates this field by subtracting from the Expense Incurred any amount that is over the ceiling and is not reimbursed and by any personal amount.
This non-editable field displays the "not to exceed" ceiling for this type of lodging expense. The system calculates this value on a per day basis, meaning that, if the expense is for three days, the system multiplies the ceiling amount by three and displays the result here.
Supervisors with rights to modify their employees' expense reports can use this field to adjust the ceiling amount up or down depending on the expense and the explanations given. For all other users, this field is non-editable.
This non-editable field displays the new ceiling, which is the original ceiling plus any adjustments that were made.
This field displays the amount of the expense that is over the company-defined ceiling amount. Whether it is reimbursed or not depends on how the expense type was configured.
Select this button to return to the previous page.
Select this button to move forward to the next page of the Lodging Wizard. If you have gone over the ceiling and the Require Over-Ceiling Explanation check box is selected in the Expense Types screen, you will be required to explain why you went over the ceiling.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Lodging Wizard.
Sometimes additional charges appear on a hotel bill that must be charged to a different General Ledger account than the lodging expenses. These additional charges may or may not be reimbursed to the employee. The Other Expense page of the Wizard allows you to expense these additional charges to the appropriate General Ledger accounts as set up in the Expense Types screen.
Use this table to add and delete other lodging expenses.
Use the Add Other Lodging Expense function to add an additional lodging expense that appears on a hotel bill.
Use the Lookup to select the date on which you are entering this expense.
Use the drop-down box to select the expense type that applies to this other lodging expense. Valid values are those "Other" expense types that are linked to the lodging Expense Type in the Other Lodging Expenses tab of the Expense Types screen.
Select the Personal check box if this other lodging expense is personal.
Enter the amount of this other lodging expense in this required field.
Enter any notes regarding this other expense in this optional field.
This field displays the total amount of all other expenses that are deemed personal.
This field displays the amount of other expenses that have not yet been allocated. This amount must be zero before you can proceed to the next screen.
This field displays the total amount of all other expenses that will be reimbursed to the employee.
Select this button to return to the previous page.
Select this button to move forward to the next page of the Lodging Wizard. The system will check to verify that the total amounts entered here equal the Other Expenses amount from the Expense Amount page of the wizard.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Lodging Wizard.
Select the other lodging expense that you wish to delete by selecting the check box on the row that you wish to delete. Then use the Delete Other Lodging Expense function to delete the row.
The Taxes page of the Lodging Wizard displays tax information for this expense type. Depending on how the tax schedule selected for this expense type is configured, it may be a one-tier tax or a two-tier tax. Also, depending on your configuration, you may be able to edit the tax amounts.
This field displays the type of tax that is used for this expense type. This field is non-editable.
Use the drop-down box to select the tax schedule that should be used for this car rental expense. The valid values are those tax schedules that have the same tax type that was linked to the expense type in the Expense Types tab of the Expense Report Types screen.
Use the drop-down box to select the location where the expense occurred. The values are locations that were set up for the tax schedule that is linked to the expense type.
Enter the tax ID for this expense. If a provider has been supplied and that provider contains a tax ID, that ID will be displayed. Otherwise, you must enter one.
This field displays the tax amount for the first-tier tax of this expense. The system calculates this amount by multiplying the expense incurred amount that was entered in the Expense Amount screen by the tax rate that was entered for the tax schedule or location (if one is required). You can change the rate if both the expense report type and the expense class allow you to do so.
This field displays the tax amount for the second-tier tax of this expense. The system calculates this amount by multiplying the expense incurred amount that was entered in the Expense Amount screen by the tax rate that was entered for the tax schedule or location (if one is required). You can change the rate if both the expense report type and the expense class allow you to do so.
This field displays the total amount of taxes for this expense. The system will add together both the first tier and the second tier tax amounts to get the total.
Select this button to move forward to the next page of the Lodging Wizard.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Lodging Wizard.
The Charge Allocation page of the Lodging Wizard displays information regarding how the expense is allocated and allows you to change the percentage or the amount that is allocated to each of the charges.
Use the drop-down box to select how you want the expense allocated. The valid values are "Percentage" and "Amount." If you select "Percentage," you can edit the Percent field in the allocation table. If you select "Amount," you can edit the Amount field in the above allocation table. The default is "Percentage."
The drop-down list in Expense Portion contains the following: Under Ceiling, Over Ceiling, Unallowable, Tax 1, and Tax 2. Select the portion of the expense for which you want to view or enter charge allocation information.
When you make a selection in Expense Portion, the allocation table is set up so you can enter or review charge allocations for the selected portion of the expense amount. When you are through with that portion of the expense, you can select another.
Use this table to select the charge types used for the selected portion of the expense. It also contains the default UDTs that you selected when entering the General portion of the expense report. All fields in this table can be configured to default in automatically, or you may be required to select a value for one or more of the fields. (If there is only one valid charge type, it is displayed in the Charge Type field, and you cannot change it.)
This non-editable field displays a system-configured number assigned to each allocation of the expense.
This field displays the percentage allocated to the charge. If you selected "Percentage" in the Allocate By drop-down box, you can change this percentage.
This field displays the amount allocated to the charge. If you selected "Amount" in the Allocate By drop-down box, you can change this amount.
Use the drop-down box to select a charge type. The charge type determines which other UDTs are used for this expense. Only those charge types that are linked to this expense type are available. If there is only one valid charge type, it is displayed in the Charge Type field, and you cannot change it.
Use Lookup to select a UDT01. Only UDT01s that are valid for the default charge are available. If there is only one valid UDT01, that value will default in and this field will be non-editable. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will be used in Deltek Expense. |
This UDT will be used in Deltek Expense. |
If used, the UDT02 will default from the General Wizard. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will be used in Deltek Expense for charges requiring a project. |
Use Lookup to select a UDT03. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT04. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT05. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT06. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT07. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT08. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Use Lookup to select a UDT09. Only UDT09s that are valid for the default charge are available. If there is only one valid UDT09, that value will default in and this field will be non-editable. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will be used in Deltek Expense. |
This UDT will be used in Deltek Expense. |
Use the drop-down box to select a UDT10. Only UDT10s that are valid for this charge are available. If there is only one valid UDT10, this field will be non-editable. This field will display only if the Show check box is selected for this UDT in the Expense Configuration screen.
This UDT will most likely NOT be used in Deltek Expense. |
This UDT will most likely NOT be used in Deltek Expense. |
Enter a reference code for this expense. This field will be available only if "None" is not selected in the Expense Reference Source field in the Charge Types screen.
Select this button to add an additional Charge Allocation to the list of allocations that were entered when you initially filled out the expense report. You will be taken to a different wizard page where you can add one or more allocations that can be used for this expense and any remaining expenses to be entered.
If your system is set up to provide direct access to a Costpoint database for charge lookups rather than using Time & Expense with ESS charge trees, see Charge Lookup Using Direct Costpoint Access if you need help selecting charges.
This field displays the total amount allocated to the portion of the expense selected in the Expense Portion drop-down box. (The label for this field changes to match the selection in Expense Portion.)
Select this button to return to the previous screen.
Depending on how your system is configured, this button will be labeled either Next or Finish. If the Expense Summary page is available, it will be labeled Next. Select this to move forward to the next page of the Lodging Wizard. If the Expense Summary page is not available, it will be labeled Finish. Select this button to complete the expense and return to the main Expense Report screen.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Wizard.
The Default Charge Allocation page of the Wizard will be displayed if you selected the Add Allocation button on the Charge Allocation page. On this Wizard page, you can add additional charge allocations for the expense you are currently entering as well as any later expenses.
This table displays the specific charging information that will default on the expense report.
Click Add Charge Allocation to add a default allocation ID to this expense report. You must fill out the following:
Charge Type - Use the drop-down box to select the charge type that will be used. The valid values are UDT01 or UDT02.
Charge - Use Lookup to select a valid charge that will be used for this expense report. (If your system is set up to provide direct access to a Costpoint database for charge lookups rather than using Time & Expense with ESS charge trees, see Charge Lookup Using Direct Costpoint Access if you need help selecting charges.)
Default Allocation % - Enter the allocation percentage that will be the default for this charge.
Select the charge allocation that you wish to delete by selecting the check box next to the row that you wish to edit. Then use the Delete Charge Allocation function to delete the row.
To keep a charge in your list of "Favorites," select the one(s) you wish to save by selecting the check box in the field to the left of the row. Then select the Add Line to Favorites function. This will put the charge in your list of favorites where you can easily select it when entering another expense report.
OK - Select the OK button to save the additional charge allocation entries that were made. You will then be brought back to the Charge Allocation page of the expense that you were entering. You can then change any allocation amounts or percentages that need to be changed for this expense.
Cancel - Select the Cancel button to disregard any new allocations that were just entered. You will be brought back to the Charge Allocation page of the expense that you were entering.
The Expense Summary page of the Lodging Wizard is optional. Depending on the configuration of the expense report type, this page may not be available. It displays summary amount information regarding the expense just entered. You can view it in the transaction currency or your pay currency.
Use the drop-down box to select the currency in which to view the summary.
This non-editable field displays the total expense incurred.
This non-editable field displays the total amount of taxes that were incurred.
This non-editable field displays the amount of the expense that was entered as personal. This amount will not be reimbursed to the employee.
This non-editable field displays the amount of the expense that will not be reimbursed to the employee.
This field displays any other expenses that are associated with this Lodging expense. For example, you might have expenses such as phone calls, room service, parking fees, and other charges that are on your hotel bill but are not a part of the room costs or taxes. The system calculates this amount by adding the Room rate and the Tax rate and multiplying the result by the number of nights. Any remaining amount is entered in this field. You can account for these charges on the next page of the wizard. Please see the section on Other Lodging Expenses for details.
This non-editable field displays the amount of the expense that will be reimbursed to the employee.
This non-editable field displays the amount of the expense that is billable. It is based on the configuration of the charge type.
This field displays the amount of the expense that is not billable. It is based on the configuration of the charge type.
This non-editable field displays the ceiling amount after any adjustments have been made.
This field displays the amount that is over the company defined ceiling after any ceiling adjustments have been made.
Select this button to return to the previous screen.
Select this button to complete the expense and return to the main Expense Report screen.
Select this button to return to the main Expense Report screen. If you select this button while entering a new expense, information regarding this expense will not be saved to the database. If you select this button when editing an existing expense, any changes that you made will not be saved to the database.
Select this button for instructions on what to do on this page of the Wizard.
When you want to edit an existing expense, select the amount in the hyperlink that corresponds to the date of the expense and the category you wish to edit.
If there is more than one expense for that date and category, you will be taken to the Select Expense screen where you can select the expense that you wish to edit.
If there is more than one expense for that date and category, you will be taken to the Select Expense screen where you will select the expense that you wish to edit. This screen contains a table with information that can help you determine the proper expense.
Depending on the configuration of your expense class, the type of change that is made and the status of the expense report, you may need to enter an explanation for the change and resign the expense report. Then the expense report will go through the approval process again. These steps are required if any of the following occurs:
The user or supervisor changes the amount of the reimbursement.
The user or supervisor changes the allocation of the expense.
When an expense needs to be deleted from an expense report, select the amount hyperlink that corresponds to the date of the expense and the category that you wish to delete. You will be brought to the Expense Details screen for that expense. Select the Delete button.
Depending on the configuration of your expense class and the status of the expense report, you may need to enter an explanation when deleting an expense. A confirmation message will appear to verify that the expense should be deleted. Once it is confirmed, the expense will be deleted from the expense report and you will return to the main Expense Report screen.