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

Connect bank account

Good Afternoon,

 

I connected my bank account to QB. I chose the date from when I want transactions to be imported - from 1st of May 2021. However, the QB imported all transactions from April 2020 - May 2021. Now, my QB balance doesn't match. Could you please let me know how can I delete all those transactions, so my QB balance will be only from 1st of May 2021? 

 

Thank you in advance,

Lucija

Solved
Best answer May 20, 2021

Accepted Solutions
Adrian_A
Moderator

Connect bank account

We can modify the transactions, Lucija.

 

If the items were not supposed to be included on the account, we can delete it. Let me guide you how:

 

  1. From the Accounting tab, select Chart of Accounts.
  2. Locate the account that have the transactions that you want to delete.
  3. Select the transaction.
  4. Click More at the bottom page and then select Delete.
  5. Select Yes.

 

Afterward, you can reconcile the account to ensure accuracy of your books. Here's an article as your guide:  How to reconcile your accounts so they always match your bank and credit card statements?

 

Get in touch with me if ever my assistance is in need. Have a good one!

View solution in original post

EmmaM
QuickBooks Team

Connect bank account

Hello Lucija, We'd like to look into the background of the connection as it should only bring through historical transactions if the bank connection is disconnected and reconnected. Could you PM/DM QuickBooks Uk on either Facebook or Twitter with your email address(it will redact it on this public forum ) and a screenshot showing the connection in QB  and we'll investigate why this is happening. Thnaks

View solution in original post

5 REPLIES 5
JonpriL
Moderator

Connect bank account

Hello @Lucija,

 

In QuickBooks Online, you can exclude and delete your downloaded transactions to fix the balance of your bank account. Let me show you how.

 

  1. Go to Transactions.
  2. Select Banking.
  3. Choose your bank account.
  4. Under For Review, select all imported transactions for April 2021.
  5. Click Exclude.

 

In addition, here's an article you can read to learn more about excluding your bank transactions: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once done, you can go ahead and delete your transactions from the Excluded tab. To do so, select all your excluded transactions and click Delete.

 

Lastly, I've also included this helpful article for the steps in case you need to start balancing your account register: How to reconcile your accounts so they always match your bank and credit card statements?

 

I'd suggest getting back to this thread if you need assistance with your transactions. I'm always here to back you up. Take care and stay safe!

Lucija
Level 2

Connect bank account

Hi,

 

Thank you so much for your assistance.

I exluded the transactions and afterwards deleted them, but the balance in Quickbooks hasn't changed (the bank balance is correct). I read the articles (thank you for providing them), and went to Charts of Accounts --> History by account. I can see my Quickbook balance there under the deposit, but I am not sure if I can change that.

 

Any advice would be really appreciated.

Adrian_A
Moderator

Connect bank account

We can modify the transactions, Lucija.

 

If the items were not supposed to be included on the account, we can delete it. Let me guide you how:

 

  1. From the Accounting tab, select Chart of Accounts.
  2. Locate the account that have the transactions that you want to delete.
  3. Select the transaction.
  4. Click More at the bottom page and then select Delete.
  5. Select Yes.

 

Afterward, you can reconcile the account to ensure accuracy of your books. Here's an article as your guide:  How to reconcile your accounts so they always match your bank and credit card statements?

 

Get in touch with me if ever my assistance is in need. Have a good one!

View solution in original post

Lucija
Level 2

Connect bank account

Hi,

 

Thank you so much for your assistance. I excluded and deleted the transactions before 1st of May and update the Quickbooks balance. However, the next day, when I came to the banking tab, I found transactions before 1st of May (those I deleted). I exluded and deleted them again, but the next morning QB again updated the transactions before 1st of May.

 

Could you please let me know how to fix this, so I don't have to delete those transactions every day?

 

Thank you in advance,

Lucija

EmmaM
QuickBooks Team

Connect bank account

Hello Lucija, We'd like to look into the background of the connection as it should only bring through historical transactions if the bank connection is disconnected and reconnected. Could you PM/DM QuickBooks Uk on either Facebook or Twitter with your email address(it will redact it on this public forum ) and a screenshot showing the connection in QB  and we'll investigate why this is happening. Thnaks

View solution in original post

Need to get in touch?

Contact us