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
Highlighted
QuickBooks Team

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

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. 

Highlighted
Level 1

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

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

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

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.
Highlighted
Level 1

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

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?