Collapse AllExpand All

3.3. Worksheets

Worksheets are documents used to capture time and expenses for Employees and Contractors. When Worksheets are created, they appear on this workbench screen where managers can review and approve them all in one place.

Note

For more information on using Worksheets to help manage projects, please see the eBook Managing Projects with xTuple.

The following set up information will help ensure your Worksheets are complete when you process them:

Employees

Should have compensation rate defined, but billing rate is optional. The compensation rate is used to determine the labor cost of Employees when their time entries are posted to the General Ledger (G/L). The billing rate may be used when Employees are doing billable work for a Customer, depending on the billing rate hierarchy defined for the Customer. To ensure Employees can be reimbursed for their expenses, Employees must also be defined as Vendors in the system.

Contractors

Should also have compensation rate, but billing rate is optional. For Contractors, the compensation rate is used to determine the amount owed to Contractors for their time entries. Contractor costs are not posted directly as a Labor cost, as they are for Employees. Instead, Contractor time is vouchered and then Checks are written to the Contractors—thereby closing the Vouchers. Because Contractors are paid both for their time and their expenses, Contractors must be defined as Vendors in the system. Like Employees, the billing rate for Contractors may be used when Contractors are doing billable work for a Customer, depending on the billing rate hierarchy defined for the Customer.

To review Worksheets, select the "Worksheets" option. The following screen will appear:

Worksheets

When reviewing Worksheets, you are presented with the following options:

Employees

Specify which Employee Worksheets you want to include in the display, using the specified date range:

All

Select to include Worksheets for all Employees in the display.

Selected

Select to include a specific Employee's Worksheets in the display.

Direct Reports

Select to include Employee Worksheets for a specific Manager in the display. Managers are linked to Employees on the Employee record.

Week of

Specify a date range for the Worksheets you want to review:

Start Date

Worksheets dated on and after this date will be included in the display.

End Date

Worksheets dated on and before this date will be included in the display.

Status

Specify which Worksheet statuses you want to include in the display:

Open

Select to include open Worksheets in the display.

Approved

Select to include approved Worksheets in the display.

Closed

Select to include closed Worksheets in the display.

Worksheets

Display will list Worksheets based on the specified parameters. By right-clicking on a Worksheet, you can perform several actions, including edit, print, delete, and approve.

When Processing

Select one or more of the following options to be performed automatically when processing Worksheets:

Invoice

Select to generate an Invoice to bill the specified Customer for their billable time and/or expense entries on the selected Worksheet(s). This option only applies to billable entries.

Voucher

Select to generate a Voucher to reimburse Contractor type Employees for their expenses. In the case of Contractors, expense reimbursement may also be combined with payment for hours worked. Regular Employees are not paid in this way.

Post Time

Select to post Employee labor and overhead costs to the General Ledger. This step applies to Employees only and does not apply to Contractors.

The following buttons are unique to this screen:

NEW

Select this button to create a new Worksheet.

APPROVE

Highlight one or multiple open Worksheets and then select this button to approve the highlighted Worksheets.

PROCESS

Highlight one or multiple open Worksheets and then select this button to process the highlighted Worksheets, using the processing instructions indicated at the bottom of the screen.