Splitting a QuickBooks Desktop Company File by Date: Pre-Repair, Cutoff, and

A damaged QuickBooks file must be repaired before a date-based split; this guide covers pre-repair, cutoff selection, opening-balance reconciliation, and re-entering removed transactions.

Splitting a QuickBooks Desktop company file at a specific date — keeping only transactions from a chosen cutoff forward — is a proven way to reduce file size, improve performance, and keep legacy data manageable. But the split will fail, or produce unreliable opening balances, if the source file carries structural damage. Our engineers follow a strict sequence: repair first, choose the cutoff carefully, split, then reconcile and re-enter. Skipping the repair phase is the most common reason splits produce files that cannot pass verification or tie to an audited trial balance.

Phase 1: Pre-Split File Assessment

Before any split work begins, we need a clear picture of the file's current health and contents. Gather the following from the Product Information screen (press F2 with the file open): file size, list counts (customers, vendors, employees), transaction target count, and the date of the earliest transaction in the file. Run Verify Data from the File → Utilities menu. If Verify returns no errors, the file is a candidate for a direct split. If Verify reports errors — particularly target chaining errors, list damage, or transaction-link corruption — the file must be repaired before proceeding. Attempting a split on a damaged file will either fail outright or carry corrupted records into the new working file, defeating the purpose of the operation.

Phase 2: Mandatory File Repair

When Verify identifies damage, repair the company file before scheduling the split. Run Rebuild Data first; in many cases it resolves minor structural issues. If Rebuild does not clear the errors, a deeper repair is required. During a deep repair, our engineers may need to remove specific damaged transactions — typically bills, invoices, or payments whose internal links are broken beyond reconstruction. Every removed transaction is documented in a deletion report so nothing is lost silently. The file must pass a clean Verify with zero errors before it is approved for splitting. This is the gate: no clean Verify, no split.

Phase 3: Cutoff Date Selection

The cutoff date determines which transactions remain in the new working file and which are summarized as opening balances. Choose a date that aligns with a natural accounting boundary — a fiscal year-end, a quarter-end, or an audited period close. Provide the desired cutoff to the engineer performing the split, and confirm it in writing. If the business has an audited trial balance for the period ending on or just before the cutoff, gather that document now. It will be essential in Phase 5. Also note whether the file uses multi-currency, as currency data adds complexity to the balance-forward calculations.

Phase 4: Performing the Split

With a repaired, verified file and a confirmed cutoff date, the split is performed. The process creates a new company file containing only transactions dated on or after the cutoff. All prior activity is collapsed into opening balances for every account — balance sheet accounts carry forward their net balances, and income and expense accounts begin at zero. The original file remains intact as a historical archive. Once the split completes, run Verify Data on the new file to confirm structural integrity. If the new file does not pass Verify, roll back to the pre-split repaired file and re-evaluate before trying again.

Phase 5: Opening Balance Reconciliation

This is the phase where accuracy is confirmed or problems surface. Export a trial balance from the new file as of the cutoff date and compare it line by line against the auditor's trial balance (or the internal trial balance from the original file). Most balance sheet accounts should match. Discrepancies can arise from transactions that were removed during Phase 2 repair, from rounding in multi-currency files, or from accounts that had unusual linking issues in the historical data. Provide the auditor's trial balance to the engineer for review; adjustments can be made via journal entry to bring the new file's opening balances into exact alignment. Document every adjusting entry for the audit trail.

Phase 6: Re-Entering Removed Transactions

Using the deletion report generated during Phase 2 repair, re-enter each removed transaction into the new file from paper records, PDF copies, or a backup predating the damage. Enter these transactions with their original dates so historical reporting remains accurate. After re-entry, run Verify Data one final time. A clean outcome is a new working file that passes Verify, ties to the trial balance at the cutoff date, and contains all legitimate transactions from the cutoff forward — with the original file preserved as a read-only archive.