Choosing a Supercondense Cutoff Date for Long-Term QuickBooks Desktop Use

Picking the right supercondense cutoff date balances file-size reduction against retaining enough transaction history for audit trails, comparative reporting, and accountant review.

When a QuickBooks Desktop company file grows large enough to slow daily work, supercondensing removes transactions dated before a chosen cutoff and replaces them with summarized journal entries. The hardest part of that process is not technical execution — it is selecting the cutoff date itself. Push it too far back and the file barely shrinks; push it too far forward and comparative reports, audit trails, and accountant review periods lose their underlying detail. Our engineers have guided many Desktop users through this decision, and the framework below covers the factors that should drive it.

What a Supercondense Actually Removes

The cutoff date determines which transactions are retained in full detail. Every invoice, bill, payment, deposit, and adjustment dated before that boundary is removed from the working file. In its place, the process posts summary journal entries by account, preserving correct opening balances for every balance-sheet account and accurate year-to-date totals for income and expense accounts. What remains after the cutoff is identical in every respect to the original file — individual transactions, reports, drill-downs, and reconciliation status are all intact.

List items — chart of accounts entries, customers, vendors, employees, items — are not automatically removed. They remain in the file even if they have no post-cutoff activity. Optionally, inactive list entries can be cleaned out after the supercondense is complete, but that step requires explicit confirmation for each list type and should only be done once you are confident the condensed file is working correctly.

Factors That Should Drive the Cutoff Date

Statutory and Tax Record-Retention Requirements

The IRS generally expects supporting transaction detail for six years from the date a return is filed, though certain situations extend that period. State requirements vary. Your cutoff date should leave at least that much detail intact in the working file. Keep in mind that supercondensing does not destroy the archived pre-cutoff backup — it only removes those transactions from the active file. As long as the original backup is preserved, you have not lost the data; you have simply moved it out of the file you work in every day.

Comparative Reporting Needs

Many businesses run year-over-year comparisons, rolling twelve-month reports, or multi-year trend analyses. If your cutoff lands in the middle of the period you typically compare, those reports lose their pre-cutoff detail. A practical approach is to align the cutoff with a clean fiscal year boundary — typically the first day of the fiscal year two or three years before the current one. That preserves full detail for recent comparative periods while still removing several years of older transactions.

Accountant Review and Audit Cycles

If your CPA or external auditor reviews two or three prior years during an engagement, the cutoff should leave that window untouched. Coordinate with whoever reviews your books before finalizing the date. An auditor who needs transaction-level detail for a period that has been summarized will have to request the archived backup, which slows the engagement.

Current File Size and Annual Growth Rate

The cutoff date should be aggressive enough to produce a meaningful reduction. Open the file, press F2 or Ctrl+1, and note the file size on the Product Information screen. Compare it to the file size from a year ago if you have an older backup. The difference is your approximate annual growth. A file growing 150–200 MB per year with a current size of 1.2 GB needs a cutoff that removes at least three to four years to bring it into a healthy range and buy enough runway that you will not need to repeat the process annually.

Preparing for the Condense

Before any transactions are removed, create a verified backup of the file in its current state. That backup is your permanent archive of pre-cutoff detail. Store it on redundant media and document the QuickBooks version used to create it. If your file has any damage — verify errors, rebuild failures, or list corruption — have it repaired before supercondensing, since condensing a damaged file can carry existing problems into the summarized entries and make them harder to isolate afterward.

A Practical Starting Point

For most businesses on a calendar fiscal year, a cutoff of January 1 three years prior to the current year is a reasonable starting position. A company in mid-2025 would test January 1, 2022. That preserves three full years of detail plus the current partial year, satisfies most retention and review windows, and typically removes enough transaction volume to produce a noticeable size reduction. Adjust earlier or later based on the factors above, confirm the target file size after a test run, and always retain the pre-cutoff backup as your permanent record.