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

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

 
9 REPLIES 9
Highlighted
QuickBooks Team

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Hello there, @user243598

 

I'd like to ask for clarification. This way we can better help you.

 

Are you trying to match your receipts to your recorded entries in QuickBooks Online? If so, we can use the Find match option to see the matching entries. Here's how:

  1. From the Banking page, select on the transaction.
  2. Select Find match.
  3. From the Show drop-down option, select All.
  4. Choose the date range.
  5. Then, select the entries. 
  6. Click on Save.

If you're trying to reconcile your bank account, you would want to make sure you have a copy of your bank statement. This helps you identify if these receipts are duplicate entries. Then, you can eliminate them.

 

To delete a transaction from the register:

  1. Go to Chart of Accounts and select the bank account.
  2. Select a transaction.
  3. Click on Delete.

To delete an accepted bank:

  1. From the Banking page, go to the In QuickBooks tab.
  2. Select the transaction and click on Undo.
  3. Go to the For Review tab.
  4. Click on Batch actions.
  5. Select Exclude Selected.
  6. From the Excluded tab.
  7. Select Delete.

In case you have mismatched transactions and want to undo to correct them, follow the steps listed in this article: Unmatch or move bank transactions after reviewing them.

 

If you have other questions in mind, share them in the comments below. I'll get back to you as soon as I can

Highlighted
Level 1

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Hello,

 

Think I have the same issue but the answer provided doesn't seem to resolve.

Have receipts loaded/snapped/forwarded from email. Also have bank transactions for those receipts showing but the two are separate & I can't see how/where to match the receipt upload to the bank transaction.

 

First year using QB Self Employed module, hopefully be straight forward once I'm used to it!

 

Kind Regards,

 

Highlighted
Moderator

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Welcome to the QuickBooks family, @BenJones81.

 

I can share some insights about how the receipt forwarding feature works in QuickBooks Self-Employed. When sending the files to our data extraction service, there are four types of information that they check.

 

Here's the list:

 

  • Vendor
  • Date
  • Total
  • Credit/Debit card number (optional)

The matching of the transactions in the system will depend on the forwarded information. If you included the Credit/Debit card number along the process, it should automatically match the transactions from the connected bank.

 

If you haven't provided this information or the bank account isn't connected, we still try to match the receipt against transactions. Once we find identical details, we attach the receipt to the existing transaction. If we're unable to find one, we create a new transaction on your behalf.

 

I've also included some articles in case you need more ideas about the feature like how to export them in bulk, as well as attaching them manually in transactions:

 

Please know that I'm just a post away if you have any other questions. Have a great day ahead.

Highlighted
Level 1

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Thank you!

We have used the email forward & the snap feature on the mobile app which both work to load the receipts. 

 

The part we're struggling with is these now show as a duplicate transaction. eg 1 transaction listed for the receipt, and another listed for the same amount pulled from the bank account.

 

How do we link the receipt to the bank acc transaction? Please don't tell me I need to go in to every single 1 (12 months worth!) to mark one as a duplicate & the re-load a receipt to the other?

 

I'm sure there must be a way to select the receipt and the bank lines to attach together?

Hope that makes sense!

 

Thanks in advance Smiley Happy

Highlighted
QuickBooks Team

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Let me share details on how our data extraction service pull out your receipt information and match them to your bank account transactions in QuickBooks Self-Employed (QBSE), BenJones81.

 

With the receipt forwarding feature in QBSE, receipts are linked to your bank account transactions once they match with the vendor name, date, total amount, and the credit/debit card number (if connected to QBSE).

 

In case one of the required information is missing or we don't find one, the receipts will be classified into the "Needs Action" folder to avoid duplicates. 

 

Once your credit/debit card account is connected to QBSE, your receipts should match to a bank transaction. Since it's not matching, I'd recommend contacting our QuickBooks Self-Employed Support team. They can verify your account details and can check for your receipt's available match so you'll not go through each of them manually.

 

Furthermore, there are several ways on how to enter your transactions in QBSE. You can either add a receipt to an existing transaction or create a new one from a receipt. For the detailed steps, kindly refer to this article: Enter receipts on your QuickBooks Self-Employed. It also has the link about the receipt forwarding feature in the end for further reference.

 

