How to Make WooCommerce eCommerce Accounting Easier in QuickBooks

14th September 2020

The beauty of cloud-based accounting tools such as QuickBooks is that they can be made to connect to a wide variety of services.

Connecting to these external services can save you time as a result of not needing to do manual data-entry for items which have been inputted automatically.

If you run an eCommerce platform, it is imperative that your chosen platform integrates properly with your online accounting software.

WooCommerce and QuickBooks Integration

If you operate a WordPress eCommerce website, chances are that you’re using WooCommerce.

WooCommerce is an extensive WordPress plugin that can connect to QuickBooks.

WooCommerce offers a “secure payment gateway” so that customers can pay for services right on your website. The gateway connects with over fifty different payment processing providers such as Stripe, PayPal, AmazonPay and numerous others.

There are four ways we know of to connect QuickBooks to WooCommerce so that the two systems can share data.

Connect QuickBooks to WooCommerce Using Zapier

The first way to connect QuickBooks to WooCommerce is to use Zapier.

Zapier is an online tool that allows integration between hundreds of different services.

If integration isn’t built right into the service, the chances are high that Zapier can facilitate that integration.

Zapier acts as a sort of “middleman” between services.

To Connect WooCommerce to Zapier. You need a Zapier account. You can create one here.

After that, go to this page and integrate your WooCommerce Orders with QuickBooks using Zapier.

Once the integration is working, Zapier will create a receipt for you in QuickBooks every time someone places an order on your WooCommerce eCommerce platform.

You can also automatically create customers in your QuickBooks account every time someone places an order on your WooCommerce site, as well as generate receipts in QuickBooks whenever someone renews a subscription. You can find all these additional integrations on the Zapier website here.

Although Zapier does have a free-tiered account, integrating with QuickBooks Online requires one of its paid plans.

When compared to the other offerings on this page, Zapier’s pricing might not appear competitive when comparing apples to apples, i.e. when looking only at connecting your WooCommerce eCommerce platform with QuickBooks.

But, remember that Zapier allows you to connect hundreds of other services to each other.

So, if you’re looking for more than just integrating your eCommerce platform with your online accounting software, Zapier’s paid plan might be an option for you.

Connect QuickBooks to WooCommerce Using MyWorks’ QuickBooks Sync

Connect QuickBooks to WooCommerce Using MyWorks

The second way to connect WooCommerce to QuickBooks is by using the free “QuickBooks Sync for WooCommerce” extension.

Although the extension is free, you will need to choose and pay for a MyWorks plan to achieve the integration.

The resultant integration is far more extensive than using Zapier, however.

In comparison to the MyWorks option, Zapier’s offering is quite paltry, merely offering the creation of sales receipts and customers, but nothing else.

MyWorks provides two-way sync of data between WooCommerce and QuickBooks.

According to the MyWorks website, you can synchronise orders, payments, sales tax, and shipment details. You can also track transaction fees and coupon codes.

The integrations can be managed right from within your WordPress admin interface.

Integrate WooCommerce with QuickBooks Using OneSaas

OneSaas offers an extensive option to connect your WooCommerce eCommerce website with your online QuickBooks accounting platform.

Using OneSaas, it is possible to create invoices in QuickBooks every time an order is placed on your WooCommerce website. If you create a new product inside WooCommerce, it is automatically added as an inventory item in your QuickBooks cloud account.

It also synchronises the other way: If you update stock levels in QuickBooks, these will automatically be updated inside your WooCommerce eCommerce website.

OneSaas is a paid service and offers various packages according to your business size.

Integrate WooCommerce with QuickBooks Using Webgility

The final way to connect WooCommerce to QuickBooks online and eliminate manual data entry is Webgility.

The Webgility system allows you to synchronise inventory levels from QuickBooks to WooCommerce, or vice versa.

According to its website, Webgility has “QuickBooks-certified staff” ready to assist with your integration, if you need help.

Like the other offerings on this page, Webgility will create an invoice for you in QuickBooks whenever someone places an order via your WooCommerce website. You can map all the invoice data from your WooCommerce site to your QuickBooks Online accounting system so that you can have all that data recorded in the accounting system, thereby eliminating manual data entry.

You can learn more about their pricing here.

Saving Money Due to Human Error

It’s important to remember that connecting your eCommerce platform with your online accounting platform will also reduce the possibility of human error when manually inputting data.

Human errors in accounting can often lead to far more expensive mistakes than the cost of one of these integrations.

Saving Money Due to Human Error

Paying for one of the integrations discussed in this article is not only about saving time, but actually about saving money as a result of accounting mistakes.

Accountants London
Company Registration No. 07078392