cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
info-acousticalc
Level 1

Can one remove multiple duplicates

by selecting multiple expenses and removing them?
14 Comments 14
Ivan_G
QuickBooks Team

Can one remove multiple duplicates

The ability to delete multiple expense entries at once depends on which area of QuickBooks you're referring to, info-acoustic. I'm glad to help you if it's within your Bank transactions page or the Expenses tab.

 

I recommend excluding these expenses if you're referring to erasing them from your Bank transactions page. Keeping them excluded rather than deleted prevents these data from being downloaded again on your bank feeds. The excluded data will not reflect on your books.

 

If your transactions are not yet categorized, let's exclude them from the For review tab:

 

  1. Go to Transactions and then Bank transactions.
  2. Navigate to the For review tab.
  3. Click the Box icon for the entries that you want to exclude.
  4. Hit Exclude to remove them from your entries.

 

However, if they're already categorized, let's undo the categorization first before excluding them:

 

  1. Select the Categorized tab from the Bank transactions page.
  2. Tick the Box icon for the data that you want to exclude. Then, click Undo.
  3. Confirm the action by tapping Continue.
  4. Go to the For review tab.
  5. Put a checkmark on the entries and hit Exclude to remove them.

 

Nevertheless, deleting them in bulk is not an option if the data you're referring to is from your Expenses tab. We can only remove these transactions manually:

 

  1. Go to the Expenses tab.
  2. Click the dropdown arrow beside View/Edit under the Action column.
  3. Select Delete and confirm by hitting Delete.

 

Additionally, once you've decided to run your report in the program, you may manage and customise the available information in its data. Doing so could help you handle and review your needed details in the report.

 

Whenever you have additional questions about your expenses or other transactions, please add a comment on this thread. I'll make sure to address your concerns accordingly.

info-acousticalc
Level 1

Can one remove multiple duplicates

Its very hard to do when you have no idea up to which date was reviewed and which not. Even the data within the expenses and payments doesn't make sense anymore. Why should people be reviewing a year's worth of accounts because of some update? Its meant to help small business not make them employ some one to review it.

info-acousticalc
Level 1

Can one remove multiple duplicates

Having removed everything categorized, the numbers are still not right.

MichaelaS
QuickBooks Team

Can one remove multiple duplicates

I recognize it's much work to review your yearly data, @info-acousticalc. Let me share insights about the categorized balance transaction in QuickBooks Online (QBO).

 

If you're referring to the bank or QuickBooks balance, there are instances that they don't match, as the QuickBooks balance is affected by all transactions entered in the register, including the ones you haven't reviewed yet. While bank balance is determined based on the cleared transactions from your bank. The following factors below can also cause the balances to vary:

 

  • Outstanding transactions
  • New transactions for a connected account
  • Duplicate transactions
  • Edited or deleted transactions
  • Credit card (liability) account

 

If it's something else, please give us more information about the incorrect number you mean to narrow an accurate solution to fix them.

 

In addition, you can check these references to help you reconcile your account once every month to keep your books accurate and review the transactions after being downloaded or imported:

 

 

If any queries arise, please don't hesitate to reach us. I'll be around to help. Stay safe.

info-acousticalc
Level 1

Can one remove multiple duplicates

If I remove all the categorized items it still doesn't make a change. If I go to expenses and payments everything is still there. The cash flow trend shows only this month no reference is made to what is under expenses and payments. If I try and categorize again that are entered in payments and expenses doubled. It is as if the modules are not talking to each other. This happened after the latest bank transaction update, a few days ago. It looks like the data is corrupted. Is there any way of returning to the data from a few days ago? If I exclude what is under review, it goes again berserk. If I go to the mobile app it is again different. I wish there was somebody that could give me a solid direction as I have lost faith in the software, even my first version from 1998 didn't have such issues.

info-acousticalc
Level 1

Can one remove multiple duplicates

In fact on some of the transactions it says 'Something is not right, t(0) is undefined.'

JanbonN
QuickBooks Team

Can one remove multiple duplicates

We appreciate your effort and patience in resolving your duplicate concern, info-acoustical. I'm here to provide further details.

 

To further narrow down your concern, can you clarify where exactly you are seeing duplicate transactions? Attaching a screenshot is much appreciated.

 

As mentioned by Ivan_G, if you're on the banking page, the option to return to the data from a few days ago is by excluding the transactions.

 

For now, please access your QuickBooks in a private or incognito browser window to access it in a clean slate since the error message you receive may be a cause of browser incompatibility. Please use these keyboard shortcuts: 

 

  • Google Chrome: Ctrl + Shift + N
  • Mozilla Firefox: Ctrl + Shift + P
  • Microsoft Edge: Ctrl + Shift + P
  • Safari: Command + Shift + N

 

