Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 9 Next »

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. 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.

     Click here for a table with financial quarters.
    QuarterStart DateEnd Date
    Q11/1/YYYY3/31/YYYY
    Q24/1/YYYY6/30/YYYY
    Q37/1/YYYY9/30/YYYY
    Q410/1/YYYY12/31/YYYY
  • A complete year—1/1/YYYY – 12/31/YYYY.

Correct entry

The image below shows rows in the spreadsheet populated with the correct entry types:

Incorrect

The image below shows rows in the spreadsheet populated with incorrect entry types:


Entering rate overrides in the Adjustments template CSV file

As explained above, all rate override entries must be entered as complete periods, quarters, or years. However, there are instances when you want to add an override from a time frame that does not meet the required criteria. In these instances, use separate records for each job—that is, use separate spreadsheet rows to segment the time into acceptable time frames.

  • No labels