Import Sales Orders into QuickBooks Desktop using Business Importer. Check out the guide how to import Sales Orders in Excel into QuickBooks Desktop. Don’t wait! Run several imports simultaneously – save your time!
Video Guide: How to import Sales Orders into QuickBooks Desktop using Business Importer
Import Sales Orders into QuickBooks Desktop
Connect QuickBooks Desktop and Business Importer. Select company you’re going to import Sales Orders into.
Step 1: Select your file (Excel) containing Sales Orders.
Select sheet in your file. Select a QuickBooks transaction or list type to import.
Click on the Next button.
Important Notes for your Sales Orders List:
Sales Order Number – the number of your Sales Order. Assign your numbers, or use Reference Number autocreation function. To enable this function, go to Settings – General – Generate RefNumber automatically .
Multi-Lined Sales Orders – you can easily import multilined Sales Orders into QuickBooks, using Business Importer. Please use Sales Order number for this. Business Importer will group your transactions lines into one transaction with several lines, if they have the same Sales Order number. Make sure, that the Sales Order number is the same in the lines you want to join into one transaction.
Products autocreation – to enable this function, go to Settings – Product – Create New Products if cannot find them.
Customers autocreation – to enable this function, go to Settings – Customer/Vendor – Create Customer/Vendor if cannot find them.
Step 2: Mapping
Connect your labels to QuickBooks Desktop labels.
Save your Mapping to use it in subsequent imports, or upload the saved import.
Click on the Next button.
Step 3: Preview
Preview your Sales Orders you are importing into QuickBooks Desktop. Make sure all labels are mapped in a correct way.
Note: You can correct values in the table, if necessary.
Click on the Next button.
Import Sales Orders into QuickBooks Desktop using Business Importer: Result
Your import is in process! Don’t wait until it’s finished. Start new import. Run several import simultaneously with Business Importer.
When the import is finished, view import log.
Check out the import result in QuickBooks Desktop – all Sales Orders are imported correctly into QuickBooks Desktop.
Import Sales Orders into QuickBooks Desktop using Business Importer: Mapping Fields
|Business Importer Name||Description||Example|
|Customer||Name of customer. Please, provide its Display name, as soon as if it is different from the one you meant, Sales Orders will be associated with another customer.||Janice Johnson|
|Line: Item name||Reference to an Item object. Please, provide only its name.||Paper|
|Bill To City
(Ship To City)
|The city name in an address. Maximum of 31 chars.||Half Moon Bay|
|Bill To Country/Region
(Ship To Country/Region)
|The country name in an address. Maximum of 31 chars.||US|
|Bill To Line 1
(Ship To Line 1)
|The first line of an address. Maximum of 41 chars.||110 Main Street|
|Bill To Line 2
(Ship To Line 2)
|The second line of an address (if a second line is needed). Maximum of 41 chars.||Suite 2000|
|Bill To Line 3
(Ship To Line 3)
|The third line of an address (if a third line is needed). Maximum of 41 chars.|
|Bill To Note
(Ship To Note)
|The note will be written at the bottom of the address. Maximum of 41 chars.|
|Bill To State/Province
(Ship To State/Province)
|The state name in an address. Maximum of 21 chars.||CA|
|Bill To Zip/Postal code
(Ship To Zip/Postal code)
|The postal code in an address. Maximum of 13 chars.||99875|
|Class name||Reference to the Class associated with the overall transaction. Please, provide only its name.||Payments|
|Currency||Values: USD, AUD, EUR, CAD, etc.||USD|
|Customer Message||A standard message such as ’Thank you for your business’, or ’Please sign and return this estimate to indicate your approval’.||Thank you for your business and have a great day!|
|Due date||The date on which payment is due. Default date format is yyyy-MM-dd.||2017-09-04|
|Email Later||Is transaction to be emailed later. Possible values: true or false.||true|
|Exchange Rate||The exchange rate is the market price for which this currency can be exchanged for the currency used by the QuickBooks company file as the “home” currency. The exchange rate should be considered a snapshot of the rates in effect at the AsOfDate.||1.7|
|FOB||QuickBooks uses the term FOB, freight on board, to indicate the place from which the product is shipped.||FOB Shipping|
|Line: Amount||The monetary amount of the line item.||150|
|Line: Class Name||Reference to the Class for the line item. Please, provide only its name.||Payments|
|Line: Description||Free form text description of the line item that appears in the printed record.||Sample description|
|Line: Mark as Closed||Is line to be mark as closed. Possible values: true or false.||false|
|Line: Other 1||Other 1 is a standard QuickBooks custom field available to transaction|
|Line: Other 2||Other 2 is a standard QuickBooks custom field available to transaction|
|Line: Price||The price per item.||3.00|
|Line: Quantity||Number of items for the line.||50|
|Line: Sales Tax Code||Sales Tax Code name. Each item on a sales form is assigned a sales-tax code that indicates whether the item is taxable or non-taxable.||Tax|
|Mark As Closed||Is transaction to be mark as closed. Possible values: true or false.||false|
|Other||Other is a standard QuickBooks custom field available to transaction.|
|PO Number||Purchase order number.||6237|
|Print Later||Is transaction to be printed later. Possible values: true or false.||true|
|Sales Order Number||Reference number for the transaction.||SO-001|
|Sales Rep||The sales representative. Please, provide only its name.|
|Sales Tax Item||The sales-tax item that is used to calculate a single sales tax that is collected at a specified rate and paid to a single agency. Please, provide only its name.||San Tomas|
|Ship Date||The date when the product was, or will be, shipped. Default date format is yyyy-MM-dd.||2017-09-04|
|Ship Method Name||The shipping method, for example, standard mail or overnight delivery. Please, provide only its name.||DHL|
|Template Name||The template in order to specify how to print certain transactions. Please, provide only its name.||Custom Sales Order|
|Terms Name||Payment terms that associated with this entity. Please, provide only its name.||Net 30|
|Transaction date||The date of the transaction. If the date is not supplied, will be prefilled with the date of the last-saved transaction of the same type. Default date format is yyyy-MM-dd.||2017-09-04|
|Update Sales Order||Update linked labels. Possible values: true or false.
Note: Sales Order number is required for update.
Check out the Sales Orders import results
FAILED — There were some problems with import. Look into Import Log for details.
FINISHED — Import is finished successfully.
CANCELED — Import canceled by user.
REVERTED — Import reverted by user.
Use Business Importer to import transactions in Excel into QuickBooks Desktop.