Understanding the dashboard
The Overall Profitability Dashboard provides profitability metrics and in-depth insights. It allows you to compare billing amounts to job costs calculated using timesheets and hourly salary rates. Additionally, it helps analyse the profitability of each job. You can optimise its use by selecting a job manager and assessing their profit margin. If it falls below acceptable levels, your organisation can take corrective measures to boost profits.
Why is it important?
Enables you to make informed decisions about resource allocation and job management to maximise profits.
Identifies instances where the cost of a job exceeds its billing amount, indicating potential profit loss.
Highlights areas where your organisation can improve profitability and implement counter measures.
Explore the Overall Profitability dashboard by clicking through the interactive demo below!
Interactive demo
Dashboard FAQs
The Overall Profitability dashboard consists of key metrics such as Billing, Costs, Profit and Profit % to help further analyse the financial health of your organisation or specific jobs. Let us answer the FAQs for each metric below:
How is Cost calculated?
This calculation relies on the Hourly Rate entered in Google Sheets, multiplied by the Hours recorded in the timesheet (referred to as Time Costs), in addition to Disbursement Costs.
How is Profit calculated?
Profit is determined by subtracting the Invoiced Billing amount from the total Costs incurred.
How is Profit % calculated?
This is the ratio of Profit to Invoice Billing, indicating the portion of revenue your firm retains after accounting for job costs.
How do you flag which Profit % is red, yellow, or green?
Utilising the Profit Margin Traffic Light, you can establish minimum and maximum thresholds. When the profit % falls below the minimum, it's indicated in red. If it's within an acceptable range, it's displayed in yellow. When the profit % exceeds the maximum threshold, it's shown in green.