Expense Type Wizards

Una$ense comes with 10 pre-defined expense types which have wizards.  These wizards assist with the collection of additional expense information.  

This help page provides an example for each of the built-in wizards, including:

Note: All wizards contain the "Comments" field, Save and Cancel buttons.


AIR

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor N

Select a Vendor for the list of available Vendors.  Note 'Preferred Vendors' are marked with an *. If the expense type has been defined as requiring a vendor, either this field or the next will be required.

Vendor Name N

If the appropriate Vendor name is not available in the Vendor drop down list, enter the vendor name in this field.  If the expense type has been defined as requiring a vendor, either this field or the previous will be required.

Departed From Y

Specify the location where the travel originated.

Arrived At Y

Specify the location where the travel terminated.

Departure Date Y

Specify the date the travel originated.

Return Date N

Specify the date the travel originated.

Ticket Number N

Enter the airline ticket number.

Expense Amount Y

Enter the amount of the expense.

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 


CASH-RETURN

Field Name Required Description
Your Check Number Y

For tracking purposes, enter the check number of the check with which you are returning funds previously advanced.  Note: the CASH-RETURN expense type can only be used in conjunction with an accompanying ADVANCE expense type (on the same expense report).

Amount you are returning Y

The amount of the unused Advance that is being returned.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Amount you are returning 


CELL-PHONE

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor Name N

Enter the vendor name in this field.  If the expense type has been defined as requiring a vendor,  this field will be required.

Total Charges Y

Enter the total amount of the bill.  

Note: the values necessary for this and the next two fields may vary depending on your company policy.

Monthly Service Charge N

Enter the amount of the monthly service charge.  

Note: the values necessary for this and the next two fields may vary depending on your company policy.

Personal Calls N

Enter the amount of any personal calls.  

Note: the values necessary for this and the next two fields may vary depending on your company policy.

Total Phone Call Expense Calculated

This field is calculated as follows:

Total Charges - Monthly Service Charges (which may include taxes)

Total Business Call Expense Calculated

This field is calculated as follows:

Total Phone Call Expense - Personal Calls

Percentage of Business Calls Calculated

This field is calculated as follows:

Total Business Call Expense / Total Phone Call Expense

Prorated Service Charge and Taxes Calculated

This field is calculated as follows:

Percentage of Business Calls * Monthly Service Charge

Total Business Telephone Expense Calculated

This field is calculated as follows:

Total Business Call Expense + Prorated Service Charge and Taxes

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Total Business Telephone Expense 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 


COMPANY-CAR


ENTERTAINMENT

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor Name N

Enter the vendor name in this field.  If the expense type has been defined as requiring a vendor,  this field will be required.

Location Y

Specify the location of the activity.

Activity Y

Enter a description of the activity.

Purpose Y

Enter the purpose of the entertainment expense.

People, Title, Affiliation Y

List the People attending, their Titles and affiliation to you.

Discussion Took Place Y

Select whether the business related discussion took place before, during or after the entertainment event.

Expense Amount Y

Enter the amount of the expense.

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 


LODGING

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor N

Select a Vendor for the list of available Vendors.  Note 'Preferred Vendors' are marked with an *. If the expense type has been defined as requiring a vendor, either this field or the next will be required.

Vendor Name N

If the appropriate Vendor name is not available in the Vendor drop down list, enter the vendor name in this field.  If the expense type has been defined as requiring a vendor, either this field or the previous will be required.

Check in Date Y

This is the date you checked into the lodging establishment.

Location Y

Enter the location of the lodging establishment.

Nights Charged Y

This is the number of nights that you were charged for lodging.

Daily Room Rate N

This is the amount you were charged for the room.  Your company policy will determine what may be included in this field.  Either 'Daily Room Rate' or 'Daily Tax Rate' is required.

Daily Tax Rate N

This is the amount you were charged for the room tax (if you are required to break out this amount for reporting purposes).  Your company policy will determine what may be included in this field.  Either 'Daily Room Rate' or 'Daily Tax Rate' is required.

Expense Amount Calculated

This field is calculated as follows:

Nights Charged * (Daily Room Rate + Daily Tax Rate)

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 


MILEAGE

Field Name Required Description
Date of Trip Y

This is the date the travel was incurred.  This date will correspond to the expense line item date.  The Mileage Rate will be determined based on this date.

From Location Y

Specifies the starting point for the travel.

Destination(s) Y

Specify the destination or destinations visited during the travel.

Total Miles Y

Enter the total miles driven on the trip eligible for reimbursement.

Mileage Rate Calculated

The mileage rate associated with the 'Date of Trip'.

Amount Calculated

'Total Miles' times 'Mileage Rate'.


EMP_BUS_MTG

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor Name N

Enter the vendor name in this field.  If the expense type has been defined as requiring a vendor,  this field will be required.

People Y

Enter the names of all the individuals that attended the Business Meeting.

Attendees Y

Provide the number of people attending the Business Meeting.

