Use the Expense Unit Prices tool to update one or more prices that are linked to active expense codes.
Note: Typically, expense codes are set up in advance and you cannot delete or change them. You cannot use this tool to add new expense codes - see your system administrator if you want to add or change codes.
You can update expense unit prices in the following ways:
•Upload a .csv or Excel file—Create a data file that contains the new prices, and then upload the file to TeamConnect.
•Enter new prices manually—Type the modified rates on the Expense Unit Prices page.
1.Click the Tools button in the top right corner of the page. 2.Click Expense Unit Prices from the drop-down menu. The Expense Unit Prices page opens.
 Expense Unit Prices Page
|
Creating Expense Unit Price Data Files
Before you can upload prices into TeamConnect, you must first create the file that you want to upload. You can upload an Excel spreadsheet or a .csv file.
Create an Excel spreadsheet or .csv file based on the following guidelines:
•The first row must contain labels only. •Additional rows must contain expense unit price data only Note: TeamConnect provides a sample Excel file. To access this file, click Download Sample File on the Expense Unit Prices page. The sample file opens in Excel.
|
Sample Excel File
A completed expense unit price Excel file may appear as follows:

Sample .csv File
A completed expense unit price .csv file may appear as follows:

Uploading Expense Unit Price Data
Once you create the data files, you can upload them to TeamConnect.
1.With the Expense Unit Prices page open, click Browse and locate the file that you want to upload. 2.Click Upload. The Unit Price column is updated.
Note: You can only update prices for codes that currently exist. If you try to upload prices for codes that do not exist, an error message appears and none of the unit prices are updated.
|
Updating Expense Unit Prices Manually
You can manually update expense unit prices on the Expense Unit Prices page.
1.In the Unit Price column, modify the appropriate prices. 2.Click Update to save the changes. |