cancel
Showing results for 
Search instead for 
Did you mean: 
girlie16
Level 1

Banking Expenses not matching

Hi there,


Need some help on identifying what seems to be the problem. I did some research of what could be the reasons why bank transactions not matching. However, seems like most of the bullet points doesn't resolve my issue.

 

We had set up a Sweep Account to match our expenses vs what has been taken out from our bank account. But upon matching both entries, the expense transaction doesn't show on the lists of expenses. 

 

Attached are the screenshot of what I'm trying to match. Amount may be different but it should somehow show on the selection of all the lists of what i can match (even if its for multiple transactions)

 

Hope I'm making sense lol. 

 

Thank you

 

Solved
Best answer August 16, 2019

Best Answers
Ryan_M
Moderator

Banking Expenses not matching

Hi @girlie16,

 

Thank you for your reply, as well as the screenshots you provided.

 

Let's consider the images you provided as an example of what I mentioned earlier. Your recorded transaction amount is $152, while the downloaded transaction you're trying to match is $112.

 

As stated above, the screen where you can match recorded transactions will only show those with amounts that are equal to or lower than your downloaded transaction. This isn't an ongoing issue with the product, it's the normal operation of QuickBooks Online.

 

To put it to practice, you can edit the $152 transaction and split it into 2 parts. Say, one part is $112 and the other is $40. Retain the same transaction date to ensure they will appear. If you try to find a match for the $112, I'm sure you'll see the edited transaction on the list.

 

Don't hesitate to leave a comment below if you have other questions. I'll get back to you as soon as I can.

View solution in original post

9 Comments 9
David-212915
QuickBooks Team

Banking Expenses not matching

Welcome to the Community, @girlie16. I'm here to help with matching expenses. 

 

Just to clarify, are the transactions that you're trying to match to contained in the register of the account that is connected to the bank feed? The reason for asking is that you're only able to match to expenses contained in the connected account's register. 

 

Additionally, if the transactions have already been matched or reconciled, they will be unable to match to downloaded transactions. For an overview of matching transactions, please see the following article: Match and categorize your downloaded bank transactions.

 

I'll be keeping an eye out for your response and look forward to getting to the bottom of this. Take care.

girlie16
Level 1

Banking Expenses not matching

Hi David,

 

Yes it is. The expense entry i recorded manually is connected to the same bank account register where I'm trying to reconcile the transaction. 

 

I noticed that it has been an ongoing issue that I couldn't match the "expense" over what was deducted from the bank account.  The expense/bill if you may want to call it  hasn't been reconciled previously or matched to other bank transaction. 

 

And I noticed that this only happens when I'm trying to match Expenses/Bill vs Spent (Bank Register). 

 

The attached image i sent from my first inquiry shows that the entry has never been reconcile before not even excluded. I hope you can help me on this. 

 

 

Thank you.

David-212915
QuickBooks Team

Banking Expenses not matching

Hello again, @girlie16. Thanks for providing that clarification since it helps to rule out some of the possible reasons.

 

Based on the screenshot that you included, it looks like the date range is for only June. I just wanted to mention it since that can cause transactions to not appear. 

 

To ensure that I'm on the same page, there is a discrepancy between the amounts, correct? If so, it would be helpful to know approximately how large the discrepancy is. 

 

I'll be waiting on standby for your response. Have a good one.

girlie16
Level 1

Banking Expenses not matching

Hi there @David-212915 uhm I don't think the amount should be a problem (I think). Based on how I match the transactions regardless of the amount, all expenses should show on the lists. And yes the date range is only for June as I want to filter out all expenses for June. 

 

 

Ryan_M
Moderator

Banking Expenses not matching

Hi @girlie16,

 

Allow me to join this conversation and clear things up for you about matching downloaded bank transactions.

 

The amount on your manually recorded transactions matter. It's normal for QuickBooks Online to only show transactions that are equal or lower than the amount of the downloaded transaction you're trying to match. What I'm saying here is, you can match a single downloaded transaction to many recorded transactions. On the other hand, matching several downloaded transactions to a single recorded transaction is a feature that's unavailable at this time.

 

If your situation is the second one I mentioned, you can exclude the downloaded transactions that supposed to match to a recorded transaction. This is fine and you won't have any issues with reconciliation since your bank account's balance will still be the same as your actual bank balance.

 

In case you made a mistake by incorrectly matching a transaction, you can still undo it and then put it back to the For Review tab. Details of which are located in this article: Unmatch or move bank transactions after reviewing them.

 

I'll be around if you ever need more help. Leave your question in the comments and I'll get back to you.

girlie16
Level 1

Banking Expenses not matching

Hi there @Ryan_M  and @David-212915  thank you for your prompt response.

 

I guess what I'm trying to figure out is why the manual entry isn't showing up on the lists of matching transactions. As far as i know it should show up. 


If we'll look at the first example below, this is what I manually entered on QB. This has not been previously reconciled or excluded.2.png

 

And on the second image, the entry isn't showing on the lists. 3.png

 

Am not sure why this is happening and it has been an ongoing issue. The amount of what I'm trying to match doesn't matter (at least for me) since i can override whatever is in excess of the amount to be reconciled.

 

Hope to hear from you soon.

 

Thank you.

Ryan_M
Moderator

Banking Expenses not matching

Hi @girlie16,

 

Thank you for your reply, as well as the screenshots you provided.

 

Let's consider the images you provided as an example of what I mentioned earlier. Your recorded transaction amount is $152, while the downloaded transaction you're trying to match is $112.

 

As stated above, the screen where you can match recorded transactions will only show those with amounts that are equal to or lower than your downloaded transaction. This isn't an ongoing issue with the product, it's the normal operation of QuickBooks Online.

 

To put it to practice, you can edit the $152 transaction and split it into 2 parts. Say, one part is $112 and the other is $40. Retain the same transaction date to ensure they will appear. If you try to find a match for the $112, I'm sure you'll see the edited transaction on the list.

 

Don't hesitate to leave a comment below if you have other questions. I'll get back to you as soon as I can.

joey604
Level 1

Banking Expenses not matching

Hello, I have the OP's same issue.

 

I made 2 separate transfers to settle 1 expense. 

 

When trying to match the downloaded transactions (2 separate payments) there is no expense in the list. As you mentioned, it will only find a match if the amount is equal or lower. 

 

What I don't understand is a person would never pay above the amount so why would the system not show me a match that is higher than the downloaded transaction?

Secondly, even though there is no match, shouldn't the the system let me view ALL expenses so I can match manually? Currently it won't even show any transaction regardless of the amount/name/date/etc. 

RenjolynC
QuickBooks Team

Banking Expenses not matching

Thanks for chiming in this thread, joey604.

 

Here are the following situations why you're unable to match your transactions in QuickBooks Online:

  • Transactions has been previously matched to another downloaded transaction.
  • Transactions were not entered using the same bank account.
  • The transaction are entered manually in QuickBooks could have a different number, amount, date or payee from the downloaded expenses.
  • Transactions are already reconciled.

Let’s try using the Find Match option and search for the possible match by following these steps:

 

  1. Go to Banking or Transactions on the left panel.
  2. Click the Banking tab.
  3. In the For Review section, select the transaction you want to match and click the Find match radio button. 
  4. In the Match Transactions window, select the Date and if you see any possible matches, put a check mark on the transactions.
  5. Click Save.

Once done, you can find the transactions in Categorized or In QuickBooks tab.

 

For more information about the process, you can check out this article: Categorize and match online bank transactions in QuickBooks Online.

 

Please let me know if you're able to match the transactions. I'll be right here to help you out again.

Need to get in touch?

Contact us