QuickBooks to Airtable integration
Live Export copies your QuickBooks Online customers, invoices, bills, vendors, and items into new Airtable tables, linked to each other. It refreshes on a schedule and writes nothing back.
What you can do with QuickBooks and Airtable
Track collections beside each customer's balance
Copy Customers into a table with each customer's open balance. Add fields of your own for who is following up and what happens next, and the office runs collections in Airtable while QuickBooks stays the record of what's owed. Each run refreshes the balances and leaves your fields as you set them.
Plan the week's payment run by vendor
Copy Bills and Vendors in the same export, and each bill links to its vendor's record in Airtable. A view grouped by vendor and filtered to bills with a balance shows what's due before Friday's payment run, and a bill paid in QuickBooks drops out of it after the next run.
Flag stock that needs reordering
Copy Items, with the quantity on hand QuickBooks keeps for each inventory item. Add a reorder point of your own and a formula that compares the two, and the crew lead orders from one view instead of counting the yard.
Everything it copies
Each card is a QuickBooks table Live Export keeps a copy of in Airtable.
-
Invoices
Into Airtable
-
Payments
Into Airtable
-
Customers
Into Airtable
-
Bills
Into Airtable
-
Bill Payments
Into Airtable
-
Vendors
Into Airtable
-
Items
Into Airtable
-
Accounts
Into Airtable
-
Estimates
Into Airtable
-
Sales Receipts
Into Airtable
-
Credit Memos
Into Airtable
-
Refund Receipts
Into Airtable
-
Purchases
Into Airtable
-
Purchase Orders
Into Airtable
-
Deposits
Into Airtable
-
Journal Entries
Into Airtable
-
Employees
Into Airtable
-
Time Activities
Into Airtable
-
Terms
Into Airtable
-
Payment Methods
Into Airtable
-
Tax Codes
Into Airtable
-
Tax Rates
Into Airtable
-
Company Info
Into Airtable
How to export QuickBooks to Airtable
Step 1: Connect QuickBooks Online
In Whalesync, start a new Live Export. On the Connect step, choose QuickBooks as the source and sign in to Intuit to authorize the company you want to copy. QuickBooks Desktop isn't supported.
Step 2: Connect Airtable
Choose Airtable as the destination, authorize it, and pick the base the copy goes into. Live Export doesn't create bases: it adds a new table for each QuickBooks table you choose, and leaves the base's existing tables alone.
Step 3: Choose the tables, fields, and primary fields
On Choose data, pick the QuickBooks tables and the fields to copy from each. Airtable needs a primary field for every table, so choose one that names the record, such as the customer's display name or the bill's number. Copy the tables a link points to in the same export: Customers for invoices, and Vendors for bills. Otherwise the link field is left out.
Step 4: Activate
Turn on the schedule and pick how often it runs, up to the fastest your plan allows, or leave it off and use Run now. Click Run first export to start.
Step 5: Check the base and build on it
The first run copies the full history of each table, so check that your Airtable plan's record limit per base has room for it. Later runs update changed records, add new ones, and remove deleted ones. Add your own fields beside the copy, such as formulas, rollups, or a status: runs leave them alone, and a formula fills in for new records by itself.
3 ways to connect QuickBooks and Airtable
-
QuickBooks export to Excel
Best when you need a one-time copy of some reports and lists, and can import them into Airtable yourself.
- Built into QuickBooks Online, under Settings, then Export data
- Reports and lists download as Excel files in one .zip (Intuit)
- A snapshot: each update is a new export and a new import
-
Zapier
Best when a QuickBooks event, such as a paid invoice, should add or update one Airtable record.
- Create or Update Record keeps one Airtable record per QuickBooks record
- Update triggers cover only bills, credit memos, customers, estimates, and invoices
- No delete trigger, so a record deleted in QuickBooks stays in Airtable
-
Whalesync
Best when you want several QuickBooks tables in one base, linked to each other and kept current.
- Up to 23 QuickBooks tables, each a new table in your base
- Customers, vendors, and items arrive as linked records
- Fields you add in Airtable keep their values from run to run
QuickBooks export to Excel and Zapier checked against their own pages in November 2026.
Frequently asked questions
How do I connect QuickBooks to Airtable?
Set up a Live Export with QuickBooks Online as the source and an Airtable base as the destination. Pick the tables and fields, choose a primary field for each table, and Whalesync creates the tables in that base and fills them.
How often does the Airtable copy update?
As often as its schedule says: daily, hourly, or every 10 minutes, depending on your plan. Run now starts a run at any time. Each run rereads QuickBooks and writes only the records that changed.
Can I change QuickBooks records from Airtable?
No. Nothing in the base goes back to QuickBooks. If you edit a copied field, the next run puts the QuickBooks value back, but fields you add yourself, such as formulas, notes, or a status, keep what you put in them.
Do invoices link to customers in Airtable?
Yes, when Customers is in the same export: an invoice's customer becomes a linked record. Without the Customers table, that field is left out. Invoice lines, addresses, and tax detail arrive as JSON text in a long text field.
What happens to deleted or inactive records?
A transaction deleted in QuickBooks is removed from Airtable on the next run. QuickBooks doesn't return inactive customers, vendors, or items, so they're left out of the copy, and one you make inactive is removed from it.
Does it work with QuickBooks Desktop?
No, only QuickBooks Online, which you connect by signing in to Intuit. The first run copies the full history of every table you pick, back to the start of the company file.
Other apps to connect
Connect your tools in minutes
