Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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:
Recurring Sales:
Recurring Purchase Orders:
Recurring Journal Entries:
Recurring Estimates:
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.
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.
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.
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!!
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.
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
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here