cancel
Showing results for 
Search instead for 
Did you mean: 
bdental
Level 3

Bank feed: match to existing transaction window error

WQb pro 2017 desktop

im posting two pictures

one shows online YouTube video screenshoot with proper function.

second shows my match to existing transaction window with my comment.

intuit tech support can’t help me as I don’t have paid support.

i tried to resolve once when I had paid support but tech said nothing is wrong

something is wrong

 Trouble posting the pics

i try in separate posts

50 Comments 50
bdental
Level 3

Bank feed: match to existing transaction window error

A6C48FCB-67AA-418D-ABF6-CFF2470E5F55.jpeg

bdental
Level 3

Bank feed: match to existing transaction window error

E2486DD3-F8B9-4F57-B62F-6285BC27EBF2.jpeg

qbteachmt
Level 15

Bank feed: match to existing transaction window error

The screen you show indicates everything entered into that Bank account is also already Reconciled, for the radio button you selected = last 30 days.

 

Either this is a New Entry for you; or, you made yours in the wrong account; or, change the radio button to All, because perhaps you dated yours wrong or into the future.

 

If you never entered the payment into banking already, there is never a possible Match. Do you typically use match To Existing Transaction?

bdental
Level 3

Bank feed: match to existing transaction window error

Here’s a pic of same field with choose show all083876E3-E757-443B-90BF-A8E5C65D2397.jpeg

bdental
Level 3

Bank feed: match to existing transaction window error

Here’s a pic of previous field that shows many matched transactions AED3E041-E0F2-42D4-A7D9-8F132F6A9657.jpeg

bdental
Level 3

Bank feed: match to existing transaction window error

Here’s previous screen with many matched transaction20500AEC-15E4-44B9-A67E-8D8366AC4935.jpeg

bdental
Level 3

Bank feed: match to existing transaction window error

Sorry for duplicate post

I get around the feature but often I will have entered two deposits that i enter into ledger.  The bank statement has the two deposits added together.  I discover this and i would like to match my separate deposits to the bank statement deposit.  I don’t think I’m doing anything wrong but if you can help found out how to fixit much oblige.

 

GarlynGay
Moderator

Bank feed: match to existing transaction window error

Hello bdental,

 

Let's try to configure your Internet Explorer's connectivity. It's possible that it wasn't properly set up to connect with QuickBooks. That's the reason why you can't see new bank transactions in the Bank Feed Center window.

  1. In Internet Explorer, select the Gear icon at the top right and then choose Compatibility View settings.
  2. You can also go to the Tools drop down (or press Alt+T on your keyboard to access the Tools option).
  3. On the Compatibility View settings screen, check the Display all websites in Compatibility View box and click Close.

Try to close your QuickBooks, then open it again. Go back to the Bank Feed Center window. If you can't still see new transactions, can you tell me what is the name of your bank? I can check my resources to see if there has been any reports similar to yours. 

 

Thanks in advance! 

bdental
Level 3

Bank feed: match to existing transaction window error

Tried compatability view protocol with no success.  Also typed long response that didn't get saved.

To clarify the problem is not that bank feed transaction don't get downloaded or seen.  The problem is ledger transactions are not listed to be matched.

I think it is win 10 or some problem with the size of my monitor not matching with quickbooks view

bdental
Level 3

Bank feed: match to existing transaction window error

See the picture I posted where I hand wrote with my ipad?

That window is messed up.  The text is truncated.  I can't see the last line but I can see the top part of the letters.  Why does intuit not want to investigate this bug?  I think it has to do with the size of my monitor or windows 10. 

JessT
QuickBooks Team

Bank feed: match to existing transaction window error

Hi bdental,

 

I agree with qbteachmt, you're existing transactions could be reconciled or recorded in a different account. This why you can't see them as matching transactions.

 

