Expense Sheet Import Accounts Payable>Employee Reimbursables>Toolbar>Tools

Top  Previous  Next

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

•E/R - The Base Account must have a Subledger setting of "Employee Reimbursable". More on Chart of 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:
oIgnore - Do not process this line item. It will be available in future conversions.
oAccept - The line item is approved and will be part of the created transaction.
oDecline - 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.
•Exp. Code - Expense Code of the Expense. More on Expense Codes