Finding QuickBooks Desktop Transactions Entered in the Wrong Company File
A batch of entries that seems to have vanished from QuickBooks Desktop is rarely gone for good; this guide shows how to trace where they went.
QuickBooks Desktop rarely loses transactions that were saved. When a batch of entries seems to have vanished, the usual cause is that it was keyed into a different company file than the one now open. Two similar files on one machine is the classic setup. Our engineers trace this constantly, and the check below usually finds the entries.
Before you start, make a fresh backup of the live file and switch to single-user mode. Nothing in this check changes data, but the backup costs a minute and removes all doubt.
Confirm which file is actually open
Press F2 to open the Product Information window. The File field names the company file receiving every entry you make, and the Location field shows its folder. Read both before trusting any search. The title bar shows the company name, which does not always match the file name. Note these details; you will compare every candidate against them.
QuickBooks reopens the last file used at startup. If someone opened an old copy or a restored backup yesterday, everything keyed since then went there. That is the most common answer to a missing week of work.
Work through the Open Previous Company list
Open the File menu and hover over Open Previous Company. The submenu lists the company files opened recently on that machine. Compare each name against the file from the F2 window. Near-identical names deserve the closest look.
Check one candidate at a time:
- Open the file, press F2, and note its name and folder.
- Run the searches described next.
- Close it, cross it off, and move to the next name.
Search by entry date, not transaction date
Entries keyed in a hurry often carry the wrong transaction date, so search on when they were entered. Two searches cover it:
- Press Ctrl+F to open Find, choose the Advanced tab, and select the Entered/Modified filter. Set the range to the days the work was done and run it.
- Open the Audit Trail report under Reports, then Accountant and Taxes, and set the same dates. It lists every entry with the user who keyed it, including voided and deleted transactions.
A QuickReport on the bank account for the period works as a third check. If a candidate shows nothing on those dates, it is clean.
Restore recent backups away from the live file
If no open file holds the entries, the data may sit in a backup or a stray copy. Restoring a backup creates a new working file; it cannot touch the live one unless you aim it there. Keep it aimed elsewhere.
- Choose File, then Open or Restore Company, then Restore a backup copy, and pick Local backup.
- Browse to the backup file. If you do not know where backups are written, open the backup options dialog and read the folder shown there.
- When asked where to save, pick a folder away from the live file and give the restored copy a clearly different name.
- Open the restored copy and run the same two searches.
Never restore over the live file. While hunting, note any portable files or second copies in the working folder; those are candidates too.
How do you know you have found the entries?
You have your answer when one file's audit trail shows the entries keyed on the right dates by the right user, with payees and amounts matching what went missing. From there, two clean paths exist. For a handful of entries, back up both files, then void or delete the entries in the wrong file and re-enter them in the right one. For a larger set, the two files can be merged. QuickBooks Desktop has no merge command of its own; that is work our engineers do, matching lists by name and carrying the history across. See our QuickBooks company file merge service for how it runs.
When this check cannot reach the data
This method cannot find a file that no longer exists. If every candidate and every backup comes up empty, the entries may live in a deleted file, an overwritten backup, or a copy on another machine. Recovery then depends on the transaction log beside the file or the machine's own backups, which is emergency QuickBooks data recovery territory rather than a desktop procedure. One more trap deserves mention: if the wrong file was later condensed, entries before the cutoff were summarized into opening balances, and the detail may not be recoverable from that file at all.
Keeping it from happening again
Give each company file an unmistakable name, and keep old copies and restored backups out of the working folder. Before the first entry of a session, press F2 and read the file name. Ten seconds there prevents the entire hunt.