Connecting QuickBooks Desktop to Apideck

This guide walks you through connecting your QuickBooks Desktop company file to Apideck so your data can sync through Unify. The connection runs through the QuickBooks Web Connector, a small app from Intuit that lives on the same Windows machine as QuickBooks Desktop.

🖥️ You'll need: QuickBooks Desktop installed on a Windows machine, your company file, and access to your Apideck Vault connection. QuickBooks Desktop is Windows-only — the Web Connector cannot run on a Mac.

---

Step 1 — Open QuickBooks Desktop

1. Launch QuickBooks Desktop.
2. Open the company file you want to connect.
3. Leave QuickBooks running — it must stay open during setup and while syncing.

⚠️ Only one company file at a time. Make sure you don't have a second QuickBooks window or a second company file open. The Web Connector refuses to connect if it sees more than one running instance of QuickBooks (see Troubleshooting).

Step 2 — Open the QuickBooks Web Connector

Find it in your Windows Start menu or your QuickBooks program folder, and open it. This is the window that manages the connection and runs the syncs.

Step 3 — Get your connection file from Apideck

1. In Apideck (Unify → QuickBooks Desktop), open the connection and click Test Vault.

2. Copy the Web Connector Password shown — you'll need it in a moment.

3. Click Download apideck.qwc to save the setup file.

   

🔑 Keep the password and the .qwc together. Each time you download a new .qwc, Apideck generates a new matching password. Always use the password and the file from the same download — mixing an old password with a new file (or vice versa) will fail to authorize.

Step 4 — Add the connection in the Web Connector

1. In the Web Connector, click Add an Application.

2. Select the .qwc file you just downloaded.

3. When QuickBooks asks whether to allow access, choose Yes to authorize it.

   

4. Paste the password from Step 3 into the Password field for the new row.

5. Tick the checkbox next to the Apideck application, then click Update Selected to start the first sync.

   

Step 5 — Confirm the sync and save in Apideck

1. In the Web Connector, watch the progress bars reach 100% and the Status column show Last result: Complete.

2. Go back to Apideck Vault and click Save to verify the connection.

   

3. The connection now shows Connected.

   

✅ You're connected. Data now flows between QuickBooks Desktop and Apideck. By default the connection auto-runs every minute, so new records sync on roughly a one-minute cycle.

---

The one rule that matters most: keep the Web Connector open

This is the single most common cause of "it stopped working" — and it's a QuickBooks limitation, not an Apideck bug.

• Don't minimize the Web Connector window. Minimizing stops the automatic sync. The window can sit in the background behind QuickBooks, but it must stay open.
• Don't close it or shut the machine down if you want syncing to continue. If the computer sleeps, logs out, or powers off, the connection stops until the Web Connector is open and running again.

If your data suddenly looks stale or "a few days behind," check this first.

---

What to expect once connected

Sync timing. With auto-run on (the default, every ~1 minute), the connection behaves like it's live — but it's actually syncing on a short cycle in the background. If you create or change something and don't see it reflected instantly, wait about a minute. That delay is normal, not a sign something is broken.

Reading data. When you pull data through the API, large result sets are paginated using a cursor — follow the next cursor in each response to fetch the following page. QuickBooks Desktop does not return a total record count, so meta.total_count won't appear — page until there is no next cursor.

---

Troubleshooting

QuickBooks Desktop error messages are often cryptic and don't say what they actually mean. Here are the ones you're most likely to hit, in plain language.

What you see	What it actually means	How to fix it
QBWC1039 — "not supported while multiple instances of QuickBooks are running"	More than one copy of QuickBooks Desktop is open. The Web Connector only connects when a single instance is running.	Close all QuickBooks windows. If needed, open Task Manager and end any extra QBW32.exe processes. Reopen QuickBooks once with a single company file, then retry Update Selected.
QBWC1039 — "Unique OwnerID/FileID pair value required" (also appears as "index cannot be zero")	An Apideck application is already registered in the Web Connector with the same ID, so it won't add another. Both error messages are the same problem.	Re-downloading the .qwc alone won't fix this. Remove the existing Apideck app from the Web Connector, delete the connection in Apideck Vault, then recreate the connection, download a fresh .qwc + password, and add it again.
Status stuck on "Unauthorized"	The password and the .qwc file don't match.	Re-download the .qwc and copy the new password from the same download. Use them together.
"Last result: Another update in progress"	A previous sync is stuck in a stale state.	Close the Web Connector completely and reopen it, then run Update Selected again.
Sync silently stopped / data looks stale	The Web Connector was minimized, closed, or the machine slept/shut down.	Reopen the Web Connector and leave it running (not minimized). See "The one rule that matters most" above.

💡 The clean-state fix. Most stubborn connection problems clear up if you end with exactly one Apideck application in the Web Connector, paired with one matching password. If you've been retrying and have several Apideck rows piled up, remove them all, delete the connection in Vault, and start fresh with a single clean connection.

---

Getting help

If you run into something not covered here, contact support@apideck.com. For connection or authorization problems, it helps to include the Web Connector log: in the Web Connector, click View Log, scroll to the bottom for the most recent entries, and share those (the log can be very long, and only the latest entries are useful).