cancel
Showing results for 
Search instead for 
Did you mean: 
B Cald Well
Level 2

Sorting bank transactions

Very new with QuickBooks desktop 2019. would anyone know if their is a way to sort bank transactions in Transactions list, in order to have the same transaction auto fill "account" and "class" columns? I have found info on memorized transactions however  it doesn't seem to apply for bank transactions in my downloaded transaction list. The example would be seeing a transaction from a bank feed that was a identified vendor showing up multiple times and knowing that payment to that vendor would always fall in the "personnel"  account in a  predesignated class. I am looking at thousands of CC transactions for the year from repeat vendors and am baffled that I have to add them one at a time. I am aware of batch processing however each one requires I assign an account and class, one at a time then check mark each one and then batch accept. If anyone  can share some information or lead me in the right  direct to figure this out I will be greatly appreciative as the way it looks I will be manually adding line by line until the cows come home!  (I don't own a cow)

Solved
Best answer December 10, 2020

Best Answers
AlcaeusF
Moderator

Sorting bank transactions

Hello @B Cald Well,

 

I appreciate you for reaching out to us here in the Community. Let me share some clarification about the bank feeds feature in QuickBooks Desktop.

 

Currently, the option to auto-fill the accounts and classes of the downloaded transactions is available using the Advanced Mode option for bank feeds. However, this feature is only available in the latest version of QuickBooks Desktop.

 

See sample screenshots below for your visual reference:

 

 

 

Right now, the only option is to sort each one of the bank transactions manually. I highly recommend upgrading to QuickBooks Desktop 2021 to categorize transactions easily.

 

Here's the link: https://quickbooks.intuit.com/desktop/.

 

For additional reference, you can use the following article to learn more about adding transactions, as well as creating rules to categorize transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Fill me in if you have additional questions about managing your credit card transactions in QuickBooks. I'm always here to help. Take care always.

View solution in original post

3 Comments
AlcaeusF
Moderator

Sorting bank transactions

Hello @B Cald Well,

 

I appreciate you for reaching out to us here in the Community. Let me share some clarification about the bank feeds feature in QuickBooks Desktop.

 

Currently, the option to auto-fill the accounts and classes of the downloaded transactions is available using the Advanced Mode option for bank feeds. However, this feature is only available in the latest version of QuickBooks Desktop.

 

See sample screenshots below for your visual reference:

 

 

 

Right now, the only option is to sort each one of the bank transactions manually. I highly recommend upgrading to QuickBooks Desktop 2021 to categorize transactions easily.

 

Here's the link: https://quickbooks.intuit.com/desktop/.

 

For additional reference, you can use the following article to learn more about adding transactions, as well as creating rules to categorize transactions: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Fill me in if you have additional questions about managing your credit card transactions in QuickBooks. I'm always here to help. Take care always.

View solution in original post

B Cald Well
Level 2

Sorting bank transactions

Thank you for your prompt reply! I will look into the upgrade. Would you know if advanced mode works  when do a data dump  from bank and importing to QuickBooks desk top?

Thanks for being there!

MaryLurleenM
Moderator

Sorting bank transactions

You can import your old bank transactions, B Cald Well.

 

You can do it on every version of QuickBooks. The first time you connect, QuickBooks automatically downloads the maximum number of transactions available from your bank. Depending on the bank, this can give you up to a year of historical transactions. Most banks may only download the previous 90 days.

  1. Go to the Banking menu.
  2. Hover over Bank Feeds and select Bank Feeds Center.
  3. From the Bank Accounts list, choose the account you want to connect. (Optional) In the Send items to your bank section, you can edit or delete items by clicking the drop-down.
  4. When you're ready to get your transactions, select Download Transactions.
    Note: If you already downloaded the transactions but haven't reviewed them yet, select Transaction List. Here's how to review them.
  5. Select Synchronize. If you only want to download transactions for a specific account, select Sync this account. Or if you want to download transactions for all your accounts at the same bank, select Sync all for this Bank.
  6. In the Access to window, enter your PIN or password to connect to your bank.
  7. Select OK.

After you download the transactions, you need to match or add any new ones.

 

You can also use the Web Connect:

  1. Open a web browser and go to your bank’s website.
  2. Sign in to your bank account using your normal process.
  3. Download your transactions as a QuickBooks Web Connect (.qbo) file.
  4. Once you have the Web Connect file, follow the steps to import it into QuickBooks Desktop.

I'm just a post away if there's anything else you need.

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