Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
Victor B
Victor B
January 10, 2019
Question

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

  • January 10, 2019
  • 15 replies
  • 113 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.  

    15 replies

    Rose-A
    Rose-A
    Level 10
    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?

    ChristieAnn 11
    Level 9
    February 21, 2022

    How do you do that in QB Mac, I want to turn off the auto renaming and categories. I would like to keep the ones I make, but I don't want the software to make new ones. Seems there is a bug, because I correct the renaming and give it the proper category - but then it changes it when I add to register. 


    Welcome back to the QuickBooks Community, idsgraphics. I'll be sharing details on how renaming rules works in QuickBooks. Then, ensure you'll be able to perform an alternative way to achieve your goal and to fix unexpected movements in QuickBooks Desktop.

     

    You can always create a remaining rule in QuickBooks Desktop for Mac and when you set up this feature, QuickBooks renames the transactions you download with the conditions you set. 

     

    However, turning off the auto renaming isn't possible in Mac and this is only available in the window's version. Meanwhile, you can select the action for the conditions you set to Don’t rename. This will allow QuickBooks adds a default list of these “don’t rename” rules for checks, deposits, and withdrawals. To see further details you can open this article: Manage renaming rules for payee names in QuickBooks Desktop for Mac. 

     

    On the other hand, since correcting the renaming rules changes when added to the register, I recommend running the  Verify and Rebuild Data Utilities to get this sorted out. The Verify Data utility identifies any potential data damage issues that might've caused unusual behavior. While the Rebuild Data utility repairs damaged data in your company file. Before this, you'll have to secure a backup copy of your company file.

     

     

    To Verify data:

     

    1. Go to the File menu.
    2. Scroll down to Utilities.
    3. Select Verify Data.
    4. Click OK.

     

    To Rebuild Data:

     

    1. Go back to the File menu.
    2. Choose Utilities.
    3. Select Rebuild Data.
    4. Click on OK when you get the message Rebuild has completed.

     

    For further details, you can refer to this article: Verify and rebuild data in QuickBooks Desktop for Mac. 

     

     Lastly, you may refer to this article to see what’s included in the QuickBooks Mac Plus 2022 release and how you can use them to benefit your business: What's new in QuickBooks Mac Plus 2022.

     

    Let me know if you have other questions about setting up rules in QBDT Mac. I'm always free to help you whenever you need my assistance. Take care and stay safe always!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement