The Timesheet Details report lists individual time entries. You can group the entries in up to three levels and choose the columns. Use the report to:
- check who worked on what
- send a client the time entries for an invoice
- prepare payroll
- check when time was entered and approved, for an audit
Open the report
Go to Reports in the left menu. On the Standard tab, click Timesheet Details under Project Management, or type its name in Search. When you open the report, it runs for Last Week. Change the parameters in the panel on the right, then click Preview to run it again.
Administrators, Finance Managers and Portfolio Managers can run the report on every project. Project Managers can run it only for projects where they are an active member. The Customers and Projects lists show only those projects. To see cost and billable amounts, a Project Manager needs Can manage Project Member Cost & Billable Rates on their project membership.
Choose what to include
Dates
- Date Range: a preset such as This Week, Last Month or Year To Date. Choose Custom Date Range to set Timesheet Date From and Timesheet Date To yourself.
- Created Date From / To and Approved Date From / To: filter by the date when entries were created or approved.
Groupings
- Primary Grouping, Secondary Grouping and Tertiary Grouping: group the entries in up to three levels. Each group gets a subtotal row. You can group by Date, Customer, Project, Category, User, Task, Section, Status, Month, Billable?, Week, Project Category, Invoice Number or Project Owner.
Filters
- Customers and Projects. The project list shows only projects for the customers you choose. If you set Project Tags, Project Categories or Project Archive Status, the project list shows only matching projects too.
- Categories: the timesheet categories to include, for example only meetings or leave.
- User Tags, Users and User Archive Status. You set up user tags under Settings › Scheduling Settings, and add them to people in their contact details.
- Status: Draft, Pending, Approved, Automatically Approved, Rejected or Invoiced. Choose Pending to see time that is waiting for approval.
- Only Billable?: Billable or Not Billable. Leave it empty to include both.
- Invoice Number: only time that is on the invoices you choose.
- Task Tags and Project Owner.
- Bill Payable Status and Bill Paid Status: for contractor time that you pay through supplier bills. See getting started with bills.
Display
- Show Columns, Sort Columns and Sort Order. You can also click a column heading in the report to sort by that column.
- Rounding: apply your account's timesheet rounding. The durations then match what an invoice shows. See timesheet rounding.
- Time Format: decimal, or hours and minutes. The default is your account's format.
- Duration Decimal Places: 2 or 4.
- Hide Individual Entries: show only the group subtotals.
- Start / End Timezone: show start and end times in each user's timezone or in the account timezone.
- Remove Currency Formatting: show plain numbers, for formulas in Excel.
- Display Parameters on Report: show your choices at the top of the report. An export then shows what it covers.
- Display Saved Report Title. See showing a saved report's name as its title.
Read the report
Each row is one time entry, with its duration under Time (hrs). By default the report also shows Date, Customer, Project, User and Category. Add more with Show Columns:
Columns | What they add |
|---|---|
Notes, Tasks, Sections, Task Tags | What the time was spent on |
Status, Approved By, Approved Date, Created Date | Approval and audit details |
Billable?, Invoice Number, Payable?, Bill Number | Billing status |
Cost Rate/Amount, Billable Rate/Amount | Rates and amounts, with their currency. Non-billable time has a billable rate of zero. See cost rates and billable rates. |
Start/End Time | When the work started and ended. These columns are only filled in if your account records start and end times (Settings › Timesheet Settings). |
Task Estimate, Rem Hrs | The task's estimate and the hours left. These columns are filled in when you group by Task. |
User Email, User Tags, Position Title, External Contact Company, Project Code, Project Tags, Project Categories, Project Owner | More about the person or the project |
The report shows up to 11 columns on screen. If you choose more, export the report to Excel to see them all.
A group can include customers with different currencies. Then the group's amount subtotals show NA, because Avaza can't add those amounts together. See multiple currencies.
Click a task name to open the task. Click a duration to open that person's timesheet for that day.
If the report says No data found, choose a longer Date Range or clear some filters. On the Free plan, the report lists only the first 300 entries. If there are more, the report says "Displaying the first 300 of" and the total. It asks you to upgrade to a paid plan to see the rest.
Save, schedule or export
Click Save As in the parameters panel to keep your settings as a saved report. See saving and sharing reports. You can email a saved report on a regular schedule: see scheduling reports for email delivery. To download the report as a file, see exporting data.
To show a customer the time entries on an invoice, choose the invoice in Invoice Number and export the report as a PDF. Then add the PDF to the invoice under Attachments › Add Attachment. Your customer can see invoice attachments.