tkUsing the Import Hours and Rates Adjustments CSV file, you can add a batch of hours and rates adjustments for a property.
Process for importing hours and
...
rates adjustments
Follow the steps below to add hours and rates adjustments to the CSV file and import the file to
| Include Page | ||||
|---|---|---|---|---|
|
- (Optional) Export T&A Codes.
- Complete spreadsheetUpload the CSV files.
- Import the CSV file
...
- .
| Anchor | ||||
|---|---|---|---|---|
|
...
Completing the CSV file
W
...
Although exporting the T&A Codes is an optional step, it will help you avoid mistakes when entering values in the Hours and Rates Adjustment CSV import file.
To export the T&A Codes screen:
- In the toolbar, click the System Setup icon (
). - From the drop-down list, select Time & Attendance > T & A Codes.
The T & A Codes screen appears. - If necessary, click the Filter icon (
) and select the types of codes to display on the screen. - Click Export.
A dialog box appears. The message asks whether you would like to export assignments. - Click No.
- Select the destination folder for the exported file.
- Click Open.
A dialog box appears to confirm that your file was exported successfully. - Click OK.
The dialog box closes.
| Anchor | ||||
|---|---|---|---|---|
|
| Tip |
|---|
Tip: UniFocus recommends that you first complete a CSV file that includes only your average rate adjustments, then you complete another CSV file that contains hours and rate adjustments that are not average rate adjustments. The first file contains only adjustments for which Y (Yes) is selected for Job Rate Override; the second file contains only adjustments for which N (No) is selected for Job Rate Override. See the field description table below for more information. |
Open the Import Hours and Rates Adjustment CSV file.
Click here to open the Import Hours and Rates Adjustment CSV file.Info icon false Note: If you are unable to open the file or have any problems completing the file, contact your UniFocus Partner Relationship Manager.
In the worksheet, enter each adjustment in a separate row. For each adjustment, complete the fields as necessary.
Expand title Click here for field descriptions. Include Page Import Hours and Rate Adjustment CSV file Import Hours and Rate Adjustment CSV file - Save the file to your computer as a CSV file.
| Anchor | ||||
|---|---|---|---|---|
|
| Tip |
|---|
Tip: UniFocus recommends that you first import a CSV file that includes only your average rate adjustments, then you import another CSV file that contains hours and rate adjustments that are not average rate adjustments. The first file contains only adjustments for which Y (Yes) is selected for Job Rate Override; the second file contains only adjustments for which N (No) is selected for Job Rate Override. See the field description table above for more information. |
tk
...
- In the toolbar, click the Main Menu icon (
). - From the drop-down list, under the Financial section, select Budgeting.
The Budgeting screen appears in a separate tab. - In the Adjust Hours and Rates row, click Update.
The Adjust Hours and Rates screen appears. - Click Related Tasks and select Import Adjustments from the drop-down list.
The Add New Adjustment dialog box appears. - Click Browse.
- Select the file from your computer.
- Click Open.
The Import File field updates with the selected file name. - Click Add.
- Click Save (
).Click Refresh ( 
).
The
Fields in the hours and rate adjustment .CSV file
...
Reconcile Code
...
Name of the job to which the adjustment is applied
You must enter the full path
...
Value for the adjustment.
The number can be for either dollar values or hours
...
REQUIRED.
Numeric only.
You can positive or negative values.
...
Enter the type of adjustment:
- RAT—Rate adjustment
- HRS—Hours adjustment
- OT—Overtime Adjustment
...
The screen updates and displays your imported adjustments.