Get 50% 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.
nitsujayyy
Level 2

Bank Feeds after you register/matched it and then delete?

Hi,

 

So I've matched some bank feeds with transaction, but had to change something so i deleted the payment. How come I don't see the transaction in unrecognized again? I dont want to redelete the whole bank... or can i? 

9 Comments 9
JoesemM
Moderator

Bank Feeds after you register/matched it and then delete?

When you delete a payment from a matched transaction in the Bank Feeds, it won't show up under the Unrecognized tab, nitsujayyy. With the information below, you'll be able to restore those transactions with ease.

 

Since the payment is already deleted, you can manually upload your downloaded transactions from your financial institutions. Then, you can categorize and match the bank transactions again.

 

Here's how:

 

  1. Open a web browser and sign in to your bank’s website.
  2. Follow the instructions to download your transactions as a QuickBooks Web Connect (.qbo) file.
  3. Once done, open QBDT and go to the Banking menu.
  4. Select Bank Feeds, then Import Web Connect Files.
  5. Click the QBO file you saved, then select Open.
  6. When prompted to Select a Bank Account, select:
    • Use an existing QuickBooks account if the account you're importing transactions into is already set up in QuickBooks.
    • Create a new QuickBooks account if the account you're importing transactions into isn't in QuickBooks yet. Learn how to create an account.
  7. Select Continue, then OK.
  8. Go to the Bank Feeds Center to review your transactions.

 

 Once done, go ahead and categorize your downloaded bank transactions. This way, you can keep your financial data accurate and updated. Please see this article for the complete guide: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Also, I'd encourage you to reconcile your accounts every month. This helps monitor your income and expense transactions and detect possible errors accordingly. You can read this article for more details: Reconcile an account in QuickBooks Desktop.

 

Please feel free to reach out if you have any other banking concerns or related questions about QBDT. I'm here to lend a hand. Stay safe.

nitsujayyy
Level 2

Bank Feeds after you register/matched it and then delete?

So I did that and nothing changed. I even try checking the account I set up to make sure any matched feeds were deleted. The file I have my folder already didnt show. Are you saying I need a new fresh download?

MsNorthPND1881
QuickBooks Team

Bank Feeds after you register/matched it and then delete?

Yes, you're correct, Nitsuijayy. We need a new fresh download because once you delete a payment from a matched transaction in the Bank Feeds, it won't show under the Unrecognized tab in QuickBooks Desktop (QBDT). Once the transaction doesn't reappear, you can manually add it back in by creating a new transaction in your accounting software and matching it up manually. Let me assist you with how you delete transactions depending on the mode you're using.

 

If you know that QuickBooks is correct and want to delete the transactions that don't match. Here's how:

 

  1. Go to the Banking menu. Then select Bank Feeds and then Bank Feeds Center.
  2. Find and select the statement from the Items Received From Financial Institution sectionThen select View.
  3. Match the appropriate transactions. Select Done to match them.
  4. Select Yes in the Not Finished Matching screen. You'll return to the Online Banking Center.
  5. Find and select the same statement from the Items Received From Financial Institution sectionThen select Delete.

 

For more details on how deleting the statement prevents unwanted transactions from appearing the next time you download a statement you can check this article: Remove duplicate transactions in QuickBooks Desktop.

 

I'll leave this article if you want to customize any reports you want to generate in QBDT: Customize reports in QuickBooks Desktop.

 

If there's anything that you need any assistance with matching bank feeds, feel free to get back to us by leaving a comment below. I'd be glad to help you and resolve it right away.

nitsujayyy
Level 2

Bank Feeds after you register/matched it and then delete?

So I use webgility to post my order and payment. I notice kf import payment to bank feed account, I can’t match multi transaction to 1 bank feed payment. 

only way I can is I imported to a undeposited funds account and manually match it. Is that how I’m going to have to do it moving forward? My Shopify has some single transaction but some have multi transaction under 1 payment. 

LouiseG
QuickBooks Team

Bank Feeds after you register/matched it and then delete?

Absolutely, Jay. You're on the right track. To properly manage the transactions, you will need to import them into an undeposited funds account. Let me provide some insight on this matter.

 

In QuickBooks, bank feeds handle individual line items for transactions. When you have multiple entries, QuickBooks might struggle to recognize them due to the different line items involved. As a result, you will need to manually match each transaction, particularly when multiple entries correspond to a single payment reflected in your bank feed.

 

