Improve bookkeeping accuracy with the Wix Connector by Intuit, which syncs data directly into QuickBooks. Edit, categorize, and match Wix orders, payments, customers, and products.
If you need help with orders, you can partner with QuickBooks Live Experts. Find out more about QuickBooks Live Bookkeeping.
Data synced from Wix
Wix Connector syncs most order details to QuickBooks. The app imports net amount, fees, taxes, discounts, products/services, and customers.
PLEASE NOTE: QuickBooks Connector can integrate with the following Wix Modules only:
- Wix Stores - https://www.wix.com/app-market/wix-stores
- Wix Events - https://www.wix.com/app-market/wix-events
- Wix Hotels - https://www.wix.com/app-market/wix-hotels
- Wix Invoices - https://support.wix.com/en/ascend-by-wix/wix-invoices
- Wix Recurring Invoices -https://support.wix.com/en/article/wix-invoices-managing-recurring-invoices
- Wix Pricing Plans - https://support.wix.com/en/article/pricing-plans-an-overview
- Wix Bookings - https://support.wix.com/en/article/wix-bookings-about-wix-bookings
View status or orders/items
Wix orders will be automatically added to the books. You can view the status of the transactions and items being imported in the Integration transactions page. (Take me there).
There are several tabs in the Integration transactions page:
- Imported includes all orders and items successfully imported from Wix.
- Processing includes all orders and items in progress and not yet imported, or ran into some issues.
- Excluded includes all orders and items manually excluded from being imported.
Once an order is created in Wix, it appears in the Imported tab of the App transactions screen, usually within 4 hours.
How to connect
You need an active Wix account to use the Wix Connector by Intuit. If you haven't already, create a Wix account first. Then you’re ready to get started!
- Select Integrations
, then Find integrations (Take me there). - In the search bar, enter “Wix Connector by Intuit”, then select it when you find it.
- Select Get app now.
- Follow the on-screen instructions. Enter your Wix account email address and password, then select Log in.
- To authorize Wix to send your orders to QuickBooks, select Allow.
- Complete the app settings. You can change these settings later by selecting Settings from the options in the Wix tile.
- Select the date you want Wix to start importing orders, then select Done.
Please Note: You can import up to 1 year's worth of historical orders. - Once the connection is complete, select Go to App Transactions.
Tips and terminology for your app settings:
Retrieve settings specify which order, payment, and fulfillment statuses should be retrieved.
PLEASE NOTE: The Retrieve Store Orders with Payment Status section only applies to Store Orders as we do not sync unpaid transactions for all other supported Wix modules aside from the Wix store
Sales settings tell QuickBooks how to create sales.
-
Create Sales in QuickBooks as specifies whether to create an order from Wix as an Invoice or a Sales receipt.
Note: Sales receipts won’t get imported into QuickBooks until they are fully paid. - Order Number Prefix - The prefix you input here is added to all orders retrieved from your WIX account. For example, If you have an order '1234' in WIX and you add the prefix 'WX-' in the configuration, your order will be retrieved into QuickBooks Connector with the order number 'WX-1234' and sent to QuickBooks accordingly.
-
Automatic Invoice Numbers lets QuickBooks generate an invoice number for each sale.
By selecting this option, you will allow your accounting system to assign an automatic invoice number, e.g., to adhere to sequential invoice number rules, rather than using the invoice number provided by the source system.
Please note: To generate Invoice Numbers in QuickBooks, the Custom Transaction Numbers option in the Sales settings must be off. You can check the guide here. - Shipping charges represent which item to use for shipping charges. This is only required if the Shipping option isn't enabled in the company settings.
- Discounts applied represent which item to use for discounts. This is only required if the Discount option isn't enabled in the company settings.
- Assign to Class: Select a QuickBooks class to assign to sales.
Item settings tell QuickBooks how to create items.
-
Create items specifies whether to create items as non-inventory or inventory items. Select Inventoried Items if you would like to track inventory in QuickBooks.
Please note: Select Inventoried Items if you would like to track inventory in QuickBooks. If you do not intend to track inventory within your QuickBooks Online, then you can specify the app to create items as Non-Inventoried Items within your QuickBooks Online
- Match items specifies whether to match the Wix product SKU by the QuickBooks SKU or Name field. If the imported product matches the QuickBooks item, the app won’t create a new item.
- The Use Income account specifies which account will be used for all items. The account selected here will be the default income account assigned to all items that are sold.
- Use Expense Account specifies which account to use for purchased items. A value is recommended for the Expense Account.
Tax settings specify which Wix tax rates map to which QuickBooks tax rates. This is only applicable if you have taxes set up in QuickBooks.
Payment settings configure which QuickBooks accounts get used for Wix payments and fees.
You’re ready to go! The Wix App and your orders are available in Integration transactions (Take me there).
How to disconnect the app:
1. Go to My Apps, then the Overview tab.
2. Find the Wix app card, select more options, then select Settings.
3. Select Disconnect.
Wix orders/items overview:
| Transaction Type / Item | What you'll see in QuickBooks |
| Invoice / Sales Receipt | QuickBooks imports detailed line item data and customer data from Wix. You can also match a transaction to existing invoices and sales receipts if you already recorded them in your QuickBooks Online account. |
| Payment | If orders are imported as invoices, then a separate Payment associated with the invoice will be created. |
| Refund Receipt | Wix refunds are imported as a Refund Receipt. |
| Fees | Fees associated with orders will be imported as an expense transaction with the Sales Receipt. Note: Fees are categorized into a Fee expense account which you can set in your app settings. |
| Customers | Customers will be automatically created when the order associated with the customer is imported. |
| Items (Products / Services) | Products / services sync as line items on the invoice or sales receipt. And they will be automatically created when the associated order is imported. |
Comments
1 comment
Good to know that we have an updated article how the integration works from Wix to QuickBooks. Great job!
Please sign in to leave a comment.