Working with Expenses

The expense report is the primary vehicle available for the collection of expense entries.  

Topics covered on this help page include:

• Adding a new Expense Report

• • Purpose   (specify the purpose and projects for the expense report)

  • Details   (the anatomy of the expense report body)

• Expense Validations   (validation processes)

• Previewing Expenses   (for a standard printable view of expenses)

• Allocation View of an Expense Report   (preview version showing project allocation splits)

• Expense Type Thresholds

• Expense Requests   (request authorization for an expense)

• Attachments

• Copying existing Expense Reports and Expense Requests

You may also be interested in:

• Listing Active and Completed Expenses   (Expense >> List  menu option)

• My Projects   (user screen used to help manage which Projects and Tasks will appear in the expense report drop downs)

• Printing Tips   (a few browser suggestions for improving printed output)

• Transferring Imported Credit Card Expenses  (property driven feature allowing a user to include imported credit card transactions on an expense report)

• Expense Statuses   (review the sequence of statuses an expense report progresses through)

• AutoLock  (property driven feature allowing COMPLETED expense reports to immediately graduate to a LOCKED status)

• Reclaim Tax  (optional feature to enable additional fields to capture Value Added Tax information)

• Expense Wizards  (for more information about the built-in Wizards for various expense types)

Adding a new Expense Report

To initiate the creation of a new expense report, simply click on the () expense add icon.  This icon is available on a number of dashboards as well as on the Expense >> List screen.  Clicking on this icon will present the user with a new expense report Purpose screen.

If the unasense.email.required property is being used, users will not be allowed to create and submit an expense report without having an email address specified in their user profile.

Expense Report - Purpose

There are two main screens associated with the creation of an expense report.  The Purpose screen and the Details screen (there may be other popup wizards as well).   Displayed below is an example expense report Purpose screen.

Field Descriptions (click on a link below for additional information)

If the unasense.expense.org.display property is being used, the Project Organization code may be suppressed in your editable and preview expense reports / requests.

Likewise, if the unasense.project.title.display property is being used, you may see the Project Title concatenated onto the Project Code in your editable and preview expense reports / requests.  

Button Descriptions (click on a link below for additional information)

Expense Report - Details

The details screen is the main vehicle for entering expense line items.  You can navigate to this screen from the Purpose screen when adding a new expense report or you will directly access this screen whenever editing an existing expense report.

Field Descriptions (click on a link below for additional information)

If the unasense.expense.org.display property is being used, the Project Organization code may be suppressed in your editable and preview timesheets.

Likewise, if the unasense.project.title.display property is being used, you may see the Project Title concatenated onto the Project Code in you timesheet and preview timesheet.  

If the unasense.corpcard.reimburse property is set to true, those line items having a payment method of "Corp. Card" will be treated as reimbursable expenses, otherwise, if set to false, those items will not be included in the Total Reimbursement amount.

An additional total "Total Overage" will appear in the expense report preview only when there are expenses of type LODGING_ALLOWABLE or MIE_ALLOWABLE.  It will reflect the sum of all the numbers displayed in the Total Overage field of the wizard itself.  MIE Per Diem and Lodging Per Diem overages are not included in this total.

Button Descriptions (click on a link below for additional information)

Expense Report Validations

