Skip to main content
Victor B
Victor B
January 10, 2019
Question

How to fix improperly auto assigned data in bank feeds? Help!

  • January 10, 2019
  • 1 reply
  • 0 views

Okay, so yesterday I imported hundreds of transactions into QB pro from Chase Bank via a downloaded web connect file.  Because of a move to a location far from a Chase bank location, I switched to using the Chase bank mobile app to deposit customer checks into my chase business account a few months ago.   This is the first time I have imported these transactions into QB since this change to the Chase Mobile Deposit system.

 

Here is my issue.  Chase bank reports each mobile deposit as simply; "Remote Online Deposit".  So QB sees every deposit I made via mobile deposit as being from the same customer, which for some odd reason it automatically assigned to a single customer name.  So now I have 239 deposit transactions sitting in the Bank Feed Manager list as "Changed By Rules" all in the name of one customer.  

 

Now, I keep copies of the checks I deposited via chase mobile deposit, so I have the correct information, but there is a problem associating it with the auto-assigned transactions in the Bank Feeds Manager.  I have tried entering the checks manually via the "Enter Sales Receipts" function and then going to the Bank Feed Manager and trying to use the "Match to Existing Transaction" action to tie the appropriate (but misassigned)  transaction to the correct customer check that I entered manually, but I am not given the option to match it, because the date of the check and the date of the deposit are not the same, and there is no additional customer data associated with the Chase web connect data other than the amount.  

 

I am at a loss as to how to fix this issue and could really use some help.  I have attached a screen-shot to show you an example of what I am talking about.  

    1 reply

    Rose-A
    Rose-A
    January 10, 2019

    Hey there, Victor B.

    I appreciate the details you've provided. Let me help you sort this out.

     

    Based on the screenshot you've provided,  you have a Renaming Rule that was set up, which is being recognized by QuickBooks. If the assigned name is incorrect, you need to simply edit the rule.

     

    Here's how to  modify a renaming rule:

     

    1. From Banking menu, select Bank Feeds > Bank Feeds Center.
    2. Select Rules in Bank Feeds window.
    3. In the Rules List window, highlight the renaming rule you need to change.
    4. From the Action column, select the drop-down and choose:
      • Edit Rule: If you need to change details of the rule. Make the appropriate changes then click Save.
      • Delete Rule: If you need to remove the rule. Click Yes when prompted to confirm if you want to delete the selected rule.

    You can check out this article for more details: Use renaming rules for Bank Feeds.

     

    However, if you'd like to go through this over the phone, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours:

     

    1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
    2. Choose your QuickBooks Product.
    3. Select your QuickBooks version.
    4. On the Contact Us page, click a topic.
    5. Click on the Get Phone Number button to see the support number.

    Feel free to get back in touch with me if you have other concerns about QuickBooks. I'd love to help.

    Victor B
    Victor BAuthor
    January 10, 2019

    Thank you for your reply and offer to help.  But there may be an issue with your advice that you may have not thought of.  The problem is not the rule.  The problem is that I have 239 transactions all listed under the same exact name with no other unique identifiers. So yes, I can go in and delete or modify the original rule that caused the problem, but the first time I associate one of these 239 transactions listed as "Remote Online Deposit" with a new customer, QB will then automatically create a new rule and just reassign all remaining 238 transactions to the new rule.   So each time, I will have to go back and delete the new rule for each deposit.   Am I wrong about this?

    R
    Rasa-LilaM
    January 10, 2019

    Welcome back to the QuickBooks Community, Victor B.


    Thanks for letting me know that QuickBooks automatically creates a rule after linking the transactions to a new customer. The information helps me identify on what’s causing this behavior.


    This can happen if the automatically creating renaming rule is turned on. To keep this from happening, you’ll have to turn off the feature.


    Here’s how:

     

    1. First, make sure you’re in a single-user mode.
    2. Go to Edit at the top menu bar, then select Preferences.
    3. Choose Checking on the left panel, then go to the Company Preferences tab.
    4. In the Bank Feeds section, select the Classic Mode (Register Mode).
    5. Click OK.

    With these steps, you'll be able to assign the transactions seamlessly. 

     

    If you have additional questions using the online banking feature, leave me a comment. I'll be happy to answer them. Have a good one.

     

    Terms & ConditionsAccessibility statement