Banner images

How can I locate a missing QuickBooks transaction?

How can I locate a missing QuickBooks transaction?
Aug 02, 2022   |   By admin

It might have happened to you while working on QuickBooks that you found yourself in a situation where while working with the company file, you noticed that you are not able to find the transactions that you had entered previously. This issue is called the “How to find missing transactions in QuickBooks?” problem. QuickBooks users usually face such issues while working on QuickBooks Desktop. These bunch of steps will guide you in finding a missing transaction in QuickBooks Desktop.

How can I find a missing transaction in QuickBooks Desktop?

You might wonder, at times, how to find about the missing transactions in Quickbooks Desktop. To do this, you have to follow a series of steps. These steps are as follows:

Also Read –  QuickBooks Error H101

Step 1: Check the audit trail report.

Checking the audit trail report is the first thing that you would want to do in order to find the missing transaction in QuickBooks. The audit trail report will list each and every transaction in the company file. This also includes the deleted ones. Any earlier modifications made to QuickBooks transactions are also included in the Audit Trail Report. To view the Audit Trail Report, you need to open the Reports menu; after that , select the Accountants and Taxes and then pick the Audit Trail to view the Audit Trail Report.

QuickBooks gives you a platform where the user can manipulate product details, payroll system, and majorly the company information. The audit trail report has some advanced features for displaying the deleted values of the recorded transactions. It is also able to highlight them. Any modification or change in the system gets reflected for specific sections. For instance, in the company file of an organization, the product value can be changed by replacing the old with the new products. These values are highlighted in bold format and, therefore, can be easily made out.

The audit trail report can be accessed in the Reports menu by choosing the accounts and taxes option and then locating the audit trail option. You can also customize the report with the help of the transaction date, type of transaction, and name of the transaction. It allows you to manipulate the data in the format of your choosing. Also, it helps you to modify that easily.

Step 2: Check the company file

You need to check the company file. A company file would have ample amounts of data. In such a scenario, a single transaction is hard to find sometimes. However, the correct information and approach can let us find it. A person who owns different businesses will have multiple company files.

The correct file location can be found by pressing the F2 key. Doing this shows the entire information of the file along with the product information and the software version of the company file that you are using. Once you select the correct company file, you can very easily find and trace the deleted or changed transaction in QuickBooks.

Step 3: Run Condense Information

Condense is a QuickBooks function that helps in deleting data before a cut-off date. When you want to make your company file smaller or for other purposes, you use the Condense option. Pressing F2 returns you to the Product Information window. There, you can check if the condense function has been run or not. You can see a condense information section on the right-hand side.

Condense is known as one of the major and significant features which can help us remove the information from an existing file and decrease the size of the file along with unnecessary financial transactions to a specific date. It eases the process of selecting a specific date range to keep or delete certain data from the file. It is only to make sure that the transaction has been removed during the data condense process. Here, you might want to take the help of experts who can help retrieve the information for you.

Also Read – QuickBooks Error 103

You may find the Condense Information screen on the Product Information screen.

If there is a date of the transaction that is later than the date of the transaction that you are looking for, then there is a high possibility that the transaction was deleted as a result of the condense process. Before going forward, you would want to inquire with your accountant about the condense function and also the reason behind running the condense function.

Step 4: Re-enter Missing Transactions

If the above-mentioned steps have not helped, you might want to re-enter the missing or deleted transaction. This might be your best gamble at this point. If, after looking through the company files, searching the Audit Trail Report, and checking to see if the condense has been run, you have not been able to find the missing transaction, then the only thing you are left with is the re-entering the missing or deleted transaction. The solutions you have employed are all great and can help much in the resolution of the problem. But, if, after following these steps, one is not able to discover the missing transaction in QuickBooks Desktop, then it is very safe to say that the transaction probably was not added to your company file. Because, if that would have been the case, then you must have been able to find it or locate it.

Also Read – QuickBooks Error H202


Following the above-mentioned steps carefully, you can very easily navigate through the “missing transaction in QuickBooks Desktop” problem. However, if you see that you are unable to resolve the issue by yourself, then you should contact our team of QuickBooks professionals who are adept at resolving such issues. They are trained and proficient in analyzing and resolving QuickBooks issues.

After you have exhausted all the available set of options, you can leave the worrying part and let our experts take charge into their own hands. They will carefully look into your problem and find an easy, quick, and reliable solution for you in minutes. They will also suggest alternatives to you should you not be ready to apply those solutions. So, feel free to contact with us. For more, kindly visit our website–> Accountingwhizz or chat with us or send us a mail.
Read Also – QuickBooks Error 15106

Frequently Asked Question

You can follow these easy steps to find a missing transaction in QuickBooks Desktop:
1.) Firstly, you would have to find the audit report
2.) Secondly, you need to examine the company file
3.) Thirdly, you should find the condensed information
4.) Finally, you would have to re-enter the missing transactions

The following steps can help you in recovering a transaction in QuickBooks that has been excluded:
1.) Firstly, you will have to choose the excluded tab
2.) Secondly, you need to select the checkbox for the transaction
3.) Thereafter, select the Undo option. Selecting this will undo all the changes.
4.) Finally, the transaction is sent to the Review tab where you may decide what do you want to do with it

You can reset the transactions in QuickBooks by following steps:
1.) Firstly, go to the Accounts and Settings option by clicking on the gear-like icon
2.) Secondly, select the billing and the transaction tab
3.) Thereafter, click on the Cancel Subscription button
4.) Consequently, follow the steps mentioned on the screen to cancel your account. Should you be using payroll, you must cancel your payroll account too

Here’s how you can manually add transactions to your QuickBooks account:
1.) Firstly, you need to open an account. Thereafter, Go to Bookkeeping and select the Chart of Accounts. Then select the account that you want to review.
2.) Subsequently, add a transaction to the account. Select the Add Journal Entry option. Thereafter, on the top of the list, choose the “Add Deposit” or “Add Cheque drop-down”option.

You need to follow the following steps in order to find and use the Transaction journal:
1.) Firstly, go to the transaction toolbar, select Reports, and then choose the Transaction Journal
2.) Thereafter, access the QuickBooks Reports menu and after that, select the Transaction Journal
3.) For Windows, you need to press on the Ctrl+Y
4.) For Mac, you will have to press the Cmd+T keys

Author Image

We are an independent third party service provider to our customers. We don’t claim to have any such connection with any brand is implied nor should be assumed. All logos and brand images belong to their respective copyright holders and companies.

Get Solution To All Of Your Accounting And Bookkeeping Problems With Industry Leading Experts

Call Now Chat Now

Get solutions to all of your accounting and bookkeeping problems with industry-leading experts.