QuickBooks Daily Syncing
Connect Thrive to QuickBooks® Online for Daily Syncing
Joe Barlow avatar
Written by Joe Barlow
Updated over a week ago

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

QuickBooks Online (QBO) can be connected to Thrive for nightly reports to your QuickBooks account! This is only for QuickBooks Online. Products like QuickBooks Desktop or QuickBooks Enterprise are not supported.


FAQs

"Why is Thrive's QuickBooks Integration messing up my General Ledger/Profit and Loss Statement/Transaction Reporting?"

  • Great question. That is likely because you are not deleting the invoice sent over to QuickBooks by Thrive. Once you have reviewed the invoice from Thrive 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's QuickBooks integration automatically make journal entries for me in QuickBooks?"

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

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

You cannot map your chart of accounts to Thrive 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 sends over as a "report". You review the "report" we send over, make appropriate journal entries, then delete the "report" (invoice).

"If Thrive 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, 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 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 has sent over.

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


What we send out

Each day, for each location, Thrive 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'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 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.


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.

  • We report refunds to QuickBooks on the day they happen, whereas our Sales Reports get attributed back to the original receipt.

  • Net Payments (on Quickbooks) equals Net Sales (on Thrive) minus any transaction or processing fees from your integrations.

  • 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 are 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?