Skip to main content
February 3, 2024
Question

I need to see the customer payments matched to a deposit.

  • February 3, 2024
  • 1 reply
  • 0 views

In the bank feed I match deposits to the customer payments included in that deposit. A payment was applied to the wrong customer and invoice so I changed it. It was already reconciled and was part of a match on a deposit. So now I need to match the correct payment to the deposit and unmatch the wrong one. But when I click on the deposit anywhere it shows up I am unable to see the matches. I can't figure out what is in that deposit. Is there anywhere I can actually see what payments were selected for that reconciled deposit?

1 reply

February 3, 2024

Welcome to the Community space, Susan.

 

Let me help you in finding the payment link to your deposit in QuickBooks Online (QBO).

 

To find the payments link to your deposit, you'll need to the Categorized tab and search for the total amount of the deposit. You'll be able to view multiple transactions that were associated with the deposit. However, to match the payment with the correct deposit, you'll first need to manually unreconcile it. After matching, you can then manually mark it as reconciled again.

 

Here's how you can manually unreconcile:

 

  1. Go to Settings, then Chart of accounts.
  2. Find the account that has the reconciled transaction. Then select View register.
  3. Find the transaction. If the transaction is reconciled, you’ll see an in the checkmark ✔ column.
  4. Select the transaction to expand the view.
  5. In the checkmark ✔ column, select the box with the until the box is blank. This removes the transaction from the reconciliation.
  6. Select Save.
  7. Close the account register.

 

Moreover, I'm adding this helpful article as your reference in creating an adjusting entry: Enter an adjusting entry for a reconciliation in QuickBooks Online.

 

Return to this post if you have other concerns about linking payments to your deposit in QBO. I'll be here to lend a hand. Have a good one!

February 3, 2024

I click on the categorized transaction and I still can't see the matched payments on the deposit. When I click on the upper left "One online banking match" it shows a manually added deposit. Still no "list" of matched payments for the deposit. I have clicked on that deposit everywhere it shows up, including in the register, in the categorized tab....I can't see the matched transactions to it. I get a list of optional payments that have old, old dates on them but none of the recent ones are checked so that doesn't tell me either what the deposit matches to. I am a new accountant so I asked the employee who does these and she said she clicks on the transaction in the review tab, clicks on match, then when the list pops up she selects the ones that are in that deposit. Where do I see afterwards what she clicked on. I can only see a total. 

AlverMarkT
February 3, 2024

Thanks for getting back to us, @Susan Rainbow.

 

Let me join this conversation and further help you go through the steps to view and alter the matched payments for your deposit. You're following the correct process by looking in the categorized transactions for the deposit matches. 

 

The One online banking match tab on the upper left corner of the bank deposit window only helps to show that the deposit is associated or matched to a categorized downloaded transaction.

 

Furthermore, once you click the deposit link in the Categorized tab, it will route you to the original manually added bank deposit containing the customer payments. You mentioned that when you click the deposit link, you only get to see optional payments that are old transactions and none of the recent transactions are with a checkmark. Here are the things we can take from this case:

 

  • The transactions that have checkmarks are the ones that are associated with the bank deposit. In case you don't find them, I suggest scrolling through the old and recent transactions, as they aren't arranged sequentially sometimes. 
  • The recent and old ones without checkmarks are still in your Undeposited Funds (or Payments to Deposit) account. Moving forward, you can deposit them to avoid double counting of income when you run financial reports and match them to the correct downloaded transactions. 
  • If none of the transactions shows the correct customer payment when you click the deposit link, the payment you're looking for is associated with a different bank deposit. To resolve this, I recommend reviewing the other transactions from the Categorized tab.

 

Once fixed, you'll have to reconcile again. To help you in this task, let me add these references as guides:

 

 

We'll be here in the QuickBooks Community if you have further updates on altering matched payments for your deposit. We'll do our best to assist. Take care.