Data Recovery & Backups
Recovering Lost Transactions from a QuickBooks .TLG File
When the company file is damaged and the backup is old, the transaction log can help recover recent work — if paired correctly with a base file.
Community Issues
Problems, outages, and quirks that QuickBooks users are reporting — tracked and explained by the desk.
File Size & Performance
Removing the QuickBooks Audit Trail to Shrink a Bloated Company File
The QuickBooks audit trail can be removed to reduce file size, but the trade-offs are significant. Here is what to know before you proceed.
Data Import & Migration
Understanding IIF Import for Lists and Transactions in QuickBooks Desktop
Learn how IIF files move lists and simple entries into QuickBooks Desktop, where the process can fail, and what alternatives give a more complete migration.
Company Files
Understanding QuickBooks Company Files and Their Companion Extensions
Learn what the .QBW, .TLG, .ND, .ADR and .QBB files do, which hold your live data, and how to keep them safe for recovery.
Conversion & Migration
What Actually Converts When You Move from QuickBooks Desktop to Online
QuickBooks Desktop-to-Online migration moves most lists and history, but reconciliation data, templates, payroll, and some transaction types don't survive the trip. Here's what to expect.
Developer & API
Building a Single Integration for QuickBooks Online and Desktop
Developers needing one integration for both QuickBooks Online and Desktop face a historical challenge: the two products have never shared a single current API.
Web Connector & API
Calculating Customer Balances Through the QuickBooks Web Connector
Developers building customer-facing balance tools with the QuickBooks Web Connector often discover that reconstructing balances from individual transactions is harder than expected.
Data Import & Integration
Getting Web Form Data Into QuickBooks: Your Integration Options
QuickBooks locks its database behind encryption, but several pathways exist for importing external data like web form submissions into the company file.
Data Import & Export
Importing Web Data Into QuickBooks: Why IIF Is the Wrong Answer
Developers moving data from web-based systems into QuickBooks should avoid the deprecated IIF format and use the SDK instead.
Integration & API
Passing Live QuickBooks COM Objects Between PowerShell Sessions
Users replacing legacy QuickBooks plug-ins with PowerShell scripts lose their COM object connection when each session exits, blocking multi-request workflows.
Reporting & ODBC
QODBC Linked Table Queries Run Slow Against QuickBooks
Queries that return instantly from a local MS Access table can take fifteen minutes or more when run through a QODBC linked table. Here is what causes the gap and what helps.
Errors
QuickBooks "Connect to Intuit" Button Keeps Control in Pop-Up Window
Developers implementing the Intuit connect button find the OAuth flow stays inside the pop-up instead of returning control to the parent page — by design.
Developer & Integration Errors
QuickBooks Desktop "Error Parsing XML Text Stream" on BillQuery Requests
Developers integrating with QuickBooks Desktop encounter an XML parsing error when BillQuery filters are placed at the wrong nesting level instead of inside the proper container element.
Errors
QuickBooks Desktop Error 0x80040400: XML Parsing Failures in Item Requests
QuickBooks Desktop rejects malformed data requests with error 0x80040400 when field tags are mismatched, a problem traceable to the underlying XML structure.
API & Integrations
QuickBooks Online API Access Without Browser-Based OAuth Each Time
QuickBooks Online's API supports fully unattended server-side data queries after an initial one-time OAuth connection, though developers frequently misunderstand the credential flow.
API & Integrations
QuickBooks Online API Access Without End-User Login: How Server-to-Server OAuth Works
Developers building customer-facing integrations with QuickBooks Online can use server-to-server OAuth to access company data without requiring customers to log in to QuickBooks.
API & Integration
QuickBooks Online API: Backend Invoice Generation Without Customer-Facing OAuth
Developers building server-side order systems can connect to QuickBooks Online once using OAuth, then generate invoices automatically with no customer involvement.
API & Integration
QuickBooks Online India Integration: Why Website Data Fetching Hits a Wall
Developers connecting PHP websites to QuickBooks Online India face a major roadblock — non-US versions lack official API integration support.
API & Integration
QuickBooks Online Integration: The Legacy QBOE Gateway Problem Developers Hit
Developers connecting custom applications to QuickBooks Online encounter a deprecated SDK workflow that no longer functions under Intuit's current API framework.
Errors
QuickBooks QBW32.exe Stays Running After SDK Session Ends
Third-party apps connecting via the QuickBooks SDK can leave QBW32.exe running in the background on QuickBooks Desktop 2015 and earlier, blocking users from launching the program normally.
Developer & Integration
QuickBooks Sales Orders Don't Have "Columns" — Understanding the XML Data Model
Developers integrating with QuickBooks via QBXML often ask how to retrieve column names from Sales Orders, but QuickBooks uses XML, not SQL tables.
Errors
QuickBooks SDK "Different Company File" Error Explained
When a third-party app connects to QuickBooks via the SDK, a mismatch between the requested file and the open file triggers a specific access error. Here is what causes it and how developers handle it.
Data Export & Encoding
QuickBooks SDK Exports Mismatch En-Dash Characters From Native Reports
QuickBooks stores special characters like en-dashes in Windows-1252 encoding, but the SDK can misinterpret those bytes as Unicode, breaking data joins.
Web Connector & Integrations
QuickBooks Web Connector Bottlenecks When Servicing Multiple Sync Clients
QuickBooks Desktop Web Connector integrations built on Node.js can stall when multiple clients connect, but an asynchronous pattern resolves the contention.