Rates

In DOVICO Timesheet, Rates are the hourly pay and billing rates assigned to employees. Rates are multiplied by employee hours to calculate client and company costs. If you are not concerned with client and company costs, then rates are not required.

 

This topic describes how to (1) create rates, (2) edit rates, and (3) how to retroactively enter rates after the system has been used for a period of time.

 

If you are tracking both company and client costs, you should create two types of rates for each employee or category of employee within your organization:
 

1. Rate of wages (pay rate): The employee’s hourly paid salary plus benefits used to calculate company costs. If you are using Rate of wages for payroll purposes, then there is no need to create this type of rate.

 

Company cost = hours worked x rate of wages x overtime prorating

 

2. Rate charged (billing rate): The employee’s hourly charge out (billable) rate used to calculate client costs. If you are using rates for payroll purposes only or if you do not bill (or charge back) clients, then Rate charged is not needed.

 

Client cost = hours worked x task prorating x rate charged x overtime prorating

 

Rates are displayed in the Employees view as an optional selection. As a result, any rate can be assigned to employees. The Rates view is also the location where Overtime Rates An Overtime Rate is a prorating (multiplier) assigned to employee wage and charge out rates. When employees work overtime, they can select one of the assigned overtime rates, and the appropriate client or company costs are calculated.are assigned to Rates.

 

Prerequisite:

To add a new rate:

  1. Click the Rates button located in the Rates & Billing section of the side navigation bar.

  2. Click the New button on the toolbar

  3. Enter a unique name for the rate (up to 50 characters). As rates are usually created for either employees or categories of employees within your organization (John Smith, Mary Ford, Engineer, Senior Engineer, Project Manager), it is a good practice to clearly name each rate you create. For example “Engineer Wage Rate” for Rate of wages and “Engineer Charge Out Rate” for Rate charged.

  4. Enter the Rate per hour amount. When editing a rate, a More button is displayed to offer more options. When creating a new rate, this button can be ignored.

  5. Click Save .


    OPTIONAL INSTRUCTIONS:

  6. Enter a description (up to 250 characters).

  7. From the Available Overtime Rates list near the bottom of the screen, select the overtime rates which apply to this rate and click the Add button on the right-hand side.

  8. Check the Hide box if you want to hide this rate from lists when generating reports.

  9. Check the Flag for archive box if you want to remove this rate from the database the next time the Archive Database function is run.

  10. Click Save .

 

Once the rates are created, go to the Employees view to assign the appropriate rates to employees.

 

To edit a rate:

  1. Select a row and edit information as needed.

  2. If you edit the rate, a More button will appear. Click the button to select your update preferences.

  3. Click OK after making your update selection. If you have selected Replace last value only, or Replace all values from, a message box will appear to advise that the change applied is permanent and cannot be undone. Click OK to continue or Cancel.

  4. Click Save .

 

To apply rates after using the system for a period of time:

  1. Enter the rates in the Rates view if they do not currently exist.

  2. For each employee receiving the new rates, open that employee's properties window, and select the new rates using the appropriate drop-down lists (Rate of wages and Rate charged).

  3. For each modified rate, click the More button next to the rate field, a pop-up window opens.

  4. Select the Replace all values from option.

  5. Select a date that will span all previous time entries for this employee. This will apply the rate to all past and future timesheet entries.

  6. Click OK.

  7. Click Done.

  8. Repeat steps 2 through 7 for other employees as required.

 

Note: The number of rates displayed in the view is limited by the Paging setting. You may need to click the paging buttons or (at the top of the screen) to view additional record pages.

 

Tips:  

  • See Hints & Tips on instructions for applying a single rate for an entire project.

  • The term "Rate" can also be customized to better fit your company's terminology.

  • Additional tabs are available at the bottom of the rates view to add Notes, Phone Numbers and Addresses.

  • Use the Show/Hide column function to personalize what information is displayed in the rate view's grid.

  • You can add fields to track extra rate information by using Custom fields .

  • Use the Find function to locate a specific rate by name.