Please let me know if you have other concerns. I'm just around to help.

Highlighted
Level 2

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

I have had this problem and just managed to find a workaround.

I emailed invoices to receipts@quicbooks and these weren’t matched to my payments of them.  Clearly- the invoice date was different to my payment date.  I changed the receipt scan date to the same as my transaction date- QBSE then matched them.

Highlighted
Level 1

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

I am having exactly the same problem and less than amused at what look like replies from Bots rather than real people!

 

Having got into a mess after Quick book imported corrupt bank details without highlighting the issue I spend hours pulling in the missing records manually with CSV files. I then decided to go back to basics and enter my suppliers invoices manually using the expenses section. Now I have loads of transactions for those suppliers in my Bank feed and none of them will match to the original bill/expense I have created. When I check the bill or expense it shows it to be linked to the correct bank transaction but fails to recognise that link under banking 

 

The only solution I have been given by support is to exclude all these records from my bank feed. Which is plain stupid. While appreciating I do have a knack of screwing up software it seems to me there are some major glitches with this online system that need sorting

Highlighted
Level 1

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

If you are reading this, then you are frustrated with the bot-like responses to this issue that are more or less worthless. After doing some digging around and beating my head against the wall, I found out how to make manually make a receipt match a transaction. I am posting these following steps based on the desktop web version of Quickbooks online.

 

Manually Match Receipts with Existing Transactions:

 

1. In the banking area, make sure the transaction has already been reviewed and added. Basically, it should no longer be shown in the "For Review" area. 

2. Now go find that transaction in the banking area under the categorized tab.

3. Open up a new browser tab and copy and paste the URL from the current tab to the new tab. This is important as it will make it easier for you to compare the transaction and the receipt by simply switching tabs versus going back and forth in the system. Now, navigate to the receipts area.

4. Find the receipt that you want to match in the "For Review" area and click on that receipt.

5. A popup window will appear and it should say "No Matches Found." Now click on the link in that popup towards the top that says "< Edit receipt details" and the right-hand column should now display all the details about the receipt.

6. Make sure that the details all match the details of the transaction that you want to match. Switch back and forth between tabs to ensure the bank/credit account, payment date, account category, and total amount all match.

7. Once all this matches, on the receipt popup click the "Save and Next" button in the bottom right. It will bring you to the next screen where it will either find you a match or confirm to you that AI isn't as advanced as they make us believe. If you find a match, great. Match it and move on with life. If not, continue to Step 8.

8. Since no match has been found, click the "< Edit receipt details" link at the top of that popup and it will take you back to the details area. Hover of the preview of the receipt shown on the left and you will see a download icon appear at the top of it. Go ahead and download a copy of the receipt to your desktop.

9. Switch back to the other tab where the transaction is. Click on the transactions blue link that says "Added to: blah blah blah" in the banking area (categorized) and you should see a new popup appear that gives you some basic details about the transaction. In the bottom left of the popup you will notice that there is an area where you can upload an attachment. Go ahead and click on that and attach that receipt that you had downloaded to this transaction and click the "Save" button in the bottom right. It might ask you if you are sure...and just say yes.

10. Now switch back to your receipt tab and you should still be on the receipt details area. Click on the button in the bottom right that says "Save and Next"

11. This time, it should find your match. 

12. Celebrate by taking a day off.

 

If you want to make this a little quicker you can try uploading the receipt to the transaction before you accept it in the banking area "For Review". 

 

I hope this helps. I don't use the mobile app at this time so I don't know what it would take to make it work in that context.

 

Highlighted
Level 1

Some expense receipts will not match with the appropriate transaction from my connected bank account. Manually added receipt and bank are both in QB, but will not match.

Found the same issue  receipts not matching transaction already posted in bank  feeds "for Review"  ( already in "Categorized" tab)  

Work around: 

1-Reviewed receipts  and added any missing detail,  if matched cool  accept move on

2-if not,  save receipt detail ( not matched),  the enter them as expenses

3-Go to bank "Categorized" tab  click and undo the transaction (not matched in the "receipts' that had to be entered as expense)  from bank feed  

4-Return to  for "Review" tab  you should see that they have matched  the "receipts"  posted 

 

Hope it helps