cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
henryb1
Level 2

Not showing matches - Sales Receipts / Bank Deposits

So, I enter a sales receipt on 30/05/23 for £12.00. There is a deposit into my bank account on the 6/04/23 for £11.82. I want to match the two and resolve it to show 0.18p for processing fees. When I click find match - it doesn't show the Sales Receipt. However, if I click on a different deposit for £33 on the 5/04/23 it does! This seems to be totally hit and miss - sometimes the Sales Receipt shows up to match and resolve, other times not. Any idea why? Or is QB trying to be too clever?

5 REPLIES 5
Ashleigh1
QuickBooks Team

Not showing matches - Sales Receipts / Bank Deposits

Hello Henryb1, thanks for posting on the Community page and for the screenshot, So bank transactions will only ever see things smaller than itself, never larger. You can match one transaction to several, not the other way around. 

henryb1
Level 2

Not showing matches - Sales Receipts / Bank Deposits

Hello Ashleigh1,

Thank you for your reply. However, I regularly have Sales Receipts that are larger than the Bank Deposits and am able to match them as described in my original email. Screen shot attached of a Bank Deposit for £49.05, the Sales Receipt is for £50 - my next move is to toggle the resolve button and then post the commission from the sale into the appropriate account. I just don't understand why I can do this sometimes and other times I can't. 

Rubielyn_J
QuickBooks Team

Not showing matches - Sales Receipts / Bank Deposits

I'm grateful for your continued participation in this thread, and thank you for sharing the screenshot, @henryb1.

 

The sales receipts will be automatically matched with your deposits if the transactions have identical amounts and dates. In case you encounter any issues with matching them, you can refer to the potential causes listed below:

 

  • Verify that the transaction has not been reconciled.
  • Confirm the transaction was entered using the same bank account.
  • Make sure the QuickBooks Online transaction has not been previously matched to another bank-downloaded transaction.
  • If it is a deposit or payment received, make sure it is not on the Bank Deposit page (undeposited).

 

Currently, the process entails depositing the sales receipt into the desired bank account. Subsequently, you would need to include the fee as a negative amount under the Add funds to this deposit section to ensure that the total matches the downloaded deposit.

 

Here's how:

 

  1. Select Bank Deposit from the New (+icon.
  2. Choose the correct bank, then click the sales receipt under the Select the payments included in this deposit section.
  3. Scroll down to Add funds to this deposit, then add the fees/expenses in a negative amount.
  4. Click Save and Close.

 

Once done, proceed with matching the sales receipts and deposits.

 

If you require assistance with any other QuickBooks tasks, I'm just a few clicks away. It would be my pleasure to provide you with further support.

Afrotherapy
Level 1

Not showing matches - Sales Receipts / Bank Deposits

I am having the same issues and its rather frustrating. I don't have any accounts linked to the app and i only use one bank account anyway. I have two transactions on 26.10 and i only see one. I have done new sales receipt for the other but still chant see it on the matching screen :(

MariaSoledadG
QuickBooks Team

Not showing matches - Sales Receipts / Bank Deposits

I completely understand how you want to match the sales receipt to your deposit without issues. Let's make sure you'll be able to match your transactions, Afrotherapy.

 

When QuickBooks looks for matches, it reviews the books for recorded transactions that might be matched. And these transactions will show similar records found. There are several reasons why the match may not have been recognized. I've outlined them below in bullets:

 

  • The transaction is older than 180 days
  • The amount in QuickBooks is different than what cleared the bank.
  • The transaction type is different in QuickBooks than at the bank. QuickBooks wants to match a check with a check and an expense with an ACH or debit/credit card swipe.
  • The transaction was recorded in a different bank account
  • The transaction from the bank is a payment/ deposit of two or more open transactions in QuickBooks.

 

You can turn on the Suggested Matches option to see what we can match. You can also use filters or search to locate transactions. To do so, follow the steps below:

 

  1. Go to Bank transactions.
  2. Under the For review tab, locate the transaction.
  3. Click Find other matches. Please know that the sample screenshot provided below was taken from a QBO US version but works the same way with the UK version.


 

Additionally, review your accounts to make sure they match your bank and credit card statements. Learn how to reconcile them by following this article: Reconcile An Account In QuickBooks Online.

 

If you have any questions when matching transactions or anything to do with your bank deposit or sales receipt, let us know we can get back to you. We're here to make sure to cover everything. Have a nice day!

Need to get in touch?

Contact us