Tutorials

eBay - QuickBooks Online Automation

eBay sync with QuickBooks Online

Sync Initialization

During the first execution of the automation, Sush.io creates a payment Method ‘eBay’. For the eBay 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 ‘eBay Payments’  and a generic Item called ’Shopify Sales’ (you can still decide to use one of your choice).

eBay Customers, Income and Expense Accounts options

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

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

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

eBay Orders and Refunds

The eBay Orders are created as Sales Receipts in QuickBooks. We keep the order reference and the description comes directly from the products or the charge description in eBay.

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

eBay Fees

For each Shopify Payment transfer to your bank account, Sush.io automatically creates a deposit in QuickBooks with all matching eBay 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 eBay Fees, Fee Refunds and other Fees  for the given eBay 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.