vw_project_financials

Overview

This view sums various financial data for each project.

It can be used to analyse*;-

▪overall fees, time, expenses invoiced / currently in WIP

▪hours booked, in progress, invoiced, written off

▪target values

* this list is not exclusive.

 

Column Definitions

 

Columns

Comments

projectid

The unique project identifier. Join to the Projects table (or other views that have the projectid column)

Project Title

as name suggests

Project Value

as name suggests

Agreed Invoice Limit

as name suggests

Client Fee

as name suggests

Forecast This Year

These figures are only relevant if you run the Period End Routine.

The forecast is based on;-

 

Timecharges

If the charge of timecharges booked to the fee is greater than the estimate then the charge value is used, otherwise the estimate is used.

Fixed Fee (Scheduled)

Scheduled - the amount billed from the schedule.

Fixed Fee (%age Complete)

the %age is based on how far through the duration of the task you are (based on the task dates and the Effective Date).

 

Forecast Next Year

Forecast Year 2

Forecast Year 3

Forecast Year 4

Forecast Unallocated

The remaining fee that has not yet been forecast.

Scheduled Fee Earned

The amount of scheduled fees that have currently been invoiced.

Total Fees

The sum of all client fees for all the project's tasks

Potential Fees

The amount of fees allocated to speculative tasks.

Total Target

The overall target value for the project.

Total Target Hours

The overall target hours for the project.

Fees Invoiced

The total value of all Fees invoiced.

Hours Invoiced

The total number of Hours invoiced.

Time Invoiced

The total amount of Time charges invoiced.

Expenses Invoiced

The total amount of Expense charges invoiced.

Fees Invoiced This Year

The total value of all Fees invoiced in the current financial year.

Time Invoiced This Year

The total amount of all Time Charges invoiced in the current financial year.

Expenses Invoiced This Year

The total value of all Expenses invoiced in the current financial year.

Fees Earned

The total value of the fees earned.

Timecharges Earned

The recharge value of all hours booked to the project.

Expenses Earned

The value of all chargeable expenses booked to the task.

Fees Earned This Year

The total value of the fees earned this financial year.

Timecharges This Year

The total value of the timecharges this financial year.

Expenses Earned This Year

The total charge value of the expenses this financial year.

Hours to Date

The total number of hours booked to the project (based on the Effective Date currently set in the system).

Finalised Hours to Date

The total number of hours booked to the project that have been finalised (based on the Effective Date currently set in the system).

Hours This Year

The total number of hours booked to the project this financial year.

Hours in Progress

The total number of hours booked to the project that are still at status 'In Progress'.

Finalised Time Costs

The total resource costs of all hours booked to the project.

Time Costs to Date

The total resource costs of all hours booked to the project (based on the Effective Date currently set in the system).

Time Costs This Year

The total resource costs of all hours booked to the project this financial year.

Time Costs In Progress

The total resource costs of all hours booked to the project that are still at status 'In Progress'.

Time as Recharges

The total recharge value of all hours booked to the project.

Expense Costs to Date

The total costs of all expenses booked to the project (based on the Effective Date currently set in the system).

Expense Costs This Year

The total costs of all expenses booked to the project this financial year.

Expense Costs In Progress

The total costs of all expenses booked to the project that are not yet approved.

Non Chargeable Expense Costs

The cost of all non chargeable expenses recorded to the project.

Outsourced Costs To Date

The cost of all outsourced expenses recorded to the project up to the Last Costing Date.

Outsourced Costs This Year

The cost of all outsourced expenses recorded to the project this financial year.

Outsourced Costs In Progress

The cost of all outsourced expenses recorded to the project that are still marked as 'Entered' (not approved).

Outsourced Costs Earned

The charge value of all outsourced expenses (based on the Effective Date currently set in the system).

Outsourced Costs Earned This Year

The charge value of all outsourced expenses this financial year.

Target Percent Complete

This value is determined on how your system is configured to enter %age completions;-

 

By Hours Calc Percent Complete

100    *   Hours currently spent on the task    /    ( Hours currently spent on the task    +     Hours to complete the task  )

By Costs

100    *   Timesheet costs currently spent on the task    /    ( Timesheet costs currently spent on the task    +     Timesheet costs to complete the task  )

 

Cost to Complete

Refer to:- Cost to Complete (explained)

Last Percentage Complete Date

Returns the most recent date a task's completion date was entered.

Fees WIP

The value of Fees in WIP stored against the task (based on the Effective Date currently set in the system).

Timecharges WIP

The value of Timecharged in WIP stored against the task (based on the Effective Date currently set in the system).

Expenses WIP

The value of Expenses in WIP stored against the task (based on the Effective Date currently set in the system).

Fee Discounts Invoiced

The discounted value of Fees invoiced against the project.

Time Discounts Invoiced

The discounted value of Time invoiced against the project.

Expenses Discounts Invoiced

The discounted value of Expenses invoiced against the project.

Fee Discounts Invoiced This Year

The discounted value of Fees invoiced against the project this Financial Year.

Time Discounts Invoiced This Year

