Job Cost Ledger

Job costing is as important to the majority of our customers as their accounts.  Because of this Construction Industry Accounts (CIA) has a very flexible, fully integrated job cost structure.

Each new contract is setup within the job costing ledger, this can be linked to a customer if necessary.  Information recorded is the job name and address (this can default to the customer address), contact names and telephone numbers.  You can also record the estimated start time of the job.

The most important part of job costing is designing the job breakdown or analysis structure.

Key Benefits

• User definable analysis codes
• Unlimited breakdown of a job
• Budget entries
• Multiple reports
• Summary or full breakdown of costs
• Profit reporting on jobs
• Compare actual costs against budgets

Analysis Codes

Analysis codes are the heart of the job costing ledger, each job can be broken down into any number of analysis codes.

The user may keep a simple structure eg:

Materials

Labour

Sub contractor

Plant Hire

Miscellaneous

Or break down into as much detail as necessary eg

Materials

Tiles

Bricks

Blocks

Aggregate

Labour

Bricklayer

Carpenter

Roofer

The Job Cost structure is completely flexible and the user can have as many or few codes as is necessary.

Templates.

Most companies keep the same job cost structure, using the same analysis codes for every job.  The user can define any number of templates, when a new job is created a standard template is copied across automatically. 

Budgets

An optional part of job costing, if an estimate has been raised the user can assign a budget against each analysis code, enabling them to compare actual job costs against budgets.

Variations

Once a job is running there are often changes to the plan, if the user wants to job cost these variations separately, extra analysis codes can be added to the job at anytime.

Once a job is setup, the actual job costing occurs automatically as purchase invoices, payoll, subcontractor invoices, application for payments (stage payments)etc are entered.

Reporting

The key part of job costing is the reports that can be generated, Construction Industry Accounts (CIA) has a number of reports depending on the information the user requires.  All reports can simply be exported to Excel.

• Job Cost Daybook

Details all job costs entered for any job over the specified date range in order of job then date.

• Job Cost by Date

Details all job costs entered for a specific job over the specified date range in date order.

• Job Cost by Analysis

Details all job costs entered for any job over the specified date range in analysis code order

• Job Cost Summary

Shows the total job cost entered for each analysis code, against the budgeted costs, over a specified date range.  Shows percentage of budget used and highlights when any analysis code has gone over budget.

• Job Cost Report (Filtered)

Allows the user to filter the Job Cost by Date report.  Instead of listing every single entry, the user can filter for a particular analysis code, supplier, description or employee for a particular date range.  This can be very useful job cost report for finding particular information. Eg when was the last time we hired a cherry picker? the report will show what job it was for, who it was hired from, the cost and the invoice that was posted (allowing the user to find the original).

• Job Value Report

Shows the total job cost, revenue, profit/loss, markup and profit margin for  the selected jobs over the selected date range.

• Job Subcontractors

Shows for each subcontractor, the total Application for Payments (Stage payments), Total Paid, Total Discount, and Total balance outstanding for each job that subcontractor has worked on.

• Statements

Detailing all sales invoices or sales applications, with money still outstanding, for any job at a particular date.

• WIP Report (Work in Progress)

Shows total costs, total revenue and the work in progress figure, for the selected jobs for the selected date range.

• Committed Costs Report

Shows the total job cost for each analysis code, the total committed cost for each analysis code, (the committed cost is the costs from purchase orders raised, that have not been matched against an invoice).  Compares this against the budgeted costs over a specified date range.  Shows percentage of budget used and highlights when any analysis code has gone over budget.

• Budget Analysis

Shows the total costs and total budget, with the variation, also shows the total revenue and the budget, with its variation, and the total profit or loss.  This is detailed for the specified jobs over the specified date range.

• Employee by Job

Shows for each job, every employee who has worked on it, a line by line breakdown is given for each timesheet entry made.  This report can be run by a date range, a PAYE week, or PAYE month.

• Job by Employee

Shows for each employee, every job they have worked on, a line by line breakdown is given for each timesheet entry made.  This report can be run by a date range, a PAYE week, or PAYE month.

• Jobs without Sales Invoices

Lists all current jobs that have not had a sales invoice booked to it, shows job name and contact details, start date and a total of all costs booked to it.

• List of Jobs
• List of Analysis Codes