cancel
Showing results for 
Search instead for 
Did you mean: 
mjensen50
Level 2

Desktop 2019 Bank Feeds

I have uploaded bank transactions to bank feeds.  The rules match to the "downloaded as" column.

The definitive information is in the Bank Memo column which means I have to add each one.

I have turned of automatic matching or creating rules but I would really like to be able to memorize them!

The bank is Old National Bank.

Has anyone else had this problem?

Thank you!

 

Marti

Solved
Best answer October 28, 2020

Best Answers
Nick_M
QuickBooks Team

Desktop 2019 Bank Feeds

Hey, mjensen50. 

 

Thanks for dropping by the Community and clarifying. Unfortunately, bank rules can only be set to bank text description and amount and you can only copy bank detail to the memo column. However, i can see how it would be beneficial to include the rules in the memo, so I'm going to recommend this to our product development team to see about getting it added to a future update. You can keep an eye on our Blog, that's where information is posted about updates coming to the QuickBooks product. 

 

I'm also including a helpful article for you to check out about adding and matching bank feed transactions in QuickBooks

 

If you have any other questions, feel free to post here anytime. Thank you for your time and have a nice evening. 

View solution in original post

7 Comments
CharleneMae_F
QuickBooks Team

Desktop 2019 Bank Feeds

Let me share some insights about memorizing bank transactions, mjensen50.

 

QuickBooks can automatically enter your transactions using the Memorize feature to save time. However, this feature is unavailable for downloaded bank transactions. I've listed all the transactions below that can be memorized.

 

Recurring Outgoing Cash Flows:

  • Rent
  • Loan or lease payments
  • Recurring bills in QuickBooks
  • Monthly health insurance bills
  • Monthly electronic withdrawals from checking, such as internet access payments or business insurance installment payments
  • Recurring checks in QuickBooks for software or personal services paid in regular amounts or intervals
  • Recurring checks in QuickBooks for software or personal services paid in regular amounts or intervals

 

Recurring Sales:

  • Rent collections
  • Repeating tuition invoices
  • Monthly installment payments due from customers
  • Recurring sales transactions for services or products supplied monthly or other regular intervals

 

Recurring Purchase Orders:

  • Purchase Orders that are repeated with the same items. With this type of transaction, you can manually select from the memorized transaction list and delete the lines for products that aren't needed in the next purchase.

Recurring Journal Entries:

  • Recurring Monthly Depreciation journal entries
  • Allocation of overhead to other departments

Recurring Estimates:

  • If you frequently choose the same line items when creating a quote

 

For now, you can use the Bank Rule option when sorting your downloaded transactions in QuickBooks.

 

I also encourage you to browse this article about creating and modifying renaming rules in QuickBooks. This guide ensures that the payees match in QuickBooks. Use renaming rules for Bank Feeds.

 

Additionally, I've included an article that'll help you manage the transactions in your Bank Feeds differently: Switch Between Banking Modes.

 

In case you have other banking questions in mind, don't hesitate to leave a comment below. This way, We'll be able to get back to you.

mjensen50
Level 2

Desktop 2019 Bank Feeds

Thank you, Charlene for your time.  I wasn't asking about Memorized transactions per se.  I was asking about the rules reading from the "downloaded" column of the bank feed instead of the Memo Column.  

 

The downloaded column only has CRD PUR then a series of numbers, which change on each transaction.

The MEMO column has the vendor the purchase was made from.  I'd like the rules to read from the MEMO column for its direction.

Sorry, I must not have been very clear.  I apologize.

 

Nick_M
QuickBooks Team

Desktop 2019 Bank Feeds

Hey, mjensen50. 

 

Thanks for dropping by the Community and clarifying. Unfortunately, bank rules can only be set to bank text description and amount and you can only copy bank detail to the memo column. However, i can see how it would be beneficial to include the rules in the memo, so I'm going to recommend this to our product development team to see about getting it added to a future update. You can keep an eye on our Blog, that's where information is posted about updates coming to the QuickBooks product. 

 

I'm also including a helpful article for you to check out about adding and matching bank feed transactions in QuickBooks

 

If you have any other questions, feel free to post here anytime. Thank you for your time and have a nice evening. 

View solution in original post

mjensen50
Level 2

Desktop 2019 Bank Feeds

Thank you, Nick!  I appreciate all of the info & that you will make this suggestion.

If I may ask 1 more question.  

Is there a way for me to rearrange the columns in the Upload or export file BEFORE I upload it to Desktop?  Without being a degreed programer?   (Probably not, but worth the asking to be sure)

 

Thanks again!!

LieraMarie_A
QuickBooks Team

Desktop 2019 Bank Feeds

It's our top priority to help you with all your QuickBooks needs, @mjensen50.

 

We can only see the content of the .qbo file when you've imported it into QuickBooks Desktop. You may consider looking for a file converter so you can open it into Excel, then make the necessary changes. Then convert it back to .qbo file format.

 

Also, I've added these articles to guide you on how to fix web connect errors:

 

Feel free to visit the Community again if you need help with QuickBooks. We're always here to help. Have a great day ahead.

mjensen50
Level 2

Desktop 2019 Bank Feeds

Thank you LisaMarie!!!   Can you tell me what "file convertor" program converts from Excel to .qbo file format???  That would be great if I can do that!  Thanks....  Marti

Adrian_A
Moderator

Desktop 2019 Bank Feeds

Thanks for getting back to us, Marti.

 

We can look for a third-party application that suits your company. We can do that by going to this page: Apps for QuickBooks Desktop.

 

Once imported and categorized, you're good to reconcile the transactions: Reconcile An Account in QuickBooks Desktop.

 

Feel free to tag my name if you need help in reconciling the transactions. Take care!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us