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

QuickBooks syncing is included in Professional and Elite plans. 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.


Each day, for each location, Shopventory 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

Shopventory's entries do not affect the General Ledger in QuickBooks, as each business does things a little differently. We simply push the balanced information and allow you to allocate the lines according to your preference.


How to Connect:

In the Settings section of Shopventory, 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 Shopventory.

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


Things to know:

  • This is only for QuickBooks Online. Products like QuickBooks Desktop or QuickBooks Enterprise are not supported.
  • Sales reports are only sent from the day Shopventory 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
  • Shopventory 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 Shopventory to stop any further billing for an Add-On.


Related Articles: 

Keywords: quickBooks online, QuickBooks desktop, quick books, xero, Accounting, fresh books, Daily, QBO, quick

Did this answer your question?