Total Amount Y

Enter the total expense amount for the Business Meeting.

Amount Applied Against Daily Meal Cap Calculated

This field is calculated as follows:

Total Amount / number of Attendees

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 


LODGING_PER_DIEM

A Lodging per diem allowance is a fixed maximum amount allowed for a single day’s lodging expenses, excluding taxes, during business travel.  The actual allowance amount typically varies by location and time of year.  Lodging per diem expenses are reported and calculated on a daily basis, and require that the actual incurred expense amounts be captured.  The reimbursable amount for a lodging per diem is the lesser of the actual incurred lodging expense, excluding taxes, or the lodging per diem allowance for the reported location and date.  Additionally, the percentage of lodging taxes attributable to the incurred lodging expense amount that is less than or equal to the per diem allowance is also reimbursable as part of the lodging per diem.

Actual incurred lodging expense amounts that exceed the lodging per diem allowance are considered overage and are not reimbursable as part of the per diem expense.  Likewise, the percent of lodging taxes attributable to lodging overage is considered tax overage and is also not reimbursable as part of the per diem expense.  Una$ense will calculate the lodging and tax overage amounts, but will not automatically generate additional expense items to represent the overage amounts.  Those amounts will show up in both the wizard and in the wizard summary on the main details page.

 

Field Name Required Description
Receipt Provided N

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided N

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor N

Select a Vendor for the list of available Vendors.  Note 'Preferred Vendors' are marked with an *. If the expense type has been defined as requiring a vendor, either this field or the next will be required.

Vendor Name N

If the appropriate Vendor name is not available in the Vendor drop down list, enter the vendor name in this field.  If the expense type has been defined as requiring a vendor, either this field or the previous will be required.

Date Y

This is the date the lodging expense was incurred.  This date will correspond to the expense line item date. The per diem rates will be determined based on this date.

Country/State Y

Select the region (Country or State) that most closely matches the location associated with the lodging expense.  Once this value is selected, the relevant 'City/County' choices will be populated.

City/County Y

Select the region (City or County) that most closely matches the location associated with the lodging expense.  The values in this list correlate to the item selected in the previous drop down list.

Per Diem Allowance Calculated

This value is looked up based on the 'Date', 'Country/State' and 'City/County' entries.

Daily Room Rate N

This is the amount you were charged for the room.  Your company policy will determine what may be included in this field.  Either 'Daily Room Rate' or 'Daily Tax Rate' is required.

Daily Tax Rate N

This is the amount you were charged for the room tax (if you are required to break out this amount for reporting purposes).  Your company policy will determine what may be included in this field.  Either 'Daily Room Rate' or 'Daily Tax Rate' is required.

Total Amount Calculated

This field is calculated as follows:

Daily Room Rate + Daily Tax Rate

Rate Overage Calculated

This field is calculated as follows: See examples below.  Also see Overage Note below.

Tax Overage Calculated

This field is calculated as follows: See examples below.  Also see Overage Note below.

Total Overage Calculated

This field is calculated as follows: See examples below.  Also see Overage Note below.

Reimbursable Amount Calculated

The reimbursable amount for a lodging per diem is the actual incurred daily lodging expense less any lodging and/or tax overage amounts for the reported location and date. 

See examples below.

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 

Lodging Per Diem Reimbursement Amount Calculations - Examples

Using the following possible reference data values:

Country/State City/County Lodging Allowance
Virginia Reston $119.00

Consider the following examples:

Example 1: You have an overnight stay for your trip in Reston, Virginia.  Your daily room rate for that evening was $85.00 and your daily room tax was $8.50. 

Since your actual lodging expense was less than the per diem lodging allowance, the full amount for both lodging and taxes is reimbursable.  Your actual reimbursement amount would be:

Lodging Reimbursement = $85.00 + $8.50 = $93.50

Example 2: You have an overnight stay for your trip in Reston, Virginia.  Your daily room rate for that evening was $148.75 and your daily room tax was $14.88.

Since your actual lodging expense exceeded the per diem lodging allowance, the full amount for both lodging and taxes is not reimbursable.  Your actual reimbursement amount would be the per diem allowance and the percentage of the tax amount attributable to the allowable lodging expense:

Allowable Lodging Expense = $119.00

Allowable Tax Percentage = $119.00 / $148.75 = 0.80

Allowable Tax Expense = $14.88 * 0.80 = $11.90

Lodging Reimbursement = $119.00 + $11.90 = $130.90

 

Lodging Overage = $148.75 – $119.00 = $29.75

Tax Overage = $14.88 – 11.90 = $2.98

Total Overage = $29.78 + $2.98 = $32.73

 

Overage Note

If the saved lodging per diem details contain a non-zero overage amount, the lodging per diem expense will be "red flagged" on the expense details screen as exceeding the expense type's threshold.  Depending upon company policy, lodging overage amounts may need to be entered as a separate expense item.

 

Click here for additional information regarding Per Diem rate schedules.


