Job Costing Sheet

What Is a Job Costing Sheet?

A Job Costing Sheet is a record used to track the actual expenses and income associated with a specific project or task. For Australian tradespeople, builders, and small businesses, it is the primary tool used to determine if a job made money or lost it. Unlike a basic invoice, which tells a client what they owe, a costing sheet tells the business owner what the job actually cost to complete.

This document tracks every expense involved in a project. It records the cost of materials, the labour of employees and subcontractors, and any other specific expenses like equipment hire. By comparing these actual costs against the original quote or budget, a business can see exactly where profit was made or lost.

In the Australian context, this sheet is more than just a financial tool. It acts as a legal record of business activities. The Australian Taxation Office (ATO) requires businesses to keep records that explain all transactions. A Job Costing Sheet serves this purpose by linking income and specific deductible expenses to a particular job. It is essential for proving the validity of a deduction during an audit.

The document also helps distinguish between "Hard Costs" and "Soft Costs". Hard costs are the direct physical expenses like timber, concrete, and subcontractor fees. Soft costs include overheads, design fees, and sometimes internal labour allocations. Tracking these separately is vital for understanding Gross Margin. Industry experts, such as the Master Builders Association, highlight that detailed costing is the only way to identify profitability leakage, particularly in construction where small errors can compound.

When to Use This Document

You should use a Job Costing Sheet for every distinct project you undertake, regardless of size. It is most effective when used from the moment a quote is sent until the final invoice is paid.

For Cost-Plus Building Contracts

If you work in the construction industry, you may enter into "Cost-Plus" contracts. This is where the client agrees to pay the actual cost of the build plus a percentage margin. Under state-based regulations, such as the Home Building Act 1989 in NSW, builders must provide evidence of actual costs incurred. In this scenario, the Job Costing Sheet is a legal requirement. It must be a "true record" of the costs. You cannot simply guess the numbers at the end of the month; they must be recorded as they happen.

For Fixed Price Projects

Even when working on a fixed price, using this sheet is critical. It allows you to monitor variance. If you quoted $5,000 for a job but your costing sheet shows the materials alone cost $4,500, you have a serious problem. Identifying this variance early allows you to fix processes or pivot on spending before the job finishes.

For Tax Time

The ATO requires records to be kept for five years under the Income Tax Assessment Act 1936 and Taxation Administration Act 1953. Using a Job Costing Sheet throughout the year makes end-of-year tax returns much simpler. Instead of digging through a shoebox of receipts, you have a consolidated record of income and expenses linked to specific jobs.

For Employee Tracking

If you employ staff, this document is often used alongside timesheets to track labour costs. Under the Fair Work Act 2009, employers must keep accurate records of hours worked and pay rates. A Job Costing Sheet that captures these details helps ensure you are paying staff correctly according to Modern Awards and the National Employment Standards.

Key Sections and Required Elements

To be effective and compliant with Australian regulations, a Job Costing Sheet needs specific sections. A blank sheet is not enough; it must be structured to capture the right data.

Job Identification & Control

This section links the financial data to the physical work. You must include the Job Number, Client Name, and Site Address. The dates for the Start and Completion of the project are also required. This information is necessary to satisfy ATO record-keeping requirements, which dictate that you must be able to link income to specific jobs.

Labour Costing

This section tracks the cost of your workforce. It is not enough to just write "Labour: $2000". You need detail. The sheet should include the Employee Name, Date, Hours Worked, and the Hourly Rate. You should differentiate between the "Cost Rate" (what you pay the worker plus superannuation) and the "Charge-Out Rate" (what you bill the client). This level of detail ensures compliance with Fair Work Regulations 2009 regarding record-keeping.

Materials & Inventory

Here you record the physical items used. For each line item, include the Item Description, Supplier Name, Unit Cost, and Quantity Used. Crucially, you must note the GST status. This helps when reconciling your Business Activity Statement (BAS) at the end of the month. It ensures you are claiming the correct Input Tax Credits from the ATO.

Variations & Scope Changes

This is often the most important section for profitability. Clients often ask for small changes, like moving a power point or changing a paint colour. These are "variations". The sheet must record the Variation Description, the Cost Impact, and the Client Approval. Under Australian Consumer Law and state building regulations, you must have evidence that the client agreed to pay for the extra work. Failing to record this means you often end up doing the work for free.

Summary & Profitability Analysis

The final section provides the overview. It should list the Total Estimated Cost versus the Total Actual Cost. This shows the Variance in dollars and percentage. It should then list the Total Revenue and the resulting Net Profit. This summary allows you to see if your quoting is accurate. If you consistently see a negative variance on materials, your supplier prices might have gone up and your quotes need to adjust.

How to Write a Job Costing Sheet (Step by Step)

Creating a useful Job Costing Sheet requires a methodical approach. Follow these steps to ensure your records are accurate and useful.

Step 1: Set Up Your Cost Codes

Before you start a job, establish a list of Cost Codes. These are standard categories for your expenses. For example, you might use code 100 for Timber, 200 for Concrete, and 300 for Electrical. Aligning these codes with the categories used in your tax return simplifies your reporting. Many Australian businesses use categories that match their accounting software, such as Xero or MYOB, to make data entry easier.

Step 2: Fill in Job Details at the Start

When the job begins, fill out the identification section immediately. Write down the client name, site address, and the date. Assign a unique Job Number. This number should be used on all purchase orders, timesheets, and invoices related to this project. It creates a "digital thread" that ties everything together.

