This document provides comprehensive guidance on integrating QuickBooks Online with Flxpoint to automate accounting operations. It covers essential setup requirements, authentication steps, and configuration options for syncing data such as purchase orders, invoices, and sales receipts. Users can follow structured instructions to establish a secure connection, map sources and channels, and enable key accounting exports. With a focus on ensuring accuracy and efficiency, this guide helps streamline financial data management within Flxpoint.
How to Connect
Accounting Operations
Naming Conventions
- “Orders” in FLX → “Sales Receipts” in QuickBooks
- “Purchase Orders” have the same name on both platforms
- “Invoices” in FLX → “Bills” in QuickBooks
Purchase Order & Invoice SKU Differences
If the SKU your supplier returns on an invoice doesn’t match the SKU originally sent on the purchase order, QuickBooks can’t associate the invoice item with that PO. In this scenario, QuickBooks won’t create the invoice.
Tax
FLX sends the total tax amount of an order to QuickBooks, leveraging Automated Sales Tax for US-based QuickBooks accounts created after November 17, 2017. QuickBooks determines the correct tax agency based on your business and shipping locations, legacy users can find more information here.
Accounting Orders
Accounting Orders primarily deal with syncing order-related data (e.g., sales receipts, tax info) from Flxpoint to QuickBooks.
Send Accounting Orders
This operation pushes Flxpoint Orders as Sales Receipts into QuickBooks. Depending on your config, it can also link to existing sales receipts if present.
- Operation Workflow: Describe how the job runs, user authentication, referencing numbers, etc.
- Operation Details: Create new sales orders, link to existing sales receipts, item association, etc.
Accounting Transactions
Accounting Transactions handle deeper financial processes such as purchase orders, fulfillment requests, and invoices (bills).
Send Accounting Fulfillment Requests
This operation syncs fulfillment requests from Flxpoint to QuickBooks, linking them to existing Sales Receipts or Invoices if possible.
- Operation Workflow: Checking source addresses, POST vendor, link with receipts/invoices, etc.
- Operation Details: FR status for sync, item association, limitations, etc.
Send Accounting Invoices
This operation pushes Flxpoint Invoices (supplier bills) into QuickBooks as Bills, matching them to an existing PO if SKUs line up.
- Operation Workflow: Using PO IDs, matching customers, sending the Bill (QBO terminology).
- Operation Details: Payment status, acknowledgements, item association, ledger sync, etc.
Send Accounting Purchase Orders
This operation creates purchase orders in QuickBooks based on Flxpoint POs, ensuring item SKUs are mapped properly (SKU → Description).
- Operation Workflow: PO creation, linking items, handling SKUs, etc.
- Operation Details: Supported fields, item association, ledger sync, limitations, etc.