Please open your "chk... (based on screenshot)" account and check the transactions you want to match. If they have a check mark in the Check column, they are reconciled. If you can't see them in there, they're probably posted in a different checking account. If these are payments, you want to make sure you create them as payments so they show as matching transactions.

 

Please go back to this thread if you need further assistance.

qbteachmt
Level 15

Bank feed: match to existing transaction window error

It has nothing to do with internet. This is a Desktop tool. That is not a Web Page being displayed.

 

The screenshot showing Yellow/Mustard color, the transactions are not Matched. They are REV = waiting for review. If you see nothing to Match to, then you go to the Banking perspective of your register, to understand that condition. It states 9 are New, and there is a little scrollbar on the right, so that you Scroll through those 9. You either assign what they are, because they are new to you, too. Or, you want to use Add More Details, because these do not exist as Banking, but you have other activity in QB that this deposited amount relates to.

 

"The bank statement has the two deposits added together.  I discover this and i would like to match my separate deposits to the bank statement deposit."

 

You do this using Undeposited Funds; example: Two Sales Receipts, each flow to UF. Then, you can use the far right option to perform that action = Add More Details. Then, you get a new screen to see the UF tab and the Open Invoices tab, so that you can Match to Open Invoices (if that is payments you did not already process) or Match to transactions in transit, waiting in UF.

 

Please see my screenshot.

qbteachmt
Level 15

Bank feed: match to existing transaction window error

Let me clarify one more thing:

 

Match to Existing Transaction is trying to match a Banking transaction from the download to the Banking transaction that already exists.

 

Add More Details is the tool for "matching" to a transaction type that is not banking already.

bdental
Level 3

Bank feed: match to existing transaction window error


@qbteachmt wrote:

Let me clarify one more thing:

 

Match to Existing Transaction is trying to match a Banking transaction from the download to the Banking transaction that already exists.  I thought Match to Existing Transaction is when you have transactions that you downloaded via the bank feed function that dont match any transactions you have entered into your ledger at "home".  As you can see in my example there are 255 transactions that "automatched" meaning the software was able to match bank statement transactions them to existing "home" transactions in my ledger that I previously entered manually so that I don't have to tediously check them off as matches and go thru the whole statement the traditional way. When you use the bank feed function the whole idea is that quickbooks is able to "get your bank statement for you and evaluate if the transactions in the bank statement match what you have entered previously.

Match to existing transactions is designed to manually let you match transactions that quickbooks can't because the match isn't obvious.  My problem is that the software function for this doesn't work.  I don't see how I should get a screen that truncates the text to where it is not even visible.........barely I can see it.  Is that normal?

Forgive me as I'm trying to understand and I can live life without this function but it is difficult because there is still a question that perhaps the software is functioning properly and I just don't know how to use it.  It is not concievable that quickbooks is supposed to show truncated text in a window that is 80% gone.

 

Add More Details is the tool for "matching" to a transaction type that is not banking already.


 

bdental
Level 3

Bank feed: match to existing transaction window error

A77BD217-00C2-4F8F-9972-3EA716BF17F3.jpeg

bdental
Level 3

Bank feed: match to existing transaction window error


@qbteachmt wrote:

Let me clarify one more thing:

 

Match to Existing Transaction is trying to match a Banking transaction from the download to the Banking transaction that already exists.

 

Add More Details is the tool for "matching" to a transaction type that is not banking already.

Could you clarify this statement more?  "not banking already".  In the past there was no quickbooks, no excel, no lotus 123.  We had bank accounts and we had checkbook ledgers.  Nowadays I think the young folks don't bother with data entry of their transactions.  To clarify when they buy somthing from amazon they don't record it in any ledger.  They assume it will be recorded by amazon, their creditcard company etc.  It is 99.9 % of the time.  Old folks like me we record it before hand and we confirm or reconcile our books with the banks books......credit card books etc. monthly via a statement from the bank etc.

I may blow off the data entry thing alltogether because most of the time there is no fraud.  Lots of work.  Sometimes there is fraud however.

 

