Expense Type Setup

Once the expense type group has been created, related expense types can be set up. In DATABASICS Expense, employees charge expenses by expense types. Expense types may be restricted and assigned to particular expense report types, WBS activities and employees.

General overview of how to create Expense Types:

Expand Expense by clicking on the arrow .
Click Expense Type
Click on the Add button.
Fill in the following fields:
1. Format Type*:
  1. Advance/Prepaid - If you are creating an expense to handle advance or prepaid purchases. These types of expenses only appear on the request for advance reports and in the advances bin.
  2. Meals Per Diem Only - If you are creating a per diem expense type that covers only meals. For these types of expenses, a user simply enters a start date and end date, and the totals get calculated based on the meals per diem rate unit (see per diem rate setup below).
  3. Lodging Per Diem Only - If you are creating a per diem expense type that covers only lodging. For these types of expenses, a user simply enters a start date and end date, and the totals get calculated based on the lodging diem rate unit (see per diem rate setup below).
  4. Fixed/Mileage Rate - If you are creating an expense based on a specific rate. For these types of expenses, a user simply enters a total number of units (such as miles or number of copies) and the total amount is calculated based on a rate per unit (see Fixed/Mileage rate setup below).
  5. Other - For all other expense types such as Airfare, Gas, etc.
  6. Max Per Diem - If you are creating a per diem expense type that covers both meals and lodging. For these types of expenses, a user simply enters a start date and end date, and the totals get calculated based on the max per diem rate unit (see per diem rate setup below).
2. ID*: Enter an ID for the Expense Type. The maximum length of this field is 20 characters.
3. Name*: Enter a name to identify the expense type. The maximum length of this field is 100 characters.
4. Expense Group*: Select the expense group from the drop down associated with the expense type.
5. Reimbursable*:
  1. Not Reimbursable to Employee - If the expense type should never be reimbursable, regardless of payment type.
  2. Depends on payment type (DOES NOT apply to Mileage/Fixed Rate) - If the expense should be reimbursed based on whether or not the payment type used is reimbursable. This does not apply to a mileage/fixed rate expense type because there is no payment type tied to those line items.
  3. Reimbursable to Employee - If the expense type should always be reimbursable, regardless of payment type (often used for mileage expense types).
6. Breakout Type*:
  1. General - Use for all other non-meal and non-lodging expense types
  2. Lodging - If using the Lodging Per Diem Only format.
  3. Meals - If an expense type is a meals expense and you would like to see the associated configuration fields, such as tips, attendees etc.
  4. Meals-Breakfast - If this expense is a meals expense type and need to see the additional setup fields such as tips and attendees, in addition if you would like to setup deductions from per diem based on this expense.
  5. Meals-Dinner - If this expense is a meals expense type and need to see the additional setup fields such as tips and attendees, in addition if you would like to setup deductions from per diem based on this expense.
  6. Meals-Lunch - If this expense is a meals expense type and need to see the additional setup fields such as tips and attendees, in addition if you would like to setup deductions from per diem based on this expense.
7. Icon: Select an icon for this expense type
8. Restrict Access:
  1. Yes - If the expense type will be restricted based on OBS or WBS assignment. This can pertain to a specific group or individual.
  2. No - If the expense type will be available for all.
9. Require Notes*:
  1. Yes - Notes field on expense type is required before the expense can be saved.
  2. No - Notes field on expense type is optional.
10. Currency*:
  1. Yes - If user needs to specify a currency with the amount provided. An exchange rate field will appear if currency is different than users home currency. This is determined on the employee profile.
  2. No - User will not have the option to select a currency and will default to the employee's home currency.
11. Attachments*: Field determines whether or not attachments (such as receipts) can be associated with this expense type.
  1. Yes - If attachments are allowed on expense type line.
  2. No - If attachments are not allowed on expense type line.
12. City*: (Note: Yes must be selected if: this is a per Diem expense type; if an expense policy rule will be created comparing this expense type to the rates in the per Diem tables; or if VAT taxes may apply to this expense type.):
  1. Yes - If employees must select a city when entering this expense type.
  2. No - If no city field will appear for selection when employees enter this expense type.
13. Tip*: Field determines whether employees can specify the portion of a transaction that was recorded as a tip/gratuity.
  1. Yes - A field will appear for this expense type for employees to enter a tip amount.
  2. No - A field will not be available for users to enter a tip amount.
14. Personal*:
  1. Yes (Always On) - If users are able to specify a portion of the business expense as non-reimbursable. This may be useful in the case a user makes a transaction on a business paid card and a portion of it should not be reimbursable.
  2. No - If users are not able to specific a portion of the business expense as non-reimbursable.
  3. Yes - Only for Credit Card Payment Type Only - For out of packet charges Personal field is disabled and it will be only enabled for Credit Card Transactions.
15. Itemization Option*:
  1. Disabled - If the expense type does not need to be itemized.
  2. Required - If the expense type should always be itemized.
    1. For out-of-pocket expenses, users will only see this expense type when they use Itemize Out-of-Pocket option.
    2. For credit card expenses, users will only see this expense type when they click on Itemize on the transaction menu.
  3. Optional - If the expense type can be itemized, but it is not required.
16. Allow Modify Description*:
  1. Yes - If description field is needed on expense type and user is able to update the description text. This field is defaulted to the expense type name.
  2. No - If description field is not needed on the expense type.
