Equipment Job Costing
I'm using Quickbooks Online and Projects for Job Costing for my excavation business. How can I set up accounting and reporting for equipment costs that are not directly part of the Projects?
For example, I have two excavators that I typically bill at $150/hr and $200/hr. That's what shows up on the estimate and invoice, but for my accounting purpose I want to track the actual hourly costs of operating those machines, which might include:
Operator cost: $50/hr
Fuel Costs: $10/hr and $15/hr
Total machine ownership costs including maintenance & repairs: $25/hr and $70/hr
Business overhead costs: $45/hr
and Profit/Loss from each machine per hour/job: $20/hr
Is there a best way to set up accounts for job costing these machines that can show me the difference between what I estimated/invoiced for against the actual cost of operating the machines? I'd like to be able to compare the estimate/invoice against actual hours on each job.