So the terminology that is used confuses me.

If you were born before 1990 I think you balance bank statements by matching what you already have to what your bank has.  So enough of my rant.

 

Add More Details is the tool for "matching" to a transaction type that is not banking already.

So I disagree with this statement.  Add more details is a tool to clarify a transaction that occurred in the account but there is not a match and the quickbook user knows it did occur but they should add more details because the downloaded bank transaction has no category etc for accounting purposes.


 

qbteachmt
Level 15

Bank feed: match to existing transaction window error

If you already have the transactions in your system, because you made them as you work, then the Match To Existing, or the Auto-Match, are finding what already exists in Banking in your QB file. These functions are looking for Uncleared transactions in that Checking account or that Credit Card Account, that are there = exist.

 

The function for "Add More Details" from the far right of the entry where you see a Downloaded transaction that you get to REV = review, or assign here in the banking feeds listing, or select Ignore, is because there is no Existing entry in Banking in QB. I shows how this function allows you to Match to the Open and Unpaid Invoices, or to amounts I will have already processed via Receive Payment or using Sales Receipts that are amounts sitting in Undeposited Funds. In other words, one stage Prior to being a Banking transaction in my file, I can match the Downloaded transaction to one of the other Transaction Types, such as Customer Sales. That way, I am able to link that this Banking deposit is Settlement from sales.

 

This is my Specific Monthly Example: I have 41 monthly invoices paid by One ACH that I initiate at the bank's secure site. I wait until this comes into Banking center download, then I use Add More Details to allocate it to each invoice that is an ACH customer. I do not use Receive Payment or Make Deposit myself. I wait for the result of my own work to appear in the download.

 

These are Two different Functions:

 

Match to Existing = want to already find it in Banking. If you see it in your bank account register view, then this function also finds it, as long as you have not already marked it as clear during a reconciliation. If you already Reconciled this account, you use the far right selector for that row waiting for REV in the banking download and choose Ignore because you don't need this entry at all. You already did that work.

 

Add More Details is how you manipulate the banking downloaded entry relative to other transactions in your file, such as you still have Open Invoices and this is a deposit of customer payment against the invoice(s) or this check spending needs to be matched to your open AP bill.

 

I am simply explaining how Intuit uses the words. I teach this as "learning QB-ese."

bdental
Level 3

Bank feed: match to existing transaction window error

Qbteachmt,

thank you for tryping to  help me.

 

https://m.youtube.com/watch?v=FcwBOiZDJx8

 

Im going to reference this YouTube video in which the author does an excellent job in explaining how you can use the match to existing transaction function.  

Im also goung to reference screenshots from his video because I can not get my Quickbooks to duplicate what he is doing.  So far, despite suggestions to the contrary I feel strongly that either my Quickbooks has a flaw or I am neglecting some setting that needs to be changed to make it function properly

In this QuickBooks training tutorial, you will learn how to match transactions that have already been entered into Quickbooks with transactions that have bee...
bdental
Level 3

Bank feed: match to existing transaction window error

37132315-18E9-48B0-B28D-A22F57101739.jpeg

JamesDuanT
Moderator

Bank feed: match to existing transaction window error

Hello bdental,

 

Based on the tutorial video, the author's Bank Feeds is set to Express Mode. You can follow these steps to set your QuickBooks, too.

  1. Click Edit at the top menu and select Preferences.
  2. In the Preferences window, select Checking and go to the Company Preferences.
  3. Under the BANK FEEDS section, select Express Mode.
  4. Click OK.

From there, you should be able to follow the tutorial video.

 

Meanwhile, when selecting a downloaded bank transaction in the Transaction List window (NEED YOUR REVIEW), you'll need to click the Select button that is associated to the said transaction. Then, you can choose Match to Existing Transaction. You can also refer to the screenshot below.

 

The author purposely entered an amount that differs a penny from the downloaded transaction. This is to show you how QuickBooks works when matching your bank transactions.

 

