Use Job Headers to group similar Jobs together

If you have numerous Jobs and you are drowning in detail you will find it difficult to understand your job profitability and see trends in your business.  

Why not Categorise your jobs into similar groupings or into a hierarchy?

In MYOB you are able to easily setup a Job Hierarchy by creating Job Headers and then associating each detail job with a header.  You can even set up multiple Job Header levels.
For example you could group your Jobs by Division  (New Sales/Service/Admin) and or by State etc.

Once setup in MYOB these Job Headers will also appear in BI4Cloud where you can use them to:

• Group by
• Analyze by
• Filter
• Pivot on
• Visualize in Charts & Dashboards

1. In MYOB add new jobs that are Header Jobs.
   
   
   
   Remember you can have more than one Level of Header Jobs. This will build up a hierarchy.  
   
   Do not set up Header Jobs for Fields in the Job Card as you will already be able to group and report based on these fields.
   
   - Manager
   - Linked Job Customer
   - Contact (This field can be used for any purpose to group and report on Jobs) 
   
   
   
   
   
   
   
2. Next assign all detail jobs to a header job. Remember that you can have multiple levels of Header Jobs. 
   
   
   
   
   
3. In BI4Cloud use Job Headers to Group by Job Header Levels to see like Jobs together.
   
   Here all Jobs are shown as a List in rows and Grouped together by the Level 1/Job Header, in this case the Header is a Division/Department.
   See activity monthly
    
   
   Show Jobs as a LIst grouped by the Job Header
   
   
   
4. Use Job Header Levels to Analyze by to see your business at a higher level.
   
   Copy the Tab P&Lby  Mth, note it is set up to Analyse by individual GL Accounts. If you change this to Analyse by Job Level 1, this will consolidate up all Job Numbers into the Level 1 Header, the result shows the contribution of each Division to Income, COGS, Expenses etc.
   
   
   
   
   
5. Filter on one Job Header Level to focus on just that part of your business. Then you can see a  mini P&L for only Jobs under that header.
   
   Classic Month to date v Year to date P&L
   
   
   
   
   
6. Pivot on a Job Header Level to compare performance across all Job Headers (Divisions).
   
   Copy the Tab P&L by Mth, note it is set up to Pivot by Months in the Columns. If you change this to Pivot by Job Level 1, this will consolidate up all Job Numbers into the Level 1 Header, the result shows a P&L for  each Divisionand chan include Actual, Budget Variance etc. 
   
   
   
   
   
7. Chart to see the monthly Income trends by Job Headers (Divisions).
   
   Copy the Income Bar Chart and change the Analyse by field to Job Level 1 to Analyse by Job Header, Group by Transactions by Month to get Months across the bottom and Filter for just the Job Headers you want included. This shows the contribution of each Division to total Income by month.
   
   
8. Run a Dashboard then add a Filter by Job Header to create a Dashboard for each Division. Here I have filtered for Just the Pool Shop division which picks up the two Shops/Jobs under that division.
   
   
   
   
9. Save - Don't forget once you have created a report tab with just the right dimensions Save the Workbook so it is there for you to use again and again.

www.BI4Cloud.com