Page Comparison

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

plus sign

arrow Image Added.
Click Expense Type
Click on the Add button.
Fill in the following fields

:

ID*: Enter an ID for the Expense Type. The maximum length of this field is 20 characters.
Expense Group*: Select the expense type group to which this expense type will belong.

Name*

:

Enter a name to identify the expense type. The maximum length of this field is 100 characters.

1. Restrict Access:
  1. Yes - If this expense type will only be available on reports you assign it to
  2. No - If this expense type will be available to all reports.
2. Description: Enter text to further identify the expense type. This field is limited to 255 characters.
3. 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
4. 1. 1. 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.
    2. Meals-Dinner -
5. Meals - If using the Meals Per Diem Only format.
6. Lodging - If using the Lodging Per Diem Only format.
7. General - If using a fixed rate or other format.
8. Meals-Lunch - If you are creating a meals per diem expense type allowance for just Lunch.
9. Currency:
  1. Yes - If user needs to specify a currency with the amount provided. An exchange rate field will appear if currenty 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.
10. 1. 1. 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.
    2. 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.
  2. Icon: Select an icon for this expense type
  3. 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.
  4. 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.
  5. 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.
  6. Attachments*:Field determines whether or not attachments (such as receipts) can be associated with this expense type.
    Yes - If attachments are allowed on expense type line.
    No - If attachments are not allowed on expense type line.
  7. 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.):
    Yes - If employees must select a city when entering this expense type.
    No - If no city field will appear for selection when employees enter this expense type.
11. Yes - Whenever you select Meals Per Diem Only format type.
12. 1. 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.
  2. 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.
13. 1. 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.
  2. 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.
  3. 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.
  4. Description: Enter text to further identify the expense type. This field is limited to 255 characters.
  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.
  6. 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.
  7. Online Help - Connect a website to the application through the help button at the bottom of the screen.
  8. 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
14. 1. 1. available for user to input information but will be optional.
15. 1. Track Attendee Amount*:
    1. Disabled
16. 1. 1. - Tracking of amounts by attendee is not available.
    2. Required
17. 1. 1. - If
18. Optional - If the expense type can be itemized, but it is not required.
19. The Meals Tip field determines whether employees can specify the portion of a transaction that was recorded as a tip/gratuity. If this is set to yes, a field will appear for this expense type for employees to enter a tip amount.
20. Select Disabled if alcohol is not included within the expense type (i.e. non-meal expense types).
21. 1. 1. tracking amounts by attendee are required.
    2. Optional - If tracking amounts by attendee is optional.
  2. 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.
      Info
      Once the field is selected and saved the value can no longer be updated.
  3. 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
  4. Meals Provided Label: Enter in a label to be shown to user
  5. 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.
  6. 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.
22. 1. 1. Not Reimbursable - If the alcohol expenses can be itemized within this expense type and their amounts will be non-reimbursable to the employee
23. The Attachment field determines whether or not attachments (such as receipts) can be associated with this expense type.
24. 1. 1. .
  2. 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.
  3. Unit Label: Enter in a label for the Fixed/Mileage field.
  4. 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
        Rate based on monthly number of units or miles - If rate changes based on a specific number per month.
        Rate not based on Threshold. - If rate is not based on a threshold.
        Rate based on yearly number of units or miles. Year starts January - If the rate determination is reset every January.
        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)
25. The Recurring Charge option is to be used if you want to enable date range copy of the same charge, for example; hotel room for 5 nights.
26. The Enable Commute Mileage field is available whenever you select mileage/fixed rate format type. If you do using Commute Mileage functionality then you need to enable it at the expense type level. Default is No (Disabled)
27. The Receipt field determines whether employees need to specify whether they have a receipt or not.
  1. Select Receipt to only display a receipt option.
  2. Select VAT Receipt to only display a VAT receipt option. This clears out any VAT calculations performed by the system
  3. Select Both to display both Receipt option & a VAT Receipt option.
  4. Select No Receipt to disable both options
28. In the Grid Grouping field, enter a name that will be used as the heading for this expense type when users enter expenses using the Grid Entry view.
29. In the Online Help field, connect a website to the application through the help button at the bottom of the screen.
30. In the Expense Express Icon field, select the icon that will be displayed on Expense Express menu.
31. Click Save to save this Expense Type.
Assigning Additional Fields to ExpenseTypes
...
1. Expense Type
2. Additional Fields
3. Expense Assignment
4. OBS Assignment
...
1. Decimal
2. Integer
3. Date
4. Display Only
5. Free Text
6. Drop Down
...
1. 1. 1. 1. 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.
        No - If users do not have the option to choose how the taxes would be computed.
        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.
      2. Recurring Charge*:
        Yes - If you want to enable date range copy of the same charge, for example, hotel room for 5 nights.
        No - If a date range for the expense is not available.
    2. Click Save to save this Expense Type.
      * Indicates a required field

Versions Compared

Old Version 2

New Version Current

Key

General overview of how to create Expense Types:

Assigning Additional Fields to ExpenseTypes