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
- 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.
|
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. |