Skip to main content
April 13, 2024
Question

Batch Entries for Sales Orders and/or Purchase Orders

  • April 13, 2024
  • 1 reply
  • 0 views

Is there a native way or a third-party add-in that will allow me to enter items in bulk, using import or copy/paste, when creating a Purchase Order or a Sales Order.
See attached screenshots.
When creating either, it is extremely time consuming to manually type in each and every item, since they are all already in an Excel workbook, it would be extremely efficient to simply copy and paste.

1 reply

April 13, 2024

I can see how entering items in bulk will make your work faster, jkhalaf. I'd be glad to help you how to make this happen in QuickBooks Desktop (QBDT). 

 

To achieve this, you can create a Group item in QBDT, which allows you to quickly enter a group of individual items that are typically purchased or sold together. This is especially useful when tracking the details of individual items is necessary. 

 

Here's how:

 

  1. Click the Lists menu, then select Item List to open the Item List window. 
  2. Click the Item button in the lower left corner of the list window arrow and select New. 
  3. Select Group in the Type dropdown. 
  4. Enter the necessary information and then hit OK

 

Once you have created a group of items, you can proceed to create either a purchase order or a sales order. You can then apply the group items you've created by selecting or entering the group name or number in the line item. This way, you can easily add multiple items to the order at once instead of adding each item individually. 

 

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.

 

Feel free to reach out to us if you have further questions about batch entries in QBDT. The Community is always available to help. Have a good one.