Skip to main content
T
telgammal
February 12, 2021
Question

Payment record does not appear when trying to match during a bank reconciliation

  • February 12, 2021
  • 1 reply
  • 0 views

Hello,

 

I'm trying to do a bank reconciliation and I have a customer that made a payment with two transfers. The payment record was already manually entered, so during the reconciliation I am just trying to match the records. The problem is that the payment record does not appear in the items list.

 

Please refer to the two tables in the screenshot attached. The table on the left is an extract from the customer's activity history, which shows three payments: January 29, February 5 and February 10.  The table on the right shows the list of transactions to match. These have been filtered to show only payment records for the specific customer, BUT the February 5 record is missing. I checked the bank register and the payment record was not previously matched. 

 

I have tried to reach out to QBO support several times to address the matter, but the issue still isn't resolved. Can somebody please help me? 

1 reply

T
telgammalAuthor
February 12, 2021

Screenshot attached here.

J
JamesM4
February 12, 2021

Hello telgammal, 

 

Making sure your transactions match is a good way to keep your books tidy. QuickBooks is a hassle-free program that's designed to assist you with the accounting side of your business. I'll be happy to give you a hand so you can complete your reconciliation. 

 

If the transactions are missing, don't worry, there are places where you can check and I'll show you. First, it would be good to confirm that they're in the account by selecting Go to Register on the Banking page. 

 

If you find them in the register, the next step would be to verify that they're not matched to another downloaded transaction or have been reconciled. There will be two Green squares in the Reconcile status column if they've been matched. Additionally, an R will signify that it's reconciled. Both of these will prevent a transaction from being able to be matched. Here's a screenshot for visual reference:

 

 

For information on this, please see the following article: Match and categorize bank transactions in QuickBooks Online.

 

In case these transactions are in the register and don't have anything preventing them from being matched, I suggest clearing the cache of your browser. Doing this helps by fixing most issues the site may be having. Here's an article which shows you how to do that: How to clear Cache and Cookies.

 

Let me know if this info helps. I'll be here in case you need anything else. 

T
telgammalAuthor
February 14, 2021

Hi James,

 

Thank you for the helpful tips, but unfortunately I still could not solve the problem. 

 

Let me explain the situation a little more, which may shed some light into why the payment is not showing up during the reconciliation. We entered a single payment of $40, but the customer actually paid in two transfers $35 + $5. Is it possible that QBO automatically filters out payment records that have a higher value in the bank reconciliation? In general, is it not possible to reconcile two line items in the bank reconciliation to a single payment record?

Terms & ConditionsAccessibility statement