QuickBooks Super Condense Service — Canadian Files Supported

When a QuickBooks file has accumulated years of detail, Super Condense reduces its size dramatically while keeping every balance accurate. Best of all, it works on Canadian editions — something Intuit's own Condense Data utility cannot do.

Overview

Super Condense is a database-level rebuild of your QuickBooks company file that removes historical transaction detail prior to a cutoff date while preserving summary balances, list data, and all transactions after the cutoff. The result is a file that behaves identically for day-to-day use but is a fraction of the original size, with full reporting capability for the current and prior fiscal year intact.

Canadian QuickBooks files cannot use Intuit's built-in Condense Data utility. The utility either fails silently, corrupts payroll data, or refuses to run on the Canadian edition. This has been a long-standing limitation that leaves Canadian businesses with no first-party way to shrink bloated files. Super Condense fills that gap with a database-layer process that respects Canadian-specific structures (GST/HST tax codes, bilingual records, CRA reporting period boundaries, and the Canadian Payroll add-on schema).

What is preserved: full chart of accounts, all lists (customers, vendors, items, employees), all transactions after the cutoff date, opening balances that correctly reflect the condensed period, templates, memorized reports, and preferences. What is removed: transaction-level detail before the cutoff date, which is replaced by a single opening balance journal entry per account. The visual effect is that historical reports for periods after the cutoff continue to look exactly as they did before, while reports for periods before the cutoff show summary opening balances rather than line-item detail.

File size reductions of 50–80% are typical for files with several years of history. Combined with Audit Trail Removal, reductions of 90%+ are possible on very old files. The most dramatic reductions are seen on retail and point-of-sale files (which have very high transaction volume in early years) and on files that have been carried through multiple QuickBooks version upgrades without ever being maintained.

The right cutoff date for most businesses is the start of the second-prior fiscal year — far enough back that you no longer reference line-item detail in day-to-day work, but recent enough that you still have full prior-year comparatives in the file. We will help you choose the cutoff during the engagement; many customers pick a date and then ask us to run a dry-run analysis to see what the resulting file size would be before committing.

Super Condense is a one-way operation. The transaction detail before the cutoff is collapsed into opening balances and cannot be reconstructed from the condensed file. We always recommend keeping a full backup of the source file in long-term storage so that the historical detail remains available for audit, legal-discovery, or simple curiosity reasons. Most customers keep the source backup on offline media (USB or external drive) rather than active storage, since they will not need to open it day-to-day. We can also produce a read-only "archive copy" of the source file alongside the condensed file as part of the engagement if you want a guaranteed long-term reference copy that is clearly labelled as historical-only.

Why NexFortis

Works on Canadian editions

The only practical way to condense Canadian QuickBooks files, including files using the Canadian Payroll add-on. Intuit's own utility refuses to run on these.

Massive size reduction

50–80% smaller is typical; 90%+ when combined with audit trail removal on long-running files.

Balances stay accurate

Opening balances are generated so every account ties back to the pre-condense totals on the cutoff date. Trial balance comparisons ship with the file.

Recent detail intact

All transactions after your chosen cutoff date remain at full detail, so current-year and prior-year comparative reporting are unaffected.

How it works

  1. Choose a cutoff date

    Pick a date before which transaction detail can be summarized. Most customers choose the start of the second-prior fiscal year so prior-year comparatives stay intact.

  2. Back up and upload

    Create a .QBM and upload it to NexFortis over a 256-bit encrypted connection. Your original file stays untouched on your computer.

  3. NexFortis condenses

    We rebuild the file at the database level, summarize pre-cutoff detail into opening balances, and validate totals against your original on a per-account basis.

  4. Download the condensed file

    You receive a much smaller .QBM that restores into your existing QuickBooks version, plus a before/after size and balance comparison report.

Frequently asked questions

Intuit's built-in Condense Data utility does not support Canadian editions. It either fails outright, corrupts payroll data, or refuses to run when it detects the Canadian edition header. This is a long-standing product limitation and Intuit has not signalled plans to address it. Super Condense is a database-level alternative that works on Canadian files without touching payroll integrity.