ODOO 19 CE ⇌ QUICKBOOKS

CSV Integration Framework

System Online |
Integration Dashboard
Odoo 19 CE ↔ QuickBooks CSV Sync Overview
Records Synced
2,847
↑ 143 today
Active Profiles
12
8 import · 4 export
Pending Queue
34
Processing now
Errors Today
3
↓ 2 from yesterday
Odoo Records
14,290
Partners, Products, Invoices
QB Records
13,948
Customers, Items, Txns
📦 Current Sync Pipeline Running
📂
142
CSV Read
✅
139
Validated
🔄
34
Transforming
💾
0
Imported
❌
3
Errors
Overall Progress 24%
⏱ Started: 2 minutes ago · ETA: ~8 minutes
📊 Entity Sync Coverage
👥 Customers / Partners 98%
🏷️ Products / Services 91%
🧾 Invoices 87%
💳 Payments 79%
📒 Chart of Accounts 100%
🕒 Recent Sync Activity
Timestamp Operation Entity Direction Records Status Duration
2025-06-16 09:42:11ImportCustomersQB → Odoo142Success4.2s
2025-06-16 09:38:00ExportInvoicesOdoo → QB87Success6.1s
2025-06-16 09:30:45ImportProductsQB → Odoo34Partial3.8s
2025-06-16 09:15:22ExportPaymentsOdoo → QB223 Errors2.1s
2025-06-16 09:00:00ImportChart of AccountsQB → Odoo520Success12.3s
📥 CSV Import
Import QuickBooks CSV files into Odoo 19 CE
Upload File
Import Profiles
Preview & Validate
Scheduled Imports
📂
Drop CSV file here or click to browse
Supports QuickBooks, Wave, Xero, Sage exports
Import Settings
Profile Name Source App Entity Type Odoo Model Fields Mapped Last Import Status Actions
QB Customer ExportQuickBooksCustomerres.partner18/22Today 09:42Active
QB Vendor ListQuickBooksVendorres.partner14/18Today 08:15Active
QB Products/ServicesQuickBooksProductproduct.template22/28YesterdayActive
QB Invoice ExportQuickBooksInvoiceaccount.move31/36Today 08:00Active
Wave Contact ExportWaveCustomerres.partner10/223 days agoPartial
Xero Contact ImportXeroCustomerres.partner16/22NeverDraft
🕒
Scheduled imports use Odoo's built-in cron job system. Configure schedules in the Odoo Technical menu under Automation → Scheduled Actions, or use the prebuilt cron jobs installed with this module.
ProfileFrequencyNext RunLast RunStatusActions
QB Customer ExportEvery 6 hours2025-06-16 12:002025-06-16 06:00Active
QB Invoice ExportDaily at 08:002025-06-17 08:002025-06-16 08:00Active
QB Products/ServicesWeekly Monday2025-06-23 00:002025-06-16 00:00Paused
🗺️ Field Mapping
Map QuickBooks CSV fields to Odoo 19 CE model fields
Entity Type
Field Mappings: QuickBooks Customer → res.partner 22 fields mapped
QuickBooks CSV Field Odoo Field (res.partner) Transformation
🔌 API Configuration
Configure Odoo 19 CE XML-RPC API and CSV automation settings
🟣 Odoo 19 CE API
🟢 CSV Automation Settings
📘 Odoo 19 CE API Field Reference
EntityOdoo ModelKey FieldsQB CSV EquivalentImport Method
Customerres.partnername, email, phone, street, city, zip, country_id, customer_rankCustomer Name, Email, Phone, Address fieldsXML-RPC create/write
Vendorres.partnername, email, phone, supplier_rank, vatVendor Name, Email, Tax IDXML-RPC create/write
Productproduct.templatename, list_price, standard_price, type, categ_id, uom_idItem Name, Sales Price, Cost, TypeXML-RPC create/write
Invoiceaccount.movepartner_id, invoice_date, move_type, invoice_line_idsCustomer, Date, Type, Line ItemsXML-RPC create/action_post
Billaccount.movepartner_id, invoice_date, move_type='in_invoice'Vendor, Date, AmountXML-RPC create/action_post
Paymentaccount.paymentpartner_id, amount, payment_type, journal_idName, Amount, Type, AccountXML-RPC create/action_post
Accountaccount.accountcode, name, account_type, currency_idAccount Number, Name, TypeXML-RPC create/write
🧩 Third-Party Addons
Recommended Odoo 19 CE community addons for accounting interoperability
ℹ️
Install addons via /addons directory in your Odoo 19 CE installation. After placing addon folders, update the app list in Settings → Technical → Modules.
📊 Account Base Kit Installed

