JACK allows you to export many types of reports to help you manage your business.
Builder Gain / Loss Report
The Builder Gain / Loss report shows all gains and losses that have been entered against costing items in your Job Budget. This allows you to see where you are gaining or losing profit on your jobs.
Gains and losses are changes to the budget that you do not pass on to the client. For example, if you get a cheaper quote from a supplier and the job is a fixed-price job, this would become a gain. Your profit on the job would be more than the original estimated profit.
You can report on a specific job, or on all jobs and filter the report by:
Date created
Contract price
Job Supervisor & Created By (See how your Site managers are performing)
Reason Code (See the reasons for gains and losses)
Cost Category (Is there a cost category that you are regularly over or underestimating)
Pro Tip: Filter all losses by particular reasons, e.g. estimating error. This will give you an accurate number relating to what estimating errors cost you for that year.
Work in Progress Report
The Work in Progress report shows your construction WIP figure. This will tell you if you are in an under-invoiced (asset) or over-invoiced (liability) position on your jobs.
Understanding your Construction WIP figure can help you understand if the cash in your bank actually belongs to you or if it is money you have received from your clients that needs to be paid to your suppliers or contractors.
Note: All figures in a WIP report are tax-exclusive.
You can report on all jobs, a single job, or choose multiple jobs.
How JACK calculates WIP for fixed-price contract jobs:
WIP = Recognised revenue* - Client invoices issued to date
*Recognised revenue
= Contract price** multiplied by ( Actual costs*** divided by Expected total**** )
**Contract price = **Signed contract price plus Approved variations
***Actual costs = Bills approved for payment plus Approved timesheet costs
****Expected total
= Original estimate plus Builder gain/loss amounts plus Variation costs
If WIP is a positive number (Recognised revenue exceeds client invoices issued to date), then there is a WIP Asset.
If WIP is a negative number (Recognised revenue is less than client invoices issued to date), then there is a WIP Liability.
How JACK calculates WIP on cost-plus jobs:
WIP = Recognised revenue* - Client invoices issued to date
*Recognised revenue
= (Bills approved for payment + Approved timesheet costs) multiplied by Markup %
Pro Tip: Your accountant should request a WIP calculation at the end of the financial year, and you may also need to provide your insurer or bank with an up-to-date WIP calculation when you renew your business insurance or need a loan. JACK can provide this figure, with no additional data entry required.
Lead Activity Report
Track the amount of activity for all leads or a specific lead to better understand your business. Looking at your overall lead activity will give an insight into your sales processes, allowing you to make more informed decisions.
You can export a report that shows the number of actions that have been completed for each lead or all lead's and which staff member completed the action.
Examples of actions you can report on are:
Lead created
Details saved
Document created
Estimate created
Estimate details saved
Automation run
Costings exported
Costings printed
Lead converted to a job
Lead lost
Lead Source Report
Understand the source of your leads to help you make better-informed decisions.
You can export a report that shows the number of leads created for each staff member and/or the source of each lead.
Pro Tip: Run the report for each Created By to see how your sales employees are performing and whether they need to focus on any different types of lead sources.
Tasks Report
Understand the allocation and status of all tasks across your business.
You can export a report that shows all tasks across your business, who they are allocated to, and what status the tasks are in.
Pro Tip: Filter tasks by status, due date, and department to get an overview of how particular departments are tracking and ensure there are not too many overdue tasks in that department.
Timesheets Report
Report on all approved timesheets to understand the labor costs being allocated to jobs & cost categories.
Filtering based on jobs, or all jobs for a particular cost category, can give you an instant snapshot of hours spent across all jobs for a particular category and also drill down into a particular staff member.
Job Estimated vs Actual Report
This report allows you to compare actual profit achieved to estimated profit on a per-job basis. For fixed price jobs, this will show you the impact that Builder Gains / Losses and variations have on your profit.
You can report on all jobs, a single job, or choose multiple jobs.
You can report on jobs in different statuses.
Job Budget Report
The job budget report allows you to export a job budget into CSV format.
You will be able to review the following data:
Cost amount remaining by cost category
Item estimated cost
Item variations cost
Item gain/losses cost
Updated expected total by cost item
Bills approved against each cost item
The amount remaining to be paid for each cost item