17. Description: Enter text to further identify the expense type. This field is limited to 255 characters.
18. Recurring Charge*:
  1. Yes - If you want to enable date range copy of the same charge, for example, hotel room for 5 nights.
  2. No - If a date range for the expense is not available.
19. Template Expense Type: This is used for OCR matching. If the receipt can be scanned and recognized as the category selected in this field, it will select the expense type.
20. Online Help - Connect a website to the application through the help button at the bottom of the screen.
21. Track Attendee*:
  1. Required All Fields - If user is required to enter all fields related to the attendee.
  2. Disabled - If employees do not need to list attendees for this expense type.
  3. Required Attendee and Company - If user is required to enter the attendee and company name.
  4. Required Attendee Only - If user is only required to enter in the attendee's name.
  5. Required Attendee, Title, and Company - If user is required to enter the attendee's name, title, and company name.
  6. Optional - Attendees field will be available for user to input information but will be optional.
22. Track Attendee Amount*:
  1. Disabled - Tracking of amounts by attendee is not available.
  2. Required - If tracking amounts by attendee are required.
  3. Optional - If tracking amounts by attendee is optional.
23. Per diem Hours Enabled: Only shows up if format type is set to "Meals Per Diem Only"
  1. Yes - When Per diem expense type requires tracking of user actual time out of the office.
  2. No - By default the field will be set to No but keep as No if user does not need to track the actual time out of the office.
    
    Once the field is selected and saved the value can no longer be updated.
24. Meals Provided: By default, the field will Yes, if users will need to indicate while meals were provided leave it as is. If not, select No
25. Meals Provided Label: Enter in a label to be shown to user
26. The following fields are related to Meals and Max Per Diem set up:
  1. Full Day: Enter in a label to the shown to the user and also check the box "Enable" if the option will be available for users to choose from for Out of Office. This is based on the Allowance Rule setup.
  2. Three Fourths Day: Enter in a label to the shown to the user and also check the box "Enable" if the option will be available for users to choose from for Out of Office. This is based on the Allowance Rule setup.
  3. Half Day: Enter in a label to the shown to the user and also check the box "Enable" if the option will be available for users to choose from for Out of Office. This is based on the Allowance Rule setup.
  4. One Forths Day: Enter in a label to the shown to the user and also check the box "Enable" if the option will be available for users to choose from for Out of Office. This is based on the Allowance Rule setup.
  5. Default First Day*: Select the value defaulted for the first day. For example, if the first day gets 50% of the per diem, select the out of office set up for 50%. This could be the half day option depending on the allowance rule set up.
  6. Default 1 Day*: Select the value defaulted for the days in between. For example, if the second day gets 100% of the per diem, select the out of office set up for 100%. This could be the full day option depending on the allowance rule set up.
  7. Default Last Day*: Select the value defaulted for the last day. For example, if the last day gets 25% of the per diem, select the out of office set up for 25%. This could be the one Forths day option depending on the allowance rule set up.
27. Alcohol Tracking*: This field is only available if Breakout Type is set to any of the "Meals" type.
  1. Disabled - If alcohol tracking is not available.
  2. Reimbursable - If alcohol expenses can be itemized within this expense type and their amounts will be reimbursable to the employee.
  3. Not Reimbursable - If the alcohol expenses can be itemized within this expense type and their amounts will be non-reimbursable to the employee.
28. Track Odometer:
  1. No - If users are not required to enter in odometer reading for mileage reimbursement.
  2. Yes - If users are required to enter in their odometer reading for mileage reimbursement.
29. Unit Label: Enter in a label for the Fixed/Mileage field.
30. Unit Options:
  1. Default Unit Amount equal 1 Only - If an expense will always be one fixed value. Example: User always gets $50 for cell phone reimbursement.
  2. Mileage/KM Options - User gets to choose between miles or km.
  3. Disabled - No option is available
  4. Enabled - Will show a field based on the name entered in Unit Label.
  1. 1. Unit Rate Type
      1. Rate based on monthly number of units or miles - If rate changes based on a specific number per month.
      2. Rate not based on Threshold. - If rate is not based on a threshold.
      3. Rate based on yearly number of units or miles. Year starts January - If the rate determination is reset every January.
      4. Rate based on yearly number of units or miles. Year starts April - If the rate determination is reset every April.
    2. Enable Commute Mileage*: If you would like for users commute mileage to be deducted from their mileage reimbursement. User must set up their commute mileage in their profile.
    3. Tax 1 Code (and Tax 2 field): Indicate whether a tax field will be present for this expense type (set up in Taxes)
    4. Compute Tax Optional*: Allows users to indicate if tax should be auto calculated or manually entered. This is dependent on Tax 1 Code and or Tax 2 Code field to be selected. If auto compute is expected, a rate will need to be set up in the Tax Rate set up.
      1. No - If users do not have the option to choose how the taxes would be computed.
      2. Yes - If users have the option to have application auto compute the taxes based on the business amount if the Tax set up is completed, or users have the option to manually type in the tax amount.
        With this option the users will see the "Tax Included" box that will be checked by default. If this box is left checked, the amount put into the business field will business amount + tax and the application will split it out based on the tax set up.
        If the "Tax Included" box is unchecked, then the tax(es) will be auto computed based on the business amount and the tax set up.
        Users can uncheck the "Auto Compute Tax" Field to enter in the tax(es) manually.
    5. Recurring Charge*:
      1. Yes - If you want to enable date range copy of the same charge, for example, hotel room for 5 nights.
      2. No - If a date range for the expense is not available.
  2. Click Save to save this Expense Type.
    * Indicates a required field