• Efficient Data Migration: Import/export data seamlessly between Odoo and QuickBooks, significantly reducing migration time and effort.
• Historical Data Tracking: Keep a record of historical data for better analysis and reference.
• Individual Record Export: Export specific records as needed for greater flexibility.
• Reference Maintenance: Maintain references to ensure data consistency and integrity.
• Customizable Activity Control: Select specific objects for import/export to tailor the process to your needs.
• Error Logging: Identify and resolve issues quickly with detailed error logs.
• Record Linking: Establish and maintain links between related records for better data management.
• Scheduled Data Synchronization: Automate data synchronization at predefined intervals for added convenience.
• Timeframe Sync: Synchronization operations for Import/export data from specific time periods

• Create an Intuit Developer Account and register a new app.
• Configure the required data and set up the Odoo QuickBooks Connector with QuickBooks account credentials.

• Use a Sandbox Company for testing by navigating to API Docs & Tools -> Sandbox.
• Sandbox companies mimic real QuickBooks Online experiences with sample data and are region-specific.

• Install the QuickBooks Connector module in Odoo.
• Select the QuickBooks module for configuration.

• Configure QuickBooks account details such as Client ID and Secret Key for the desired company in the Import/Export section.

• Obtain QuickBooks credentials (e.g., Client ID, Secret Key) from the 'Keys & Credentials' section in your QuickBooks app.
• Choose between Sandbox or Production environments.
• Set the Redirect URI to: [web.base.url]/callback/[company id] 
  Example: http://localhost:8069/callback/1 (for company ID 1)

• Use the 'Sync' button to manually import or export data within specified limits.
• Activate the corresponding cron job (initially inactive) with the 'Activate Cron' button.
• Enable the 'Blocked' status for specific tables to manage and control synchronization.
• The following models support syncing of both active and inactive (archived) records [Payment Terms, Payment Methods, Employees, Customers, Vendors]
• When the scheduled cron job runs, it will import or export all records that have been updated within the past three days.

• Switch the corresponding company in which the QuickBooks is configured before importing.

• View the ID of the last imported records along with the corresponding Odoo record ID, except for the Chart of Accounts (COA)
• For COA, the Last Imported QB ID is saved based on creation time, allowing easy reference for data mapping.
• When Full Sync is disabled, the synchronization process is based on the Last Synced QB ID. Only records with a QB ID greater than the last synced QB ID will be imported or exported. After the sync is completed, the Last Synced QB ID in the History tab will be updated to reflect the QB ID of the most recently synced record. However, if the records being synced already exist in both systems, the Last Exported QB ID field in the History tab will not be updated.

• Enable all fields in the "Record Update Permissions" section to allow updates to all imported records from QuickBooks.

• Displays the QuickBooks account types linked to Odoo account types.

• Displays the QuickBooks account subtypes linked to Odoo account types.

• Provides a complete log history of QuickBooks activities.

• Odoo Data:
  • Shows how Odoo maps its chart of accounts.
  • Opening balances in the Chart of Accounts must be created manually in Odoo, as QuickBooks does not provide journal item data of type Deposit in the API response for opening balances.

• QuickBooks Data: Displays the corresponding data from QuickBooks.

• Limitations
  Accounts with the same name are not supported.
  Before export the record should be mapped to a QB Account Type and QB Account Subtype.

• Odoo Data:
  • Taxes are saved in groups based on percentages.
  • Imported taxes cannot be edited. A new tax must be created for exports.
  • Deactivated QuickBooks records remain inactive in Odoo upon re-import.

• QuickBooks Data: Displays tax configurations.

• Odoo Data: The journal’s account type is derived from the linked chart of accounts.

• QuickBooks Data: Shows QuickBooks journal details.

• Odoo Data: Configures payment terms by days.

• QuickBooks Data: Displays corresponding payment terms.

• QuickBooks Data: Displays corresponding QuickBooks payment terms.

• Pre-Import Requirements:
  • Set up Account Receivable and Account Payable under the Configurations tab in Odoo.
  • While creating a customer, if the "Is QB Customer" option is checked, a parent customer must be selected, and the new customer will be created as a sub-customer under the selected parent customer

Pre-Import Requirements:

Configure following details under the Configurations tab.

• Category Income Account
• Category Expense Account
• Product category

• For storable products, the Extra On hand Quantity and Minimum Quantity will be updated; all other details will remain the same for all product type.

