Need to delete or void transactions, how to correctly?

schmalts · ‎November 29, 2023

. What happened is my bank auto download is very unreliable so I imported the transactions from my bank from a download and I ended up with a LOT of duplicates transactions. I did not notice all the duplicates until I after I reconciled. Then when I went through and deleted the duplicates guess what, I deleted a lot of the wrong duplicate that was reconciled and made a huge mess. So I want to start over. I had my accountant delete the reconciliations. That is done. But now what I want to do is remove all the transaction (delete or whatever it takes to make them go away) and do a clean one time import of all my bank transactions by importing the file I can download from my bank. That way I know there will only be the transactions that are not duplicates and are right off my bank.

I am confused between what will happen if i just exclude them instead or void or delete. The way I read it is if I exclude them I will not be able to import them again or is that only for the auto download? Right now I went through all of the transactions and "undo" them so they are all sitting in the "for review" tab. What is the best way to do a clean start over where I import the bank transaction file from my bank and QBO will hopefully match the transactions to my pain invoices without having a bunch of duplicates. Second question is there a way to shut off where the transactions are brought in automatically? My bank's 2 step verification trip up QBO and that is why I was missing so many transactions

Erika_K · ‎November 29, 2023

I've got the steps to help you start afresh, @schmalts.

Beforehand, let me share additional details about the difference between excluding and deleting bank transactions in QuickBooks Online (QBO).

Once a downloaded transaction is excluded, QuickBooks will stop the bank from bringing the transaction into the bank feed again. On the other hand, if you remove the transaction by deleting it, the system will recognize the transaction is not accounted for and will download the same transaction again from the bank.

Therefore, the best way to do a clean start over is by excluding bank transactions.

Here's how:

On the For review tab, tick the box next to the Date to select all the transactions.
Choose Exclude.

Then, we can manually import your bank transactions in QBO.

Also, shutting off the transaction from being brought up automatically in QBO isn't possible. This option mainly relies on your bank.

If dissociating your bank is necessary to keep your books organized, I recommend disconnecting your bank in QBO.

Furthermore, here's an article about classifying your downloaded bank transactions in QBO: Categorize online bank transactions in QuickBooks Online.

For further queries about the different options to download and manage your bank transactions in QBO, hit the Reply button. I'll circle back to assist you.

schmalts · ‎November 29, 2023

Just to clarify, you said excluding them will keep quikbooks from bringing them in as a new transaction. But I would still be able to import them manually from my bank download? Will QBO still try to match them to my invoices if I manually import them?

CamelleT · ‎November 29, 2023

I'm here to clarify your questions, schmalts.

Once a downloaded transaction is excluded, QuickBooks (QB) will stop the bank from bringing the transaction to the bank feed again.

To clarify your first question, yes, you'd still get your transactions from your bank and manually import them to QB.

For your second question, yes, QB will match them to your invoices.

Additionally, I'll share an article to help you record business expenses: Enter and manage expenses in QuickBooks Online.

Drop a reply below if you have further questions about managing your transactions. I'll be here to assist you. Take care!

Topics

Training

Community

Resources

Need to delete or void transactions, how to correctly?