cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Contributor *

Correcting bank feed matches

Ok here goes.  I hope I can correctly describe what I did and not make it sound as dumb as what I think it is.  I had a lot trouble getting my bank to accept the bank feed option and so I just stopped using that option.  But, instead of just leaving the bank feed option and doing manually what should have been done, I went ahead and did the automatic matching thru bank feeds.  It matched some correctly but most of them were not done correctly.  Now I have all these matches that are in the system that I need to correct but do not know how to delete them.  I am wondering if I should start over from the first of the year since this was the time I am using QB for my accounting.  But if I do,  how do I get the payroll switched to the new company file?

Sorry for the long text.

Solved
Best answer 06-29-2019

Accepted Solutions
Moderator

Re: Correcting bank feed matches

I've read your thread and I want to share my thought about this, 3268.

 

Your main concern is that most of the banking transactions were incorrectly matched to the existing ones in QuickBooks.

 

Once you have approved the matched transactions and get out of the same page, we can only undo it directly through your Chart of Accounts. Undoing it won't put back the banking transaction to your Bank Feeds.

  1. Click Lists at the top menu and select Chart of Accounts.
  2. Double-click the bank account and look for a transaction with a lightning bolt icon.
  3. Remove the lightning bolt icon and click anywhere.
  4. Click Yes to save the changes.

The steps that LilyC provided on the earlier response is only applicable if you haven't left the Bank Feeds Transactions List window. You can also use this article for reference: Unmatch or Move Bank Transactions After Reviewing Them.

 

Meanwhile, importing a WebConnect file is the only alternative to get your banking transactions back to the Bank Feeds. The information about this was already provided by RenjolynC and AdrianRose_A.

 

Since your bank doesn't offer WebConnect files, I'd recommend doing any of the following:

  • Manually enter the transactions that were not yet added in your QuickBooks register.
  • Reconcile the affected account.

You can also reach out to your accountant to see if they have other options.

 

Feel free to drop by again if you have more questions.

7 Comments
Anonymous
Not applicable

Re: Correcting bank feed matches

Hello, @3268.

 

I'm here to help share some insights about correcting your bank feed matches.

 

You can undo all the Matching in Banking to correct the matches. Then, reconcile the Bank Register on a weekly or monthly basis. 

 

Here's how you can remove multiple deposits you've approved from the Transaction list window:

 

  1. From the Banking menu, select Banking Feeds.
  2. Select Bank Feeds Center.
  3. On the left pane, select a specific bank account.
  4. Click the Transaction List button.
  5. On the Transactions List window, mark all transactions you need to undo.
  6. Click the Batch Actions drop-down and select Ignore.

Should you need related articles about your bank feed transactions, you can check this article: Add and match Bank Feed transactions.

 

If you have other questions about matching bank transactions, do let me know. I'll be here to keep helping.

Frequent Contributor *

Re: Correcting bank feed matches

Ok LilyC, I must have really messed up royally as I do not have any transactions listed.  Now what do I do?

QuickBooks Team

Re: Correcting bank feed matches

We have a feature called WebConnect, 3268,

 

This tool is used to import transactions that were missing or deleted from the Bank Feeds section. To download the transactions, please make sure to check with your bank if they support the .qbo file. 

 

Once you have the file, we can temporarily disconnect the account from your online bank feeds.

 

Here's how:

  1. Click List located at the top.
  2. Select Chart of Accounts, and find the account to disconnect.
  3. Right-click on the account and select Edit Account.
  4. Click the Bank Feeds Settings tab.
  5. Choose Deactivate All Online Services.
  6. Click Save and Close.

Then, import the transactions by following the steps in this article: Import web connect (.qbo) files.  Finally, set up the bank account again.

 

If your bank does not support the .qbo file, then you'll need to find a converter online. 

 

Feel free to leave a reply on this thread if you need anything else. Thanks. 

Frequent Contributor *

Re: Correcting bank feed matches

One question:  If my bank accepts bank feeds into QB wouldn't that mean that they support the .qbo file?  Or am I just showing just how little I know about QB?  lol

Moderator

Re: Correcting bank feed matches

Hello there, 3268.

 

When you connect your bank to QuickBooks (Bank Feeds), it doesn't guarantee that they also support the WebConnect (.QBO) file. It'd be best to verify this with your financial institution.

 

After verifying this information, you can already import the file to QuickBooks. You can check these articles to know more about WebConnect:

Feel free to post here again if you need my help. Have a great day!

Frequent Contributor *

Re: Correcting bank feed matches

Ok, so I contacted my bank and they do not offer support thru WebConnect .QBO files. Is there something else that I can try to fix my problem?
Moderator

Re: Correcting bank feed matches

I've read your thread and I want to share my thought about this, 3268.

 

Your main concern is that most of the banking transactions were incorrectly matched to the existing ones in QuickBooks.

 

Once you have approved the matched transactions and get out of the same page, we can only undo it directly through your Chart of Accounts. Undoing it won't put back the banking transaction to your Bank Feeds.

  1. Click Lists at the top menu and select Chart of Accounts.
  2. Double-click the bank account and look for a transaction with a lightning bolt icon.
  3. Remove the lightning bolt icon and click anywhere.
  4. Click Yes to save the changes.

The steps that LilyC provided on the earlier response is only applicable if you haven't left the Bank Feeds Transactions List window. You can also use this article for reference: Unmatch or Move Bank Transactions After Reviewing Them.

 

Meanwhile, importing a WebConnect file is the only alternative to get your banking transactions back to the Bank Feeds. The information about this was already provided by RenjolynC and AdrianRose_A.

 

Since your bank doesn't offer WebConnect files, I'd recommend doing any of the following:

  • Manually enter the transactions that were not yet added in your QuickBooks register.
  • Reconcile the affected account.

You can also reach out to your accountant to see if they have other options.

 

Feel free to drop by again if you have more questions.

Need to get in touch?

Contact us