Step 3: Record Materials as They Arrive

Do not wait until the end of the week to record materials. As soon as a delivery arrives, record the items on the sheet. Note the supplier, the quantity, and the cost including GST. If you have a Tax Invoice, file it and reference it on the sheet. This real-time recording prevents forgotten expenses and ensures your inventory count is accurate.

Step 4: Track Labour Daily

Labour is often the biggest expense. Record hours daily. If you have employees, ensure they fill out timesheets that break their time down by job. Transfer this data to your costing sheet. Include the cost of superannuation and workers insurance in your labour calculation, as these are real costs to the business. This practice is recommended for complying with Fair Work Ombudsman guidelines.

Step 5: Log Variations Immediately

When a client requests a change, stop and write it down. Describe the change, estimate the cost, and get the client to sign off on the variation. Many tradies use a specific Variation to Contract form for this. Once signed, record the details on the Job Costing Sheet. This protects your cash flow and ensures you get paid for the extra work.

Step 6: Reconcile and Review

Once the job is finished, do a final review. Check that every invoice matches an entry on the sheet. Calculate the totals for materials, labour, and other expenses. Compare the total actual cost to your original quote. Calculate the final profit margin. This step is where you learn the most about your business efficiency.

Common Mistakes to Avoid

Even experienced business owners can make errors with job costing. Being aware of these pitfalls can save you thousands of dollars.

Confusing Markup with Margin

This is a classic error in Australian business. A 20% markup on a $1000 cost is $200, making the sale price $1200. However, the margin on that $1200 sale is only 16.6%. If you base your profit targets on markup but measure them on margin, your books will never balance. Always calculate your profit based on the total revenue (margin) rather than just adding a percentage to the cost (markup).

Omitting Unbillable Time

Many business owners only track time they can directly charge to a client. However, time spent on quoting, cleaning the site, or driving to the hardware store is a real cost. If you do not record this "unbillable time", your job will appear more profitable than it really is. This distortion leads to underpricing future jobs because you are ignoring the true cost of doing business.

Mixing Business and Personal Expenses

The ATO watches personal expenses closely. A common mistake is using a business account to pay for personal items and then trying to record them as job costs. Similarly, claiming 100% of a vehicle's use on a Job Costing Sheet when it is also used for personal trips is a red flag. You must apportion expenses correctly based on actual business use to avoid audit risks.

Poor Record Security

Under the Privacy Act 1988, businesses with a turnover of more than $3 million (and some smaller businesses) must protect personal information. Leaving physical Job Costing Sheets containing client names and addresses in an unsecured ute or office is a breach of "reasonable steps" for data security. Digital storage must be password protected and backed up.

Legal Considerations (AU)

Using a Job Costing Sheet in Australia comes with specific legal obligations. These are not just suggestions; they are requirements under federal and state law.

Tax Obligations

The ATO is strict about record-keeping. You must keep records that explain all transactions. Your Job Costing Sheet, supported by source documents like receipts and Invoices, must be kept for 5 years. If the ATO audits your business, they will look for these records to verify your income tax and GST claims. If you cannot produce them, you may face penalties.

Fair Work Compliance

If you use the sheet to track employee hours, it becomes an employee record. The Fair Work Regulations 2009 sets out what must be recorded. This includes the employee's name, hours worked, and rate of pay. Failing to keep these records can result in heavy fines. It is wise to cross-reference your Job Costing Sheet with your payroll records to ensure accuracy.

Consumer Law and Quoting

The Australian Consumer Law (Schedule 2 of the Competition and Consumer Act 2010) prohibits misleading and deceptive conduct. If you use your internal costing sheet to generate a quote for a consumer, the quote must be accurate. You cannot quote a low price to get the job, knowing your internal costs show it will be much higher, without disclosing this to the client. This is considered misleading conduct.

Building and Construction Regulations

For builders and contractors, state regulations add another layer. In NSW, Queensland, and Victoria, specific building acts require detailed records for home building work. If a dispute arises with a client over price, your Job Costing Sheet may be used as evidence in a tribunal or court. It must be accurate and contemporaneous (written at the time, not recreated later). If you are working under a cost-plus contract, failure to provide these records to the client can be a breach of contract.

Frequently Asked Questions (FAQ)

What is the difference between a Job Costing Sheet and an Invoice?

A Job Costing Sheet is an internal document used to track your expenses and profits. An Invoice is an external document sent to a client to request payment. The costing sheet helps you determine what to put on the invoice, but they serve different purposes.

Do I need a Job Costing Sheet for very small jobs?

Yes. Even small jobs have costs. Tracking them helps you understand if small jobs are actually worth your time. Many small businesses find that small jobs are often the least profitable due to high setup and travel costs. A costing sheet reveals this truth.

Can I use spreadsheet software for my Job Costing Sheet?

Yes, many Australian businesses use Excel or Google Sheets. However, cloud-based accounting software like Xero or specialised trade apps are becoming more popular. These platforms can automate the entry of supplier invoices and bank feeds directly into your job costing records, saving time and reducing errors.

How long do I need to keep Job Costing Sheets?

Most business records must be kept for 5 years after the record was created or the transaction was completed, whichever is later. This is mandated by the ATO. It is best to store them digitally to ensure they are safe and easily accessible.

What if I forget to record a variation?

If you forget to record a variation, you will likely have to absorb the cost. This reduces your profit. In a legal dispute, without a signed variation record, it is very difficult to prove the client agreed to the extra cost. Always record changes immediately.