Additionally, you can match bank transactions with the correct accounts in QuickBooks to avoid duplicates.

 

Please return to this thread for further assistance with your duplicate transactions. We're waiting for your response.

info-acousticalc
Level 1

Can one remove multiple duplicates

Okay did all that and solved one issue. Went to payments and everything looks fine, only that they are negative on the totals. All seem paid but I removed all i the categorized from the beginning of usage, in reality if these are connected I should go back to zero. Same with the expenses, all are there but I removed everything from categorized threw everything in excluded and total figures on the dashboard are still there. I give up on messing around, I need to work. So I'll see how to export what I have and sort accordingly from afresh with something else.

info-acousticalc
Level 1

Can one remove multiple duplicates

Is there the desktop version in Europe? Can one transfer the online data to desktop?

JoesemM
Moderator

Can one remove multiple duplicates

QuickBooks Desktop doesn't exist in Europe, info-acoustical. Currently, it's available in the United States and Canada. Let me share insights about this.

 

While this isn't available in Europe, you can still purchase QuickBooks Desktop, but you need to subscribe to the US QuickBooks Desktop (QBDT) version, considering you can process your payments with US payment services. 

 

If you consider purchasing QuickBooks Desktop and setting up your account in the US version, I'd suggest consulting your accountant to ensure that you comply with the relevant accounting standards and regulations in Europe. For reference about their plans and pricing, see this link: Select the right product for you.

 

Also, moving your data from QBO non-US version directly to QBDT US is unavailable, you can look for a third-party application to help you with this conversion process. Once you have successfully transferred, you can check out this article to learn the limitations  when moving from QBO to QBDT: What data does and doesn't export from QBO.

 

To start using QBDT, click this link: Get started with QuickBooks Desktop. This is how you set up your company file, customers, vendors, items, and financial accounts.

 

Please let me know if you need more clarification about the availability of QuickBooks Desktop or converting data from QBO to QBDT. Have a good one.

info-acousticalc
Level 1

Can one remove multiple duplicates

The issue is that I found multiple entries of the same expense or expenses, at times four or five entries of the same thing. Without a multiple delete I am stuck here without working and tendering to an accounting software. Furthermore, in the last few days all the expense which were for review under transactions just got dumped into the expenses without me doing anything. I lost faith in it.

Rasa-LilaM
QuickBooks Team

Can one remove multiple duplicates

We acknowledge the importance of having precise financial records, info-acousticalc. I'm here to ensure you're connected to the right channel that can help resolve your duplicate expenses and keep your books organized. 

 

We'll have to perform in-depth troubleshooting steps to identify why your transactions are dumpled from the For Review tab. That said, I recommend contacting our QuickBooks Online (QBO) Care Team for further investigation. They'll also assist you in implementing the permanent fix to keep the issue from happening again.

 

To get the contact information:

 

  1. In your company, navigate to the Help menu in the upper right to see more details.
  2. In the Assistant tab, type a brief description of your concern in the field box.
  3. Select Contact Us, key in your question or concern in the field, and click the Continue button to proceed.
  4. Tap the Chat option to start a conversation.

To learn more about the support hours and types, click the following link for the full details: How and when can I contact QuickBooks Online support?


In addition, categorise your online bank transactions to the correct account to facilitate an easy reconciliation process. I've got some resources that contain topics about managing duplicates and finding missing entries: 

 

Visit the Community again if you have other banking-related concerns or need further assistance navigating QBO. We're here to make sure everything is taken care of for you.

info-acousticalc
Level 1

Can one remove multiple duplicates

maybe you can help me understand this: If I delete entries from expenses on one day they disappear from everywhere, if I delete the next day they appear back in for review and obviously they have to be thrown into excluded. This is always talking about duplicates.

GlinetteC
Moderator

Can one remove multiple duplicates

Ensuring the accuracy of your financial data is very important within any business framework, info-acousticalc.

 

Allow me to direct you to the optimal support system equipped to address any account-related concerns promptly.

 

While I'm aware that you have been recommended by my colleague to contact our QuickBooks support team, I'd recommend reaching out to them again to understand why deleted expenses disappear and then reappear the next day you delete an expense transaction.

 

Here are some resources on managing your bank transactions in QuickBooks Online:

 

 

In addition, you can reconcile your account to identify and correct any discrepancies or errors, providing a clear and transparent view of your finances: Reconcile an account in QuickBooks Online.

 

If you have any further banking-related concerns or other issues, post them below. I'll be here to help.