QuickBooks Optimization, Condense and File Repair · Canada
Your QuickBooks file is not broken. It is too big, and it is costing your team an hour a day.
Slow multi-user sessions, a company file that will not stop growing, Verify and Rebuild failing on a loop, reports that time out before they tie out. These are not separate faults. They are the same file problem showing up in different places. We condense, merge, reduce and repair QuickBooks company files with no loss of transaction detail, and we tell you in writing what is out of scope before we start.
15,000+ migrations completed. 90+ source platforms. Client data processed in Canada.
Symptoms
The symptoms that bring people here
If two or more of these describe your file, the problem is the file itself.
Everything is slow in multi-user mode
One user is fine. Four users and the file crawls. The usual cause is file size and list bloat rather than your network, and swapping the server rarely fixes it.
The file will not stop growing
A company file that grows every month without a matching growth in transactions is carrying audit trail, TLG and list overhead you do not need to keep in the live file.
You are near the 14,500 name limit
QuickBooks Pro and Premier cap the combined customer, vendor, employee and other-name lists at 14,500. Hitting it stops you adding customers, which stops you invoicing.
Verify and Rebuild keep failing
Running Rebuild repeatedly on a damaged file can make things worse. Repeated failure is a signal to stop and get the file looked at, not to run it again.
Reports time out or do not tie out
Reports that hang, or a balance sheet that will not agree to your own trial balance, usually point at damaged links inside the file rather than at how the report is built.
You are running several company files
Separate files per entity or per year mean consolidated reporting is done by hand in Excel every month. Merging them removes that job permanently.
The four jobs we do most
What we actually do to the file
Super Condense
Goes further than the condense built into QuickBooks, which frequently removes far less than people expect. Reduces file size and restores speed while your closed-period detail is preserved in an archive copy you keep.
List reduction
Merges and retires duplicate and dormant names to pull you back under the 14,500 ceiling so you can add customers again. Active names, balances and history stay where they are.
File repair and recovery
For files that fail Verify Data, throw error codes, or will not open at all. We work from a copy, identify what is damaged, and rebuild the structure without inventing transactions to fill gaps.
File merge
Combines multiple company files into one, so consolidated reporting stops being a monthly Excel exercise. Common for organizations that grew by acquisition or split files by year.
Process
How an optimization job runs
Four steps. You approve the scope and the exclusions in writing before anyone touches anything.
Free health check
You send a copy of the file. We report its actual size, list counts against the limits, audit trail and TLG overhead, and whether it passes Verify. No charge and no obligation. If the file is healthy we tell you that and you keep the report.
Fixed scope and fixed price
A written scope naming what we will do, what the file will look like afterwards, and what is not coming across. Priced as a fixed fee in Canadian dollars, not an hourly estimate that drifts.
We work on a copy
Your live file stays in use. Your team keeps invoicing and processing payroll while we work. There is no multi-day shutdown and no weekend cutover unless you specifically want one.
Verify and hand back
The returned file passes Verify Data. We reconcile balances against your originals and walk you through the archive copy so you know exactly where your closed-period detail lives.
Full list
Complete list of QuickBooks optimization services
Repair and recovery
- QuickBooks Data Recovery
- QuickBooks File Repair
- QuickBooks Corruption Fixes
- QuickBooks Error Repairs (Pro, Premier, Enterprise)
- QuickBooks Multiple Currency Removal
- QuickBooks for Mac Data Recovery
- QuickBooks Password Recovery
- QuickBooks Error Code Repairs
- QuickBooks Negative Quantity on Hand Repair
- QuickBooks Rebuild
Optimization and cleanup
- QuickBooks File Optimization
- QuickBooks File Condense
- QuickBooks Super Condense
- QuickBooks List Reduction
- QuickBooks Cleanup
- QuickBooks File Size Reduce
- QuickBooks Archiving
- QuickBooks File Merge
- QuickBooks TLG Recovery
- QuickBooks Verification Service
Reference
What each service changes, and what it leaves alone
Super Condense
Fixes: oversized company files and the slowdown that comes with them.
Stays intact: your chart of accounts, your open transactions, your current-year detail, and a full archive copy of everything removed.
List reduction
Fixes: hitting the 14,500 combined name limit on Pro and Premier.
Stays intact: active customers and vendors, all balances, and transaction history against merged names.
File repair
Fixes: Verify Data failures, error codes, files that will not open.
Stays intact: every transaction we can recover, with a written list of anything we cannot.
File merge
Fixes: consolidated reporting done by hand across several company files.
Stays intact: per-entity reporting through classes or locations, so you do not lose the split you had.
Canadian specifics
What Canadian files need that the generic advice misses
GST and HST history is not optional
A condense that quietly drops filed sales tax detail is a problem the first time you are reviewed. We keep your filed period detail intact and tell you exactly where it sits after the job.
Multi-currency files behave differently
CAD and USD books with realised and unrealised exchange gains carry extra structure. Removing multi-currency is possible but changes historical reporting, so we quantify what shifts before you agree to it.
Payroll history and CRA remittances
Payroll detail and remittance history are the parts clients most often assume will survive and most often ask about afterwards. It is named explicitly in the scope, either way.
Client data processed in Canada
The same commitment that governs our migration work. Your company file does not leave Canadian processing to be worked on.
If optimization is not the answer
Sometimes the file is not the problem. The platform is.
If you are at the ceiling of what QuickBooks Desktop can hold, condensing buys you months, not years. We will say so during the health check rather than sell you a condense every year.
QuickBooks Desktop to QuickBooks Online
The move most Canadian clients are now making, with Intuit having stopped new Pro, Premier and Payroll subscriptions in Canada in April 2025.
QuickBooks Enterprise to QuickBooks Online
Enterprise is still sold in Canada, so this is a choice rather than a forced move. We help you make it on the numbers.
Enterprise and multi-entity
When your finance stack spans entities, provinces and currencies, a migration is not a file transfer.
For accounting firms
Refer the file work, keep the client
You stay the adviser
We do not sell your client accounting services, tax work or advisory. We fix the file and hand it back. Firms refer optimization work to us precisely because we are not competing for the relationship.
Two ways to work together
Refer the client and stay informed, or engage us under your firm and present the work as yours. Both are set up in advance so the client experience is deliberate rather than improvised.
Questions
QuickBooks optimization FAQ
Will I lose any history when you condense my file?
Not from your records. A condense removes closed-period transaction detail from the live working file and preserves it in an archive copy that you keep. Summary journal entries hold the balances so your reports still tie out. What you lose is the ability to drill into individual closed-period transactions inside the live file, which is why the archive copy matters and why we walk you through it on handback.
How large is too large for a QuickBooks company file?
There is no single number, and anyone who gives you one is guessing. What matters is size relative to your hardware, your user count and your list counts. Files that feel slow in multi-user mode are usually the first real signal. The free health check gives you your actual numbers instead of a rule of thumb.
What is the 14,500 limit and does it apply to me?
QuickBooks Pro and Premier cap the combined total of customers, vendors, employees and other names at 14,500. It is a hard stop: at the limit you cannot add a new customer, which means you cannot invoice them. Enterprise raises the ceiling substantially. If you are within a few hundred names, list reduction is urgent rather than optional.
Can you fix a file that fails Verify Data?
Usually. Repeated Rebuild attempts on a damaged file can compound the damage, so the right move is to stop running it and send us a copy. We identify what is structurally damaged and repair it, and we give you a written list of anything that cannot be recovered rather than inventing transactions to fill the gap.
Do we have to stop working while you have the file?
No. We work on a copy and your live file stays in use throughout. Your team keeps invoicing and running payroll. There is a short cutover at the end when you switch to the optimized file, measured in minutes for most clients.
How do you price this?
Fixed fee in Canadian dollars, quoted after the free health check, because the price depends on file size, damage and how much list work is involved. You get the scope and the number in writing before any work starts. We do not quote hourly for this because a drifting estimate is the client problem we are usually hired to clean up.
Do you work on QuickBooks for Mac and QuickBooks Online?
QuickBooks for Mac, yes, including data recovery. QuickBooks Online is different: because Intuit hosts the file, most condense and repair work does not apply. If your QuickBooks Online company is slow or unwieldy, the issue is usually list hygiene or data structure, and we will tell you honestly whether there is anything worth paying us for.
We are a Canadian company with GST and HST filed through QuickBooks. Is that at risk?
No, and it is the first thing we check. Filed sales tax detail is preserved and its location after the job is named in the scope document. If a particular request would compromise it, we tell you before you agree rather than after.
Free Health Check
Book a discovery call
Send us a copy of the file and we will report its real size, list counts, overhead and Verify status at no charge. If it is healthy, we will tell you that and you keep the report.
