Skip to main content
H
henryb1
June 5, 2023
Question

Not showing matches - Sales Receipts / Bank Deposits

  • June 5, 2023
  • 1 reply
  • 0 views

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?

1 reply

A
Ashleigh1
June 5, 2023

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. 

H
henryb1Author
June 5, 2023

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
Rubielyn_J
June 5, 2023

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.

Terms & ConditionsAccessibility statement