Overview
The Expense Sheet Import allows you to Approve/Reject Expense Sheets and import them into the Employee Reimbursables Journal so that you can issue the checks to the employees. More on Expense Sheets
Field Descriptions
Pop-up Buttons
• | Load Expense Sheets - When clicked, this takes you to the Expenses Tab. |
• | Accept All - When on the Expenses Tab, this button will mark all of the items in the Gris as "Accepted". |
• | Post Expense Sheets to E/R - When selected, all transactions in the Expenses grid will be Posted to the Employee Reimbursables Journal. You will then be prompted for the G/L period and invoice date. |
• | Reset - Resets the selections. |
• | Cancel - Cancels the Import process. |
Search Criteria Tab
Filters
Description - This tab allows the user to filter available expense sheets and establish posting accounts.
Note - When deriving G/L accounts from base accounts the system will first attempt to use the Employee Profit Center and if unsuccessful then the Project Profit Center.
• | All Employees - When selected, all employee expense sheets will be analyzed. |
• | Single Employee - When selected, only the selected employee's expense sheets will be analyzed. |
• | Transaction Cut-Off Date - When selected, only transactions As-of the selected date will appear in the Expenses Grid. |
• | Org. Unit Path - When filled out, only employees belong to this org unit, or one of its child org units will be analyzed. |
Accounts
• | Direct ODC - The Base Account must have a Metric Type of "Cost, Cost Type of "Direct" and PM Type of Other Direct Charges. |
• | Direct OCC - The Base Account must have a Metric Type of "Cost, Cost Type of "Direct" and PM Type of Out of Contract Consultants. |
• | ICC - The Base Account must have a Metric Type of "Cost, Cost Type of "Direct" and PM Type of In Contract Consultants. |
• | Indirect Exp. - The Base Account must have a Metric Type of "Cost, Cost Type of "Indirect" and PM Type of Other Direct Charges. |
• | Indirect CNS. -The Base Account must have a Metric Type of "Cost, Cost Type of "Indirect" and PM Type of Out of Contract Consultants. |
• | Error Account - Error G/L account. Used when a G/L account cannot be derived. |
• | Credit Card Clearing Account - This is the offset account for credit card line items. |
• | Employee Non-Reimbursements - This is the variance account for non-reimbursements. |
Search Criteria Tab
Description - This Tab displays all unprocessed expense sheet line items. Here you flag which line items should be processed. allows you to approve, reject and ignore expense sheets.
• | Action - A drop-down list of possible actions for the respective row. The actions are as follows: |
o | Ignore - Do not process this line item. It will be available in future conversions. |
o | Accept - The line item is approved and will be part of the created transaction. |
o | Decline - The line item is rejected and will not be part of the created transaction. The employee will not be reimbursed. |
• | Emp. Name - The name of the employee that submitted the expense. |
• | Transaction Date - The Expense Sheet Transaction Date. |
• | Charge Amount - Amount of the Expense. This includes Company Credit Card Charges that are not paid to the employee. |
• | Reimbur. Amount - Amount to be reimbursed to the employee. |
• | Credit Card - Company Credit Card Amount. This is indicated by checking the Credit Card check-box in the expense sheet. |
|