Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks. Explore QuickBooks Payroll
milesmoen
Level 1

Importing multiple invoices with a "Ship To Name" field

I need to bulk upload invoices every day into QuickBooks Enterprise. Is there a way to include the field "Ship To Name" when doing that? I can get the ShipToAddress 1-5 fields, but haven't found a way to include something in that dropdown

 

 

 

2 Comments 2
Fiat Lux - ASIA
Level 15

Importing multiple invoices with a "Ship To Name" field

You can prepare invoices data with the following template

CustomerTransaction DateRefNumberPO NumberTermsClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureAR AccountCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000              Non
Anne's Bakery01/09/2020100    Y15/09/2020Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50              Non
John's Barber Shope02/09/2020101    Y15/09/2020John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500              Non

 

then use one of these importer tools to proceed

https://get.transactionpro.com/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

LeizylM
QuickBooks Team

Importing multiple invoices with a "Ship To Name" field

Hi there, milesmoen. Let me share details about importing process in QuickBooks Desktop (QBDT).

 

In QuickBooks Desktop, in order to import a CSV file, you'll have to install first the QuickBooks Import Excel and CSV toolkit. 

 

Here's how:

 

  1. Access the file download window for the toolkit, then click Save.
  2. Next, head to your Windows Desktop, then select Save.
  3. Then, double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Click Browse, choose the folder where you want to install the toolkit (such as your Desktop), then select OK.
  5. Select Unzip to extract the contents, and then click Close to close the WinZip Self-Extractor window.
  6. Then, open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

 

Additionally, let me share this link to help import or export info with QuickBooks Desktop: Import and export data in QuickBooks Desktop.

 

Also, if you're trying to import CSV files for bank transactions, you can check out this link to guide you through the process: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Feel free to leave a comment below if you have further concerns with importing invoices using an Excel file. I'll be happy to help. Keep safe!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us