Python Connector for QuickBooks Online: Query and Update QuickBooks with SQL from Python
Devart Python Connector for QuickBooks Online is a Python DB API 2.0 module for Windows that lets your scripts read and change QuickBooks Online data with plain SQL, for $74.95 a year or $149.95 perpetual (Single license). Accounts, customers, invoices, bills and the rest of a QuickBooks Online company look like database tables, and INSERT, UPDATE and DELETE go straight back to QuickBooks.
Talking to QuickBooks Online from Python normally means Intuit's REST API: registering an app, handling OAuth tokens, paging through results and turning JSON into rows. For a report, a reconciliation script or a pandas analysis, that's a lot of plumbing. This connector hides it behind the same connect(), cursor() and execute() calls you'd use with a database driver.
Quick facts
- Version: 1.4.0, released October 22, 2026 (first released December 2023)
- Developer: Devart
- Python: 3.10 to 3.15, 32-bit or 64-bit; installed as a wheel (
devart-quickbooks-connector on PyPI)
- Platform: Windows and Windows Server, 32-bit and 64-bit; no macOS or Linux build
- QuickBooks: QuickBooks Online companies, including sandbox companies; not QuickBooks Desktop
- SQL: ANSI SQL, with SELECT, INSERT, UPDATE and DELETE
- Price: $74.95 a year or $149.95 perpetual for Single; Team $189.95 a year or $379.95 perpetual; Site $339.95 a year or $679.95 perpetual
- Trial: 30 days, for evaluation only, not production
- Refund: the order page promises a 30-day money-back guarantee if you're not satisfied, while Devart's ordering FAQ ties refunds to technical problems that support can't fix
- What we checked: the order page charged $74.95 for a one-year Single license and $149.95 perpetual, $189.95 and $379.95 for Team, and $339.95 and $679.95 for Site, the download page listed version 1.4.0 at 12.94 MB for Python 3.15, and PyPI listed version 1.4.0 with Windows-only wheels, on November 22, 2026. We didn't connect it to a QuickBooks company.
Download Free TrialBuy Single LicenseBuy Team LicenseBuy Site License
Overview
Devart Python Connector for QuickBooks Online follows the Python DB API 2.0 specification, so code written for other database drivers looks the same here. You import the module, call signin() once to log in to Intuit through OAuth 2.0 and get a refresh token, then pass the token and your company ID to connect(). From there, cursor.execute("SELECT ...") returns QuickBooks records as rows you can loop over or load into a pandas DataFrame.
Behind the scenes, simple queries are turned directly into QuickBooks Online API calls and run on Intuit's side. A complex query, with joins or grouping the API can't do, is split into simpler calls, and an embedded SQL engine finishes the job on a local cache. You write one SQL statement either way.
Features
Standard SQL over QuickBooks Online
Devart Python Connector for QuickBooks Online supports ANSI SQL against QuickBooks Online objects, including joins, filters, grouping and sorting that QuickBooks' own query language can't do, because the embedded engine completes those parts locally.
Read and write
Devart Python Connector for QuickBooks Online handles create, read, update and delete operations, and can send several update statements to QuickBooks Online as one batch to cut the time a bulk change takes.
Built-in Intuit sign-in
Devart Python Connector for QuickBooks Online includes a signin() method that runs Intuit's OAuth 2.0 login and returns the refresh token, so you don't have to register your own Intuit app first. Connections also accept a Sandbox flag for test companies and proxy host, port, user and password settings.
Pooling and caching
Devart Python Connector for QuickBooks Online pools connections (on by default, with a pool ID per connection or a switch to turn it off) and caches data locally, which speeds up scripts that open many connections or run the same lookups again.
Types and Unicode
Devart Python Connector for QuickBooks Online maps QuickBooks Online data types to Python types, with options to control that mapping, and handles multilingual text in any encoding.
Benefits
- No REST plumbing. OAuth, paging and JSON parsing are handled for you.
- Familiar code. Anyone who has used a Python database driver can use it right away.
- Data science ready. Query results go straight into pandas for analysis or charts.
- Low price of entry. $74.95 a year for one developer is less than a day of writing and testing API code.
Real-World Uses
- Month-end reports. A script pulls invoices and payments into pandas and emails an aging summary.
- Data sync. A scheduled job copies new customers from a web shop database into QuickBooks Online.
- Bulk fixes. One UPDATE statement corrects a field on hundreds of items after a pricing change.
- Testing on a sandbox. A developer builds and tests an integration against an Intuit sandbox company before pointing it at the live books.
Who It's For, and Who Should Skip It
Devart Python Connector for QuickBooks Online suits Python developers and analysts on Windows who need QuickBooks Online data in scripts, notebooks or small integrations, and who would rather write SQL than learn Intuit's API.
Skip it if your Python runs on Linux or macOS, such as a cloud function or a Docker container, because the wheels are Windows-only. It doesn't connect to QuickBooks Desktop. If you only need QuickBooks data in Excel or Power BI, Devart's ODBC Driver for QuickBooks Online fits better, and if you're comfortable with REST, Intuit's own API and its free SDKs cost nothing.
Usage Guide
- Install the module with
pip install devart-quickbooks-connector, or download the wheel for your Python version from Devart's download page.
- Start the trial or activate your license key with the module's
activate() method; a subscription license needs internet access to check its status.
- Sign in to Intuit by calling
devart.quickbooks.signin(), log in in the browser, and keep the returned refresh token.
- Connect with
devart.quickbooks.connect(CompanyId=..., RefreshToken=...), adding Sandbox=True for a test company.
- Query and update with a cursor, for example
cursor.execute("SELECT * FROM Customer"), then fetch the rows or load them into pandas.
Before you buy
The Single license is for one user at one company address. Up to four people need the Team license ($189.95 a year), and more need Site ($339.95 a year). The trial is for evaluation only, so production scripts need a paid license. Shipping the connector inside an application you distribute needs an OEM license, sold separately by Devart.
Where it falls short
- Windows only. The wheels on PyPI and Devart's site are for 32-bit and 64-bit Windows; Linux and macOS aren't supported.
- Python 3.10 or newer. Version 1.4.0 dropped Python 3.7, 3.8 and 3.9.
- QuickBooks Online only. QuickBooks Desktop files and servers aren't supported.
- API limits still apply. Complex queries fetch data into a local cache first, so a large company file can make them slow.
- Few reviews. We found no published reviews of this connector.
Comparisons
Python Connector vs. Devart's ODBC Driver for QuickBooks Online
Devart's ODBC Driver for QuickBooks Online serves Excel, Power BI, Tableau and any language with ODBC support, Python included through pyodbc. The Python Connector is a native DB API module with no DSN to set up, and costs less for one developer. Choose the ODBC driver if several tools need the data; choose the connector if only Python does.
Python Connector vs. Intuit's REST API
Intuit's API is free, works on any platform and gives you every endpoint, but you write the OAuth handling, paging and data mapping yourself and query with Intuit's limited query language. The connector costs money and runs only on Windows, but turns all of that into SQL with joins and grouping.
Editions and Pricing
Each button opens the order page with that license and term selected; you can change the term to 2 or 3 years or add premium support there. A perpetual license keeps working at the version you bought and includes one year of updates.
FAQs
Does the Devart Python Connector for QuickBooks Online work on Linux or macOS?
No. Devart Python Connector for QuickBooks Online ships as wheels for 32-bit and 64-bit Windows and Windows Server only.
Which Python versions does the QuickBooks connector support?
Devart Python Connector for QuickBooks Online 1.4.0 supports Python 3.10 through 3.15. Support for Python 3.7, 3.8 and 3.9 was removed in that release.
Do I need my own Intuit developer app to use the connector?
No. Devart Python Connector for QuickBooks Online has a signin() method that runs the OAuth 2.0 login and returns a refresh token you pass to connect().
Can the Python connector write to QuickBooks Online?
Yes. Devart Python Connector for QuickBooks Online supports INSERT, UPDATE and DELETE, and can send several updates as a batch.
Does the QuickBooks Python connector work with QuickBooks Desktop?
No. Devart Python Connector for QuickBooks Online connects only to QuickBooks Online companies, including Intuit sandbox companies.
What happens when the subscription ends?
A subscription license of Devart Python Connector for QuickBooks Online stops working at the end of the term unless you renew. A perpetual license keeps working at the version you bought.
System Requirements
- Windows or Windows Server, 32-bit or 64-bit
- Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15
- A QuickBooks Online company or Intuit sandbox, and an Intuit sign-in
- Internet access, directly or through a proxy
Conclusion
Devart Python Connector for QuickBooks Online is worth $74.95 a year if you write Python on Windows and need QuickBooks Online data in scripts or notebooks: you get SQL with joins over QuickBooks objects, write-back and a built-in Intuit sign-in, without writing API code. The reason not to buy it is the platform: if your Python runs on Linux, in a container or in the cloud, it won't install there, and Intuit's free API is the way to go.
Download Free TrialBuy Single LicenseBuy Team LicenseBuy Site License