The Importing hours and rates adjustments page describes the process for exporting the Adjustments Template CSV files, completing the file, and then importing it into the Budgeting application. As recommended by UniFocus, you should have a file that contains only your average rate adjustments (that is, rate adjustments marked Y for the Job Rate Overrides) and another file that contains only hours and rate adjustments that are not average rate adjustments.
Time frames for overrides
When completing the CSV file that includes only your Job Rate Overrides, the time frame specified in the Start Date and End Date fields must define one of the following options (assuming that the standard calendar month is a financial period and the years is from January through December):
- A complete financial period (or month)—1/1/YYYY – 1/31/YYYY, 2/1/YYYY – 2/28(9)/YYYY, 3/1/YYYY – 3/31/YYYY, …etc.
A complete quarter—Q1 is 1/1/YYYY – 3/31/YYYY, Q2 is 4/1/YYYY – 6/30/YYYY, Q3 is 7/1/YYYY – 9/30/YYYY, Q4 is 10/1/YYYY – 12/31/YYYY.
Expand title Click here for a table with financial quarters. Quarter Start Date End Date Q1 1/1/YYYY 3/31/YYYY Q2 4/1/YYYY 6/30/YYYY Q3 7/1/YYYY 9/30/YYYY Q4 10/1/YYYY 12/31/YYYY - A complete year—1/1/YYYY – 12/31/YYYY.
Correct and incorrect entries
Correct
The image below shows rows in the spreadsheet populated with the acceptable correct entry types:
Incorrect
The image below shows rows in the spreadsheet populated with incorrect entry types:
