Question 1

What QuickBooks data can I load into ClickHouse?

Accepted Answer

Most of the accounting model: accounts, bills and bill payments, budgets, classes, credit memos, customers and customer types, departments, deposits, employees, estimates, invoices, items, journal entries, payments and payment methods, purchases and purchase orders, refund and sales receipts, tax agencies, codes and rates, terms, time activities, transfers, vendors and vendor credits. Reports come too, including general ledger, balance sheet, vendor expenses, customer balance and cash flow.

Question 2

Why does ClickHouse need access to my storage bucket?

Accepted Answer

Because ClickHouse does the reading, not Polytomic. Rows are staged as Parquet in your bucket and then pulled in by the server itself using its storage table function, which means the ClickHouse account needs the external source grant, READ ON S3 for AWS and Google Cloud Storage or READ ON AZURE for Azure, and the server needs network access to that bucket. Polytomic being able to write the files is not sufficient on its own, and this catches people out more than any other setup step.

Question 3

Are voided QuickBooks transactions removed?

Accepted Answer

Yes, for the objects QuickBooks includes in its change tracking feed. The connector reads that feed, treats a deleted status as a real delete, and applies it with a one day overlap and up to a ten day lookback. The row gets a tombstone version by default, or is removed for real if hard deletes are on, which runs a mutation rather than a simple statement. Plain last updated reads do not surface deletions at all, so change tracking is what makes this reliable.

Question 4

Which QuickBooks products are supported?

Accepted Answer

QuickBooks Online editions, Advanced included, because the connector runs on the QuickBooks Online Accounting API. Desktop and Self-Employed are not supported, since a Desktop company file is a local artefact rather than something reachable over that API. Confirm which product your finance team uses before scoping anything, as it is the difference between a straightforward setup and a migration project.

Question 5

Why put accounting data in ClickHouse?

Accepted Answer

Honestly, usually because it is already there for something else. Finance data on its own does not need a columnar engine built for billions of rows. Where it earns its place is joining the ledger to usage or event data to work out which customers are actually profitable at the unit level. ETL into a data warehouse makes that join possible, and if your event store is ClickHouse then the ledger belongs beside it.

Sync Quickbooks to ClickHouse

Sync Quickbooks to ClickHouse with Polytomic

The whole ledger

Server side storage access

Voided entries picked up

Or sync ClickHouse to Quickbooks

Trusted by businesses worldwide

Step-by-step integration guide

Connect Quickbooks in Polytomic

Connect ClickHouse in Polytomic

Create a sync between Quickbooks and ClickHouse

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Quickbooks with ClickHouse?