Some merchants choose to use QuickBooks to manage their business. Store v.1, Merchant Solutions Standard, and Merchant Solutions Professional have the ability to do so through exporting order data. It's easy to export order information from your Store Manager to QuickBooks. Here's how:
- Sign in to your My Services page.
- Click the Store link.
- Click the Orders link.
- From the all-new Order Manager:
- Click the Export button on the top right, then select Export.
- Next, enter a range of orders, select QuickBooks from the Format pull-down menu, then click Export.
- In classic Order Manager, enter a range of orders, select QuickBooks from the Format pull-down menu, then click Export.
- On the next page, click the Export link and on the bottom right, then choose Save File, name your IIF (Intuit Interchange Format) file, and save the file to the hard drive of your computer.
- Open QuickBooks.
- In QuickBooks, select Import from the File menu.
- Finally, select the IIF file that you saved on your hard drive in Step 5. Your Store order information will now be viewable in QuickBooks.
Note: Turbify currently supports QuickBooks exports of order information up to QuickBooks 2002. Other versions may also be compatible, but are not guaranteed.
Enhancements to improve compatibility between your store and QuickBooks are noted below. Please note that these enhancements are only supported for QuickBooks 2002 and previous versions of QuickBooks. We cannot guarantee compatibility and functionality for other versions of QuickBooks.
- The customer email address is now exported to the correct matching field in QuickBooks. In the old format, the customer email address was exported to the QuickBooks alternate phone field. Because this field has a 21-character limit, some email addresses were truncated in the old format.
- We've improved the mapping of address fields from Store to QuickBooks. Now, the first 40 characters from the first line of the Store address field are mapped directly to Address 1 in QuickBooks. Likewise, 40 characters from the second line of the Store address field are mapped directly to Address 2 in QuickBooks.
- Shipping and billing info fields have been reformatted for your convenience so that they fit within the standard QuickBooks template.
- The Store discount field now exports correctly to QuickBooks. In the old format, discount orders were not exported correctly.
- It's now possible to export two transactions for each order: one for invoice and one for payment. In the old format, only the invoice transaction was exported. Exporting the payment makes it easier to reconcile order with invoice, and eliminates the need to reenter the payment manually.
- We've prefilled the payment methods menu on the Receive Payments screen in QuickBooks with the methods your store supports. Now you don't need to reenter this information.
Please note that exporting to non-U.S. versions that use VAT instead of sales tax may not work if you use automatic sales tax calculation.