QuickBooks Online can be connected to Thrive Inventory by Shopventory for nightly reports to your QuickBooks account! 

QuickBooks Online syncing is included in Professional plans and above. QuickBooks can be enabled on any other plan as a Billing Add-On for $30/mo or $300/yr ($25/mo).

  • NOTE: This is only for QuickBooks Online. Products like QuickBooks Desktop or QuickBooks Enterprise are not supported.


FAQs

  • "Thrive Inventory (Shopventory QuickBooks Integration) is messing up my General Ledger/Profit and Loss Statement/Transaction Reporting. Why?"

    • Great question. That is likely because you are not deleting the invoice sent over to QuickBooks by Thrive Inventory (Shopventory QuickBooks Integration). Once you have reviewed the invoice from Thrive Inventory and posted the sales numbers to the appropriate line items, you should delete the invoice. This will fix the reporting "errors" you see.

  • "Will Thrive Inventory (Shopventory QuickBooks Integration) automatically make journal entries for me in QuickBooks?"

    • No, Thrive Inventory won't make journal entries in QuickBooks. However, if you notice you have incorrect financial information and you drill down to see that Thrive Inventory (Shopventory QuickBooks Integration) is the cause, that is likely because you have not deleted the invoice Thrive Inventory has sent to QuickBooks.

  • "How do I map my chart of accounts to Thrive Inventory?"

    • You cannot map your chart of accounts to Thrive Inventory at this time. Please let us know if this is a feature you would like to have!

  • "Why do you send over the previous day's sales information in the form of an invoice?"

    • QuickBooks makes it easier for us to work with their invoicing. Think of the invoice Thrive Inventory sends over as a "report". You review the "report" we send over, make appropriate journal entries, then delete the "report" (invoice).

  • "If Thrive Inventory doesn't automatically post to QuickBooks, what is the benefit of using the integration?"

    • Many times accountants/bookkeepers/CPAs do not have access to Thrive Inventory, but they do have access to QuickBooks! Setting up this integration will make it easier for your bookkeeper to see the numbers they need for your accounting. This will save them time and will save you money! We simply recommend you share this help article with them before turning on the integration.


Since each business has a unique chart of accounts, we are not able to help when mapping the reported sales numbers in QuickBooks. That job is best suited for your CPA or bookkeeper since you will have more intimate knowledge about your financials. Thrive Inventory simply sends an invoice to QuickBooks which you are then responsible for posting the numbers to the correct line items. Once you have made your journal entries in QuickBooks, you should delete the invoice Thrive Inventory has sent over.

With QuickBooks, Thrive Inventory will send over an invoice each day with the numbers and information outlined in the following section.


Each day, for each location, Thrive Inventory will automatically send over: 

(1) Summary data in an invoice, including:

  • Net Payments

  • Shipping (if applicable)

  • Tax Collected (if applicable)

  • Total Refunds

(2) Transaction information, in the form of a detailed invoice including:

  • Total Cost of Goods sold (COGS)

  • Total Discounts

  • Total Fees

  • Gross sales

  • Net sales

  • Profit

  • Refunds

  • Shipping

  • Tax Collected

  • Tips

As well as the following for each category:

  • COGS

  • Discounts

  • Net sales

  • Profit

  • Refunds

(3) A Payment for each payment type, including:

  • Visa

  • MasterCard

  • Discover

  • American Express

  • Cash

  • Gift Cards

  • Refunds

Thrive Inventory's entries will affect the General Ledger in QuickBooks if you do not delete the invoice we send to QuickBooks (refer to the FAQs section at the top), as each business does things a little differently. We simply push the sales information and allow you to allocate the sales numbers according to your preference. Once again, Thrive Inventory is not able to assist with this process and it is best left for our CPA or bookkeeper.

To explain further, the data doesn't "map" - rather we send the information over on an invoice that is broken out by location/category/tender type/etc. That information will sit on the invoice until you post the numbers to the appropriate line items on your chart of accounts. Once the numbers are manually moved, you'll want to delete the invoice we sent over so it doesn't show up in your Accounts Receivable section.


How to Connect:

In the Settings section of Thrive Inventory, click on the Accounting tab, and use the button in the top right to add your QuickBooks integration. 

This will prompt you to log into QuickBooks to authorize Thrive.

Once you're back in Thrive, make sure you enable syncing. There should be a green "ON" indicator to let you know Thrive will push out values later tonight. 


Things to note

  • This is only for QuickBooks Online. Products like QuickBooks Desktop or QuickBooks Enterprise are not supported.

  • Sales reports are only sent from the day Thrive was connected going forward. We do not send information on prior dates to QuickBooks.

  • QuickBooks will NOT count towards your plan's location/integration limit.

  • Invoices are sent between 2 a.m. - 4 a.m. (in the account owner's timezone)

  • Purchase Order information and inventory data is NOT sent to QuickBooks

  • Thrive does not have any part in bill pay functions

  • Each location will have a separate invoice broken out. 

  • QuickBooks Online does not offer a trial unless you are trialing the Pro+ plans.

  • The Billing Add-On is not removed if you disconnect the QuickBooks Online integration. You will have to visit the Billing settings in Thrive to stop any further billing for an Add-On.


Related Articles

Still have questions? We are here to help!

Start a chat with us by clicking the chat bubble at the bottom-right of this page.

Did this answer your question?