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 |
License | OPL-1 |
Website | https://www.actionfi.com |
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 |
License | OPL-1 |
Website | https://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

This Odoo Intuit connector allows both manual and automatic sync.
REQUEST ODOO QUICKBOOKS DEMO
HIGHLIGHTS

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

- Go to QuickBooks Connection in Odoo.
- Click New Connection.
- 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
)
- Ensure this Redirect URL is also added in your QuickBooks app settings.
- Click Authenticate to connect.
- 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

Write a mail to us:
odoosupport@actionfi.comHave questions or need additional features? Just drop an email to our support team.

Connect with our Experts:
https://www.actionfi.com/contactusHave 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?

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