Unbilled Timesheets

The Unbilled Timesheets list shows billable timesheets that are not yet assigned to an invoice. It is the standard starting point for creating invoices from recorded work.

Typical Audience

Under standard permissions, this list is typically relevant for:

Billing Admins
Project Managers
Project Controllers

Standard navigation: Management -> Billing -> Unbilled Timesheets
Deeplink: https://web.timecockpit.com/app/lists/APP_UnbilledTimesheetsList

What the List Shows

The list is based on timesheets. It keeps the standard project and billing context, but applies filters that focus on billable and still unbilled work.

By default, the list:

groups entries by customer and project
filters to Billable = true
filters to Billed = false

Standard Filters

The standard filter area contains these filters:

Filter	Technical Reference	Meaning
User	`APP_UserDetail`	Limits the list to one user
Customer	`APP_Project.APP_Customer`	Limits the list to one customer
Project	`APP_Project`	Limits the list to one project
Task	`APP_Task`	Limits the list to one task
Description	`APP_Description`	Searches in the timesheet description
From	`@BeginTime`	Shows entries on or after the selected date
To	`@EndTime`	Shows entries up to the selected date
Billable	`APP_Billable`	Defaults to `true`
Billed	`APP_Billed`	Defaults to `false`

Columns

The following table documents the visible standard columns.

Column	Technical Reference	Meaning	How the Value Is Determined
User	`APP_UserDetail`, query alias `UserDetailName`	User who recorded the timesheet	Display value of the related user detail
Customer	`APP_Project.APP_Customer`, query alias `CustomerName`	Customer of the related project	Display value of the customer linked through the project
Project	`APP_Project`, query alias `ProjectName`	Related project	Display value of the project
Task	`APP_Task`, query alias `TaskName`	Related task	Display value of the task
Date	`APP_BeginTime`, shown as `APP_Timesheet.APP_DateActual`	Calendar date of the timesheet	Based on the begin date of the timesheet
Begin Time	`APP_BeginTimeActual`	Recorded start time	Taken from the timesheet's actual begin time
End Time	`APP_EndTimeActual`	Recorded end time	Taken from the timesheet's actual end time
Description	`APP_Description`	Free-text description	Taken directly from the timesheet
Location	`APP_Location`	Location or place of work	Taken directly from the timesheet
Hours	`APP_DurationInHours`	Duration of the timesheet	Calculated duration in hours of the timesheet
Hourly Rate	`APP_HourlyRateActual`	Effective hourly rate used for billing-related calculations	Taken from the timesheet's actual hourly rate
Revenue	`APP_Revenue`	Calculated revenue of the timesheet	Standard revenue value of the timesheet, typically based on duration and effective hourly rate
Billable	`APP_Billable`	Indicates whether the timesheet is billable	Taken from the timesheet
Billed	`APP_Billed`	Indicates whether the timesheet is already assigned to billing	Taken from the timesheet
Fixed Price	`APP_Project.APP_FixedPrice`	Indicates whether the related project is fixed price	Taken from the related project

Grouping

The standard list groups rows by:

customer
project

This makes it easier to select a set of timesheets for a single invoice.

Standard Action

Create Invoice

The most important standard action on this list is Create Invoice.

In the standard workflow, the action:

takes the selected timesheets
creates or fills invoice items
assigns the selected timesheets to the invoice context

After timesheets are assigned to an invoice or invoice item, they become read-only in the standard billing workflow.

For the full invoicing workflow, see Invoicing.

Notes

The list is meant for billable work that still has to be invoiced.
If you need all timesheets instead of only billable and unbilled ones, use Timesheets.
The column values come from the underlying timesheet and its related customer, project, task, and invoice context.