cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

Have anyone imported a CSV bankstatement and found banking rules not working?

 
4 Comments
QuickBooks Team

Let's check the transactions on your CSV file to match it...

Let's check the transactions on your CSV file to match it to the bank rules, go.gc.b038.

To resolve this, I suggest excluding the transactions from the imported file, but first, check each entry of the CSV file and make sure to match the criteria that you've set per bank rules before re-importing.

Here's how to exclude the transactions per batch:

  1. Go to your Banking tab and then For review tab. 
  2. Click on the box beside the Date to put a check mark on each transaction.
  3. Once done, click the Batch actions drop-down, then Exclude Selected.
  4. Transactions are now on your Excluded tab. 

From here, you can now check each transaction on the CSV file. They should qualify on the Bank rules that you currently have. 

Check the following article for more information: How to set and use banking rules for downloaded transactions

Feel free to let me know if you have additional questions. I'm always here to answer them, and help you out with other concerns. Take care and have a wonderful day. 

Level 1

Hi, Thank you for the suggestion. Please send me an email...

Hi, Thank you for the suggestion. Please send me an email and I will share and discuss the problem I experience.
QuickBooks Team

As much as I want to provide, @go.gc.b038. But this is a...

As much as I want to provide, @go.gc.b038. But this is a public space and everyone has access to it. We highly discourage adding personal info like an email address. Just add it below and I'll do my best to help you with it.
Level 1

I understand. So let me try. Getting the transactions in...

I understand. So let me try. Getting the transactions in the FOR REVIEW screen is not a problem but suppose my CSV file's descriptions is all in capital letters and when I look at this screen with the transactions that was imported I see the transaction descriptions have been changed from All capital letters to Small case with the first letter of all the words Capital letters. This change in my opinion causes numerical characters not to be displayed and this in turn causes the rules not to work because the rules are setup using the numerical characters in the description column. Hope you can help and understand my problem?