Skip to main content
November 8, 2023
Solved

QBO: Daily CC bank deposits match to some daily sales receipts but many don't match. How can I force QBO to find a matching sales receipt in the Transactions window?

  • November 8, 2023
  • 1 reply
  • 0 views
When I try to "Find a match" the list of possible transactions doesn't bring up ANY sales receipts to pick from although I've entered one for every day.  Invoices, JE and Payments are in the list.
Best answer by CharleneMaeF

I can shed some light on the possible reasons behind this issue, Matt.

 

It's not uncommon to encounter situations where seemingly identical transactions don't always match seamlessly. While QuickBooks Online aims to simplify financial management and reconciliation, certain aspects can lead to variations in how transactions are recognized and linked.

 

In your case, this can be attributed to a combination of factors related to timing, categorization, data synchronization, and the logic of the matching algorithm. Check out the pointers below:

 

  • The payees or dates don’t match.
  • The entry is older than 6 months.
  • The bank account on the transaction isn't the same as the bank where the match is located.
  • The sales/refund receipt has been reconciled.
  • The record is already matched to another entry.
  • There are multiple currencies involved with significant exchange rate shifts, leading to varying amounts.

 

Should any of these factors come into play, manual intervention is required to ensure accurate matching. I recommend double-checking each transaction and adjusting the date filters as needed. Furthermore, don't forget to consider the differences in bank accounts, currencies, and reconciliation status.

 

Your financial accuracy and confidence are essential, and I'm here to support you every step of the way. If you need further clarification, assistance with reviewing your books, or additional insights, please feel free to get in touch.

1 reply

November 8, 2023

I can shed some light on the possible reasons behind this issue, Matt.

 

It's not uncommon to encounter situations where seemingly identical transactions don't always match seamlessly. While QuickBooks Online aims to simplify financial management and reconciliation, certain aspects can lead to variations in how transactions are recognized and linked.

 

In your case, this can be attributed to a combination of factors related to timing, categorization, data synchronization, and the logic of the matching algorithm. Check out the pointers below:

 

  • The payees or dates don’t match.
  • The entry is older than 6 months.
  • The bank account on the transaction isn't the same as the bank where the match is located.
  • The sales/refund receipt has been reconciled.
  • The record is already matched to another entry.
  • There are multiple currencies involved with significant exchange rate shifts, leading to varying amounts.

 

Should any of these factors come into play, manual intervention is required to ensure accurate matching. I recommend double-checking each transaction and adjusting the date filters as needed. Furthermore, don't forget to consider the differences in bank accounts, currencies, and reconciliation status.

 

Your financial accuracy and confidence are essential, and I'm here to support you every step of the way. If you need further clarification, assistance with reviewing your books, or additional insights, please feel free to get in touch.

Matt-TAuthor
November 10, 2023

it was the reconciliation status - perfect.  thanks a million! -Matt

November 10, 2023

Hello, Matt-T.

 

Thank you for getting back in this thread and verifying that my colleague's suggestions above worked for you. It's our goal to help you get the most out of QuickBooks.

 

We're glad to help you with any issue relating to QuickBooks. If there's more, add them below. Have a great day!