Shopify - QuickBooks Online Automation

Shopify sync with QuickBooks Online

Sync Initialization

During the first execution of the automation, Sush.io creates a payment Method ‘Shopify’. For the Shopify Fees and shipping costs, you can decide to hit one of the account already created in your QuickBooks account, or to use a default account.
At last, by default Sushio creates in QuickBooks a vendor called ‘Shopify Payments’  and a generic Item called ’Shopify Sales’ (you can still decide to use one of your choice).

Cash or Accrual Basis

During the first execution of the automation, Sush.io lets you choose between cash or accrual basis for your Shopify accounting within QuickBooks.

If cash basis is selected, then Sush.io will sync Shopify Orders as Sales Receipts. When Accrual is selected, Sush.io will sync Shopify Orders as Invoices.

Shopify Customers, Income and Expense Accounts options

You can define during the setup whether you want Sush.io to create all your customers coming from Shopify or a single customer for all your orders.

You can choose an existing Income account for the Shopify Orders synced as Sales Receipts or Invoices. Or Sush.io will create a default Shopify Income account automatically during the first sync setup.

Same option for the Shopify Fees, that will be added to a new or existing QuickBooks Online Expense Account.

Shopify Orders and Refunds

The Shopify Orders are created as Invoices in QuickBooks. We keep the order reference in the Invoice and the description comes directly from the products or the charge description in Shopify.

The Shopify refunds are created as Refund Receipts in QuickBooks. The refunds are processed to the customer in QuickBooks if you choose to synchronize all your Shopify customers.

Shopify Payment Transfers / Deposits

For each Shopify Payment transfer to your bank account, Sush.io automatically creates a deposit in QuickBooks with all matching Shopify Data (orders, fees and refunds). The account of the deposit will be linked to the bank account chosen during automation setup. The deposit captures Invoices & Refund Receipts previously created, but also the Shopify Fees, Fee Refunds and other Fees  for the given Shopify transfer period. Each corresponding to separate deposit lines.

In QuickBooks, the deposits match automatically the transactions of the linked Bank Account. Now you only need to manually reconcile the matched deposits.