LIMITED TIME OFFER get 90% off for 6 months
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
psellick8
Level 2

Can different categories of an invoice be separated and recorded?

Eg. If an invoice totals £300 but is made up of 3 lines, labour £150, Materials £100, mileage £50 for example. Can these be broken down like the expenses tab and added altogether. So all the labour from every invoice gets added together after a year, all the materials get added up after a year, all the mileage gets added up after a year. This way i can find how much income was labour, how much income was from materials sold etc.
Solved
Best answer May 11, 2020

Accepted Solutions
Mark_R
Moderator

Can different categories of an invoice be separated and recorded?

Hi there, @psellick8.

Adding different categories in an invoice is currently unavailable. However, you can consider creating a service item and add it to the invoice to break down the income. Let me guide you through the process.

Based on your example, you can create service items for labour and mileage and add them as line items in your invoice. Here's how:

 

  1. Click the Gear icon, then select Products and services1.PNG
  2. Select New and choose Service.
  3. In the Name field, enter Labour.
  4. Enter the amount in the Sales price/rate field and choose the appropriate income account from the drop-down.
  5. Click Save and close.2.PNG

Please repeat the steps for the mileage. For more guidance, feel free to check out this article: Add product and service items to QuickBooks Online.

You can also set up sub accounts which in reporting will show separately the income/expense of the sub account and then overall the total of the parent chart of account so you can see both which is handy in some situations.

 

Once done, you can now create an invoice and add the service items you created as a line item.

 

I've attached a screenshot below for your visual reference.3.PNG

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good one and be safe.

View solution in original post

1 REPLY 1
Mark_R
Moderator

Can different categories of an invoice be separated and recorded?

Hi there, @psellick8.

Adding different categories in an invoice is currently unavailable. However, you can consider creating a service item and add it to the invoice to break down the income. Let me guide you through the process.

Based on your example, you can create service items for labour and mileage and add them as line items in your invoice. Here's how:

 

  1. Click the Gear icon, then select Products and services1.PNG
  2. Select New and choose Service.
  3. In the Name field, enter Labour.
  4. Enter the amount in the Sales price/rate field and choose the appropriate income account from the drop-down.
  5. Click Save and close.2.PNG

Please repeat the steps for the mileage. For more guidance, feel free to check out this article: Add product and service items to QuickBooks Online.

You can also set up sub accounts which in reporting will show separately the income/expense of the sub account and then overall the total of the parent chart of account so you can see both which is handy in some situations.

 

Once done, you can now create an invoice and add the service items you created as a line item.

 

I've attached a screenshot below for your visual reference.3.PNG

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good one and be safe.

Need to get in touch?

Contact us