Expense Batch Types
Use the Batch Types screen to set up configuration information regarding batch expenses. This includes identifying default information, setting up starting and ending position information from file layouts, selecting a bill currency, determining file filters, and setting up ghost card information. Information set up in this screen is used when importing credit card files.
You should set up batch types before setting up records on the Maintain Imported Expenses screen and before importing files from a credit card feed.
Overview of the Batch Types Feature
The Batch Types feature allows you to easily import expenses charged to company-issued credit cards and generate monthly, weekly, or daily expense reports.
Deltek Expense supports the ability to import batch expenses, or "Credit Card Feeds." This is very useful if your company distributes company credit cards to your employees and you receive one or more statements detailing the expenses charged to that card. You can import the credit card statements as often as necessary - monthly, weekly, even daily. Your employees can select these imported expenses on expense reports where they can be detailed and accounted for.
Maintain Imported Expenses Screen
Once the file has been obtained, you can import it into Deltek Expense using the Maintain Expenses screen.
Use this screen to import expenses from a credit card feed, select existing records to maintain, and manually enter expenses. You can also use this screen to post these transactions so the employee can select and expense them on an expense report. You have the ability to both import expenses from a feed and manually enter them in the same batch. See the Maintain Imported Expenses Screen online help topic for details.
Using Batch Expenses
Once posted, the transactions entered in the Maintain Imported Expenses screen are available for you to select as expenses on an expense report.
The list of Outstanding Expenses will be the first screen displayed once you select the Category on an expense report. The list will contain all outstanding expenses for the Category selected plus any outstanding expenses that have a Category of "Other." After selecting the outstanding expense, you will be taken through the wizard. Any fields that are required for the Expense Type selected that were not provided in the Maintain Expenses screen will be blank and you will be required to make a selection before continuing with the expense. Some fields will already be filled out you will not be able to change them. Once selected, that expense is removed from the list of Outstanding Expenses.
- Related Topics:
- Display the Expense Batch Types Screen
You access the Expense Batch Types screen from the Time & Expense domain. - Basic Information Tab
Use the Basic Information tab to set up the batch type code, description, and source. You can also use this tab to select the bill currency and transaction currency that should be used for the batch type. - Import Options Tab
Use the Import Options tab to set up options for importing American Express, Visa, or Mastercard charges. - Ghost Cards tab
If your company uses ghost cards, use the Ghost Cards tab to set up identification values to identify which expense belongs to which employee. - Filters Subtask
The Filters subtasks displays the starting and ending positions and the value between those positions of the credit card file you want to filter as well as notes related to the filter. - Transaction Type Filter Subtask
Use the Transaction Type Filter subtask to configure the system to include or exclude them from the uploaded VISAVCF40 file or Mastercard file. - Wizard Type Identification Subtask
The fields in the Wizard type Identification Subtask display the merchants, wizard type, and pay method of the expense batch type, and whether the expense type is personal. - Ghost Card Identification Values Subtask
Use Ghost Card Identification Values subtask to identify what the starting and ending positions represent. - Generic Layout Details
The Generic Layout provides predetermined fields and is PCI (Payment Card Industry) compliant. - American Express (Amex) Record Mappings
The file that you receive from Amex has a distinct layout that identifies header and detail transaction information. There are 13 Amex KR 1025 record mapping layouts: