cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
QuickBooks Team

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

7 Comments 7
Highlighted
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.

Highlighted
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.

Highlighted
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.

Highlighted
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. 

 

 

Highlighted
QuickBooks Team

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.

Highlighted
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.

Highlighted
QuickBooks Team

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

Need to get in touch?

Contact us