cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
muhammad-farooq-
Level 1

Can we add multiple Products in single Invoice While Importing bulk Invoice through sample excel file? or we have to create multiple Rows/Invoices for each prod/services?

QBO has the option to add mutiple products while Importing bulk Invoices through Excel file?
2 Comments 2
Fiat Lux - ASIA
Level 15

Can we add multiple Products in single Invoice While Importing bulk Invoice through sample excel file? or we have to create multiple Rows/Invoices for each prod/services?

Like this one?

RefNumberCustomerTxnDateDueDateShipDateShipMethodNameTrackingNumSalesTermLocationClassBillAddrLine1BillAddrLine2BillAddrLine3BillAddrLine4BillAddrCityBillAddrStateBillAddrPostalCodeBillAddrCountryShipAddrLine1ShipAddrLine2ShipAddrLine3ShipAddrLine4ShipAddrCityShipAddrStateShipAddrPostalCodeShipAddrCountryPrivateNoteMsgBillEmailBillEmailCcBillEmailBccCurrencyExchangeRateDepositToBePrintedToBeEmailedAllowIPNPaymentAllowOnlineCreditCardPaymentAllowOnlineACHPaymentShipAmtShipItemDiscountAmtDiscountRateTaxRateTaxAmtDiscountTaxableLineServiceDateLineItemLineDescLineQtyLineUnitPriceLineAmountLineClassLineTaxable
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y MP3 PlayerBlue MP3 Player255  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Leather CaseLeather Case210  TAX
101Janice Johnson01/10/2020 01/12/2020Ground Net 30  110 Main StreetSuite 2000  DallasTX99875 110 Main StreetSuite 2000  DallasTX99875 Special HandlingThank you for your order!     0NYNNY12Shipping 0.02  Y Gift CardsGift Cards25  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y HandheldsPortable Game Player1100  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Software1 Year Warranty125  TAX
102Leonard Walker Inc01/10/2020    Net 30  9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345  Thank you for your order!     0YNNNY      Y Extended Warranty1 Year Extended Warranty15  TAX

 

SirielJeaB
Moderator

Can we add multiple Products in single Invoice While Importing bulk Invoice through sample excel file? or we have to create multiple Rows/Invoices for each prod/services?

Greetings, Muhammad! Thank you for reaching out to us. We're thrilled to assist you in clarifying how to handle bulk invoices. 

 

Indeed, it is possible to include multiple products when importing bulk invoices through an Excel file. To help you get started, please download this sample spreadsheet as a reference.

 

Here's a step-by-step guide on how to upload your spreadsheet to your QuickBooks Online (QBO) account:

 

  1. Click on the Gear icon and select Import data.
  2. Choose Invoices.
  3.  (Optional) Tick the checkboxes to add new customers or products and services that are not yet in QuickBooks.
  4. Browse and select the relevant invoices.
  5. Hit Next.

 

For more details and processes, check out this article: Import multiple invoices at once in QuickBooks Online.

 

Additionally, here are other helpful articles that you can refer to in importing data within the program:

 

 

We're available round the clock to assist you. If you have any further concerns, please feel free to click on the Reply button below. We look forward to assisting you in the future. Stay safe!