I'm struggling to get my shopify site to sync correctly with Quickbooks. I've used the Bold app to sync the orders and fees and that works well. However, this only works for those orders where customers have used Shopify payments.
But customers can also use Paypal (and Afterpay, I'm based in Australia) and I can't work out how to set this up correctly. I tried the paypal app but Quickbooks can't match the individual orders with the info it pulls from my bank account (which is a daily sum of several orders). Everything seemed doubled up and it gets very messy.
I have yet to find an accountant who can help me set this up correctly. There would be so many people in the same situation as me, yet I cannot find any info anywhere on how to do this.
Any help would be very much appreciated!
Unfortunately one app can't handle it all. Believe me I've tried many being an Accountant who specializes in eCommerce across all platforms. Yes some apps will get the data to Quickbooks, but once there I have to go in and make adjustments to either correct what came over, or force the numbers where they actually need to go. The best way I've found to date is to simply import all of the data myself for my clients. This way I know the information coming over is accurate, and I'm also balancing out each of the payment channels, orders, sales tax, discounts gift cards, etc., within Quickbooks with each import, something these apps simply do not do for the Quickbooks account holder.
Thank you for responding! I was afraid that was the case. I can't understand that there is no app out there that does all of it since there would be so many people using Quickbooks and Shopify. Would it be easier if I used Xero? Or is the problem the same? I'm trying to avoid doing manual work as much as possible. This should all be able to be automated.
There's just too many moving parts. Inventory item #'s by sku's or just name, Quickbooks allows negative inventory a huge problem. Payments coming from Paypal, Square, Stripe, Authorize.net, etc., and Shopify itself, including gift cards, discounts and one time promotions. Now you're talking a spiders web of money transactions, and we haven't even discussed all the subscription and merchant fees charged by every platform I've listed. And it won't matter if you use Xero you're still going to have the same issue.
But if you're willing to leave Quickbooks and try something else, there's a fairly new platform called AccountingSuite that handles eCommerce, here's their pricing website: https://www.accountingsuite.com/pricing/, it looks a bit pricey, but if you work through an Accountant like myself, we're able to offer the eCommerce version for about $90 a month.
The way I import, yes I handle all payment channels. Depending on the client and how many moving parts they have, I either start from the Shopify (or Amazon, CrateJoy etc) orders and sync them to Quickbooks. Or if there's a ton of activity going on in Quickbooks, I have a couple clients I balance from the payment receiving side in Quickbooks bank feeds, backward to the orders. Actually I do this usually with a new client just to make sure everything is flowing as it should.
If I understood your use case correctly, you are looking to sync Shopify orders to your QuickBooks account when payments are made via PayPal or any other source. In that case, I think the "accountant" you need is in here - https://automate.io/integration/quickbooks/shopify
Then follow these steps:
1. Connect your Shopify and QuickBooks Online accounts.
2. Map the data you need.
3. Test the integration and make it live.
Hope this helps.