QuickBooks ODBC Driver
for QuickBooks Desktop

Connect Excel, Power BI, Tableau, and your SQL tools to QuickBooks Desktop Pro, Premier, or Enterprise. One installer includes 32-bit and 64-bit ODBC drivers, 120+ tables, and SQL read/write access for supported entities.

Download Free Trial Documentation →

30-day free trial · No credit card · Plans from $299 USD/year

SQL Client - localhost:5433

$ psql -h localhost -p 5433 -U qbconnect qbconnect

qbconnect=# SELECT c.name, SUM(i.total) as revenue
             FROM invoices i
             JOIN customers c ON i.customer_ref_list_id = c.list_id
             WHERE i.txn_date >= CURRENT_DATE - INTERVAL '1 year'
             GROUP BY c.name
             ORDER BY revenue DESC
             LIMIT 5;

     name        │  revenue
─────────────────┼──────────
 Acme Corp       │ $45,200.00
 TechStart LLC   │ $32,750.00
 Global Trade    │ $28,400.00
 Premier Svcs    │ $19,800.00
 DataFlow Inc    │ $15,600.00
(5 rows)

qbconnect=# ▌

Choose the right setup for your QuickBooks edition

Syntra has been tested with US and Canadian QuickBooks Desktop and Enterprise from 2018 onward, including 32-bit and 64-bit QuickBooks. Install it on the Windows machine that runs QuickBooks, then use the bundled driver from your reporting application.

US and Canadian QuickBooks Desktop compatibility and Syntra read and write capabilities
QuickBooks edition	Regions	Cached reporting	SQL writes	Direct Enterprise live reads
Pro / Premier 2018+	US and Canada	Standard and Pro	Supported entities	Unavailable
Enterprise 2018+	US and Canada	Standard and Pro	Supported entities	Pro plan, with setup

Windows and driver support. Windows 10/11 (64-bit); Windows Server 2019+ and RDS require Pro. Both 32-bit and 64-bit ODBC applications are supported.

Data freshness. Cached data reflects the last sync. Enterprise direct reads need configuration and cover supported tables. Enterprise live-read setup.

Annual licensing. Standard: $299 USD for one company file. Pro: $499 USD for unlimited company files. Compare plans.

Both 32-bit and 64-bit QuickBooks are supported. Choose the ODBC driver that matches your reporting application, such as Excel; its architecture can differ from QuickBooks. QuickBooks Online is not supported. Contact us about your setup.

30-second product tour

See Syntra ODBC in action

From authorizing your QuickBooks Desktop company file to familiar SQL results and the tools your team already uses.

A QuickBooks ODBC Driver Built for Real SQL

Use the bundled 32-bit or 64-bit ODBC driver for Excel and legacy tools, or connect modern applications directly to Syntra's local SQL server.

Built-in SQL Server

No driver install needed for most clients. Syntra includes a built-in SQL server on port 5433 with native connectivity for modern tools.

120+ Tables

Invoices, customers, items, bills, estimates, and more. Custom fields are auto-discovered from your QuickBooks file.

Full SQL Support

JOINs, CTEs, subqueries, aggregates, window functions. Full SQL engine built in, no external dependencies.

Smart Caching

Smart local cache with incremental sync. Adaptive polling tiers keep data fresh without hammering QuickBooks.

Read & Write

INSERT, UPDATE, DELETE directly into QuickBooks. Void transactions via SQL. Full CRUD on supported entities.

Built-in MCP Server

Let Claude, Cursor, and Windsurf query QuickBooks through natural language. 24 QuickBooks tools are exposed through MCP, including a persistent memory layer.

How to connect to QuickBooks through ODBC

Install Syntra. Download the trial on your QuickBooks machine. The installer registers the drivers and the Syntra QuickBooks System DSN.
Authorize your company file. Open QuickBooks as an administrator, launch Syntra, and grant application access. Allow the first sync to finish.
Choose your data source. Select Syntra QuickBooks in your tool’s ODBC connector, enter your configured credentials, and load a table or run SQL.

QuickBooks to Excel →

Load invoices into Power Query and refresh your workbook.

QuickBooks to Tableau →

Build sales dashboards with ODBC and choose Live or Extract.

QuickBooks to Power BI →

Choose the bundled ODBC data source and import your tables.

QuickBooks to SQL Server →

Configure a linked server for your reporting workflow.

Need a custom DSN or help with 32-bit versus 64-bit tools? Read the QuickBooks ODBC driver setup guide.

Talk to QuickBooks with AI

Built-in MCP server lets Claude, Cursor, Windsurf, and any MCP-compatible tool query and manage your QuickBooks data through natural language. Book journal entries, pull reports, create invoices. Just ask.

◆24 QuickBooks tools, including query, insert, update, delete, void, preview journal entries, built-in reports, and a persistent memory layer

◆Zero config stdio. AI spawns the process, instant connection

◆Preview before commit. Validates journal entries before writing

Learn more about MCP →

Claude + QuickBooks via MCP

You:  Show me all overdue invoices over $1,000

Claude: Let me query your QuickBooks data...

