Import actual cost from approved timesheets

Altus allows you to import actual labour costs from approved timesheets directly into the Financials section of a project.

This ensures alignment between:

  • Resource effort (timesheets)
  • Financial actuals (cost reporting)

Using this functionality helps maintain accurate reporting for:

  • Budget vs Forecast vs Actual
  • Cost tracking across time and financial categories

For more details on how time-based data is synchronised into financials, refer to:
https://docs.altus.pro/products/AltusPPM/Configuration/Resources/TimesheetSynctoActuals.html?q=Import%20timesheet


Important: Prerequisites

Before importing timesheet actuals:

  • Timesheets must be:
    • ✅ Submitted and approved
  • Resources must have:
    • ✅ Configured cost rates
  • Timesheet periods must be:
    • ✅ Active and correctly configured
  • You must have access to:
    • Project Financials
    • Import functionality

Where This Is Performed

This action is completed within:

  • Project → Information → Financials tab

High-Level Steps

  1. Navigate to Projects
  2. Open the required project
  3. Select: Information → Financials

    Tip: When approved timesheet data is available, a yellow notification banner will appear at the top of the Financials grid stating “New Information to import”. A salmon indicator dot will also appear on the Data menu. Select Import Timesheet Actuals to open the review window, where you can preview the imported values before applying them to Financials.
  4. In the Financials view:
    • Locate the Data menu (top right)
    • Select Import Timesheet Actuals
  5. ✅ This option appears alongside:
    • Import Resource Forecasts
    • Export to CSV

What Happens During Import

When you select Import Timesheet Actuals:

  • Approved timesheet entries are converted into labour costs
  • Costs are calculated based on:
    • Resource rates
    • Time recorded in timesheets
  • Values are mapped into the Financials grid across:
    • Time periods (e.g. months)
    • Financial categories (e.g. Opex, Capex)

You will see:

  • Updated Actual values
  • Updated totals for each category
  • Variance automatically recalculated

Ongoing Synchronisation Behaviour

Timesheet actuals are based on approved timesheet data and may require re-import to reflect updates.

  • New or updated approved timesheets → require re-import
  • Adjustments to entries → also require re-import
  • Financials reflect the latest approved data at time of import

👉 This ensures financial actuals stay aligned with the latest recorded effort


Post-Import Actions

After importing:

  1. Review updated Actual values
  2. Validate totals across:
    • Time periods
    • Financial categories
  3. Select Save (if required) to persist changes

How This Impacts Altus

This functionality enables:

  • Accurate tracking of actual labour costs
  • Alignment between:
    • Resource utilisation
    • Financial performance
  • Reliable reporting for:
    • Variance analysis
    • Financial forecasting



Key Considerations

  • Only approved timesheets are included in actuals
  • Import reflects latest approved data at time of execution
  • Updates to timesheets require re-import
  • Incorrect or missing resource rates will affect cost accuracy

Tips

  • Run this import regularly as part of your financial reporting cycle
  • Re-import after:
    • Timesheet approvals
    • Time adjustments
  • Use alongside:
    • Import Resource Forecasts (planned cost)
    • ✅ This process (actual cost)

👉 Together, they provide a complete view of:

  • Budget → Forecast → Actual



Altus Help Centre