MIE_PER_DIEM

A M&IE (Meals and Incidental Expense) per diem allowance is a fixed amount allowed for a single day’s meals and incidental expenses during business travel.  The actual allowance amount typically varies by work location and time of year.  M&IE expenses are reported on a daily basis, and do not require that the actual incurred expense amounts be captured.  Each reported M&IE expense will result in a single line item on a Unanet Expense Report.  The reimbursable amount for a M&IE per diem is the daily M&IE allowance for the reported location and date, less the allowance for meals provided, pro-rated for partial days.

Field Name Required Description
Date Y

This is the date the M&IE expense was incurred.  This date will correspond to the expense line item date. The per diem rates will be determined based on this date.

Country/State Y

Select the region (Country or State) that most closely matches the location associated with the M&IE expense.  Once this value is selected, the relevant 'City/County' choices will be populated.

City/County Y

Select the region (City or County) that most closely matches the location associated with the M&IE expense.  The values in this list correlate to the item selected in the previous drop down list.

Per Diem Allowance Calculated

This value is looked up based on the 'Date', 'Country/State' and 'City/County' entries.

Travel Day N

Checking either First Day or Last Day will cause the respective pro-ration factor to be applied to the reimbursement amount.  

Meals Provided N

Checking any of the Meals Provided check boxes will cause the respective meal amount to be subtracted from the per diem allowance amount.

USD Amount Calculated

The reimbursable amount for a M&IE per diem is the daily M&IE allowance for the reported location and date, less the allowance for meals provided, pro-rated for partial days. 

See example below. 

M&IE Per Diem Reimbursement Amount Calculations - Examples

Using the following possible reference data values:

M&IE Per Diem Allowance Schedule

Country/State City/County M&IE Allowance
Virginia Reston $46.00

M&IE Per Diem Allowance Breakdown

M&IE Rate Breakfast Lunch Dinner Incidentals
$46.00 $7.00 $11.00 $18.00 $9.00

M&IE Per Diem Allowance Pro-Ration Policy

Only ¾ of the M&IE allowance will be reimbursed for partial working days (first and last day of travel).

Consider the following example:

Example: You leave home at 6 am on Monday morning for your trip to Reston, Virginia.  You worked in Reston through Thursday.  You arrived back at home at 7 pm on Thursday evening.  On Wednesday and Thursday lunch was provided for you at your work location.

Your M&IE calculations would account for the first and last days of your trip as partial days, and the two lunches that were provided would be deducted from the M&IE allowance for the days in which the meals were provided.  The M&IE expense calculations would yield the following:

 

Day M&IE Rate Breakfast Reduction Lunch Reduction Dinner Reduction Pro-Ration Factor Reimbursement Amount
Mon. $46.00       75% $34.50
Tues. $46.00         $46.00
Wed. $46.00   $11.00     $35.00
Thu. $46.00   $11.00   75% $26.25
         

Total:

$141.75

 

Monday’s Reimbursement           = $46.00 * 0.75 = $34.50

Tuesday’s Reimbursement          = $46.00

Wednesday’s Reimbursement    = $46.00 - $11.00 = $35.00

Thursday’s Reimbursement         = ($46.00 - $ 11.00) * 0.75 = $26.25

 

Click here for additional information regarding the M&IE Breakdown


Generic Wizard

Field Name Required Description
Receipt Provided Optional

This check box indicates that a receipt will be provided with the expense report.  If the expense type has been defined as requiring a receipt, either this field or the next will be required.

Receipt Provided Optional

If no receipt will be provided, specify a reason.  If the expense type has been defined as requiring a receipt, either this field or the previous will be required.

Vendor Name Optional

Enter the vendor name in this field.  If the expense type has been defined as requiring a vendor,  this field will be required.

Expense Amount Y

Enter the amount of the expense.

VAT Amount N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the next (VAT Location) is supplied, both fields are required.

VAT Location N

If your system has been configured to allow for the capture of VAT (Value Added Tax) information, this field will appear, otherwise, it will not.  Even if it does appear on the screen, however, the system does not require entry.  If, however, either this field or the previous (VAT Amount) is supplied, both fields are required.

Currency Used Y

This field will default to your system default currency, or the value specified in each user's custom Profile.  If the expense was incurred in a currency other than your system default, you'll want to select the appropriate currency. 

Exchange Rate Y

This field will default to 1.  If you have specified a 'Currency Used' in the previous field, you will want to supply the appropriate exchange rate that was applied at the time of the transaction. 

USD Amount Calculated

This field is calculated as follows (USD label will reflect company currency label):

Exchange Rate * Expense Amount 

USD VAT Amount Calculated

This field is calculated as follows (USD label will reflect company currency label) (and may not appear on your wizard if VAT is not enabled in your system):

Exchange Rate * VAT Amount 

Return to Unanet Table of Contents page


Copyright © 1998-2002 Computer Strategies, Inc., All Rights Reserved.
Last revised: September 13, 2002 .