When you save an expense report, you may encounter two general types of errors.  First, those errors that prevent the saving of your expense report (e.g. you've entered an invalid character in a numeric field), and secondly, entries that are syntactically correct, but may violate an assignment or some other rule.  In the latter case, the expense report will save successfully, however, you will see the error messages displayed across the top of the screen.  Expense report submittal will not be allowed if theses types of errors exist.  Below is an example of this type of error message.

In addition to the business rules defined by setting project profile options, assignment date ranges, etc. you can also create additional customized validations using the Expense Stored Procedure feature.

Previewing Expense Reports

In addition to the editable version of the expense report, users can also view a non-editable preview version.  This version may be more suitable for purposes of creating a printed copy (also see the Print Friendly icon).

Which sections are collapsed upon initial display of the expense report preview can also be configured by your administrator via the various  unasense.preview.expand properties.  If you desire to review the details in these sections, you can expand or collapse these sections using the  or ( or ) controls.

If the unasense.expense.org.display property is being used, the Project Organization code will be suppressed in your editable and preview expense reports.

Note that whether the list of Approval History section is available for viewing by users having the customer role during approvals is controlled via the unasense.customer.view_approval_history property.

Allocation View

If an expense report has more than one project identified on the Project Allocation portion of the Purpose screen, then an additional Allocate button will be visible on the expense preview.  Clicking on this button will present an alternative preview version detailing the allocated amounts.  An example allocation preview follows:

Expense Type Thresholds

Expense users can view the current thresholds of each expense type (as defined by the Unanet Administrator via the Admin >> Setup Expense Types screen).  By pressing the Threshold button, users will see a window pop up similar to the one shown below:

If a threshold is exceeded for an expense type (on any particular line item), you will see a warning icon () next to that detail line.  

Expense Requests

Expense Requests are very similar to Expense Reports.  The purpose of an expense request is to request authorization for an expenditure. The process of creating and submitting an expense request is nearly identical to that of creating an expense report.   

To initiate the creation of a new expense request, simply click on the () expense request add icon.  This icon is available on a number of dashboards as well as on the Expense >> List screen.  Clicking on this icon will present the user with a new expense request Purpose screen (you'll notice a background watermark to remind you that this is a request rather than a report).

Once a Request has been submitted and approved, that Request becomes and active Expense Report for that user.  The expense report can then be further modified and submitted at a later time.  The original approved expense request remains available for viewing (in it's unaltered state).

Expense Requests have slightly different statuses than Expense reports.  Check out the statuses help page for more information.

Attachments

When editing an Expense Report or Expense Request, users have the ability to attach documents.  This feature may be useful for example if your policy requires you to attach an electronic copy of an expense receipt to each voucher, but may also be used to attach any type of document (e.g. perhaps this is a request for an equipment purchase and you may desire to attach the equipment specs).  

Note: The Unanet Administrator may want to suggest guidelines with regards to what types of files may be acceptable to be used as expense attachments, particularly in the case where receipts are being scanned and saved as a graphics file. Certain graphics file formats are known to result in much larger files sizes than others and you may want to consider suggesting a specific file type to help control the amount of data being stored in your database.  Generally speaking, jpg and gif files tend to be much smaller than tif and png file formats.

To assist with the management of allowable attachment types and size, the administrator can use the following three properties: unanet.attachment.max_size, unanet.attachment.invalid_file_extensions and unanet.attachment.valid_file_extensions.

While in edit mode, clicking on the Attach button will launch the following Attachment screen.

Using this screen, the user can add, remove or view an attachment.  The Save button will save the changes to the attachment screen and return the user to the Expense Report Edit screen.  The Cancel button will also navigate the user to the Expense Report Edit screen but without saving any changes.  Clicking on the paper clip icon will launch a new window and attempt to display the attachment (assuming your local PC knows what application to execute to view the specific file type).

Field Descriptions (click on a link below for additional information):

Who can view Attachments

Other than users having permission to edit an expense report, users such as Administrators, Managers, Project Approvers and Customers may also be able to view expense report/request attachments by clicking on the paper clip icon located on the preview version of the expense report.  

Note that whether the list of attachments are available for viewing by users having the customer role is controlled via the unasense.customer.view_attachments property.

This section will only appear if attachments exist.

Expense reports having attachments will also include an indicator in the upper right hand corner of the preview version.  Finally, note that the various Expense Lists will contain an icon to indicate attachments exist on a particular expense report (and will resemble the following):

Copying existing Expense Reports and Expense Requests

The ability to copy existing expense reports (or 'in progress' expense request) can be enabled via the unasense.enable_copy property.  When enabled, a new set of copy buttons will appear on the preview version of the expense reports (and 'in progress' expense requests). Users that have permission to add or edit an expense report on someone's behalf can create their own new expense report (or request) by copying one of that user's existing expense reports.  When the feature property is disabled, the copy buttons will not appear.

This feature may be useful in cases where your users may submit an expense report on a periodic basis containing the same basic items, and may find it easier to copy an existing expense report to serve as a template for the new expense report.

If your site has been configured to suppress the display of the "Add Expense Report" or "Add Expense Request" links (via menu.xml overrides), the corresponding copy expense report or copy expense request buttons will also be hidden.

The new buttons will appear below the expense report / request as follows:

Copy Rules

• The user performing the copy will become the owner of the newly copied expense report / request.
• You can only copy expense reports from users with whom you have permission to create or edit expense reports for.
• If the expense report being copied has an associated expense request, the request would not also be copied.
• The copied expense report will be left in the INUSE status.
• All dates will be the same as the original expense report line item dates.
• The copy will be prevented if the expense report has any inactive projects.
• Only those line items having active expense types (allowed for a given project) will be copied.
• Should a user no longer have an assignment for a particular project/task, the copy will be allowed, however the Save validation will report the issue (and the expense report cannot be submitted).
• Line items having a wizard will have all wizard details also copied.
• Line items associated with an imported credit card transactions will not be copied.
• Expense attachments will not be copied.
• The approval history of the original expense report will not be copied.
• When copying an expense report to an expense request:  
• • if any "overage" / related expense types were used on the original expense report (ie Lodging_Unallowable, MIE_Unallowable) and those expense types are not allowed on an expense request -- the "overage" record will not be copied (otherwise the values will remain the same).
• Expense reports in any status can be copied.  Expense Requests in any status except AUTHORIZATION_APPROVED can be copied.