• This is used to update the on-hand Quantity of the products.

Limitation

• The export of purchase orders containing tax details is not supported.
  

1. Vendor Credit Linking
   • In Odoo, applying a vendor credit to a bill does not create a payment record.
   • In QuickBooks, applying a vendor credit to a bill requires a payment to be created.
   • Due to this difference in workflow, vendor credits cannot be directly linked to bills when exporting from Odoo to QuickBooks.
   • As a result, vendor credit applications made in Odoo will not be reflected as payments in QuickBooks.
2. Credit Auto-Application Issues
   • When exporting a bill from Odoo to QuickBooks, QuickBooks may automatically apply any existing vendor credit to that bill.
   • If the vendor credit has not yet been exported from Odoo, QuickBooks may still apply available credits, potentially causing incorrect reconciliation.
   • Later, when the credit is synced from Odoo, it may appear as unlinked, leading to mismatches between the two systems.
   • Our plugin cannot prevent this automatic behavior, as credit application is managed internally by QuickBooks.

• Export Order
  • Always export vendor credits from Odoo before exporting the corresponding bills.
    This ensures QuickBooks has the credit available before it attempts to auto-apply it.
• Manual Adjustment (if needed)
  • If QuickBooks auto-applies a credit before it is synced:
  • Open the Vendor Credit in QuickBooks.
  • Unapply it from the bill.
  • Re-apply it manually after syncing the credit from Odoo.
• Optional QuickBooks Configuration
  • Disable auto-application of credits in QuickBooks:
    • Go to Account and Settings > Advanced > Automation.
    • Turn off the setting: “Automatically apply credits”.
• This ensures credits are applied only when explicitly instructed, helping to maintain consistency between Odoo and QuickBooks.

• Inactive records in QuickBooks or Odoo will be skipped during the import/export process.
• Employee with the same name is not supported.

• Multiple Tax and Discount
  • If a record (such as a Sale Order, Invoice, Purchase Order, or Bill) contains multiple taxes or discounts applied across multiple product lines, it will not be considered for export.

• Credit Note Linking
  • We can only link payments to invoices; credit notes cannot be directly linked to invoices during export.
  • In Odoo, applying a credit note to an invoice does not create a payment record.
  • In contrast, QuickBooks requires a payment to be created when a credit note is applied to an invoice.
  • Due to this fundamental difference in workflows, credit notes applied in Odoo will not be reflected as linked in QuickBooks upon export.
• Automatic Credit Application by QuickBooks
  • When exporting an invoice from Odoo to QuickBooks, QuickBooks may automatically apply any existing credit (credit memo or vendor credit) for that customer or vendor.
  • If the corresponding credit has not yet been exported from Odoo, QuickBooks may still apply available credits, potentially leading to incorrect reconciliation.
  • When the credit is eventually synced, it may appear unlinked, resulting in mismatches between the two systems.
  • Unfortunately, our plugin cannot override or control QuickBooks’ auto-application behavior.

• Export all credit memos or vendor credits from Odoo before exporting the corresponding invoices or bills.
  • This ensures QuickBooks has the necessary credit available before attempting to apply it.

• If QuickBooks prematurely auto-applies a credit:
  • Open the relevant credit memo in QuickBooks.
  • Unapply it from the invoice.
  • Reapply it manually after the credit has been synced from Odoo.

• Disable the “Auto-apply credits” setting to prevent premature application:
  • Navigate to Account and Settings > Advanced > Automation.
  • Turn off “Automatically apply credits”.
• This ensures that credits are only applied when explicitly instructed, helping maintain synchronization integrity.

Navigate to Quickbook → Import/Export → Company → Timeframe Sync tab

• Target Model: Select the Odoo model you want to synchronize with QuickBook
• Partner Type: Specify whether to sync customers or vendors
  Required for: Partner, Account Move, Payment, Sale order, Purchase order
• Activity: Choose the synchronization direction 
  Import - Import data from QuickBooks to Odoo
  Export - Export data from Odoo to QuickBooks
• Refund Type: Specify the refund type for invoice synchronization
  Required: Conditional (Only for Invoice/Bill model)
• Start Date & End Date: The beginning date of the synchronization timeframe The ending date of the synchronization timeframe

• Compatible with Odoo 16.0 Community Edition.

• Version 1.0.0: July 2025
  • Initial release