Devart ODBC Driver for Zoho Invoice: Clients, Projects and Billing Data in Excel or Power BI
Devart ODBC Driver for Zoho Invoice is a $109.95-per-year Windows ODBC driver for the people who bill clients with Zoho Invoice: freelancers, agencies and small service firms. It exposes 58 Zoho Invoice tables, from invoices and items to clients (with addresses, contact persons, comments, refunds and statement e-mails), projects with their comments and hours, and currencies, to Excel, Access, Power BI and other ODBC tools.
Zoho Invoice is free and focused on billing, which is exactly why its reporting is basic. If you want to know which clients pay late, which projects bill below their hours, or what you earned per currency this year, this driver lets a spreadsheet or BI tool ask Zoho Invoice directly.
Quick facts
- Version: 1.9.0, released October 16, 2026 (on sale since December 2021)
- Developer: Devart
- Runs on: 32-bit and 64-bit Windows from Vista on, including Windows Server and Terminal Server, with .NET Framework 4.5 or later
- Connects with: Zoho data center, Zoho Invoice Organization ID and a "Sign In with Zoho" refresh token
- Schema: 58 tables, with a whole group for contacts and another for projects
- Price: $109.95 per year, $219.95 one-time perpetual (Desktop)
- Trial: 30 days, activated with a trial key from a Devart account
- Refund: 30-day refund only for technical faults Devart support can't fix
- What we checked: on November 14, 2026, $109.95 at checkout for Desktop for Windows with a 1-year subscription, and version 1.9.0 offered as a 32.58 MB EXE on the download page. We didn't link it to a live Zoho Invoice organization
Before you buy
Zoho Invoice itself costs nothing, so compare the driver's $109.95 a year with what you'd save over exporting reports by hand. It pays off when you report every week or every month, or need Invoice data inside another system; for a yearly tax summary, Zoho's built-in reports are enough. If you already moved to Zoho Books, buy Devart's Books driver instead, since the Invoice driver reads only Zoho Invoice.
Download Free Trial Buy Now
Overview
The driver mirrors how Zoho Invoice stores a client relationship. Besides Contacts, Excel's Navigator shows ContactAddresses, ContactPersons, ContactComments, ContactRefunds and ContactStatementEmail, so billing addresses, the people you invoice, notes, refunds and statement settings each come as their own table. Projects get the same treatment, with project comments and fields such as billing type and total hours.
Excel Navigator on a Zoho Invoice DSN: 58 tables, the contact family at the top, and the Currency table previewed.
Connection is the standard Zoho OAuth flow Devart uses: pick the data center, enter the Organization ID, sign in to Zoho in a browser window, and the driver saves a refresh token (encrypted since version 1.5.0). No API key, no password in the DSN.
Features
Every side of a client, joined
Devart ODBC Driver for Zoho Invoice keeps client data in related tables, so one query can produce a list of clients with their billing address, main contact person and any refunds issued.
Projects and billable hours
Devart ODBC Driver for Zoho Invoice exposes projects with their billing type and total hours, plus project comments. Devart's sample query joins projects to their comments and sorts them by total hours.
Multi-currency data
Devart ODBC Driver for Zoho Invoice includes a Currency table with code, name, symbol, decimal precision and format for each currency set up in the organization, useful for converting totals in reports.
Write-back for invoicing chores
Devart ODBC Driver for Zoho Invoice supports INSERT, UPDATE and DELETE and batched statements, for jobs such as updating many client records after a change in billing details.
The Currency table in an Excel sheet: USD, INR, CAD, GBP, AUD, ZAR, EUR, JPY and CNY with symbols, precision and number format. The GBP and JPY symbols show as "?" in this capture.
Benefits
- Know who pays late. Invoices and payment dates per client in one pivot table.
- Project profitability at a glance. Total hours next to invoiced amounts shows which projects are underbilled.
- Clean client records. Missing addresses or contact persons are easy to find with a LEFT JOIN.
- Your bookkeeper gets a live sheet. Share a workbook that refreshes rather than a monthly export.
Real-World Uses
- Freelancer income tracker. A consultant keeps an Excel sheet of invoices by client and currency that refreshes before each quarterly tax payment.
- Agency utilisation check. An agency owner compares project hours with fixed-fee billing types in Power BI to spot overruns.
- Statement run prep. An office manager lists clients whose statement e-mail settings are missing before sending month-end statements.
- Client data cleanup. After merging two client lists, an admin fixes duplicate contact persons with SQL updates.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Zoho Invoice suits freelancers, small agencies and service businesses on Windows who invoice through Zoho Invoice and want regular reporting in Excel or Power BI, or who need Invoice data next to time tracking, CRM or accounting records.
It's not for Mac users (Windows only), not for occasional reporting that Zoho Invoice's free reports already cover, and not for companies on Zoho Books, which needs Devart's separate Books driver.
Usage Guide
- Download the trial from the button on this page, sign in with a free Devart account, and install the driver.
- Open the ODBC Data Source Administrator (32-bit or 64-bit, to match Excel or your other tool) and add a DSN using Devart ODBC Driver for Zoho Invoice.
- Activate your trial key on the License tab.
- Choose your Zoho data center, enter the Zoho Invoice Organization ID, click Sign In with Zoho and allow access, then click Test Connection.
- In Excel, use Data > Get Data > From Other Sources > From ODBC and select the DSN; in Power BI, pick ODBC.
Tip
If currency symbols such as £ or ¥ come through as question marks, as they do in one of Devart's own screenshots, set the driver's String Types option to Unicode in the DSN's advanced settings so text columns are returned as wide (Unicode) strings.
Where It Falls Short
- No Mac version. The driver is Windows-only, while many Zoho Invoice users are freelancers on Macs.
- Costs money for a free app. $109.95 a year on top of a free invoicing service needs regular use to be worth it.
- Runs at Zoho API speed. Large invoice histories load slowly and use your organization's API calls.
- Schema discovered by browsing. Devart doesn't publish column lists for the 58 tables.
What Users Say
No reviews of the Zoho Invoice driver itself are published. Devart's ODBC drivers are reviewed as one product on GetApp, Capterra and TrustRadius.
Line-wide ratings
GetApp lists Devart ODBC Drivers at 4.7 out of 5 from 25 reviews, Capterra at 4.7 from 26, and TrustRadius much lower at 5.2 out of 10. GetApp reviewers mostly mention value for money and documentation; the lower TrustRadius scores come from users with heavier workloads.
None of those reviewers wrote about Zoho Invoice, so the ratings tell you about Devart as a vendor (installation, licensing, support) rather than about this driver's tables. The free trial is the honest test.
Comparisons
Zoho Invoice driver vs. Zoho Books driver
Both cost $109.95 a year. The Zoho Invoice driver covers billing (clients, projects, invoices, currencies) for the free Zoho Invoice app; the Zoho Books driver adds the accounting side of Zoho Books, such as bank accounts, taxes and vendor credits.
ODBC driver vs. CSV exports
Zoho Invoice can export data to CSV for free, which is fine a few times a year. Devart ODBC Driver for Zoho Invoice keeps a live connection, so the same report refreshes in seconds every time and can join tables an export keeps apart.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Who can use it |
|---|
| Desktop for Windows | $109.95 | $219.95 | One user at a time on one computer |
| Server Standard for Windows | $799.95 | $1,599.95 | Several users on one server with up to 6 cores, one legal entity |
| Server Enterprise, Site, OEM | Quote | Quote | Any core count, a whole company, or shipping the driver in your own app |
You order any edition from the one Buy Now button. Checkout opens at Desktop for Windows with a 1-year subscription, and offers Server Standard, 2- and 3-year subscriptions and the perpetual license as options on the same page, together with priority support and volume discounts from 5 copies.
FAQs
Is Devart ODBC Driver for Zoho Invoice free like Zoho Invoice?
No. Zoho Invoice is free, but Devart ODBC Driver for Zoho Invoice is a paid product at $109.95 a year or $219.95 perpetual, with a 30-day free trial.
Does the Zoho Invoice ODBC driver include time tracking data?
Devart ODBC Driver for Zoho Invoice exposes projects with fields such as total hours and billing type, plus project comments, so project time totals are available for reports.
Can I switch the driver to Zoho Books later?
No. Devart ODBC Driver for Zoho Invoice connects only to Zoho Invoice. Zoho Books needs Devart's ODBC Driver for Zoho Books, a separate license.
Does the Zoho Invoice driver work from a Mac with Excel?
No. Devart ODBC Driver for Zoho Invoice installs only on 32-bit and 64-bit Windows.
Does a perpetual license include updates?
A perpetual license of Devart ODBC Driver for Zoho Invoice keeps the version you bought working indefinitely and activates offline. Devart delivers new versions and personal support through its subscription, so later upgrades depend on keeping a subscription active.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, incl. Windows Server and Terminal Server
- .NET Framework 4.5 or later
- 32.58 MB installer, one installed version of the driver
- A Zoho Invoice organization and a Zoho user to authorise the connection
- HTTPS access to Zoho, directly or via proxy
Conclusion
Devart ODBC Driver for Zoho Invoice is worth $109.95 a year to freelancers and small firms who report on their billing every month: clients, projects, hours and currencies become live Excel or Power BI data, joined the way Zoho Invoice stores them.
If you only look at your numbers once a year, use Zoho Invoice's free reports and CSV exports instead. And if you're on a Mac, it won't run. Otherwise, the 30-day trial will show quickly whether its 58 tables cover your reports.
Download Free Trial Buy Now