13.3.3. Exporting Expenses

Expenses can be exported to MS Excel format for reporting; both individual expenses and bulk expenses can be exported.

  1. From your login, select Timesheets, then Expenses, then Export.

  2. If you select the Individual Expense Report link, you can generate an expense report for a given user for a specific time period.

  3. You can select the details to be included in the report. Choose the date range and select the users using the checkbox, and click Continue. Click Select all to select all users at a time or click Clear all to clear the selections. If there is no expense sheet, the following message is displayed There is no expense in the system for the selected period.

  4. To export expense details for multiple users to a comma separated (CSV) file, select the Bulk Expense Export link. Here there is a provision for exporting only approved expenses. Choose the date range, select the users, and click Continue.

  5. In following screen you can rename the fields and move the fields as you wish them to appear in the report. Click on theorbutton to move the fields up or down the list, which will determine their order in the Excel sheet. In the top section, select the checkbox if you want the column names to appear as the first row in the Excel sheet. Click Export to view or save as an Excel file.

See Also:

Creating an Expense

Inbox/Outbox Portlet

Generating Expense Reports

Archiving Expenses

Reimbursements

Shared Items