10. Customizable Project Timesheet Report

Reports on project time can be run for a custom selection of users, with a variety of customizable parameters, over any date range up to 366 days. To use this form:

  1. Click Reports in the left menu.
  2. Click to report number 10, Customizable Reports under Project Time Tracking.
  3. Using the two calendars that appear, select the date range for the report.
  4. All available users, customers, projects, and account codes will be included in the report by default. If you wish filter out any of these list items, simply un-check the box next to the corresponding Include All… option, and check the boxes to make your selections.
  5. The Group Report By drop-down menu controls how the report is organized. The default selection is “Employee,” which will display all of the records for each employee in their own table, each with their own separate totals. Pro Tip: when downloading to your spreadsheet, grouping by None and using the detailed text version will deliver a single, sortable table of your data. Reports can be grouped by:
    • Employee
    • Job Title (generated using current employee titles found on the Profile tab of the employee’s settings page)
    • Supervisor
    • Customer
    • Project
    • Account Code
    • Date
    • None (all records shown in one table with no grouping)
  6. Choose whether to Include Unsigned Records and/or Include Signed Records.
  7. Choose whether to Include Records With Pending Alerts, Include Unapproved Records, and/or Include Approved Records.
  8. Choose whether to Include New Time and/or Include Archived Time.
  9. Choose whether to Include Bill Rates and/or Include Cost Rates in the report.
  10. Choose whether to Include Billable Time and/or Include Unbillable Time.
  11. If you wish to run a report that only includes records with certain keywords in the Notes field, then those keywords can be entered into the Search Notes on Key Words text box, and the report will display only the records with matching words in their notes. Important note: Any search entered must be at least 3 characters long, and if searching for a specific keyword than the entire word must be entered. Also, other report filters will still apply.
  12. The Include Notes When Downloading option will include work notes for the downloaded Detailed PDF and Detailed Text (CSV) versions of the report. Note: Work notes are always shown when viewing the detailed report on screen.
  13. The Include Page Breaks When Downloading a PDF option will separate each table/grouping (set in the Group By drop-down menu) into individual pages in the PDF document. Note: When grouped by employee, the PDF will also contain signature fields for the employee and two supervisors on each page.
  14. Choose your report format at the bottom of the page:
    • Select the Summary or Detailed format then click View to view the report on your screen. The summary report contains only totals for each grouping, whereas the detailed report contains sortable columns for every included list item.
    • On the next page, you can print the report or download the report as a PDF by clicking the Print/PDF button in the upper right corner in the format you chose.
    • A Text/CSV file of the report that can be opened in any spreadsheet software like Excel can be downloaded from the Downloads drop-down menu in the upper right corner.
    • The QuickBooks CSV and Payroll by Account Code formats are specially formatted CSV files for use with our QuickBooks Desktop importer tool. (See the articles in the QuickBooks Desktop section of the Help Pages for more information.)

Was this article helpful?

Related Articles