Skip to Content
Menu

QuickBooks Online Connector

by
Odoo

148.61

v 18.0 Third Party
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Inventory (stock)
Invoicing (account)
Purchase (purchase)
Sales (sale_management)
Lines of code 7748
Technical Name afi_quickbooks_connector
LicenseOPL-1
Websitehttps://www.actionfi.com
You bought this module and need support? Click here!
Availability
Odoo Online
Odoo.sh
On Premise
Odoo Apps Dependencies Discuss (mail)
Inventory (stock)
Invoicing (account)
Purchase (purchase)
Sales (sale_management)
Lines of code 7748
Technical Name afi_quickbooks_connector
LicenseOPL-1
Websitehttps://www.actionfi.com

QuickBooks Online Connector

Seamlessly integrate QuickBooks with Odoo and streamline your business operations.

By actionfi

Unlock the power of two-way synchronization between Odoo and QuickBooks with actionfi's QuickBooks Online Connector. This robust and user-friendly module ensures your critical data stays accurate and up to date across both platforms eliminating manual entry and reducing errors.

Key Features:

  • Real-time data updates for consistent and reliable records
  • Effortless management of customers, vendors, inventory, and financial documents
  • Simplified workflows that save time and boost operational efficiency
  • Easy configuration with secure API-based integration

Whether you're handling accounting, procurement, or sales, our connector keeps your systems aligned-empowering your team to focus on what matters: growing your business.

FLOWCHART

Module Screenshot

This Odoo Intuit connector allows both manual and automatic sync.

REQUEST ODOO QUICKBOOKS DEMO

HIGHLIGHTS

Module Screenshot

QuickBooks Developer Account Setup

  • Navigate to https://developer.intuit.com/app/developer/homepage
  • If you don't have an account, click "Sign Up" to create a new one.
  • If you already have an account, click "Sign In" and enter your login credentials.
  • Follow the on-screen instructions to complete your account setup.

Create Your App in the QuickBooks Developer Portal

  • Sign in to your Intuit Developer account at https://developer.intuit.com
  • From the top-right corner, go to My Hub > App Dashboard.
  • Click on the app card with a "+" icon to start creating a new app.
  • Select the scope accounting & payments scope for your app.
  • Click "Create".

Access Client ID & Secret in QuickBooks

  • From your App Dashboard, select the app you just created.
  • In the top-left menu, click on "Keys & Credentials".
  • Here, you'll find your Client ID and Client Secret.

Set Up Redirect URL

  • To set your Redirect URL, go to Settings.
  • Under the Redirect URIs section, click "Add URI"
  • Use your Odoo domain with /quickbooks/callback as the Redirect URL.
    For example: https://yourdomain.com/quickbooks/callback

