Employee Expense Report - Bill Backup
Additional
Information
The Employee Expense Report - Bill Backup report is an expense report for Billing Backup that allows users to define backup criteria. Expense Report is a Backup Type on the Bill Backup Style. If selected, Expense Report lines are created during the Prebill and Final Bill Initialization processes. Expense Report Bill Backup Reports are automatically generated based on the backup lines created by these processes and available on the Prebill or Final Bill Backup.
The Employee, Expense Report, Project (from the Project Bill Code), Expense Report Dates, Posting Date and Client (from the Bill Term Client Code) display for the Employee Expense Report Bill Backup Report on the header of each page. Additional header information is displayed based upon the Backup Level selections on the Bill Backup Style associated with the Project and Bill Term. For example, Bill Task is displayed if Backup Level is Backup Task, Cover Task or Task.
Sections are divided into Transaction Details and Adjustment Details, if applicable, for the employee listed on the report. Audit trail information may also be provided. Sample Report.
Transaction Details
The transaction details area displays the following columns.
| Field | Description |
|---|---|
| Sequence |
Displays the line item's sequential number from the Expense report and originating line. |
| Date | Displays the transaction date. |
| Category | Display the expense category name. |
| Project | Displays the project code when project code changes. |
| Task | Displays the task hierarchy code. |
| Location | Displays the location code associated with each project. |
| Receipt | Displays the receipt number of the expense transaction code. |
| Currency | Displays the currency code of the expense transaction code. |
| Quantity | Displays the quantity when expense type = employee unit or company unit. This is blank when the number of units is zero (0). |
| Amount |
Displays the amount when expense type = employee or company expense. Reimbursement Amount displays when expense type = employee unit or company unit. |
| Total | Displays the sum of the amount column across all expense transaction codes. |
| Net Amount | Displays the amount calculated before taxes. |
| Total Amount |
Displays the total of all the amounts entered in the Transaction Details area. |
VAT Detail
The VAT detail columns will display below Transaction Details only if VAT exists for the transaction. The following columns display for VAT transactions.
| Field | Description |
|---|---|
| Pre Tax |
Displays the pre tax amount from the Expense report transaction. |
| Tax Code |
Displays the tax code from the Expense report transaction. |
| % |
Displays the tax percentage, to two (2) decimal places, from the Expense report transaction. |
| Tax | Displays the tax amount from the Expense report transaction. |
Project Descriptions display under the Transaction Details and VAT Detail areas. These will only display if a project description exists for the transaction. The project description displays on its own line under the category column and extends to the currency column. Text wrap is available for project descriptions if needed.
Show Lines
The Employee Expense Report Bill Backup Report displays information based on the Show Lines selected on the Bill Backup Style for the Backup Type Expense Report. If Backup Level is Bill, Cover Task, Backup Task or Task, the project and task line items appear in bold for bill backup.
The following rules apply:
- Selecting Show Lines All displays the original employee expense report, displaying all lines entered on the report.
- Selecting Show Lines Project displays only expense report detail for the project code that is billed. This may include multiple lines of task detail if the employee charged to multiple WBS on the project. All other projects expense on the expense report are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
- Selecting Show Lines Bill displays expense detail for the project bill term that is billed. This may include multiple lines of task detail if the employee charged to multiple WBS on the project bill term. All other expense not on the project bill term are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
- Selecting Show Lines Single Task displays expense detail for each distinct task for the project bill term that is billed. The Bill Backup process determines which task the backup is for. All other expense not related to the task are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
Note: There is only one task listed when Show Lines Single Task is selected and the task must be for the bill term that is billed.
Adjustment Details
The Bill Backup Style allows you to specify if you want Expense Report Backup Reports to be created for Adjustments. The Employee Expense Report Bill Backup Report displays adjustment lines in the adjustment detail section of the report if Show Adjustments has been selected for a Backup Type of Expense Report on the Bill Backup Style.
|
Note: For Bill Backup, adjustments only produces backup when the Project and Task properties have changed. |
Adjustment lines display that belong to the Expense Report and are based on the backup level in use.
The following rules apply:
- Selecting Show Lines All displays all lines that were entered on the original employee expense report. When Show Adjustments is selected, and the backup line is an adjustment, all adjustments for the expense report that are bill Items on the Prebill will be displayed.
- Selecting Show Lines Project displays expense report detail for the project code that is billed. This may include multiple adjustment lines if the employee expense report had adjustments to multiple tasks on the project / bill term that is billed. All other projects expense on the expense report are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
- Selecting Show Lines Bill displays expense detail for the project bill term that is billed. This may include multiple adjustment lines if the expense report had adjustments to multiple tasks on the project / bill term that is billed. All other expense not on the project bill term are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
- Selecting Show Lines Single Task displays expense detail for each distinct task adjustment for the project bill term that is billed. The Bill Backup process determines which task the backup is for. All other expense not related to the task are lumped together in one single row and display as Other under the receipt column. These other expenses are included in the total amount.
Note: There is only one task (adjustment) listed when Show Lines Single Task is selected and the task must be for the bill term that is billed.
Audit Trail
The Audit Trail area displays on the report if Bill Backup Style property Show Audit Trail is selected for the Backup Type of Expense Report. This displays Workflow Transitions that have occurred on the Employee Expense Report.
| Field | Description |
|---|---|
| Date / Time | Displays the event date and time. |
| User Name | Displays the user's full name. |
| Action | Displays the project code when project code changes. |
| State | Displays the state name. |
| Comments | Displays any associated comments. Comments supports word wrap. |