cancel
Showing results for 
Search instead for 
Did you mean: 
deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

 
Solved
Best answer April 25, 2019

Best Answers
JonpriL
Moderator

The "Matching Transactions" screen is missing some of my open invoices.

Hi @deanna6,

 

As I've checked on my resources, we have a reported issue from other users like you who are unable to match your downloaded transactions to foreign currency open invoices.

 

Thus said, I'd recommend contacting our Customer Care Support. This way, you'll be added to the list of the affected users and will receive updates through your email.

 

To contact our dedicated support:

  1. Go to the Help icon.
  2. Select Contact us.
  3. Enter Unable to Find Match in the How can we help? field.
  4. Click Continue.
  5. Choose Start messaging or Get a callback.

In addition, here's an article you can check to learn more about contacting our support: Contact the QuickBooks Online Customer Support Team.

 

Please let me know in the comment section below if you have any other questions. I'll be always around to help.

View solution in original post

42 Comments 42
Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

Check your date filter and make sure the invoices in question have not already been matched

deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

The invoices aren't matched and I've checked the date 5 times.

 

Rose-A
Moderator

The "Matching Transactions" screen is missing some of my open invoices.

Thanks for getting back to us, deanna6.

Allow me to take over and help you get your invoices matched in QuickBooks Online.

 

When matching invoices within the banking section, QuickBooks Online looks for open invoices. If it's not finding any open invoice, you can open the payment to expand the transaction and use the Find Match option to search for the transactions.

 

Here's how:

 

  1. In the For Review tab, select a transaction.
  2. Choose Find Match.
  3. Search and select for the open invoice.

    z.PNGx.PNG

If you're still unable to find the open invoices, you may want to review the transactions and make sure that the invoices are not reconciled or cleared.

 

You can get more details in these articles:

 

Let me know how it goes by leaving a reply below or if you have additional questions about matching transactions in QuickBooks Online. I'd be happy to help.

deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

I already did that.

That's where the invoices aren't showing up.

 

Match Transaction Screen.PNG

Open Invoices.PNG

Here are the screenshot of the "Find Match" screen, then another screenshot of that Customer showing that the invoices are open/unmatched, but aren't in the "Find Match" Screen

Charies_M
Moderator

The "Matching Transactions" screen is missing some of my open invoices.

Hello there, deanna6.

 

Thanks for the screenshots you provided. It helps a lot to identify the possible cause of missing transactions while trying to match transactions.

 

Upon looking into the screenshots, I've noticed that the due date of your open invoice is 04/30/2019 while the filtered date from the Match transaction screen is set from 01/01/2017 to 04/27/2019. This may be the reason why you're not seeing the open invoice. To resolve this, you can change and extend the date until 04/30/2019.

 

Here's how:

  1. From the Banking tab choose a transaction that you want to find a match.
  2. Click the Find match radio button.
  3. Change the date To 04/30/2019.
  4. A list of invoices will show and you can choose a match.
  5. Click Save.

You should now be able to see those open invoices when trying to Find Match in QBO. 

 

That's it. If I can assist you with anything else or additional questions about this, feel free to leave me a reply.

deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

They still aren't showing up.

I even tried typing the Invoice Number in the for the search, but it just can't find these invoices.

 

Rasa-LilaM
QuickBooks Team

The "Matching Transactions" screen is missing some of my open invoices.

Thanks for your response, deanna6.


I appreciate you following the necessary steps to find the missing invoices. Allow me join the conversation and help get around the issue.


Ideally, the resolution provided by my colleagues should fix this. Now, let’s try some new ones to see if the issue is with the sales template.


To start off, delete and recreate the invoices. After creating them, go back to the Banking page to see if they appear.

 

To delete the transactions, you'll have to go to the All Sales page and locate them. Here's how:

 

  1. From the Sales panel, choose All Sales.
  2. Find the invoices you're working on.
  3. Under the Action column, click on the drop-down and select Void or Delete.

 

To enter invoices:

 

  1. Click on the Plus icon.
  2. Under Customers, choose Invoice.
  3. Enter the customer's name
  4. Fill in the necessary fields.
  5. Click on Save and close/Save and new.


If yes, you can now match them. However, if the issue persists, we’ll have to determine the root cause of the problem.


We don't want your account to be displayed here in the Community for security purposes. Since we need to collect sensitive information to verify an account, I recommend you contact our QBO Care Team.

 

They have tools to check the transactions and determine the root cause of the issue. Once identified, they’ll guide you through the steps on how to fix the problem.

 

To manage your time, you can either sign up to our callback process or message our support agent. The most up to date contact information can be found here:

 

  1. In your QBO company, go to Help at the top.
  2. Click on the Contact Us link.
  3. enter contact support in the field box.
  4. In the Ways we can connect with us section, select Message an Agent or We’ll call you.


This should help you move forward. Stay in touch if you have any follow-up questions or concerns. I’ll be right here to assist further.

 

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@Rasa-LilaM wrote:

 


To start off, delete and recreate the invoices.

 

 


Ridiculous advice.  

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@deanna6 wrote:

 

Here are the screenshot of the "Find Match" screen, then another screenshot of that Customer showing that the invoices are open/unmatched, but aren't in the "Find Match" Screen


In the screen shot the amount deposited in the bank is in USD, yet the invoices are in Euro.  

 

It is looking for ONE invoice which converts to approx USD 361. The only one seems to be the old invoice 5764. Not sure where it is but it must be further down the screen. 

 

