Report: Actual Cost

Report: Actual Cost

We all know that having access to  accurate real time information gives us the confidence to make the right decisions!  That is why QicWorks has made it super easy to see exactly what each Job is Costing you from the one report - Actual Cost Report.

This report uses the Net Cost table, expense and purchase order raw cost plus any overhead allowance set within your Job Financials to calculate your actual costs to date.   This report is visible to those with Manager and above access permissions.

Your Actual Cost report is available at both Job and individual Task levels.

The values used within the Actual Cost Report come from the Net Cost Table, plus any overhead set.

Actual Costs at Job Level

Click on   Job   from the main menu, then click on   Job Management  . To view a particular job simply click on the Job Number  from within the Job Management Table. Then click on  Actual Cost Report  from the Reports menu.


Actual Costs at Task Level

Click on   Job   from the main menu, then click on   Job Management  . To view a particular job simply click on the Job Number  from within the Job Management Table. From the Navigation men click on View Tasks. Click on the specific Task Number from within the Task Table.  Then click on  Actual Cost Report  from the Reports menu.


Actual Cost Report


A   Job/Task Details: General details pertaining to this particular Job or Task. Note: the export to excel and print buttons are also located here
B   Job Totals by Category: This report will show you your Job totals based on Resource, Material and Purchases by Quote and Rates
C   Authorised/Unauthorised Totals :  Totals based on approved or unapproved time entries
D  Data Warnings: Panel for  additional notes or warnings
E    Task Categories: Select/Deselect to filter table. See  Task Categories  for more information
F    Filters: Click on tabs to sort table by that field
G    Actual Cost Table: Itemised list of all time and cost entries incurred for this Job or Task
H    Authorised/Unauthorised Totals: At base of page for convenience

See below for full details pertaining to  F  - Actual CostTable.

Comprising of 
   Field Name
   Function
     Date
   Date of Transaction
     Type
   How this entry is costed.
   Q = Quoted Task
   R = Rates Task
   Blank = Costed direct to WBS
    WBS
    The Work Breakdown Structure this cost has been assigned to. For further details see: Work Breakdown Structure
    Task
   Task Name and number
    Name
   Name of Resource, Item purchased or Material assigned
    Report
   Reference number and hyperlink of report this cost came from ie Shift Report, Timesheet, Purchase Order or Expense
    Frequency
   How often this cost is incurred
    Charged
   How this cost is charged ie Normal Time, Time & a Half, Double Time, Double Time & a Half, Custom Rate or No Cost
    Quantity
   Number of units 
    Rate
   Unit rate that this item is costing you. This value comes from the Pure Cost table based on classification or material, or the order or expense unit value
    Total
   Value of Quantity multiplied by Rate
    Order
   Order reference number as entered during Task creation.


Not sure why your Actual Cost Report is showing a zero value at Rate or Total - read our Trouble Shooting article to find out why.
For details about your Billable Cost Report see: Report: Billable Costs


    • Related Articles

    • Why does my billable and/or actual cost report show zero dollars?

      Problem I run my billable (and/or Actual cost) report, but one of my resources shows a $0.00/hour rate. What is going on? Solution Perhaps your billable or actual costs reports are showing values similar to below. There may be a number of reasons for ...

    • Profit Report

      Similar to the Edit Billable Costs report, the Profit Report compares your Actual and Billable values for each item.  It is a view only report that quickly highlights which items you are possibly undercharging on, as well as those that are ...

    • Report: Billable Costs

      Track your Job profitability using the Billable Cost Report. This report itemises all time and costs that that can be charged to your customer from within the one report . This report is calculated using the Pricing Table selected and includes any ...

    • Cost Approval

      Cost Approval Overview

    • Cost Reporting

      QicWorks cost reporting incorporates functionality whereby users can set  when   they wish to commit their purchase order values to their Jobs.  Using the Cost Reporting setting allows QicWorks to determine which procurement document values will be ...