Quickbooks

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

  • How to Connect

    1. Go to Settings (gear icon) → Accounting.
    2. Click the Blue + Icon to create a new QuickBooks Online connection.
  • Configure Settings
    Enable or disable “Link to Existing Sales Receipts”, then click Save and Proceed.
  • Select Operations
    Toggle Fulfillment Requests, Invoices, Orders, Shipments. Choose any Source(s) or Channel(s), then click Save.
QuickBooks Setup Screenshot

 

 

 

 

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.

 

 

How can I help?