Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI 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
You can prepare invoices data with the following template
| Customer | Transaction Date | RefNumber | PO Number | Terms | Class | Template Name | To Be Printed | Ship Date | BillTo Line1 | BillTo Line2 | BillTo Line3 | BillTo Line4 | BillTo City | BillTo State | BillTo PostalCode | BillTo Country | ShipTo Line1 | ShipTo Line2 | ShipTo Line3 | ShipTo Line4 | ShipTo City | ShipTo State | ShipTo PostalCode | ShipTo Country | Phone | Fax | Contact Name | First Name | Last Name | Rep | Due Date | Ship Method | Customer Message | Memo | Cust. Tax Code | Item | Quantity | Description | Price | Is Pending | Item Line Class | Service Date | FOB | Customer Acct No | Sales Tax Item | To Be E-Mailed | Other | Other1 | Other2 | Unit of Measure | AR Account | Currency | Exchange Rate | Sales Tax Code | |
| Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Cabinets | 10 | Cabinets | 1000 | Non | ||||||||||||||||||||||||||||||||
| Anne's Bakery | 01/09/2020 | 100 | Y | 15/09/2020 | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | Anne's Bakery | One Harbor Street | Anytown | NY | 12345 | USA | (123) 456-7890 | Non | Hardware | 10 | Hardware | 50 | Non | ||||||||||||||||||||||||||||||||
| John's Barber Shope | 02/09/2020 | 101 | Y | 15/09/2020 | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | John's Barber Shope | 1 Main Street | Anytown | NY | 12345 | USA | (999) 888-8888 | Non | Blueprints | 1 | Blueprints | 500 | 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
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:
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here