Quickbooks

Overview

FLX supports a connection to QuickBooks Online that will allow you to export your account data to QuickBooks Online. To access your Accounting overview:

  • Click the Settings Gear Icon
  • Select Accounting

Data Available 

Source:  Send Accounting Fulfillment Requests & Accounting Invoices
Channel: Send Accounting Orders & Accounting Shipments


Before You Get Started

You'll need to prepare your QuickBooks Online account by adjusting the Account & Settings.

Account Settings Location 
These settings are all found on the main page of QuickBooks, under Accounting (on the left) "Chart of Accounts"

Accounts Settings

Make sure you have an account with the name "Sales of Product Income," as some new QuickBooks accounts don't have this set by default.

If you do not, look at the top-right of the page for the green New button. Press that, and create a new account with:

  • Account Type = Income
  • Detail Type = Sales of Product
  • Income Description is optional, and for your benefit only. Set it to whatever you like or leave it empty
  • Make sure you have an account with the name "Accounts Payable (A/P)" as some new QuickBooks accounts don't have this set by default.
  • If you do not, look at the top-right of the page for the green New button. Press that, and select Account Type Accounts payable (A/P). This will generate the following details, which are correct:
  • Account Type = Accounts payable (A/P)
  • Detail Type = Accounts Payable (A/P)
  • Name = Accounts Payable (A/P)
  • Description is optional, and for your benefit only. Set it to whatever you like, or leave it empty.
  • Then press the Save and Close button at the bottom right.

These settings are all found on QuickBooks by clicking on the gear icon at the top-right of the QuickBooks main screen. 

General Settings

Under Account and Settings →Sales →Sales form content

  • Both Shipping and Custom Transaction numbers should be enabled

Under Account and Settings → Sales → Products and services

  • Show SKU Column is recommended to be enabled for easier product identification when comparing your FLX inventory to the QuickBooks receipts and items we create
  • Track Quantity and Price/Rate should be enabled

Under Account and Settings → Expenses → Bills and expenses

  • Show Items Table should be enabled
  • Track Expenses and Items by Customer should be enabled

Under Account and Settings → Expenses → Purchase orders

  • Use Purchase Orders and Custom Transaction Numbers should be enabled if you want to send purchase orders and invoices over to QuickBooks (note: the Custom Transaction Numbers option only shows up if you have already enabled Use Purchase Orders)

How to Connect

tempsnip.png

  • Select Fulfillment Requests, Invoices, Orders, or Shipments
  • Select the source or channel
  • Click Save in the top right

Key Information

Naming Conventions

FLX and QuickBooks call some of the same things different names.

  • “Orders” from a sales channel in FLX  → “Sales Receipt” in QuickBooks
  • "Purchase Orders" go by the same name on both platforms
  • “Invoices” from a source in FLX → “Bills” in QuickBooks.

 

Purchase Order and Invoice SKU Differences

If the SKU your supplier sends back on an invoice does not match the SKU sent on the corresponding purchase order, QuickBooks will not be able to associate that invoice item with the previous purchase order item.

In this case, QuickBooks will not be able to create the invoice.

 

Tax

Tax is built to work with QuickBooks Automated Sales Tax.

We will send the total tax portion of the order over to QuickBooks, and it will associate the tax with the correct agency based on your business location and the shipping location. All US-based QuickBooks accounts created after Nov. 17th, 2017 use Automated Sales Tax by default, but legacy users can find more information here.