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

Banking screen showing wrong banking transaction amount

There are a couple of entries showing on the banking page (for review) which have incorrect amounts pulled through from the bank (rounded to the nearest £s). However, on the bank account history screen, the amounts are showing correctly. This has only happened to a couple of transactions, not all.

 

Why please do I have two different figures depending on which screen I'm looking at and how do I correct the incorrect ones on the banking screen?

5 REPLIES 5
GeorgiaC
QuickBooks Team

Banking screen showing wrong banking transaction amount

Hi Clare67B,

 

The transactions showing on the For-Review tab should show the same amount as in your online bank as the data is pulled directly from the bank and should not round.

 

First, please check that this is not a display issue caused by a browser issue by clearing the cache on the browser you are using following our guide here.

 

If this does not resolve, please provide a screenshot showing the transactions in the for-review tab and a screenshot of the same transactions in your online bank statement, covering any sensitive information. If you would prefer you can contact us with this in a private FaceBook or Twitter message (@QuickBooks UK) and we'll pick up with you there.

 

Thanks

Best honey
Level 1

Banking screen showing wrong banking transaction amount

Hi,

 

I'm even worse, they show a deposit instead of expense. 

GeorgiaC
QuickBooks Team

Banking screen showing wrong banking transaction amount

Hi Best honey, 

 

Thanks for joining this thread. Do you have the bank connected through a live feed or did you upload these transactions through a CSV file? 

 

What type of bank account is this (e.g. current account or credit card)? 🧐

Best honey
Level 1

Banking screen showing wrong banking transaction amount

Live feed. was trying to delete or amend the record but couldn't find how to do it. In the end I excluded the transaction and added a Journal.   

RenjolynC
QuickBooks Team

Banking screen showing wrong banking transaction amount

I appreciate your time in getting back here, Best honey.

 

Your financial institution controls the transactions transmitted over to QuickBooks Online. This is why we're unable to modify the deposit to an expense. You did the right process in excluding the transaction and adding it as a journal in QuickBooks.

 

For deleting the transaction, you can follow these steps:

 

  1. Go to Banking.> Excluded.
  2. Put a check mark on the transactions you want to delete.
  3. Click the Batch actions drop-down and choose Delete.
  4. Select Yes to confirm.

The other option that you can do is import the transaction manually using a CSV file. Just make sure to add the transaction as a negative amount, so it shows as an expense. I've got this article for more details: Import bank transactions using Excel CSV files.

 

Once you have the transactions, you can categorise and match them. You can find the instructions here: Categorise and match online bank transactions in QuickBooks Online.

 

If you have any follow-up questions or other concerns, please let me know in the comments. Take care and stay safe.

Need to get in touch?

Contact us