The discounted value of Time invoiced against the project this Financial Year.

Expenses Discounts Invoiced This Year

The discounted value of Expenses invoiced against the project this Financial Year.

Deferred Charges

The amount of Time charges that are currently deferred.

Invoiced Time Written Off

The value of Time written off after invoicing - NOTE: this time cannot be recovered.

Invoiced Hours Written Off

The number of hours written off after invoicing - NOTE: these hours cannot be recovered.

WIP Time Written Off

The value of Time written off during WIP preperation - NOTE: this time can be recovered until the next time task in invoiced. At this stage it will be added to Invoiced Time Writeoffs

Fee Hours

The number of hours booked to fee based tasks.

Timecharge Hours

The number of hours booked to time charged tasks.

Fees as Time Cost

The value of resource costs booked to fee based tasks.

Time as Time Cost

The value of resource costs booked to time charged tasks.

Fee Hours This Year

The number of hours booked to fee based tasks this financial year.

Time Hours This Year

The number of hours booked to time charged tasks this financial year.

Fees as Time Cost This Year

The value of resource costs booked to fee based tasks this financial year

Time as Time Cost This Year

The value of resource costs booked to time charged tasks this financial year.

Time Discounts WIP

The discounted value of Time currently in WIP for the project.

Draft Fee Invoiced

The value of Fees assigned to draft invoices.

Draft Time Invoiced

The value of Time charges assigned to draft invoices.

Draft Expenses Invoiced

The value of Expenses assigned to draft invoices.

Previously Written Off

The amount of time charges written off prior to the last invoice's 'Last Up to' date.

Currency Conversion Rate

as name suggests.

Fees Invoiced Currency

The total value of all Fees invoiced in the billing currency.

Time Invoiced Currency

The total value of all Time charges invoiced in the billing currency.

Expenses Invoiced Currency

The total value of all Expenses invoiced in the billing currency.

 

 

 

How to use this view

This view can be executed through any third party software you're using to connect to the Timemaster database (i.e. Microsoft Excel**, Microsoft PowerBI**, Microsoft SQL Management Studio etc.) providing it support the use of T-SQL.

 

It can also be executed directly from within Timemaster - Please refer to Executing SQL Scripts if you're unsure how to execute scripts from within Timemaster.

 

** These options can be used to create a live feed where the data can be refreshed within the software. Other options will create a static snapshot of the current data.

 

Click here for example syntax.

Basic Example;-

select

projectid,

[Project Title],

[Project Value],

[Agreed Invoice Limit],

[Client Fee],

[Forecast This Year],

[Forecast Next Year],

[Forecast Year 2],

[Forecast Year 3],

[Forecast Year 4],

[Forecast Unallocated],

[Scheduled Fee Earned],

[Total Fees],

[Potential Fees],

[Total Target],

[Total Target Hours],

[Fees Invoiced],

[Hours Invoiced],

[Time Invoiced],

[Expenses Invoiced],

[Fees Invoiced This Year],

[Time Invoiced This Year],

[Expenses Invoiced This Year],

[Fees Earned],

[Timecharges Earned],

[Expenses Earned],

[Fees Earned This Year],

[Timecharges This Year],

[Expenses Earned This Year],

[Hours to Date],

[Finalised Hours to Date],

[Hours This Year],

[Hours in Progress],

[Finalised Time Costs],

[Time Costs to Date],

[Time Costs This Year],

[Time Costs In Progress],

[Time as Recharges],

[Expense Costs to Date],

[Expense Costs This Year],

[Expense Costs In Progress],

[Non Chargeable Expense Costs],

[Outsourced Costs To Date],

[Outsourced Costs This Year],

[Outsourced Costs In Progress],

[Outsourced Costs Earned],

[Outsourced Costs Earned This Year],

[Target Percent Complete],

[Cost to Complete],

[Last Percentage Complete Date],

[Fees WIP],

[Timecharges WIP],

[Expenses WIP],

[Fee Discounts Invoiced],

[Time Discounts Invoiced],

[Expenses Discounts Invoiced],

[Fee Discounts Invoiced This Year],

[Time Discounts Invoiced This Year],

[Expenses Discounts Invoiced This Year],

[Deferred Charges],

[Invoiced Time Written Off],

[Invoiced Hours Written Off],

[WIP Time Written Off],

[Fee Hours],

[Timecharge Hours],

[Fees as Time Cost],

[Time as Time Cost],

[Fee Hours This Year],

[Time Hours This Year],

[Fees as Time Cost This Year],

[Time as Time Cost This Year],

[Time Discounts WIP],

[Draft Fee Invoiced],

[Draft Time Invoiced],

[Draft Expenses Invoiced],

[Previously Written Off],

[Currency Conversion Rate],

[Fees Invoiced Currency],

[Time Invoiced Currency],

[Expenses Invoiced Currency]

from

[vw_project_financials]

 

 

This lists all columns in the view. Columns can be removed as necessary. The last column name should not have a comma separator at the end of it.

 

 

Any images shown may be representative of the previous version of Timemaster

Report a problem

Please report any errors on this page to timemastersupport@equisys.com