→ query: SELECT c.full_name, i.ref_number, i.balance_remaining,
         i.due_date, CURRENT_DATE - i.due_date AS days_overdue
  FROM invoices i JOIN customers c ON i.customer_ref_list_id = c.list_id
  WHERE i.due_date < CURRENT_DATE AND i.balance_remaining > 1000
  ORDER BY days_overdue DESC

Found 4 overdue invoices totaling $12,450.00:

  Acme Corp       INV-1042  $4,200.00   45 days overdue
  TechStart LLC   INV-1089  $3,750.00   32 days overdue
  Global Trade    INV-1101  $2,800.00   18 days overdue
  Premier Svcs    INV-1115  $1,700.00   12 days overdue

How we compare

Compare QuickBooks ODBC drivers by SQL capabilities, client access, and data freshness. Check the full comparison for licensing and vendor sources.

Last verified September 24, 2026

Feature	Syntra ODBC	QODBC	CData	Devart	Lead
Modern client access without an extra SQL gateway	Built in	ODBC driver	ODBC driver with optional remoting and gateway tooling	ODBC driver	Syntra edge
Advanced SQL surface	JOINs, subqueries, CTEs, window functions	Standard ODBC SQL; not a relational server	SQL-92 plus complex JOINs	SQL-92 plus JOINs and subqueries	Syntra edge
SQL standards level	Beyond SQL-92	ODBC-style SQL layer	SQL-92	SQL-92	Syntra edge
Live-vs-cached control	Adaptive sync plus per-session freshness override	Optimizer cache	Smart caching and cache settings	Local caching and pooling	Syntra edge
QuickBooks-specific AI / MCP runtime	Included in Pro, with 24 QuickBooks tools	Ask vendor about MCP support	AI coding tools plus separate MCP offerings	Ask vendor about QuickBooks MCP support	Syntra edge
Client platform flexibility	Windows ODBC; SQL clients on macOS/Linux	Windows	Windows, Linux, and macOS	Windows	Tradeoff

See the full comparison research →

For developers

QuickBooks, with IntelliSense.

An open-source TypeScript SDK for Syntra ODBC. Pre-built Drizzle schema, zero-config client, and codegen CLI, all on npm. Full autocomplete on every QuickBooks table and column in VS Code.

Explore the SDK →GitHub

$ npm install @syntraodbc/drizzle-schema

import * as schema from '@syntraodbc/drizzle-schema';

db.select().from(schema.invoices)

.where(eq(schema.invoices.balance_remaining, 1000))

QuickBooks ODBC guides

Useful setup and migration articles

View all articles →

May 13, 2026quickbooksodbc

QODBC Alternative for QuickBooks Desktop: What to Check Before You Switch

A practical checklist for teams comparing QODBC alternatives for QuickBooks Desktop ODBC access, including SQL support, write workflows, performance, and migration risk.

May 13, 2026quickbooksodbc

QuickBooks Desktop to Excel: ODBC Setup

Step-by-step guide to connect Excel to QuickBooks Desktop through an ODBC driver, choose 32-bit vs 64-bit DSNs, run SQL, and fix common setup errors.

Frequently Asked Questions

Which QuickBooks versions does Syntra ODBC support?

Syntra supports US and Canadian editions of QuickBooks Desktop Pro, Premier, and Enterprise from 2018 onward on Windows. Both 32-bit and 64-bit QuickBooks are supported. QuickBooks Online uses a different API and is not supported by this driver.

Does Syntra ODBC work with US and Canadian QuickBooks?

Yes. Syntra has been tested with US and Canadian QuickBooks Desktop and Enterprise from 2018 onward, including 32-bit and 64-bit QuickBooks. Standard and Pro plan prices are listed in US dollars.

Is the QuickBooks ODBC driver 32-bit or 64-bit?

The installer includes both 32-bit and 64-bit ODBC drivers. Use the driver and System DSN that match your reporting application: 32-bit Excel needs the 32-bit driver even on 64-bit Windows.

How do I connect Excel or Tableau to QuickBooks?

Install Syntra on the Windows machine running QuickBooks Desktop, authorize access to your company file, and choose the Syntra QuickBooks DSN in your application’s ODBC connector. The installer creates this System DSN for you.

Can I write data back to QuickBooks?

Both Standard and Pro include SQL INSERT, UPDATE, and DELETE for supported entities. Some tables are read-only and individual operations have QuickBooks restrictions. Test write workflows on a backup company file before using production data.

Are queries live or cached?

Syntra normally reads from a local cache that refreshes in the background. A Live connection in a reporting tool can still read cached data. The Pro plan adds a direct live-read path for supported tables on QuickBooks Enterprise when configured. Writes and SDK data fetches require QuickBooks Desktop to be running.

How much does the QuickBooks ODBC driver cost?

Standard is $299 USD per year for one QuickBooks company file. Pro is $499 USD per year and adds unlimited company files, Windows Server and RDS support, Enterprise live reads, and MCP features. Both plans include the ODBC drivers and read/write access for supported entities.

Is there a free QuickBooks ODBC driver trial?

Syntra offers a 30-day trial with no credit card required. Continued use after the trial requires a paid license; the trial does not automatically become a paid subscription.

See all product questions or compare Syntra with QODBC, CData, and Devart.

Try Syntra ODBC Free for 30 Days

Full-featured trial. No credit card required.

Download Now

QuickBooks ODBC Driverfor QuickBooks Desktop