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

7 REPLIES 7
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

IslaH
Level 1

Connect bank account

I am having the same issue, I have been using QB Online since 1st April 21 having switched from a previous accounting software provider and have been adding transactions manually/reconciling bank etc. I have tried to connect to the bank to pull transactions from today but when connecting it pulls almost 600 transactions for review!  Is this a bug?  It makes me not want to use this feature unless you can advise how to pull only the transactions I want?

RCV
QuickBooks Team
QuickBooks Team

Connect bank account

Let me help you download the bank transactions you need in QucikBooks Online (QBO), IslaH. 

 

May I know what's your bank provider? This helps us to check if there's a reported case about this one. Some banks let you download the last 90 days of transactions and others can go back as far as 24 months. If your bank is using the old bank feed system, we can manually upload your bank transactions to your QuickBooks account. You can go to your bank's website and follow the instructions on how to download them. Here are the supported file formats below:

  • Comma-Separated Values (CSV)
  • QuickBooks Online (QBO)
  • Quicken (QFX)

Then, choose the date period for you to download the bank transactions in QuickBooks. To avoid entering duplicates, you need to know the date of the oldest existing transaction currently in the account: 

  1. In QuickBooks, go to the Accounting menu and then select Chart of Accounts.
  2. Find the bank or credit card account you want to upload the transactions into.
  3. Tap Account history.
  4. Find and write down the date of the oldest transaction. Usually, the oldest transaction is the opening balance.

Then, get transactions from your bank: 

  1. Sign in to your bank or credit card's website.
  2. Follow your bank's instructions for how to download CSV files of your transactions to your computer. Every financial institution has different steps.
  3. Check the date range for the download. It should be at least one day before the date of your oldest transaction.
  4. Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.

 

Then, follow the next steps in the Manually upload transactions into QuickBooks Online article to finish the process. Once you're done uploading the file, we can now start matching and categorizing your bank transactions.

 

Feel free to visit our Banking page for more insights about managing and reconciling your bank transactions. 

 

I want to make sure everything is taken care of for you, please let me know how it goes or if you have any other issues or concerns. Just leave a comment below and I'll get back to you. You have a good one. 

Need to get in touch?

Contact us