Collapse AllExpand All

3.3.1. Worksheet

The Worksheet is the weekly container for holding time and expenses entered by Employees. As Employees enter time and expense sheets during the course of a week, the Worksheet organizes those entries. When the next week arrives, a new Worksheet is created and Employee time and expense entries are contained there. Typically, Worksheets are approved on a weekly basis.

To review an already-existing Worksheet, select the EDIT option on the main Worksheets workbench. The following screen will appear:

Worksheet

Note

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

When reviewing a Worksheet, you are presented with the following options:

Sheet #

Displays the system-generated number of the Worksheet.

Week of Date

Displays the date for the week contained by the Worksheet. The date is set manually when creating a new Worksheet.

Site

Displays the Site associated with the work. The Site is chosen manually when creating a new Worksheet.

Employee

Displays the name of the Employee associated with the Worksheet. The Employee is entered manually when creating a new Worksheet.

Print on Save

Select to automatically print the Worksheet whenever it is saved.

The following buttons are unique to this screen:

NEW

Select to add a new time or expense entry to the Worksheet.

To enter notes related to a Worksheet, select the "Notes" tab. The following screen will appear:

Worksheet Notes

The "Notes" tab provides a text area where you can add miscellaneous notes related to the Worksheet.

To associate Documents with a Worksheet, select the "Documents" tab. The following screen will appear:

Worksheet Documents

When associating documents, you are presented with the following options:

NEW

Select to create a new document and associate it with the current record. You may create the following document types:

Image

Select to create a new Image association.

Fixed Asset

Select to create a new Fixed Asset association.

Maintenance Order

Select to create a new Maintenance Order association.

Incident

Select to create a new Incident and associate it.

Project

Select to create a new Project and associate it.

Opportunity

Select to create a new Opportunity and associate it.

To Do

Select to create a new To-Do and associate it.

EDIT

Enables you to edit associated documents. The edit screen is the same as that for creating a new document—except that when editing, the fields will contain document information. Double-clicking on a document will also bring you to the editing screen.

VIEW

Highlight a document and then select this button to reach a read-only view of the "Edit" screen

ATTACH

Select to associate already-existing documents. The following document types may be attached: Contact, Account, Customer, Employee, File, Image, Incident, Item, Opportunity, Project, Purchase Order, Sales Order, Vendor, Web Site, Work Order.

DETACH

Highlight a document and then select this button to remove the association.

To associate already-existing documents, select the ATTACH button. The following screen will appear:

Attach a Document

When associating already-existing documents, you are presented with the following options:

Relationship

Indicate how the document is related to the current record. The following relationship options are available: Related to, Parent of, Child of, Duplicate of.

Type

Specify the kind of document you want to associate. The following document types may be attached: Contact, Account, Customer, Employee, File, Image, Incident, Item, Opportunity, Project, Purchase Order, Sales Order, Vendor, Web Site, Work Order. When associating Files, you will also be given the option to save the File to the database.

Tip

There is no file size restriction when saving Files to the database. However, excessively large files could cause storage and performance issues.

Document

Use the lookup field to identify the specific document you want to attach. The data entry options will vary depending on the document type you select.

3.3.1.1. Worksheet Item

The Worksheet Item screen is where Employees record their actual time or expenses related to a Project. To add a time or expense entry, select the NEW button on the Worksheet screen. The following screen will appear:

Worksheet Item

When adding a time or expense entry, you are presented with the following options:

Worksheet

Displays the system-generated number of the Worksheet.

Line #

Displays the line number assigned to the time or expense entry.

Week Of

Displays the date for the parent Worksheet.

Project #

Enter the number of the Project associated with the entry. This is a required field. Depending on how the Project is configured, many of the other fields in the entry (e.g., Customer and Item numbers) will be filled out automatically from the Project information.

Task

Select a Task from the list of Project Tasks to associate with the entry. This is a required field.

Work Date

Enter the date the work was performed or the expense was incurred.

Type

Specify whether the entry is a time or expense type entry.

Customer

Enter the number of the Customer associated with the entry. This field may be filled automatically from the Project information, depending on how the Project is configured. The Customer is needed for billable entries, so the system knows who to invoice for the time and/or expense.

Cust. PO#

Enter the Customer Purchase Order number, if any.

Item Number

Enter an Item Number to associate with the entry, if one is not already linked from the specified Project Task. This is a required field. The Item Number is needed to map an Expense Account to the Task, which is required for subsequent General Ledger transactions. Only Reference Items which have been configured specifically to work with time and expense entries (on the "Project" tab of the Item master) may be selected.

Employee

Displays the name of the Employee indicated on the parent Worksheet.

Hours

For time entries, enter the number of hours worked on the specified Task.

Qty

For expense entries, enter the quantity of expenses incurred. For example, if mileage is being reimbursed, enter the number of miles. For hotel stays, enter the number of days.

Billable

Select if the work performed or the expense incurred is billable to the specified Customer. If not selected, time entries will be booked to overhead and expense entries will be reimbursable.

Rate

For billable time entries, enter the rate to be billed to the Customer. Depending on how the Project is configured, this information may be filled in automatically for you.

Unit Cost

For expense entries, enter the per unit cost of the expense item. For example, enter $0.25 per mile for mileage reimbursements or $125 per night for hotel costs.

Total

Displays the total billable amount for time entries and the total reimbursement amount for expense entries.

Hourly Cost

For time entries, displays the Employee's hourly rate (or cost), as distinguished from the billable rate charged to the Customer.

Total Cost

For time entries, displays the total cost for the Employee's time spent on the task, based on the Employee's hourly rate.

Prepaid (not reimbursable)

For expense entries, select if the item has already been paid for, making it ineligible for reimbursement.

Summary

When viewing the summary for a time and expense entry, you are presented with the following information:

Task

Displays the following information related to the selected Project Task:

Planned Hours

Displays the total hours budgeted for the Task.

Actual Hours

Displays the actual hours logged against the Task.

Planned Expense

Displays the total expenses budgeted for the Task.

Actual Expense

Displays the actual expenses logged against the Task.

Employee

Displays the following information for the Employee associated with the Worksheet:

Day Total

Displays the number of hours entered for the Employee on the given work date.

Worksheet Total

Displays the Employee's total hours on the parent Worksheet.

The following buttons are unique to this screen:

PREV

Select to view the previous time or expense entry. If none exists, this button will be disabled.

NEXT

Select to view the next time or expense entry. If none exists, this button will be disabled.

To enter notes related to a time or expense entry, select the "Notes" tab. The following screen will appear:

Worksheet Item Notes

The "Notes" tab provides a text area where you can add miscellaneous notes related to the time or expense entry.