Problems we fix
Can we start a new QuickBooks file and keep our history?
Your accountant says the file is too big and the cleanest fix is a new company file at year end, with opening balances. It sounds simple until you think about Monday morning: open orders to re-key, customers whose buying history is gone, and every report starting from zero.
What is actually happening
The year-end restart is common advice because it is simple. Create a new company file. Bring the lists across. Enter the opening trial balance. Enter open invoices and bills so the agings work. Set inventory quantities with an adjustment. Re-enter open sales orders, purchase orders and estimates by hand.
QuickBooks' own routes into a new file carry lists and settings only. You can export lists from the old file and import them, or run Condense on a copy with the option to remove all transactions. Either way, no transactions come over, and no attachments.
What the business loses is everything that sits in transactions. Sales by item and by customer start at zero, and last year's numbers live in another file. Average cost restarts from a single adjustment. Open orders are re-keyed, often as totals rather than lines. An open invoice entered as a single opening line loses its original items and any partial payments. A customer who calls about an order from last spring sends someone to the old file.
Owners refuse because they run the business on that history. The history is not the problem. The problem is that one file holds all of it at once.
What people try first, and what it costs them
The year-end restart. Small and clean, at the cost of your history reports and days of re-keying open documents by hand.
A summary conversion. Someone else builds the new file with lists and opening balances. Less work for your team, the same result: history stays behind, and open orders often arrive as dollar totals with a placeholder line instead of your items.
Condense. QuickBooks' attempt to keep detail after a date and summarize before it, inside the same file. On an old file it is error-prone and fails or stalls again and again. When it finishes, item and reconciliation reports for the earlier years go blank, and the file is rarely much smaller.
Moving to another system. A new chart of accounts, every integration rebuilt, a year of your team's time, and the QuickBooks history usually left behind anyway.
Living with it. No project, no cost up front, and a file that gets slower every month.
What a line-by-line rebuild does instead
A rebuild starts a new company file without starting over. You choose a cutover date, usually the first day of your last fiscal year. We build a fresh QuickBooks Desktop file: every list and item, the opening position at the cutover date, then every transaction since, line by line, and every open order with its real items, quantities and rates. Everything before the cutover stays in your current file, which becomes the retired file, read-only and untouched.
The opening position is built at document level, not as one line per account. Open invoices and bills come over one by one, each carrying what is actually still owed on it. We check each open invoice's balance against your file, not only each customer's total, because a customer total can tie while individual invoices are wrong. Inventory opens by item and by site, with average cost.
From the cutover forward, your reports work on day one: sales by item, customer and rep, agings, inventory history. Open sales orders and purchase orders are checked against your file's own open-order reports, because open orders move no money and no financial check can see them.
You see a scorecard comparing the two files at each tier before the final payment.
Check your own file first
- Run Open Sales Orders by Customer and the Open Purchase Orders report, and note how many documents and dollars your team would otherwise re-key.
- Run A/R Aging Detail and count the open invoices that have been partly paid; each one needs its true remaining balance in a new file.
- Ask your team which reports they run that reach back more than a year, and how far back they go.
- Run Sales by Item Summary for last year and this year side by side; that is the comparison a restart at year end takes away.
- Open the Memorized Report List and note the reports your team actually runs; each has to be moved to any new file.
Tell us about your file.
A few facts about your file tell us which plan it fits. Every rebuild starts with the $995 File Assessment, done on a copy and credited in full to the rebuild.