Timesheet Base
This base allows you to easily keep track of your company's timesheets.
| Available Columns | Description | Date Range Available | Chartable | Links to Page |
| General Information | ||||
| Accounting Approved | Indicates if the timesheet has been approved by accounting | |||
| Billed | Indicates if the timesheet has been billed | |||
| Company Name | The name of the company associated with the timesheet | Company | ||
| Employee Department Name | The name of the department the employee associated with the timesheet belongs to | Department | ||
| Employee Status | The status of the employee associated with the timesheet | |||
| Is Certified |
Indicates if the timesheet has been certified for accuracy |
|||
| Paid | Indicates if the timesheet has been paid | |||
| Project Manager Approved | Indicates if the timesheet has been approved by all project managers | |||
| Rejected | Indicates if there is time rejected associated with the timesheet | |||
| Submitted | Indicates that the timesheet has been submitted | |||
|
Supervisor Approved |
Indicates that the timesheet has been approved by the supervisor | |||
| Timesheet Daily Details Enabled | This indicates if Timesheet Daily Details is enabled in Setup > Employees. | |||
| People | ||||
| Accounting Approved By | The name of the employee who approved the timesheet for accounting | X | Employee | |
| Employee | The name of the employee associated with the timesheet | Employee | ||
| Submitted By | The name of the employee who submitted the timesheet for processing | Employee | ||
| Supervisor Approved By |
The name of the supervisor who approved the timesheet Approval requirements depend on your settings in Company Preferences. |
Employee | ||
| Supervisor | The name of the supervisor of the employee associated with the timesheet | Employee | ||
| Dates | ||||
| Accounting Approved By Date |
The date the supervisor approved the timesheet Approval requirements depend on your settings in Company Preferences. |
|||
| Submitted By Date | The date the timesheet was submitted | |||
| Supervisor Approved By Date | The date the timesheet was approved by the supervisor | |||
| Timesheet Date | The last date of the timesheet period | Timesheet | ||
| Hours/Units | ||||
| Day 1 Premium 1 | The total number of premium 1 hours for the first day on the timesheet | X | ||
| Day 1 Premium 2 | The total number of premium 2 hours for the first day on the timesheet | X | ||
| Day 1 Premium 3 | The total number of premium 3 hours for the first day on the timesheet | X | ||
| Day 1 Regular | The total number of regular hours for the first day on the timesheet | X | ||
| Day 1 | The total number of hours for the first day on the timesheet | X | ||
| Day 2 Premium 1 | The total number of premium 1 hours for the second day on the timesheet | X | ||
| Day 2 Premium 2 | The total number of premium 2 hours for the second day on the timesheet | X | ||
| Day 2 Premium 3 | The total number of premium 3 hours for the second day on the timesheet | X | ||
| Day 2 Regular | The total number of regular hours for the second day on the timesheet | X | ||
| Day 2 | The total number of hours for the second day on the timesheet | X | ||
| Day 3 Premium 1 | The total number of premium 1 hours for the third day on the timesheet | X | ||
| Day 3 Premium 2 | The total number of premium 2 hours for the third day on the timesheet | X | ||
| Day 3 Premium 3 | The total number of premium 3 hours for the third day on the timesheet | X | ||
| Day 3 Regular | The total number of regular hours for the third day on the timesheet | X | ||
| Day 3 | The total number of hours for the third day on the timesheet | X | ||
| Day 4 Premium 1 | The total number of premium 1 hours for the fourth day on the timesheet | X | ||
| Day 4 Premium 2 | The total number of premium 2 hours for the fourth day on the timesheet | X | ||
| Day 4 Premium 3 | The total number of premium 3 hours for the fourth day on the timesheet | X | ||
| Day 4 Regular | The total number of regular hours for the fourth day on the timesheet | X | ||
| Day 4 | The total number of hours for the fourth day on the timesheet | X | ||
| Day 5 Premium 1 | The total number of premium 1 hours for the fifth day on the timesheet | X | ||
| Day 5 Premium 2 | The total number of premium 2 hours for the fifth day on the timesheet | X | ||
| Day 5 Premium 3 | The total number of premium 3 hours for the fifth day on the timesheet | X | ||
| Day 5 Regular | The total number of regular hours for the fifth day on the timesheet | X | ||
| Day 5 | The total number of hours for the fifth day on the timesheet | X | ||
| Day 6 Premium 1 | The total number of premium 1 hours for the sixth day on the timesheet | X | ||
| Day 6 Premium 2 | The total number of premium 2 hours for the sixth day on the timesheet | X | ||
| Day 6 Premium 3 | The total number of premium 3 hours for the sixth day on the timesheet | X | ||
| Day 6 Regular | The total number of regular hours for the sixth day on the timesheet | X | ||
| Day 6 | The total number of hours for the sixth day on the timesheet | X | ||
| Day 7 Premium 1 | The total number of premium 1 hours for the seventh day on the timesheet | X | ||
| Day 7 Premium 2 | The total number of premium 2 hours for the seventh day on the timesheet | X | ||
| Day 7 Premium 3 | The total number of premium 3 hours for the seventh day on the timesheet | X | ||
| Day 7 Regular | The total number of regular hours for the seventh day on the timesheet | X | ||
| Day 7 | The total number of hours for the seventh day on the timesheet | X | ||
| Timesheet Total | The total number of hours for the timesheet | X | ||
| Dollars | ||||
| Actual Billable Percent | The percent of dollars on the timesheet that can be billed to the client | |||
| Target Billable Percent | The target billable percentage on the General tab in Setup > Employees | |||
| Keys | ||||
| Accounting Approved By Key | The database identifier of the accounting staff who approved the timesheet | Employee | ||
| Company Key | The database identifier of the company associated with the timesheet | Company | ||
| Employee Department Key | The database identifier of the department of the employee associated with the timesheet | Department | ||
| Employee Key | The database identifier of the employee associated with the timesheet | Employee | ||
| Submitted By Key | The database identifier of the employee who submitted the timesheet for processing | Employee | ||
| Supervisor Approved By Key | The database identifier of the supervisor who approved the timesheet | Employee | ||
| Supervisor Key | The database identifier of the supervisor of the employee associated with the timesheet | Employee | ||
| Timesheet Key | The database identifier of the timesheet | Timesheet | ||
| Action | ||||
| Open Timesheet |
Opens the timesheet for editing If you have access to Timesheets in the browser, this will open the timesheet in Manage > Timesheets. Otherwise it opens the timesheet in Manage > Time & Expense. |
|||
| Gantt |
unavailable in ajeraCore Select to add the Gantt chart to your table widget. |
|||
