cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Have a question about HMRC's VAT portal closure on November 1st? - Ask it here!
love hate
Level 2

bank description column is wrong.

I downloaded bank transaction to cvs file , the amounts and description column were all correct, but when I imported the transaction to Q.B, I noticed that the  bank description column is wrong:  instead of the correct description in the CSV file  "insurance Group" is it described in the bank description column as "Groupon". how do I fix this?

K.R., Sandi

Solved
Best answer November 16, 2020

Accepted Solutions
doctorpudge
Level 1

bank description column is wrong.

I think I've worked this out now!

If you click the settings button on the right side of the screen (next to print and export), you get a drop down menu.

If you tick "Show bank details". This uses the actual narrative from the bank, rather than the description that quickbooks wants it to be!

 

qb.jpg

View solution in original post

17 REPLIES 17
FritzF
Moderator

bank description column is wrong.

Welcome back to the Community, love hate.

 

I checked if there's an ongoing issue about this, but there isn't currently one. When you map the CSV file before importing it to QuickBooks Online (QBO), does it recognise the description column?

 

When preparing the CSV, make sure to removed all symbols in the Amount field and any non-transactional information in the file, such as account numbers, opening, and closing balance.

 

As an initial troubleshooting step, try logging into your QBO account using a private browser (incognito). There are times that the browser is full of frequently accessed page resources, causing some unusual responses.

 

Here's how:

 

  • Press Ctrl + Shift + N (Google Chrome).
  • Ctrl + Shift + P (Firefox or Internet Explorer).
  • Control + Option + P (Safari).

 

Once logged in, try to import the CSV file again to double-check. Please refer to these articles for further guidance:

 

 

If it works, return to your default browser and perform a clear cache. Every so often the cache becomes overwhelmed with older data which can potentially cause viewing and performance issues. Clearing it will refresh the system, and you'll be able to work with a clean slate. However, if the issue persists, try using other supported browsers.

 

Let me know if you have any other issues or concerns, and I'll get back to you right away. I'm always here to help. Take care!

love hate
Level 2

bank description column is wrong.

Thank you for your advise, but I am afraid that the CSV file has the correct description , and somehow, Q.B changed the description for "Insurance group" to "Groupon" after downloading.  

I would like to know if AFTER downloading the CSV file and accepting the transaction, I can amend the BANK description column , as necessary.

K.R., 

John C
QuickBooks Team

bank description column is wrong.

Hi love hate

 

Locate the transaction from the reviewed section, select the the transaction and edit the description.

karpat223
Level 1

bank description column is wrong.

when you check the actual ledger entry, it shows the correct description. Therefore it must be an anomaly on the review sheet but goes into the ledger correctly!!!

Batman69
Level 1

bank description column is wrong.

Hi love hate (& all the other respondents)

I'm getting the same thing and the advice of 'click in description field and change it' doesn't work, because you simply can't do that.

I have a direct feed from my bank so I don't have a CSV file to modify.

I have a description of Cars.com appear instead of ANZ Cards and I can't find any advice on how to correct this.  If anyone has a solution I'd love to hear it please.  I've attached a couple of screenshots for reference.

Cheers

CBA description.JPG QB description.JPG

Joesem M
Moderator

bank description column is wrong.

Thanks for joining this thread, @Batman69.

 

You'll have to contact your bank website to check why the transactions are not the same when downloading in QuickBooks Online. QuickBooks is just a receiver and depends on the data from your bank.

 

To fix this, after you add or match, go to the matched transaction and edit the description from there. For more details please read out this article:Add and match downloaded bank transactions [Video].

 

I'm adding our Help articles it provides tips on how to manage your account in QuickBooks.

 

I'll be right here if you need any other help. Take care.

 

Batman69
Level 1

bank description column is wrong.

Hi Joesem

Thanks for your reply.

It is not all descriptions that are incorrect, just the ones in the pictures I uploaded, which hopefully you looked at before you replied.  The information on the bank website is correct however QB seems to change it in some instances,  (again as shown in the pictures).

I've never used Cars.com, ever, so don't understand how this comes up in Description.  I've read QB forums where other users have the same issue for some transactions (Groupon instead of Insurance Group for example) but there has been no clear solution on how to rectify ongoing issues or adjust the information to reflect the correct description, so I'd love a clear step-by-step on how to accomplish this for QB Online, please.

 

This request is open to anyone that can guide me through this.

 

Appreciate your time

Cheers

Dave

SarahannC
Moderator

bank description column is wrong.

Hi, Dave. I'm glad to have you here.

 

Thanks for adding further details in regards to your concern. The screenshot is very helpful as well.

 

I've tried checking our records and found out a similar issue with this. Just to confirm, are you using the Natwest bank? If so, we have an open investigation where descriptions recorded differently than what our customers see on the bank statement.

 

Our product engineers are already aware of this. They are working to identify the cause of this issue and get the issue resolved. Please consider contacting us to add you as one of the affected users.

 

  1. Click the Help icon and select the Contact Us button below.
  2. Enter Description  inside the What can we help you with? box.
  3. Once done, click the Let's talk button. You can either select Get a callback or Call us.

 

