QBSyncQBSync · MySQL
Sync QuickBooks Desktop into MySQL for your web apps and dashboards
If your website, customer portal or internal tools already run on MySQL, QBSync puts QuickBooks data in the same place — kept current automatically, over an encrypted connection.
Why teams choose MySQL
It is already behind your website
Show customers their invoices and balances in a portal without calling QuickBooks.
Inexpensive to host
Run the database on the hosting you already pay for.
Works with everything
PHP, Node, Python, Metabase, Grafana and most BI tools speak MySQL natively.
Customer balances for a portal
SELECT refnumber AS invoice_no,
txndate AS invoice_date,
duedate,
balanceremaining
FROM qb_invoice
WHERE customer_fullname = ?
AND ispaid = 0
ORDER BY duedate;What you get
Connection
- MySQL 8
- Encrypted (TLS) connection
- Local or hosted server
Data
- 19 QuickBooks record types
- Full Unicode names and addresses
- Header, line and linked-transaction tables
FAQ
Frequently asked questions
Does it work with MariaDB?
QBSync is tested against MySQL 8. If you run MariaDB, try the free demo against your server before licensing.
Is my data encrypted in transit?
Yes. QBSync connects to MySQL over TLS.
More about QBSync
See QBSync with your own data
A Windows utility that copies QuickBooks Desktop lists and transactions — every line item included — into Microsoft SQL Server or MySQL, and keeps them current with incremental, scheduled syncs.