cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
Dannyle1
Level 1

Changed Business Bank Account and LOST all history.

I recently moved from TSB to Barclays for business banking and all of my transaction history has been lost on Quickbooks - I can't reconnect to TSB as that account is now shut but I've lost my previous 6 years of accounts. 
Is there any way I can get the history back?

Solved
Best answer June 24, 2021

Accepted Solutions
GlinetteC
Moderator

Changed Business Bank Account and LOST all history.

We may be able to pull back through the history in Self Employed. Just reach out to our support team at QuickBooks UK under Twitter/Instagram or FaceBook or our chat team at this link . If you need them as an alternative, here are the steps you'll need on how to upload a CSV file in QuickBooks Self-Employed, whoknows1.

 

Here's how to import transactions with a CSV file:

 

  1. Open QuickBooks Self-Employed in a web browser.
  2. Go to Settings and select Imports.
  3. Choose the account you want to add the transactions into.
  4. Select Browse and find the file you downloaded from your bank. It's usually in your Downloads folder.
  5. Select the file and select Open to start the import.
  6. Review the column headers and data. Make sure the Date, Description, and Amount columns on the CSV match the columns and order in QuickBooks. The other column headers can be in any order.
  7. Select Continue to complete the import.

For more information, visit this article: Manually import transactions into QuickBooks Self-Employed.

 

Once done, review what you've imported. Then,  categorise your transactions before putting them in your accounts.

 

I'm always here to help if you have other questions about managing your bank transactions.

View solution in original post

9 REPLIES 9
TaliaI
QuickBooks Team

Changed Business Bank Account and LOST all history.


Hello Dannyle1,

 

Did you delete the bank account from your chart of accounts after disconnecting?

 

Thanks,

 

Talia

Dannyle1
Level 1

Changed Business Bank Account and LOST all history.

Yes, but I assumed the history would still be available. 

TaliaI
QuickBooks Team

Changed Business Bank Account and LOST all history.

Hello,

 

In that case, go to your chart of accounts and click on the small cog wheel at the top of the list, select include inactive within that menu. Find your TSB account and make it active. This should bring back your account history, you can then delete the balance adjust QuickBooks created when you deleted the account. You will need to keep this account active for you to readily access the information within it.

 

Thanks,

 

Talia

Dannyle1
Level 1

Changed Business Bank Account and LOST all history.

Hi, 

 

This is only giving me the option to add the account again - there's no option to include inactive accounts - which I can't do now. 

 

Thanks

TaliaI
QuickBooks Team

Changed Business Bank Account and LOST all history.

Hello,

 

Could you please send a screenshot of your screen so I can point you in the right direction?

 

Thank you,

 

Talia

Dannyle1
Level 1

Changed Business Bank Account and LOST all history.

Apologies for the delay 

TaliaI
QuickBooks Team

Changed Business Bank Account and LOST all history.

Hello,

 

Ah, I can see you are using Self Employed. This product does not give you the option to bring the account back. Your only option to get this data back would be to upload a CSV file of those historic transactions.

 

Please let us know if you have any further questions.

 

Thanks,

 

Talia

whoknows1
Level 1

Changed Business Bank Account and LOST all history.

how do you do that -  upload a CSV file

My daughter has just lost all her accounts this way too - it should be very clear in QuickBooks because this is now a nightmare

GlinetteC
Moderator

Changed Business Bank Account and LOST all history.

We may be able to pull back through the history in Self Employed. Just reach out to our support team at QuickBooks UK under Twitter/Instagram or FaceBook or our chat team at this link . If you need them as an alternative, here are the steps you'll need on how to upload a CSV file in QuickBooks Self-Employed, whoknows1.

 

Here's how to import transactions with a CSV file:

 

  1. Open QuickBooks Self-Employed in a web browser.
  2. Go to Settings and select Imports.
  3. Choose the account you want to add the transactions into.
  4. Select Browse and find the file you downloaded from your bank. It's usually in your Downloads folder.
  5. Select the file and select Open to start the import.
  6. Review the column headers and data. Make sure the Date, Description, and Amount columns on the CSV match the columns and order in QuickBooks. The other column headers can be in any order.
  7. Select Continue to complete the import.

For more information, visit this article: Manually import transactions into QuickBooks Self-Employed.

 

Once done, review what you've imported. Then,  categorise your transactions before putting them in your accounts.

 

I'm always here to help if you have other questions about managing your bank transactions.

Need to get in touch?

Contact us