Preparing a QuickBooks Desktop company file for sale due diligence

A buyer's accountants will pull your QuickBooks file apart in diligence; here is how we prepare, lock, and hand over a copy they can trust.

A business sale turns your accounting file into evidence. The buyer's accountants will open it, sample transactions, rerun reports, and tie what they find back to the deal numbers. We prepare QuickBooks Desktop files for this window, and the sequence rarely changes. Prove the file is healthy, clean what the buyer will read, close the periods, cut a restricted copy, and end with one administrator and a tested backup.

Start with the health of the file

Run Verify Data (File > Utilities) on a working copy before anything else. If Verify reports damage, run Rebuild, then Verify again. Do not set closing dates or cut buyer copies from a damaged file; the errors resurface later as reports that will not foot, and you will be explaining discrepancies to strangers under deadline.

Keep the .qbw file and its .tlg transaction log together while you work. And work only on copies: leave the live file untouched until the deal closes, and take a dated backup before each phase below. A phase that goes wrong then rolls back to the previous backup instead of turning into improvisation.

If Rebuild cannot clear the damage, stop and repair first. We fix files that fail QuickBooks Verify or Rebuild at this stage often; an hour of repair beats a week of explanations.

Which lists need attention first?

Buyer accountants read lists the way auditors do. Merge duplicate customers, vendors, and chart of accounts entries; QuickBooks merges two same-type names when you rename one to match the other. Mark finished items inactive rather than deleted, since deletion is blocked once transactions exist.

Then reconcile everything: bank, credit card, loan, and payroll liability accounts through the final month before handover. Chase undeposited funds, stale uncleared checks, and negative inventory balances. A buyer's team will find all three, and each becomes a question in the data room. Finally, tie the trial balance to the last filed return and document any difference. Books that stand up to this are built on disciplined month-end close work, which we cover in our bookkeeping practice notes.

Lock the closed years before anyone asks for changes

Set the closing date once reconciliations and year-end adjustments are final. The setting sits under the Company menu, or in Edit > Preferences > Accounting on the Company Preferences tab, and it takes a password. From then on, QuickBooks warns any user who tries to edit a transaction dated on or before the closing date, and only the password holder can let the change through.

Run the Closing Date Exception Report afterward. It lists every attempt to touch a closed period, and it is the record you want when a buyer asks whether prior years moved after they were issued.

Choose the date deliberately. Many sellers close through the last complete fiscal year and leave the current year open for ordinary trading while the deal runs.

Should the buyer see the full file?

Often not. A period copy limits a company file to a date range, so the buyer reviews the three or four years that matter instead of inheriting a decade of history. In the Premier Accountant and Enterprise Accountant editions the option sits under File > Create Copy. Enter start and end dates, and QuickBooks builds the restricted file with opening balances carried forward.

Other Desktop editions have no period copy option. We build date-limited period copies for those versions, and for sellers who want the copy checked before it reaches the data room.

Leave the audit trail switched on in anything the buyer receives; it is the difference between answering questions and proving answers. And send a portable company file (.qbm) or backup (.qbb) rather than the .qbw itself, since both travel as a single file and restore cleanly on another machine.

Who still has access on closing day?

Open Users and Roles (Company menu; older releases call it Set Up Users) and write down every login before changing anything. Remove standard users one by one until a single administrator remains. Change that administrator's password and pass it through the deal's lawyers rather than by email.

If the file lives on a server for multi-user work, agree with the buyer who keeps the server, the license, and the backup schedule. Confirm the final backup restores on a machine outside your network before handover day; a backup that has never been restored is a hope, not a backup.

What does a clean handover look like?

• Verify passes on the working copy and on the restored buyer copy.
• The balance sheet stands in balance on both accrual and cash basis.
• The closing date and password are set, and the Closing Date Exception Report is empty.
• The buyer's date-limited copy opens on their QuickBooks release and its reports match yours to the cent.
• The user list shows one administrator, and the final backup has been restored and checked.

Clear every line before the diligence window opens. A file that passes those checks lets the buyer's accountants move fast, and speed in diligence is worth more than any paragraph in the purchase agreement.