Timesheet inquiry
This inquiry allows you to easily keep track of your company's timesheets. You can see who submitted the timesheet and the total number of hours on each timesheet.
If needed, you can add predefined columns and view supplemental information such as who approved the timesheet, the date of the approval, and any notes.
Using the inquiry
From the 
> Reports menu, click Standard Inquiries > Employee > Timesheet.
Audience
Accounting staff
Standard columns
| Column | Links to this inquiry | Description | Date range available |
|---|---|---|---|
|
Timesheet Date |
Timesheet Detail |
The last date of the timesheet period |
|
|
Employee |
Employee |
The name of the employee associated with the timesheet |
|
|
Timesheet Total |
The total number of hours for the timesheet |
||
|
Defined links: |
|||
|
Transaction - Labor |
Transaction - Labor |
A link to the Transaction - Labor inquiry |
|
Predefined columns
You can add predefined columns to this inquiry. These columns are available:
| Column | Links to this inquiry | Description | Date range available |
|---|---|---|---|
|
Timesheet Key |
Timesheet Detail |
The database identifier of the timesheet |
|
|
Timesheet Company Key |
Multi-company only. The database identifier of the company associated with the timesheet |
||
|
Timesheet Company Name |
Multi-company only. The name of the company associated with the timesheet |
||
|
Employee Key |
The database identifier of the employee associated with the timesheet |
||
|
Submitted By Key |
The database identifier of the employee who submitted the timesheet for processing |
||
|
Submitted By |
Employee |
The name of the employee who submitted the timesheet for processing |
|
|
Submitted Date |
The date the timesheet was submitted |
x |
|
|
Supervisor Approved By Key |
The database identifier of the supervisor who approved the timesheet Approval requirements depend on your settings in Company Preferences. |
||
|
Supervisor Approved By |
The name of the supervisor who approved the timesheet Approval requirements depend on your settings in Company Preferences. |
||
|
Supervisor Approved Date |
The date the supervisor approved the timesheet Approval requirements depend on your settings in Company Preferences. |
x |
|
|
Accounting Approved By Key |
The database identifier of the accounting staff who approved the timesheet Approval requirements depend on your settings in Company Preferences. |
||
|
Accounting Approved Date |
The date the accounting staff approved the timesheet Approval requirements depend on your settings in Company Preferences. |
x |
|
|
Day 1 |
The total number of hours for the first day on the timesheet |
||
|
Day 2 |
The total number of hours for the second day on the timesheet |
||
|
Day 3 |
The total number of hours for the third day on the timesheet |
||
|
Day 4 |
The total number of hours for the fourth day on the timesheet |
||
|
Day 5 |
The total number of hours for the fifth day on the timesheet |
||
|
Day 6 |
The total number of hours for the sixth day on the timesheet |
||
|
Day 7 |
The total number of hours for the seventh day on the timesheet |