If you're  referring to something different, please let us know.

bdental
Level 3

Bank feed: match to existing transaction window error

James thanks for your reply.

I'm trying to show that there is something wrong with my quickbooks.  I'm already in express mode view.  I put to the said youtube video because it shows a correct working qb desktop.  Mine is broken for this feature or I haven't set it correctly.  Please view the whole thread and compare my qb desktop 2017 window to youtube video qb desktop window that shows proper match to existing transaction window.

Others seem to think there is nothing wrong with my quickbooks and the problem is the user ME.

I contend that my window "match to existing transaction " in the band feed section DOES NOT SHOW UNCLEARED REGISTER TRANSACTIONS AS IT SHOULD.  INSTEAD IT GIVES NO REGISTER AND  TRUNCATES THE MESSAGE "The Quickbooks transaction amount and downloaded amount must match.  When you click "Confirm Manual Match" the amount of the QuickBooks transaction will be changed to the downloaded amount".    Is it proper for qb to show text that is not legible and cutoff ?

Anonymous
Not applicable

Bank feed: match to existing transaction window error

Hi, bdental.

 

The bank feed section won’t show uncleared transaction due to the following reasons:

  • Transactions were not created in QuickBooks Desktop.
  • Transactions created in QuickBooks were already paid manually (you can review the transactions in your register and check if there are already payments associated with them).
  • Data damaged (We can run the verify rebuild utility to locate the cause and have the system fix it).

To fix the cut message you’re getting, we can repair the software through the steps provided in this article: https://quickbooks.intuit.com/community/Getting-Started/Repair-QuickBooks-Desktop/m-p/201490.

 For additional information about adding and matching bank feed transactions, please check this article: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/Add-and-match-Bank-Feed-transactions/...

Visit us again anytime you have questions about Quickbooks. 

qbteachmt
Level 15

Bank feed: match to existing transaction window error

This sentence makes no sense: "Transactions created in QuickBooks were already pain manually (you can review the transactions in your register and check if there are already payments associated with them."

 

The reason that doesn't make sense is that this Is The Banking. These Are the Spending transactions. There is nothing related to the issue of "associated payments" because Banking is the payment being discussed. It does not matter if the Banking is a check, a paperless check such as ACH, debit card, EFT, a Bill Pay, etc. Either this banking entry exists in the File, and the Banking Download Function then can find it to match; or that banking entry does not already exist in the File.

 

The Banking Center download Feeds is like the front porch. That is not the Data File, but asking, "Can I come in (be added to this file), or does something like me already exist?" And if it doesn't exist as Banking, did you need to match it to one of the transactions types that are the preliminary phase to banking, such as an open bill or an open invoice, or something you already put in UF, awaiting banking settlement? Or, it doesn't exist at all, so the Transaction on the Porch is New to you.

bdental
Level 3

Bank feed: match to existing transaction window error

Intuit Help System

Lightning Bolt = this transaction has been Verified by the Electronic connectivity or Banking Feeds download process.

 

Qbteachmt, I believe you wrote this in relation to reconciliation symbols help question.

Can you elaborate on this?  We spend considerable time with data entry, bill pay, reconciliation and I've wanted to reduce the time but no great solution so far although bank feed downloads help.

Trying to find solution to original post I discovered that many transactions in my bank ledger do in fact have the lightning bolt.  I don't understand this.  Until about 6 months ago the only way that I"m aware of my account connecting electronically was with payroll updates.  I've researched a way to avoid all the data entry primarilary with credit card expenses entered into quickbooks credit card accounts but so far again no big changes other than trying apps like Mint to see if they could help.

Specifically how is my quickbooks desktop  2017 verifying a transaction I manually made into my bank account ledger with the bank account data?  Typically when I go to the electronic bank account i tell it that i only want to download the statement but the last time I think i mistakenly let it download a greater number of days.

thanks

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