Full accounting features for Odoo 19 CE Community Edition including financial reports, asset management, and bank reconciliation.

OCA v19.0 Free
Module: account_base_kit
Repo: OCA/account-financial-tools
🔄 CSV Import/Export Advanced Installed

Advanced CSV import/export with field mapping, transformation rules, scheduled automation, and multi-format support.

OCA v19.0 Free
Module: base_import_advanced
Repo: OCA/server-tools
🏦 Account XLSX Report Not Installed

Generate Excel-compatible accounting reports from Odoo 19 CE, compatible with QuickBooks Excel import format.

OCA v19.0 Free
📁 Attachment Queue Installed

Automatically process file attachments from specified directories, enabling watch-folder automation for CSV imports.

OCA v19.0 Free
Module: attachment_queue
Repo: OCA/server-tools
💱 Multi-Currency Advanced Not Installed

Enhanced multi-currency support for importing QB transactions with foreign currency amounts into Odoo CE.

OCA v19.0 Free
📑 Account Statement Import Installed

Import bank statements from CSV/OFX/QFX files directly into Odoo CE bank journals for reconciliation.

OCA v19.0 Free
Module: account_statement_import
Repo: OCA/bank-statement-import
📋 Sync History
Complete audit log of all CSV import/export operations
IDDate/TimeProfileDirectionEntityCreatedUpdatedErrorsDurationStatus
#10422025-06-16 09:42:11QB Customer ExportQB→OdooCustomer984404.2sSuccess
#10412025-06-16 09:38:00QB Invoice ExportOdoo→QBInvoice08706.1sSuccess
#10402025-06-16 09:30:45QB Products/ServicesQB→OdooProduct28423.8sPartial
#10392025-06-16 09:15:22QB PaymentsOdoo→QBPayment01932.1sErrors
#10382025-06-16 09:00:00QB Chart of AccountsQB→OdooAccount12508012.3sSuccess
⚠️ Error Log
Review and resolve import/export errors
⚠️
5 unresolved errors require attention. Common causes include missing required fields, invalid lookup values, or data type mismatches.
IDSync JobRow #FieldErrorRaw ValueStatusAction
#E021QB Payments #1039Row 12partner_idLookup failed: partner not found"ACME Corp LLC"Open
#E020QB Payments #1039Row 18amountInvalid number format"$1,200.00"Open
#E019QB Payments #1039Row 21journal_idAccount not found: "Checking""Checking"Open
#E018QB Products #1040Row 5categ_idCategory not found: "Services""Services"Pending
#E017QB Products #1040Row 9uom_idUnit of measure not found: "ea""ea"Resolved✓ Fixed
📤 CSV Export
Export Odoo 19 CE data to QuickBooks-compatible CSV files
Quick Export
Recent Exports
export_invoices_20250616.csv
87 records · 4.1KB · Today 09:38
export_customers_20250616.csv
142 records · 8.7KB · Today 08:15
export_accounts_20250615.csv
520 records · 22.3KB · Yesterday
⚙️ Integration Profiles
Manage all import and export profiles
💡
Profiles store all settings for a specific import or export operation including field mappings, transformation rules, and scheduling configuration. Create separate profiles for each entity type and source application.
NameTypeAppEntityMappingsScheduleLast RunStatusActions
QB Customer ImportImportQuickBooksCustomer18 fieldsEvery 6hToday 09:42Active
QB Invoice ExportExportQuickBooksInvoice31 fieldsDaily 08:00Today 08:00Active
Wave Contact ImportImportWaveCustomer10 fieldsManual3 days agoPartial