This integration allows you to connect QuickBooks Desktop with Flxpoint to sync inventory, fulfillment requests, and accounting data. The integration is webhook-based, requiring users to install and configure the QuickBooks Web Connector. Once connected, Flxpoint can import inventory, sync fulfillment requests, create purchase orders, and optionally generate item receipts in QuickBooks. Users must ensure proper source linking and SKU matching for accurate data synchronization.
How to Connect
-
Download QB Web Connector
1. Get it here (Windows only).
2. Install on your Windows machine, then open it. -
Add QuickBooks Desktop as a Source
1. In Flxpoint, go to Sources.
2. Click + to Add Source, name it “QuickBooks Desktop,” then Save.
3. Under Integrations, choose “QuickBooks Desktop” → New Connection. -
Generate API Token
1. Under Basic Info, click Generate API Token.
2. Copy this token—use it as “Password” in QB Web Connector. -
Link the .qwc File in QB Web Connector
1. If provided, download config.qwc from Flxpoint.
2. In QB Web Connector, Add an Application & select the .qwc file.
3. Paste your API token into Password, then click Update Selected. -
Enable Accounting Operations
1. In Flxpoint, click the gear icon (Settings) on the left.
2. Select Accounting, click the Blue + icon, and choose QuickBooks Desktop if needed.
3. Toggle on desired operations (e.g., Get Inventory, Send Accounting Fulfillment Requests) which can also create Item Receipts in QB.
4. Verify the Web Connector progress (100%) and check if products or FRs sync successfully.
×
![Preview]()
Product Operations
Get Inventory (Primary)
Operation Workflow
- This is a webhook integration to QuickBooks Desktop via the QB Web Connector (example).
- We provide a .qwc file to the customer for setup.
- The user adds that file in the QuickBooks Web Connector, placing the API key as the “password”.
- On each “Update Selected,” Flxpoint imports inventory data:
- SKU → Name
- Title → FullName
- Cost → SalesPrice
- Quantity → QuantityOnHand
- Category1 → IncomeAccountRef → FullName
Troubleshooting
- Common Error #1: If progress bar doesn’t finish, confirm QB Web Connector is configured properly.
- Common Error #2: If items aren’t appearing in Flxpoint, ensure your “Inventory” toggle is enabled.
Operation Details
| Feature | Support | Notes |
|---|---|---|
| Custom Fields | Not Supported | We do not import any custom fields. |
| Variations/Options | Not Supported | No variation concept in this integration. |
| Cost | Supported | Purchase cost from QuickBooks item is used. |
| Quantity | Supported | Maps to QuantityOnHand in QB. |
Accounting Transactions
Accounting Transactions handle deeper financial processes such as purchase orders, fulfillment requests, and invoices (bills).
Send Accounting Fulfillment Requests
Operation Workflow
- We connect to QuickBooks Desktop via the QB Web Connector again.
- Once a Fulfillment Request is Processed or Acknowledged in Flxpoint, we create an Item Receipt and a Purchase Order in QB (depending on your workflow).
- We rely on the same Flxpoint Source API token for authentication.
- Ensure the Accounting Sync toggle is enabled in Flxpoint for FRs to sync to QB.
Troubleshooting
- Common Error #1: If no item is found in QuickBooks, ensure the “Item association” matches (SKU).
- Common Error #2: If the job halts at 0%, confirm your config.qwc file and Web Connector logs.
Operation Details
| Feature | Support | Notes |
|---|---|---|
| FR Status for Sync | Supported | Must be Processed or Acknowledged for sync. |
| Acknowledgements | Not Supported | We do not receive separate acknowledgement from QB once FR is posted. |
| Item Association | Supported | We match existing items in QB by SKU or Name. |
| Account Ledger Sync | Supported | We sync to vendor in QB based on the Source name in Flxpoint. |
Flxpoint Pro Tip
Looking for information on connecting to QuickBooks for accounting purposes? Please see: Accounting & QuickBooks Online.