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