Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
August 15, 2021
Question

group items

  • August 15, 2021
  • 3 replies
  • 13 views

In a quickbooks data file for a new client, the group item is being used on invoices with accounts rather than items.  It is very odd.  I believe this to be incorrect, as when the invoice is created there are certain account lines that get summed in the invoice.  But the accounting effect of this is not revenue,  but a contra expense transaction?  I can add more description if needed.   I believe the "group item" should be used with grouping "items"  not expenses on the expense side of the check.  thanks Lisa

3 replies

MaryLandT
Level 10
August 15, 2021

Let's check why the group item on the invoice is affecting the expense account, lisa009.

 

There's a possibility that one of the items from the group is using an expense account. You need to check each item and make sure it's using an income account.

 

Let me show you how:

 

  1. Take note of the components of the group so you know which items are included.
  2. Open each item and go to the Income Account section.
  3. Make sure that the account here is an income, not an expense.
  4. After making the changes, you can create a new invoice to reflect the account on the transaction.

 

To help manage your products and services, I'm adding this link for a guide: Add, edit, and delete items.

 

Learn the different ways you can track customer transactions in QuickBooks Desktop by checking out this article: Accounts Receivable workflow.

 

Let me know if there's anything else I can help manage your business transactions in QuickBooks. I'm always glad to help you.

lisa009Author
August 16, 2021

Thank You for the response.  I agree with Your comment.  Unfortunately, the issue is the use of "group" item showing up on invoices, and grouping "expense" items (not items linked to expense accounts).  It just pops up automatically.  The person processing these entries is not an accountant, and did'nt notice this happening.  Very hard to explain.   

AlexV
Level 10
August 16, 2021

Hi Lisa!

 

Thanks for the reply and screenshot. Let me further assist you with your invoices.

 

The items should show when creating invoices, not the accounts linked to them. We can check if this behavior is caused by a damaged data by running the rebuild tool. Follow these steps:

  1. Click the Window menu and select Close All.
  2. Go to the File menu, select Utilities, then Verify Data. Make sure to create a backup company file.
  3. Wait for it to load.
  4. Choose File again, Utilities then Rebuild Data.
  5. Tap OK when you get the Rebuild has completed message.

 

Also, I suggest seeking some help from your accountant so they can review how these group items were handled and check the effect on your books.

 

You can check this link: Add, edit, and delete items. This will explain more how to manage the products and services in QuickBooks Desktop.

 

I've also added this article if you need a guide in customizing your sales forms: Use and customize form templates.

 

Leave a comment again here if you need more help. We'll assist you!

August 25, 2022

Is there a way to get all of the line items (from the group) to print for internal use only?  I want the invoice to show just the description and total fee(s) when sending to a customer.

 

But I need to print the estimate for my technicians so they see not only the scope of work but each item and quantity they need to prep and load into their vehicles.

 

Please advise

August 25, 2022

Is there a way to get all of the line items (from the group) to print for internal use only?  I want the estimate and  invoice to show just the description and total fee(s) when sending to a customer.

 

But I need a way to print the estimate  or some sort of report for my technicians so they see the scope of work along with each item (equipment, part, material, etc.) and quantity of each so they can prep and load into their vehicles ahead of the job.

 

Please advise

Level 8
August 25, 2022

Hey there, @HMCarley

 

Thanks for joining in on this thread. I can share some details on this subject. 

 

You can easily print an estimate by hitting the print icon on the form. However, if you can give us some additional information on what you want on the form specifically when printing, this will help me determine the best solution for your business. 

 

I'll be waiting for your response!

October 28, 2022

When I add a group item to an estimate, save the estimate, close it and then re-open it at a later date, the group item is not there and I have to re-enter it again, and again if I save and close again.  This is a pain because group items are a major part of our estimates!