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.

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.

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:

• Fix Web Connect import errors
• Fix common Web Connector 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!