How to delete a connected bank account but KEEP all historic transactions in QB self employed?

Kirkber · ‎April 15, 2022

I recently switched bank accounts and I would like to disconnect my old bank account from QB. However, I would like to keep all previous historic transactions associated with that bank account and that have been imported into QB.

I read somewhere that as long as I have reviewed them, they will all be kept in QB. However, when I was about to delete an old bank account, there was a warning that ALL transactions associated with that account would also be deleted!

Can someone please help .. :)

JessT · ‎April 15, 2022

Hi Kirkber,

It's a good thing that you've asked first before deleting your bank account. I'll share insights about it.

Deleting a bank or credit card account will also remove the transactions under it whether they are categorized or not. What you can do is hide your account so your transactions will be kept or export your transactions to Excel and import them after deleting the account. However, importing them means you need to categorize them again.

Hide an account:

Select the Profile ⚙ icon and then Bank Accounts.
Find the account you want to hide.
In the Show Account section, select the toggle to OFF.

Export transactions to Excel:

Go to Transactions.
Change the Type to All and select the account in concern.
Set the Date to All and click the Export icon on the right.
Save the file on your computer.

Delete the account, and then import the transactions afterward.

Go to the Profile ⚙ icon.
Click Import transactions.
Choose the Import transactions at the bottom. However, if you've been importing transactions before, you'll want to click the Import older transactions on the Cash account.

You can also consider creating rules to speed up the process of reviewing your transactions.

Feel free to comment below if you have other questions in mind. Take care and good evening!

View solution in original post

JessT · ‎April 15, 2022

Hi Kirkber,

It's a good thing that you've asked first before deleting your bank account. I'll share insights about it.

Deleting a bank or credit card account will also remove the transactions under it whether they are categorized or not. What you can do is hide your account so your transactions will be kept or export your transactions to Excel and import them after deleting the account. However, importing them means you need to categorize them again.

Hide an account:

Select the Profile ⚙ icon and then Bank Accounts.
Find the account you want to hide.
In the Show Account section, select the toggle to OFF.

Export transactions to Excel:

Go to Transactions.
Change the Type to All and select the account in concern.
Set the Date to All and click the Export icon on the right.
Save the file on your computer.

Delete the account, and then import the transactions afterward.

Go to the Profile ⚙ icon.
Click Import transactions.
Choose the Import transactions at the bottom. However, if you've been importing transactions before, you'll want to click the Import older transactions on the Cash account.

You can also consider creating rules to speed up the process of reviewing your transactions.

Feel free to comment below if you have other questions in mind. Take care and good evening!

Kirkber · ‎April 16, 2022

Thanks for clarifying Jess ...

AbegailS_ · ‎April 16, 2022

Hello, Kirkber.

I'm glad that my colleague was able to help you with deleting your bank account.

For more tips when managing bank transactions in QBSE, I also suggest opening these articles:

If you have any other QuickBooks or banking questions, please let me know by adding a comment below. I'm always here to help. Wishing you a good one!

Ben1991 · ‎March 05, 2023

I have the same issue, a new bank account but I want to keep the old transactions, I don’t have an option to toggle the ‘show account’ to off this isn’t there. Can anyone advise?

Daniela_A · ‎March 05, 2023

Thanks for bringing this up to our attention, @Ben1991.

I appreciate your effort in following the steps provided by my colleague above. May I know what error you've encountered while doing the process? This way, I can identify the correct resolution I can provide.

For now, we can try performing some basic troubleshooting steps. An outdated or corrupted site data in the browser causes runtime and unexpected behaviors in the program. Thus, logging in to your account using a private or incognito window helps us have a better experience when using QuickBooks, such as importing bank transactions.

Please refer to the shortcut keys I've listed below:

Ctrl + Shift + N for Google Chrome
Ctrl + Shift + P for Firefox & Microsoft Edge
Command + Shift + N for Safari

Once you're in, let's try upgrading your account again. If it runs smoothly, we can clear the cache and cookies on your regular browser to start over fresh. Switching to other supported web browsers can be a good alternative, too.

I’m also adding these resources to help manage your company efficiently:

Stay in touch with me if there's anything else you need about keeping transactions. I'll be right here to guide you. Have a good one.

Topics

Training

Community

Resources

How to delete a connected bank account but KEEP all historic transactions in QB self employed?