September 13, 2026
QuickBooks Desktop file too large? It is targets, not megabytes: when to condense, when to start a new file, and when the file is telling you to convert
The short answer: QuickBooks Desktop has no company-file size limit in megabytes, so if the file feels too large the number that matters is the target count, and that number decides whether you condense, start a new file, or convert. Intuit’s own performance article, updated 5 August 2026, says there are no limits on the size of the data file and that slowness usually comes from the network serving it. Its condense-for-import article, updated 18 August 2026, sets the only hard figure: a file must be under 4,000,000 targets to import to QuickBooks Online, and above 750,000 the import may take longer and can produce discrepancies, especially in inventory. This post explains what a target is, how to read yours in thirty seconds, what the Condense Data utility does and does not remove, and the three exits from a file that has grown past its usefulness, whether the destination is QuickBooks Online, Xero or a fresh Desktop file.
Targets, not megabytes
A QuickBooks transaction is stored as a source and its targets. The source is the transaction header; the targets are the lines it posts. An invoice with five item lines carries five targets plus one for the receivable; a bill with three expense lines carries three plus the payable; a payroll cheque can carry dozens. A file with 100,000 transactions can therefore hold anywhere from 300,000 to well over a million targets depending on what the business does, which is why Intuit counts targets rather than transactions or megabytes when it decides what QuickBooks Online will accept. The megabyte figure still matters for day-to-day speed, because a large file across a slow network is what makes the -6000 series and multi-user errors appear, and our -6000 series guide covers that side. For the decision in this post, read the target count.
To find it, open the company file and press F2 (or Ctrl+1) on Windows, or Command+1 on a Mac. The Product Information window opens; in the File Information section, read Total Targets. Note the number and the date, then read it again in three months. The rate of growth tells you how long you have.
The thresholds Intuit publishes
| Target count | What Intuit says | What it means in practice |
|---|---|---|
| Under 750,000 | Imports to QuickBooks Online within the supported path | Condensing is optional; decide on history scope, not on limits |
| 750,000 to 4,000,000 | Import may take longer and can produce data discrepancies, especially for inventory | Condense to reduce risk, or use a managed conversion that does not depend on the import tool |
| Over 4,000,000 | Will not import; condense until below the ceiling | Condense, start a new file, or convert with a reconciled opening position plus scoped history |
Two cautions on the table. The 750,000 figure is a performance and accuracy warning, not a ban, and Intuit’s inventory caveat is the part to take seriously: a large inventory file imported through the free path is where quantity and average-cost differences most often appear. And these numbers have changed before; older third-party guides still quote a 350,000 ceiling. Check Intuit’s article on the day you plan the move.
What the Condense Data utility does, and does not, remove
Condense, under File, Utilities, Condense Data, offers to remove the transactions you select. The path that reduces targets is transactions before a specific date: QuickBooks removes closed transactions on or before that date and replaces them with summary journal entries, by month or by year as you choose, and it will also drop unused list entries you tick. Before it starts it writes an archived copy of the original file into the same folder, and Intuit’s preparation steps are to make a full backup first, verify the file, and repair any data damage through the Tool Hub before condensing; our Verify and Rebuild guide covers what those messages mean.
What condense does not remove is anything still open at the date: unpaid invoices and bills, undeposited funds, unreconciled bank lines, open purchase and sales orders, and any transaction linked to one of them. A file with years of unapplied credits and unreconciled statements condenses far less than its owner expects, which is why the target count sometimes barely moves. Two more limits are in Intuit’s own text. If you track inventory, set the condense date to the last day of a monthly reporting period, because the utility recalculates historical average cost and a mid-month date distorts it. And the summary entries that replace the detail are exactly that: after condensing, a VAT, GST or sales-tax audit for a condensed period is answered from the archived copy, not from the live file, so keep the archive where your retention rules require it. The utility exists for Pro and Premier 2012 and Enterprise 12.0 and newer; Desktop for Mac has its own version.
The three exits
1. Condense and stay
Right when the file is slow, the business is staying on Desktop, and the closed history before a clean year-end is not needed live. Condense at a financial year-end, keep the archive, and re-read the target count a year later. It is the cheapest option and it solves nothing if the growth is in open items.
2. Start a new Desktop file
Intuit’s performance article describes two routes: condense with the option to delete all transactions, which leaves a copy with only the lists, or create a new company and import the lists through IIF, then enter opening balances. Right when the chart of accounts and item list have decayed as much as the transaction volume, and the business wants a clean start on Desktop. The cost is the opening-balance work and losing detail from the live file; the benefit is a file that is small because it is clean, not because it was compressed. If you run Assisted Payroll, Intuit says to check with payroll support before starting a new file.
3. Convert
Right when the size problem arrived alongside the other signs: multi-user errors, a server nobody wants to maintain, or a destination the business already wants for other reasons. A managed conversion to QuickBooks Online or Xero does not run through the free import tool, so the target ceiling does not bind it. Instead the new file opens with a reconciled trial balance, aged receivables and payables at the cutover date, and as many years of transaction detail as you choose to carry, loaded and tied out to the source. That is the condense-plus-history approach: the closed history you would have condensed away is kept in the destination where it can still be queried, and the archive stays for audit. For a file over 750,000 targets with inventory, this is the route that avoids the discrepancies Intuit warns about, and what does not convert sets out the items that are rebuilt rather than moved.
Before you decide
- Read Total Targets from the Product Information window today, and note the count and the date.
- Run Verify Data. A file with data damage should be repaired before it is condensed or converted; both processes copy the damage forward.
- Count open items: unpaid invoices, unpaid bills, unreconciled bank lines. If they run into thousands, condense will disappoint you and a conversion will need a cleanup step first.
- Decide how many years of detail the business needs live. This is the scope question for either route, and it should be answered before any condense date is chosen.
- If inventory is on, pick a month-end for whichever route you take, and print the inventory valuation summary at that date as the reconciliation target.
Send those five answers with a quote request and we will return a fixed price for the conversion route, or tell you plainly that condensing is enough. If the file is slow but the business is staying on Desktop, QuickBooks support covers the repair and hosting side.
Frequently asked questions
Is there a maximum size for a QuickBooks Desktop company file?
Not in megabytes. Intuit’s performance article, updated in August 2026, states there are no limits on the size of the company data file and that performance falls as the file grows, usually because the network cannot serve a large file quickly. The limits that do exist are list limits on Pro and Premier, and the target count used when the file is imported to QuickBooks Online.
What is a target in QuickBooks, and how do I find my count?
A target is a detail line inside a transaction; an invoice with five item lines is one transaction and five targets, plus one more for the receivable. Open the company file, press F2 (or Ctrl+1) on Windows, or Command+1 on Mac, and read Total Targets in the File Information section of the Product Information window. Intuit’s condense article uses this count for QuickBooks Online imports: under 4,000,000 to import at all, and above 750,000 the import may take longer and can produce discrepancies, especially in inventory.
What does the Condense Data utility actually remove?
Closed transactions on or before the date you choose, which it replaces with summary journal entries, and unused list entries you tick. Open transactions after the date, and anything still open at the date, stay. QuickBooks creates an archived copy of the original file before it starts. Intuit’s guidance is to back up first, verify the file and fix any data damage before condensing, and, if you track inventory, to set the condense date to the last day of a monthly reporting period so historical average costs stay accurate.
Should I condense before converting to QuickBooks Online or Xero?
Only if the target count requires it, and only after a full backup. A managed conversion can carry more history than the free import allows because it does not depend on the target ceiling, and it loads a reconciled opening position plus the years of detail you scope. Condensing first throws away detail that a conversion could have kept, so decide the history scope before you decide whether to condense.
Related service: QuickBooks Desktop → Online · QuickBooks → Xero · QuickBooks support