It seems the payment is for more than one invoice.  So what you must do is create a Receive Payment where you pick the invoices being paid.  In the exchange rate box, overwrite the populated rate and enter the total EUR amount (as shown on top right) / actual USD amount received, to calculate the actual exchange rate and force the USD amount to agree exactly.  Then in Banking the match should be found initially; it usually is not but when you  click Find Match, then the Foreign Currency option, it will be found.

 

Foreign currency in Banking is full of unexpected behavior

 

 

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

@Rasa-LilaM 

 

Fully agree with Malcolm, this is terrible advice.

 

Deleting and re-entering the invoices is not the answer. First of all, the filter in the screenshot is set to "Open Invoices", when it should be set to "All Invoices" and the date range should be narrowed down to the original invoice date range. Second, if there is a difference in currencies this opens up another set of questions. One, are you using a third-party application of some kind? Two, what currency did the transaction come through your bank feed under? Did you receive payment against the original invoice to undeposited funds in the currency amount that it was deposited in so that you can accurately find and match the transaction? You are supposed to receive payment to undeposited funds first, then create a deposit that "matches" the amount that comes into your bank feed, not just try to find invoices to apply deposits to within the bank feed. You need help from an Accountant, in my view. 

deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

I've done the filter under "All",

I've typed in the specific invoice number, I've expanded the date range to include several years just to see if the open invoices I have would show up.

 

Nope, not using a third party system.

No payments have been received against the invoices. 

 

I had a payment like this last month, and there were no problems matching them up, but suddenly this month the invoices are not showing up in the "Find Match" screen.

It's a system problem not an Accounting one.

 

But thanks for your insight! I will just do a work around because it's just getting annoying.

JonpriL
Moderator

The "Matching Transactions" screen is missing some of my open invoices.

Hi @deanna6,

 

As I've checked on my resources, we have a reported issue from other users like you who are unable to match your downloaded transactions to foreign currency open invoices.

 

Thus said, I'd recommend contacting our Customer Care Support. This way, you'll be added to the list of the affected users and will receive updates through your email.

 

To contact our dedicated support:

  1. Go to the Help icon.
  2. Select Contact us.
  3. Enter Unable to Find Match in the How can we help? field.
  4. Click Continue.
  5. Choose Start messaging or Get a callback.

In addition, here's an article you can check to learn more about contacting our support: Contact the QuickBooks Online Customer Support Team.

 

Please let me know in the comment section below if you have any other questions. I'll be always around to help.

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

I understand your frustrations. When you go to the customer transactions, can you find the invoice? If so, try receiving the payments to undeposited funds first, then create a deposit that matches your bank feed deposit.

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@deanna6 wrote:

 

 

 

 

 I will just do a work around because it's just getting annoying.


No work around needed. Did you follow my suggestion?

deanna6
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

Already did everything I could.

 

Someone above already mentioned other people have reported this problem.

It is a system error and are working on the problem, not what I have or haven't done.

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@Malcolm Ziman wrote:

@deanna6 wrote:

 

 

 

 

 I will just do a work around because it's just getting annoying.


No work around needed. Did you follow my suggestion?


In any case it's better to manually create a Receive Payment when you have more than one invoice in a deposit, because when you use the matching in the bank feed it bizarrely creates one deposit transaction for every invoice, which is not what happened, and makes it hard to reconcile

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@deanna6 wrote:

 

 

Someone above already mentioned other people have reported this problem.

It is a system error and are working on the problem, not what I have or haven't done.


I have been using QBO for 4 years and it's always been like this. 

 

"Already did everything I could."

Did you follow my suggestion?

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

Agree with Malcolm on this as well. I do not believe that this is a current technical issue that will be resolved. It is better to receive payments against invoices to undeposited funds and then create a deposit that matches the amount in your bank feed from undeposited funds. This is the only thing that will work in this case.

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@Regina_Lend_A_Hand_Accounting wrote:

Agree with Malcolm on this as well. I do not believe that this is a current technical issue that will be resolved. It is better to receive payments against invoices to undeposited funds and then create a deposit that matches the amount in your bank feed from undeposited funds. This is the only thing that will work in this case.


 

No, undeposited funds not necessary. Put it directly to the bank account and force the amount as I described above

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

@Malcolm Ziman 

 

If there is more than one invoice payment in the bank feed deposit amount why would they not receive the invoice payments to undeposited funds first?

 

How would they match the total bank feed deposit amount otherwise?

Malcolm Ziman
Level 10

The "Matching Transactions" screen is missing some of my open invoices.


@Regina_Lend_A_Hand_Accounting wrote:

@Malcolm Ziman 

 

If there is more than one invoice payment in the bank feed deposit amount why would they not receive the invoice payments to undeposited funds first?

 

How would they match the total bank feed deposit amount otherwise?


You only need to use undeposited funds if there are multiple payments in one deposit. Here there is just one payment

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

@Malcolm Ziman 

 

Thanks for clarifying, I'm glad we are on the same page. I must have missed that there was only one invoice payment in the bank feed deposit, for some reason I thought there were multiple payments.

chrismahoney
Level 2

The "Matching Transactions" screen is missing some of my open invoices.

Thank you for this advice, had a very similar issue which I managed to resolve thanks to you.

 

"Delete the invoice…" geez. Couldn't believe what I was reading!

Regina_Lend_A_Hand_Accounting
Level 9

The "Matching Transactions" screen is missing some of my open invoices.

@chrismahoney I'm happy to hear that you resolved your issue without "deleting" invoices. We have some really great ProAdvisors and QuickBooks Team Members supporting this community!
Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us