Skip to main content
April 23, 2022
Question

How to calculate most profitable type of work

  • April 23, 2022
  • 1 reply
  • 0 views

Hi,

 

I'm trying to use quickbooks to work out the types of jobs that make the most money as an electrician. I originally thought projects was the best way to go however I would manually have to group projects through something like excel to create a report. I then thought tags because I can then select job types and do a report based on that. However with tags I can't see how to link them to projects or to labour (time) which being an electrical company is essential in the costings. Does anyone have an idea on how they had a way around this?

 

Currently I have projects set up with the invoices and expenses linked. It does mean though I have to look at each invoice to determine the job type and then copy the project data into an excel spreadsheet. There must be an easier way to do things than this?!

 

Regards, Jamie

J P Electrical

1 reply

April 23, 2022

Hello, @JamieP1.

 

Thanks for reaching out to us today. I'll share some information about customer projects and tags. You're in the right track of using projects for every job type you have for your customer. From there, you can use the Project Profitability report to know how much you're making or losing on this project.

 

About tags, these are customizable labels. This feature will let you do the following:

 

  • Customized labels that let you track whatever you want.
  • Add tags to a transaction such us invoices, expenses, and bills.
  • Tags don't impact your books.

 

With the above mention, you can add tag to your project's invoices. This way, it'll be easier for you to keep track of the job types. Then, run tag reports for further details.

 

 

 

 

 

Here are some articles with information and short videos about projects and tags.

 

 

Additionally, here's a link that'll help you manage customer-related tasks. It has topics with articles to guide you along: Sales and Customers.

 

Please let me know if you have other questions or concerns with projects or job types. I'm more than happy to assist you. Take care and have a great day ahead.