Understanding the Financial WIP Dashboard

Overview of the Financial WIP Dashboard

The Work In Progress (WIP) dashboard provides a quick view of the financial status of ongoing jobs. These are jobs that have started and incurred costs but are not yet financially completed. This tool helps you efficiently assess their financial completion.

Business Rules for WIP Calculation

• Job Status: The dashboard displays jobs that have started but are not marked as financially completed. It includes jobs that have incurred costs even if they haven't started operationally.
• Financial Representation: Financials are included from individual jobs and not at the group job level.

Using the Dashboard

Currency

• The default currency is British Pounds (GBP). To view data in a different currency, use the 'Currency' filter in the global filters section.

Currency Conversion

• Financial details are converted using the exchange rate from the day the line item was created. This applies to both job financial lines and financial documents.

Understanding Visuals and Charts

Visual 1: Total Sales vs Invoiced & Uninvoiced

• Purpose: Displays total sales against invoiced and uninvoiced amounts for WIP jobs, grouped by their WIP start month.
• Interaction: Select each bar to view detailed data. Use the '?' icon for help text.

Visual 2: Costs vs Invoiced

• Purpose: Compares job costs from job lines and purchase orders against invoiced values.
• Interaction: Select each bar for detailed data. Use the '?' icon for more information.

Visual 3A: Actual Margin

• Purpose: Shows actual margin percentage using invoices and credit notes against job value.
• Interaction: Select each bar for detailed data. Use the '?' icon for more information.

Visual 3B: Actual Profit

• Purpose: Displays actual profit using invoices and credit notes against job value.
• Interaction: Select each bar for detailed data. Use the '?' icon for more information.

Visual 4A: Job Value by Job Type (Top 10)

• Purpose: Highlights the most valuable WIP jobs by job type.
• Interaction: Select to see metrics for a specific job type.

Visual 4B: Job Value by Resource (Top 10)

• Purpose: Highlights the most valuable WIP jobs by resource.
• Interaction: Select to see metrics for a specific resource.

Visual 5: Completed not Invoiced

• Purpose: Shows WIP jobs that are operationally completed but not yet invoiced.

Visual 6: Scheduled

• Purpose: Displays the total number of scheduled WIP jobs.

Visual 7: Started

• Purpose: Displays the total number of started WIP jobs.

Visual 8: Invoiced

• Purpose: Displays the total number of invoiced WIP jobs.

Visual 9: Job Value by Contact (Top 10)

• Purpose: Highlights the most valuable WIP jobs by contact.

Global Filters

• Contact Group, Parent Contact, Contact, Job Category, Job Type, Resource Group
• Date Type: Choose 'Actual start date', 'Due date', or 'Planned start date' to filter WIP data.
• Date: Select a date range for the chosen date type.
• Currency: Choose any currency to view the data in. The default is GBP.

Conclusion

The Financial WIP Dashboard is a powerful tool for monitoring the financial status of ongoing jobs. By understanding and utilising the various visuals and filters, users can gain valuable insights into job progress and financial health. Explore the dashboard and its features to maximise its potential.