Financing, tax rates, and accounting
If anyone is looking for a way to automate and summarize Shopify transactions into QBO, Bookkeep.com (I am not affiliated or employed by them. This is voluntary on my part) has been quite useful for me. We have many locations in our Shopify store and do a large volume transactions. They add daily summaries of the sales/COGS by location and they calculate and enter the expected payments which are then matched against bank deposits. This also includes entries for merchant fees and sales tax which has been very useful. If you are summarizing and want to automate, I recommend them.
Hey, @KP_Enterprises!
I'm so glad to hear you've found a solution that's working well for your business. Is it the QuickBooks Daily Summary Sync app that you have installed on your store?
Sophia | Social Care @ Shopify
- Was my reply helpful? Click Like to let me know!
- Was your question answered? Mark it as an Accepted Solution
- To learn more visit the Shopify Help Center or the Shopify Blog
No it is not the daily summary sync. Shopify support is far from encouraging.
Which plan are you using with Bookkeep.com, and how does it handle 'Draft Orders' that don't show up by Channel? Also curious how it handles the 'partial refunds' with 'Unknown' transaction type. One of our Shopify stores includes 3 locations and On-Line Sales as different sales channels, so we end up having to 'manually' identify and separate the On-Line Sales by Location to record them in QBO.
We are on Enterprise plan because we have so many locations. Draft orders show up for us in the Other location which is synced through Bookkeep. Partial refunds and unknown transactions are still be identified. Currently those book on a separate line of the JE with a memo. Bookkeep has been pretty good to work with once I could show them the obvious differences in their posts and Shopify reports. They did a deep dive and made some corrections and became much more accurate. We are still having a few issues with returns and with Route orders. Unfortunately many of these issues are because of the way the orders are entered and are not identifiable in the data. In short Bookkeep isn't 100% accurate but they are more accurate than we were with manual entries.
Portrait of Stephen positioned next to an image of planet Earth, with the Stephen's World ...
By JasonH Mar 18, 2024Digital marketers and app developers have tracked activity in apps and websites for yea...
By Ollie Mar 13, 2024February was an exciting month with Shopify Editions, informative webinars, and more! F...
By JasonH Mar 7, 2024