LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

I am using QBD 2020 Prem R13

Unfortunately the bank changed the details of the downloaded bank transactions, removing payment details and replacing them with the transaction date. Now I don't have any idea what those transactions are for.

The problem is that QB automatically defaults a payee and an account to those transactions, even though I had not assigned a payee and account to the new download transaction format.

My question is, what list of payees and accounts does QB use to assign them to the bank transactions? I checked all the list that I know off, but have not found the one QB uses for downloaded transactions. I would like to delete all of them that QB does not use any defaults.

Here is a screen shot how the bank transaction screen looks like (the screen shot does not have any sensitive information)

 

Can somebody show me where the payees/account list is kept?

9 Comments 9
JessT
Moderator

What list of payees and accounts is used for downloaded bank transactions?

Hi gerdgoebel,

 

Thank you for the screenshot and for your effort in finding a list of payees and accounts. There isn't such a list, but I'm happy to shed some light on this so won't have any challenges with this information anymore.

 

When the automatic creation of renaming rules is enabled, QuickBooks will assign a payee based on bank details and matching names from your list of customers or vendors. For example, if the details include the name Starbucks and it's on your list of vendors, that name will be assigned as the payee to the transaction. The same thing goes for account assignments.

 

QuickBooks also considers the way you managed your past transactions when auto-assigning payees and accounts.

 

I would suggest disabling the automatic creation of renaming rules to prevent QuickBooks from changing and assigning names and accounts to your transactions.

 

  1. From the Edit menu, select Preferences.
  2. Choose Checking and Company Preferences.
  3. Remove the checkmark for Create rules automatically.
  4. Click OK.

 

preferences.jpg

 

On the other hand, putting a checkmark in the Show Bank Memo checkbox can also help since the memo details are purely from your bank. QuickBooks will not replace the information in the BANK MEMO column.

 

 

You can reconcile your account once your transactions are all set.

 

I'm just around if you have other concerns with your bank transactions. Take care and have a good one!

gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

Thank you very much for the detailed explanations!

I have one more question. QB must keep a list of what payee and account I had assigned before. That's the list I would like to get, review it and probably delete some of the assignments. I remember I had some typos and QB of course remembered those as well. 

Time for a cleanup

gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

I changed the company preferences and also set the check box to "Show bank memo". And it has some more information about the transaction.

But after I added this new field and expanded it all other columns are rather small now. There does not seem to be an option to remove columns, like type or NO.

If possible I just would like the date, the bank memo, then payee, account, payment, deposit and action.

GlinetteC
Moderator

What list of payees and accounts is used for downloaded bank transactions?

Welcome back, gerdgoebel.

 

Being able to remove unwanted columns that will show on your bank transactions is unavailable in QuickBooks Desktop yet. 

 

You'll want to share this idea directly with our Product Development Team. They look through submitted feedback for future updates and use it to develop changes for the product.

 

Here's how:

 

  1. Go to the Help menu at the top.
  2. Select Send Feedback Online.
  3. Click Product Suggestion
  4. Click on the drop-down for Type of Feedback and select Product Suggestion.
  5. Select the Product Area.
  6. Enter your thoughts and suggestions.
  7. Click Send Feedback.

 

To be updated with our latest news and updates, including product enhancements, I encourage you to visit the What's New section on your QBDT account or open this link to view our product update blogs.

 

I always have your back whenever you need assistance again. 

gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

Do you know if there is a list of payees and accounts that are used for downloaded bank transactions?

I still would like to correct or delete some assignments (if possible)

gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

I submitted the feedback, but don't get my hopes up that anything will be changed.

LeizylM
QuickBooks Team

What list of payees and accounts is used for downloaded bank transactions?

Hi there, gerdgoebel. 

 

I'm here to make sure you'll be able to correct the payee from your downloaded transactions in QuickBooks Desktop.

 

  1. From the Banking menu, select Bank Feeds.
  2. Click Bank Feeds Center.
  3. Select Rules in the Bank Feeds window.
  4. In the Rules List window, highlight the renaming rule you need to change.
  5. Click Edit Rule.
  6. Click Yes.

 

Also, you can visit these links with the list of articles about the banking preferences and tutorials in QuickBooks Online Canada:

 

 

Reach out to me if there's anything else that you need help with. Thanks!

gerdgoebel
Level 4

What list of payees and accounts is used for downloaded bank transactions?

Thank you very much, this was exactly what I needed.

I am in the bank transaction list nearly every day, but obviously never "saw" the rules icon.

JamaicaA
QuickBooks Team

What list of payees and accounts is used for downloaded bank transactions?

Thanks for getting back to us, @gerdgoebel.

 

It’s our priority to ensure that you get the most out of QuickBooks. That said, I’m glad to hear that my colleague was able to provide the best resolution specific for your concern. You can now use bank rules to automatically categorize bank transactions. 

 

Please feel free to get back to this thread if you have other bank rules or QuickBooks-related concerns. It’ll always be my pleasure to assist you. Keep safe.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us