10,000ft Report Types

Learn more about the different types of reports available in 10,000ft including:

  • Time and Fees Reports
  • Expense Reports
  • Budget Reports
  • Utilization Reports 
  • Leave Reports
  • Scheduled Hours Reports

Create Time and Fees Reports

Time & Fees Reports show project progress and compares your actual time and fees to scheduled time and fees.

Time & Fees Reports pull data from your selected metrics: Hours, Days, Amounts, Amounts & Hours or Amounts & Days.

To see a Time & Fees Report:

  1. Click Analytics and then click New Report
  2. On the right sidebar, click View, select Time & Fees, and then select a time frame.

Time and fees

Time & Fees Reports have five columns:

  • First Column: Selected groupings. Click a row see individual time entries under each group.
  • Incurred: Actual amount already incurred on the project. Your Account Settings determine if this includes both Confirmed and Unconfirmed hours. Future time does not appear as incurred time on reports.
  • Difference from Past Scheduled: Shows the difference between Incurred time or money and the original plan. For example, if a person was originally scheduled to work on a project for four hours on a given day, but they confirmed five hours, Difference from Past Scheduled column shows +1.
  • Future Scheduled: Time or money scheduled in the future. 
  • Chart: Incurred, Difference, and Future Scheduled time for each row

Chart

Incurred, Difference, and Future Scheduled time chart

You can display this chart in two ways.

  • Rows relative to each other (different lengths), to visualize how the separate rows make up the whole. In this example, Development accounts for about 50% of all the work.
  • Rows are all the same length. This allows you to compare how the columns relate to each other per row. In this example, you can see which discipline has incurred the most unplanned hours as a percentage of their total workload.

Bill Rates

To see bill rates, include Amounts when you set up your report. 

The Bill Rate column shows a person’s applied bill rate for the hours worked on a project.

Sometimes reports show groups where multiple bill rates are included – for example, when grouping by discipline. In this case, the Bill Rate column calculates the average or effective bill rate for the work completed and scheduled in that group.

Bill rates

Filter your report by modifying any items under Show on the left sidebar.

Your team can create custom reports to monitor their scheduled and incurred hours. When the Difference from Past Scheduled is close to zero as possible, everyone is working according to the original plan.

Create an Expense Report

Expense Reports show non-labor related project costs. For example, costs incurred when hiring outside vendors, ordering prototypes, or travel costs. Expense Reports are included Budget Reports.

To see a Utilization Report:

  1. Click Analytics and then click New Report
  2. On the right sidebar, click View and then select Expenses

Expense

Expense Reports have six columns:

  • First Column: Data available for the selected projects and groups. Click a row to see more details for that row.
  • Incurred: Amount already expensed.
  • Remaining: Amount still available for project expenses.
  • Budget: Project Expense Budget. This number is set in Project Settings.
  • Category: (not shown in image): Categories appear when you click on a group header. The Expense Category identifies the type of purchase, for example, Travel. 
  • Notes: (not shown in image): A description of the expense. 

About Budget Reports

Budget Reports show how much time or money has been incurred on a project—and how much remains. Adjust the time frame settings to include projects that have any data within that time frame. 

Budget Reports pull data for the project (not just time entries within the time frame) and give you a complete overview of project status. You can view a budget report in Hours, Days, or Amounts.

Budget Reports set to Amounts include Time & Fees and Expenses. Reports only include budget information when a project has a budget for a specific item. For example, when a project has a budget for Hours, this information will be included in a Budget Report for Hours.

 

budget report

Budget Reports include five columns:

  • Project: Name of the selected groupings. Click the group name to see individual time entries or expenses.
  • Incurred: Actual amount of time already worked or money expensed for the project. Expenses with a future date will still appear in the Incurred column because the money for the expense has already been set aside.
  • Future Scheduled: The amount of time or money scheduled in the future.
  • Budget: Project budget. It is a fixed amount predetermined in Project Settings.
  • Remaining: The amount of time or money still available for the project.

Understanding Budget Reports

Budget reports include time entries for projects outside the Time Frame of the report. Budget reports always show the total budgets for projects that have any data within the time range you have selected. This means that even hours or amounts outside that date range will be included.

For example, if your Time Frame is January, but the project started in December and runs through March, your budget report includes data for the entire lifecyle of the project. 

This is intentional, as Budget Reports are designed to give you a holistic, high-level overview of how your projects are tracking against their entire time/fee budget. Otherwise, your project might appear to be on track because you’re not counting hours for that time frame.

For example:

  • Your project has a budget of $100K.

  • You already spent $50K in time so you have $50K left to use. 10,000ft always shows all time spent for the duration selected.

  • If you change the date range to only include $25K worth of time, it would show $75K remaining even though the math would be incorrect.

If you only want to see hours for a selected time frame, switch to a Time & Fees Report.

Create a Utilization Report

Utilization Reports show billing efficiency for a person, department, or the organization within a defined time frame. The utilization rate is based on the availability of the person within that time frame.

Utilization Reports allow you to see historic utilizations based on incurred hours and forecasted utilization based on future scheduled assignments.

To see a Utilization Report:

  1. Click Analytics and then click New Report
  2. On the right sidebar, click View and then select Utilization

Utilization report

Utilization Reports have five columns:

First Column: The first grouping set for the report.

Actual Hours: Either incurred (confirmed and unconfirmed) or future scheduled hours, depending on the time frame.

You may want to filter out non-billable hours. For example, you may want to omit internal projects, or only include time entries for a certain category  This only works when you are doing itemized time tracking for incurred entries.

Available Hours: Standard availability as defined within Account Settings, for example, 8 hours/day.

Availability can be overruled by availability settings within a person’s profile,  for example, if someone is working part time. Employment dates, as set within a person’s profile, also impact how availability is calculated. A person is only considered available between the first day of work and the last day of work as set in their profile settings.

Utilization: Utilization calculates Actual Hours divided by Available Hours, multiplied by 100%.

For example, if someone has 30 actual hours and 40 available hours, their utilization rate is 75%.

Target Utilization: A fixed value set in each person’s profile. This number is used to track how utilization compares to targets for individuals or departments.

Create a Leave Report

  1. Go to Analytics. In the top right, and click New Report.
  2. On the left sidebar under View, click Time & Fees and select Hours or Days

  3. On the left sidebar under Time Frame, select a time frame: This Year, This Quarter, or a Custom Date Range

  4. First group by Leave Type, then group by Team Member

The report will show all leave Incurred (already taken), Difference (unplanned and taken leave), and Future Scheduled (planned on the schedule for the future) for the time period you selected. Hours in the report are grouped by Project. 

You can filter on vacation days, sick leave or other leave types to get more refined results. 

  1. On the left sidebar, under Show, click Leave Type
  2. Select the checkboxes for Leave (Vacation, Sick, Parental etc) that you want to review.

You can also filter to see leave for only yourself, one person, or department using these filters.

Create a Scheduled Hours Report

Reports won't show you scheduled hours per person within a project. However, you can export the data you need create a pivot table to display this information.

To Create a Scheduled Hours Pivot Table:

  1. On the left menu of the Project Page click Time & Fees report.
  2. In the top right corner of the Time & Fees report, click Export and then click Export Underlying Data as CSV.
  3. Open the CSV in Excel. On the Insert menu, click Pivot Table.  Accept the default values in the pop-up and click OK
  4. In the PivotTable Field List, check Project and Team Member and make they appear under Row Labels. Then check Scheduled (hours) and make sure it appears under Values

The table now shows the number of hours each person was scheduled for this project.

scheduled hours report