Duplicate transactions in QuickBooks have been evolving as a major and recurring issue among accountants. The double entry issue can be caused due to different reasons in QuickBooks. The article encloses the various causes and fixes to resolve duplicate transactions in QuickBooks desktop.
What causes Duplicate Transactions in QuickBooks (Double Entry error)?
- Importing transactions and listings into the company file may result in double entry in QuickBooks. It’s possible that third-party software is used to carry out the importation.
- The “Rebuild Data Utility in QuickBooks” might occasionally be the root of double transactions. The Utility tries to recover transactions that can’t be recovered at this point.
- Duplicate clients may be entered if certain information in the Point of Sale system is ignored. If a customer record is entered incorrectly or without a middle name and the customer already exists, a duplicate transaction results.
- Manually entered transactions in QuickBooks may result in duplicate transactions.
Steps to Check Duplicate Transactions in QuickBooks
- Advance to “Bank Account’s” and then take a leap to “Chart of Accounts”.
- The next step is “selecting View Register”
- From the “Bank Register” menu, go for the “Filter” option.
- Use the filter to find transactions from a particular month or quarter.
- By clicking the “Payment or Deposit column”, you can arrange the list by amounts.
- Now, check any QuickBooks Duplicate Transactions.
Procedure to Remove Duplicate Transactions in QB (Double Entry)
Perform the following steps to accomplish the removal of the duplicate transaction error:
Web:
- Open QuickBooks Self-employed and then go to “Transactions” tab.
- In case of duplicate transactions, opt for the “Delete Duplicate Transactions” option.
- Take note of the transaction copy you want to keep; and soon after, hit on “Keep marked transactions”.
Application:
- At first, head to the “Transactions” tab
- Hit on “View” on the warning notification related to duplicate transactions.
- Make selection of the duplicate transactions to keep.
- Then, click on “Keep Marked Transactions”.
- Ensure exclusion of “QuickBooks Duplicate Downloaded Transactions” option.
- The balances will match if you exclude the downloaded QuickBooks duplicate transactions. Subsequently, reconciliation can be done after that. Avoiding such transactions is possible by:
- Head to the “Banking” tab.
- Opt for the transactions you want to keep out of the Review tab.
- Hit on “Exclude Selected” from the Batch Actions.
Deleting duplicate Transactions (in the Register mode):
The Double entry issue in QuickBooks can also be resolved in the Registry mode by performing the following steps:
- From the “Banking” menu, “select Bank Feeds”.
- Select the “Bank Feeds Centre” menu.
- Find and select the statement under “Items Received” from Financial Institution. Then select “View” tab.
- To complete the procedure, choose the appropriate transactions and press “Done”.
- In the “Not Finished Matching” box, select “Yes”.
- After that, in the “Online Banking Centre”, find duplicate transactions in the “Items Received from Financial Institution”.
- Subsequent to that, hit the “Delete” key to finish.
Removing Duplicate Transactions that come in QuickBooks Side-by-Side mode
- Go to the “Banking menu” and select “Bank feeds”.
- Hit the “Bank Feeds Centre” button.
- Now, select the account that contains the transactions to delete from the Reviewed area.
- Choose the transactions to remove from your account, then it on “Delete selected”, followed by clicking on “Yes”.
Conclusion
This article revolved about the procedure to remove double entry in QuickBooks issue, or in other words, we delved to know the “procedure to delete duplicate transactions in QuickBooks desktop”. To get help from our QuickBooks desktop error support experts, you can call us at 1–800–761–1787.