Please consider checking our support hours. Go to the QuickBooks Online section to see the details. Meanwhile, you may consider using a Web Connect  to bring the transaction with its correct description.

 

  1. Log in to your bank's website and download the transactions from starting from you need to have. Then, save it on your computer.
  2. Map the transactions as CSV format to successfully upload them in your book.
  3. Once done, go to Banking on the left panel. Then, select the Banking tab.
  4. Click the Update drop-down arrow and select File upload.
  5. Select Browse and select the file you downloaded from your bank.
  6. Hit Next.
  7. Then, follow the on-screen instructions to complete the process.

 

Once done, you'll want to read about categorizing the editing, adding the downloaded transactions. I'm sure you'll learn more things like managing the downloaded transactions.

 

I'm right here and with the Community people to assist you in case you need one. I hope you're good. Take care!

Batman69
Level 1

bank description column is wrong.

Hi SarahannC

I'm in Australia using Commonwealth Bank but I will try your suggestions for the transactions that are giving me grief.

Cheers

Dave

katherinejoyceO
QuickBooks Team

bank description column is wrong.

Thanks for clarifying, @Batman69. I understand what you're going through about the downloaded transactions showing different descriptions in QuickBooks. 

 

Checking on our records, we don't receive any reports similar to what you experienced with Commonwealth Bank. At this point, I'd recommend contacting the QuickBooks Online Customer AU Support team. They can help check and identify the cause of the issue and open a case if it needs further investigation. 

 

Feel free to visit again if you have more concerns. I'm always around here to listen and help. 

mpaull
Level 1

bank description column is wrong.

We are having the same problem.  The description in the CSV is correct, and when you see the screen in QBO before accepting transactions, it is correct.  After uploading, the description changes to something we've never used (e.g. Chicago-Sales to Chicago IL).

BettyJaneB
QuickBooks Team

bank description column is wrong.

Thanks for joining us here in the Community, @mpaull.

 

I'd like like to ensure that you this incorrect CSV description concern gets sorted out so you can get back on track.

 

To further isolate this matter, I recommend importing the transactions again to see if the same thing happens. This is because we don't have any ongoing issues about this hurdle. 

 

Know that before re-importing those entries, you'll need to exclude the transactions that were imported previously to avoid duplicates.

 

To do that:

  1. On the left pane, select Banking.
  2. At the top left, refer to the Banking tab.
  3. If multiple banks are connected, choose the bank to work with.
  4. Click the In QuickBooks tab. 
  5. Select the transaction you want to exclude, then click Undo under the ACTION column.
  6. Tick on the For Review tab. 
  7. Select the transaction you want to exclude.
  8. Hit on Batch actions drop-down and tap on Exclude Selected.

Here's a link that you can check out for more details about excluding bank entries in QuickBooks Online: Exclude expenses from downloaded bank transactions.

 

However, if the problem continues, I recommend contacting our Customer Care Team. They can run a remote-viewing session that can help identify the root cause of this matter. 

 

To add up, here are some articles that you can visit to guide you in reconciling your accounts and fixing its issues in case you encounter any along the process:

If there's anything that you need about this or with QuickBooks, let me know. I'll be right here to help. Have a lovely day!

doctorpudge
Level 1

bank description column is wrong.

I think I've worked this out now!

If you click the settings button on the right side of the screen (next to print and export), you get a drop down menu.

If you tick "Show bank details". This uses the actual narrative from the bank, rather than the description that quickbooks wants it to be!

 

qb.jpg

mwloomiscpa
Level 1

bank description column is wrong.

Same. See attached. It says Wal-mart every time Cumberland Farms transaction pops up. No way that I see to edit.

RenjolynC
QuickBooks Team

bank description column is wrong.

Thanks for chiming in on this thread, mwloomiscpa.

 

I'd like to share some details about the downloaded transactions. Please note that we're unable to see the screenshot you've attached. If you've exported a CSV file from your bank's website and imported it into QuickBooks Online, we're unable to edit these transactions. The transaction details are only shared by your financial institution, and this is why editing it in QuickBooks is not an option.

 

What we can do is exclude the transactions that have incorrect descriptions in QuickBooks, and edit the CSV file you've downloaded. Once done, re-import the transactions back to your QuickBooks Online account.

 

To exclude the transactions in QuickBooks Online, you can follow these steps:

 

  1. Go to Transactions > Banking.
  2. In the For review tab, put a check mark on the duplicate transactions.
  3. Click the Exclude button.

 

Here's a sample screenshot for a visual reference:

 

 

After excluding these transactions, you can delete them in the Excluded section. For re-importing the transactions, you can check out the steps in this article: Manually upload transactions into QuickBooks Online. After re-importing the transactions with the correct description, you can start categorizing and matching them. 

 

Furthermore, when you're ready to reconcile the account, feel free to watch the video tutorial in this link: Reconcile an account in QuickBooks Online.

 

If you have any additional questions about online banking or need help with other task in QuickBooks, please add the details on your reply. We'll be around to help you out again. Take care and stay safe.

mwloomiscpa
Level 1

bank description column is wrong.

description.jpg Not a CSV file upload. Automatically imported from bank, yes. Trying to include picture again.

GlinetteC
Moderator

bank description column is wrong.

I appreciate the screenshot you've provided, mwloomiscpa.

 

QuickBooks is dependent on the data transmitted from your bank. 

 

I suggest reaching out to our Customer Care Support to have this further checked. They have tools, like screen-sharing and can help troubleshoot this for you. 

 

If you need help reconciling your account, check out this link for detailed instructions: Reconcile an account in QBO.

 

Please reach back here with any additional information on the issue so I can get you taken care of. 

Need to get in touch?

Contact us