Skip to main content
S
schmalts12
November 24, 2023
Question

start over?

  • November 24, 2023
  • 1 reply
  • 0 views

MY bank account has a 2 step authorization that will not play well with quickbooks and I miss so may bank transactions every month it causes pain.   What I did is downloaded this years bank transactions last week and imported them in, causing many many duplicates.  I had reconciles all the way through September but then when I went to delete all the duplicates that were throwing off my reports now I have about 20 transactions that threw off my reconciliations. I dug myself into a bad hole trying to fix this and at this point I feel the best thing to to is start over.  All I need to keep is my invoices and new customers and then manually import this years banks transactions and start clean.   How would I wipe out all the recorded banking transactions and reconciles but keep my invoices?  Bank transactions I can easily get from my bank manually but I just cannot lose my customer invoices.   

1 reply

A
Archie_B
November 24, 2023

Hello there, schmalts.

 

I can see how difficult it is for you to deal with duplicate transactions and having to reconcile your accounts in QuickBooks Online. I'm here to help you navigate through this difficult situation.

 

Instead of deleting all of your data and starting from scratch, you can undo all of your imported and categorized bank transactions, including newly downloaded transactions. Then, exclude them so that you can import all of your year-to-date transactions without having any duplicates.

 

Here's how:

 

  1. Go to Transactions, then select Bank transactions.
  2. Select tile for the bank or credit card account you downloaded the transaction from.
  3. Click the Categorized tab.
  4. Mark all the transactions, then hit UNDO.
  5. If the transaction was already reconciled, you'll see this pop-up message:
  6. Just click on Continue.

 

This process will also remove added or unmatch transactions from your account. I've added this article for more information: Unmatch downloaded bank transactions or move them to another account.

Once done, QuickBooks will reset the transactions and place them all in your For Review tab. This allows you to mark all transactions as excluded in order for you to upload all of your year-to-date transactions without duplicates. Like this:

 

  1. Go to Transactions, then select Bank transactions (Take me there).
  2. Choose the For Review tab.
  3. Put a checkmark or select all the transactions we need to exclude.
  4. Click on Exclude.

 

After you've excluded all of the transactions, you can go ahead and manually upload all of your bank transactions to QuickBooks Online.

I'm adding this as a future reference if you encounter issues after reconciliation: Fix issues the first time you reconcile an account in QuickBooks Online.

 

Let me know if you have other questions or concerns about banking. I'll be here to help. Keep safe!

Terms & ConditionsAccessibility statement