Configure QuickBooks Online Integration in Odoo

  1. Go to QuickBooks Connection in Odoo.
  2. Click New Connection.
  3. Enter:
    • Instance Name (e.g., "My QuickBooks Prod")
    • QuickBooks Instance (Sandbox or Production)
    • Realm ID (from QuickBooks Developer dashboard)
    • Client ID & Client Secret (from your QuickBooks app)
    • Redirect URL (e.g., https://yourdomain.com/quickbooks/callback)
  4. Ensure this Redirect URL is also added in your QuickBooks app settings.
  5. Click Authenticate to connect.
  6. Optionally, click Test Connection to verify.

Chart of Accounts Synchronization

  • Import your Chart of Accounts from QuickBooks into Odoo with support for matching by code and name.
  • Set default accounts here for income, expenses, and assets (used for product export if not set), as well as receivables, payables, and taxes.
  • Configure sales journals for customer invoices, purchase journals for vendor bills, bank journals for payments and deposits, and credit card journals for card transactions.
  • Setting these correctly ensures accurate posting and smooth reconciliation.

Tax Synchronization

Import Tax Codes and Tax Rates directly from QuickBooks into Odoo.

  • Supports matching by tax name to prevent duplicates.
  • Can auto-update existing tax records if enabled.
  • The last successful import date is recorded for easy tracking.

Customer & Vendor Synchronization

  • Bi-directional sync of Customers and Vendors between QuickBooks and Odoo.
  • Supports matching by QuickBooks display name.
  • Includes sub-contact synchronization.
  • Choose to update all records or only those imported from QuickBooks.

Product & Category Synchronization

  • Easily sync products between QuickBooks and Odoo, including categories and inventory details.
  • Bi-directional sync of products - choose to update all products or only those previously imported from QuickBooks.
  • Match products by name and QuickBooks SKU.
  • Optionally fetch and update quantity on hand to keep stock levels in sync.

Sync Payment Methods & Terms

  • Seamlessly import Payment Methods and Terms from QuickBooks into Odoo with a single click.
  • Reflect all available QuickBooks terms and payment methods in Odoo to keep financial settings aligned.
  • Users can manually map the related payment terms and payment methods, and also map the corresponding Odoo journal for each payment method.

Invoices & Bills Synchronization

  • Bi-directionally sync Invoices and Bills between QuickBooks and Odoo with flexible controls.
  • Set a custom start date to import invoices and bills from QuickBooks.
  • Choose to update all invoices and bills or only those previously imported from QuickBooks.

Import Payments and Credit Notes

  • Keep your financial records accurate by importing Credit notes and Payments from QuickBooks into Odoo.
  • Credit Notes: Import from QuickBooks, update existing records if needed, and optionally set a custom start date for import.
  • Supplier Payments: Import from QuickBooks, update previously imported records, and optionally define a custom start date.
  • Customer Payments: Import from QuickBooks, update related invoices in Odoo, and optionally set a custom start date for import.
  • Supports automatic reconciliation of payments in Odoo.

Seamless Multi-company Support

  • Connect Multiple QuickBooks Online companies to different Odoo companies.
  • Each connection can use separate credentials, realm IDs, and settings.
  • Sync data independently for each company to keep accounting records properly separated.

QuickBooks - Odoo Mapping

  • Maintain seamless data synchronization between QuickBooks and Odoo through organized mapping configurations.
  • Account Mapping: Align QuickBooks chart of accounts with Odoo accounts for accurate financial syncing.
  • Vendor & Customer Mapping: Link QuickBooks vendors and customers to Odoo to keep records consistent and avoid duplicates.
  • Tax & Category Mapping: Sync tax codes and product categories for accurate reporting and inventory management.
  • Product Mapping: Match products by name or SKU to keep inventory and sales data aligned.
  • This mapping is performed automatically during import and export operations.

Manual Mapping

  • Easily manage and align payment terms and methods between QuickBooks and Odoo through a centralized mapping interface.
  • Map QuickBooks Payment Term IDs and Payment Method IDs to their corresponding Odoo payment terms and methods.
  • Avoid duplication and ensure consistent payment details across financial documents.
  • Use the dropdown menu under Manual Mapping to selectively update or manage mappings as needed.
  • Manually map the related payment terms and payment methods, and also link each payment method to the corresponding Odoo journal.

QuickBooks Logs: Real-Time Sync Activity

  • Track all synchronization activities between QuickBooks and Odoo in real time.
  • Each log shows the timestamp, status, and operation type (Import/Export).
  • See clear messages about what was processed, like updated customers, products, or invoices.
  • Filter by log type (Customer, Invoice, Product etc...) and view the specific QuickBooks connection used.
  • Helps verify data flow, monitor changes, and troubleshoot issues easily.

Automated Data Sync Scheduler

  • Automate and manage data synchronization between QuickBooks and Odoo using cron jobs.
  • Cron jobs are automatically created when you set up a new QuickBooks connection in Odoo.
  • These jobs handle automatic import and export of data - including accounts, products, invoices, payments, and more
  • You can manually activate or deactivate each job whenever needed.
  • Jobs are fully editable: adjust timing, priority, or job type to fit your business needs.
  • This setup ensures accurate and timely data synchronization without manual effort.

Help and Support

We're here to help you every step of the way-whether it's a question, customization, or technical guidance
Benefit from 90 days of free assistance for troubleshooting, bug fixes, and answers to your module-related questions (excludes data recovery).

Write a mail to us:

odoosupport@actionfi.com

Have questions or need additional features? Just drop an email to our support team.

Connect with our Experts:

https://www.actionfi.com/contactus

Have technical queries, need additional features, or have something else in mind? Submit a support ticket and our experts will be glad to assist you.

Why actionfi?

actionfi helps organizations connect business data between anything & anywhere
actionfi's robust platform enables businesses to extract, enhance, elevate and interlink business data while creating bridges between applications, systems, processes, and people. And that's just one of the many things we do.

We connect everything

We integrate every part of your organization and beyond to dismantle barriers and enable rapid digital progress. This allows business and IT teams to collaborate more effectively and roll out new services faster.

We use multiple systems

We have expertise with a multitude of ERP systems, spanning both horizontal and vertical solutions, as well as multiple generations of technology to maximize the value of every system. We support any environment, cloud, and ecosystem.

We adopt customizations

At actionfi, we view requests for customizations as valuable opportunities rather than inconveniences. We understand each organization has unique needs, and we're committed to tailoring our solutions to fit those requirements.

Headquarters

1441 Broadway, #5

New York, NY 10018

+1 646 290 6311

hello@actionfi.com

www.actionfi.com

Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.