Keep in mind the software does not automatically recognize or match these multiple entries; therefore, manual intervention is required to ensure your accounting records remain accurate.

 

Moreover, you can visit this article to help you reconcile an account inside the program: Reconcile an account in QuickBooks Desktop.

 

Remember, taking a moment to manually verify each transaction helps keep your financial records accurate and prevents discrepancies. If you have any follow-up questions about matching your entries, feel free to come back here—I’m always ready to help.

nitsujayyy
Level 2

Bank Feeds after you register/matched it and then delete?

Awesome thank you all! 

 

Now another question... Webgility imports all the sales payout right. If it's 1 transaction great. Most time it can be 100-1000 transaction to 1 shopify payout. With bank feed, if my bank feed account is the clearing account, the single transaction will be matched automatically, how can I match all the 100-1000 transaction ones? I dont even think it's possible?

 

After all this yes I will reconciliate the accounts. I see bank feeds can create rules, but it doesnt auto register or match it especially if it's mutli transaction? If use a undeposited funds as a clearing account, more than 100 transaction, can be really gruesome selecting it all.

Aldren18
QuickBooks Team

Bank Feeds after you register/matched it and then delete?

I appreciate your follow-up, Nitsujayyy. Effectively handling these transactions is crucial for your operations, and I am committed to simplifying this process for you.

 

In QuickBooks Desktop, you can use the Batch Actions to select multiple transactions and apply to match at once. This is particularly useful when dealing with numerous transactions from a single payout.

 

Here's how:

 

  1. Go to Banking and select Bank Feeds.
  2. Navigate to the Bank Feeds Center and choose the Bank Account in the list.
  3. Click on the Transaction List tab to view the transactions.
  4. Select the Need for Review option.
  5. Hit the multiple transactions and choose the option to Add/Approve under the Batch Actions dropdown.
  6. Once done, proceed to add the necessary details to match it.

 

I've included a screenshot below for your reference:


image_720.png
 

For auto-matched transactions, you can easily approve them in bulk by using the Batch Actions dropdown menu without additional requirements, allowing you to focus more efficiently on running your business.

 

After posting and matching, regularly reconcile your accounts by comparing your QuickBooks records with your bank statements. This will help catch any discrepancies early on.

 

If there are unmatched transactions after reconciliation, review them individually to ensure everything is accounted for correctly.

 

To further assist you in reconciling your account, I’m sharing these articles that address common reconciliation issues. These resources will guide you through troubleshooting and help ensure a smooth reconciliation process:

 

 

Remember, you can always return to this channel for any additional questions or support regarding financial management. Our Community team is here to help.

nitsujayyy
Level 2

Bank Feeds after you register/matched it and then delete?

What I mean is 1 line transaction in advance bank feed can have multiple transactions. I’ve also set the bank feed as were posted payments go to in webgility. 

Ivan_G
QuickBooks Team

Bank Feeds after you register/matched it and then delete?

Thanks for the clarification, nitsujayyy.

 

To match multiple QuickBooks Desktop (QBDT) entries in a single Bank Feeds data, you'll need to enable the Advanced Mode from the Preferences menu. I'll provide the steps below.

 

Here's how:

 

  1. Open your QuickBooks account.
  2. Navigate to Edit, then Preferences.
  3. Click the Checking tab, then Company Preferences.
  4. Tick the Advanced Mode from the Bank Feeds section.
  5. Once done, hit OK.

 

After that, you can match the single downloaded payout to multiple transactions:

 

  1. Go to the Banking menu.
  2. Select Bank Feeds, then Bank Feeds Center.
  3. Choose the appropriate bank and locate the payout from the list.
  4. Click the dropdown arrow under the Action column, then Match to existing transactions.
  5. Pick the Last 30 days or the Show all options to modify the displayed transaction period.
  6. Tick the Checkbox for the data that are included in this entry.
  7. Once done, hit Save and add to register.

 

You might also find this article handy: Reconcile an account in QuickBooks Desktop. It can help you reconcile your accounts accordingly once you're ready to do so.

 

Drop by again to this thread once you have follow-up questions about linking multiple transactions to a single bank entry. We're always here to ensure you're taken care of.

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

Need to get in touch?

Contact us