Applies to

Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Capabilities

Who can use this capability

Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, and Project Editors can create reports. The projects visible will vary by permission level. For example, Project Editors will only be able to see the projects they own

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

Create time and fees reports

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

PLANS

  • Resource Management

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Permissions

Resourcing Administrators, Portfolio Editors, People Schedulers, Portfolio Reporters, and Project Editors can create reports. The projects visible will vary by permission level. For example, Project Editors will only be able to see the projects they own

Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.

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

    View 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.

    Sample of time and fees report, it displays hours incurred, difference from past schedules, future scheduled and total per project

    Time & Fees Reports have five columns:

    • First column: selected groupings. Click a row to 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

    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.
    • Rows are all the same length. This allows you to compare how the columns relate to each other per row. 

    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.

    Example of Bill rates Report, it displays the hours incurred, the amount incurred and bill rate per project.

    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.

    This Help Article Appears in the Following Learning Tracks

    Learning Track

    This Help Article appears in the Reporting in Resource Management learning track. Get the most out of this learning track by starting at the beginning.
    Was this article helpful?
    YesNo