Quickbooks

Once you've installed the QuickBooks app, navigate to Apps > Manage > QuickBooks from your ShopWired account to connect it to QuickBooks by selecting connect to QuickBooks.

You will be redirected to the Intuit website (the parent company of QuickBooks) to log in to your QuickBooks account (if not already logged in):

Once logged in, authenticate the ShopWired app to connect to your QuickBooks account by selecting the connect option:

Once access has been granted, you will be returned to your ShopWired account to configure the app's settings.

In the app configuration page, configure each of the available settings.

Select the account that corresponds with the account on QuickBooks where the product portion of sales invoices should be allocated.

Select the account that corresponds with the account on QuickBooks that partial payments should be allocated to. Partial payments appear on an order when a customer places an order and, at least in part, makes payment using a gift voucher.

Select the account that corresponds with the account on Quickbooks that the customs & duties portion of sales invoices should be allocated to. (The accounts available will be limited to Revenue Accounts.) This setting is only relevant if you have installed the Landed cost calculator app.

Select the account that corresponds with the account on Quickbooks that the customs & duties uplift portion of sales invoices should be allocated to. (The accounts available will be limited to Revenue Accounts.) For details about uplifts, see the app settings section of the Landed cost calculator help guide.

Where VAT applies to a line item in an order, select the VAT rate from the list that corresponds with the VAT rate on QuickBooks. This is the default VAT rate; products with a custom VAT rate will export with that specific rate.

Where a line item in an order does not attract VAT, select the VAT rate from the list that corresponds with the VAT rate on QuickBooks.

Select this setting to populate the invoice number on QuickBooks with the order reference from ShopWired. If this setting is not selected, QuickBooks will generate the invoice number.

When payment is made for an order on your website, ShopWired can automatically create the payment in the appropriate QuickBooks bank account that corresponds with the payment gateway used to place the order.

Orders placed using the offline payment method will never be exported with payment information and will always show as awaiting payment.

When not selected, all invoices will be created on QuickBooks as awaiting payment.

To export payments to QuickBooks:

1. Select the export payments setting
2. Select a Default payment account from the list of QuickBooks bank accounts - payments will be exported to this account if you have not configured an account specifically for the payment gateway
3. From the Payment method name select each of the payment gateways in use on your ShopWired website and the corresponding Bank account on QuickBooks that the payment should be exported to

You can add as many payment methods as you need.

ShopWired Payments does not have an automatic bank feed into QuickBooks, but the functionality available through the QuickBooks app mimics that of a bank feed.

Select this setting to export ShopWired Payments transaction fees to QuickBooks as Bank Fee expenses.

Select the QuickBooks account that the ShopWired Payments transaction fees should be deducted from. Each exported fee will include the ShopWired order reference for traceability.

Enable this section to export refunds and credit notes from ShopWired to QuickBooks. Refunds will be linked to the original order and deducted from the ShopWired Payments bank account you have configured.

Select this setting to export refunds and credit notes to QuickBooks. When enabled, refunds will automatically create a credit note in QuickBooks and a corresponding transaction on the ShopWired Payments bank account if cash is returned.

To enable the QuickBooks app to begin exporting orders from ShopWired, select the enable the exporter setting.

and select save changes.

Use the Export on demand section to manually export a set of or all of your orders. Orders can either be exported by date range or order reference range.

1. Enter an order reference (into the From reference option) or start date (into the From date option) to select the first order to export
2. Enter an order reference (into the To reference option) or end date (into the To date option) to select the last order to export
3. Select the skip already exported option to choose not to export orders the app has already exported
4. Select the skip errored option to choose not to export orders that have previously failed to export due to an error

The Exported orders section displays all orders that have been exported to QuickBooks.

For each order, the table shows:

• The ShopWired order reference
• The date the order was created
• The customer name
• Whether the invoice was exported
• Whether the payment was exported
• Whether ShopWired Payments fees were exported
• The QuickBooks contact assigned
• Available actions (e.g. view logs)

This section allows you to verify what has successfully exported to QuickBooks and to trace transactions against their original ShopWired order reference.

From time to time, the app may encounter an error when trying to export an order to QuickBooks.

The app provides a list of orders that have failed to export in the export errors section.

For each order that fails to export, the error returned by the QuickBooks system will be displayed. You can then attempt to fix the error on the order (e.g. by editing the order, or editing the QuickBooks app settings) and retrying the export.

You can use the Error notification email settings setting to choose to receive an email when an order fails to export due to an export error.