cancel
Showing results for 
Search instead for 
Did you mean: 
CharleneMaeF
QuickBooks Team

Payment missing when trying to match to a deposit

I know this hasn't been an easy process for you, Beth104.

 

Let me make it up to you by ensuring you're able to match the payments to the deposits.

 

When matching to existing entries, QuickBooks knows the downloaded transaction is the same one you already entered. It connects the two, so there are no duplicates. However, there are cases where some of the transactions can’t find their match from existing records. Here are the possible reasons why:

 

  • The payees don’t match.
  • The amounts don't match.
  • The dates don't match or aren't close.
  • The transaction is older than 6 months.
    • Tip: You can still find a match when you select the Find match section.
  • The bank account on the payment is not the same as the bank where the match is located.
  • The payment has been reconciled.
  • The transaction is already matched to something else.
  • There’s a multicurrency issue with the exchange rates, or the transaction doesn't pass through the home currency at some point.

 

Since the credit card payment is deposited to Bank 1 and the fee is deducted from Bank 2, this is the reason why you're unable to match them. The bank account should be the same on the transactions.

 

To rectify this, I'd recommend manually adding the transactions to the program. Then, exclude the download entries. 

 

Let's start by creating a bank deposit for the income that is added to Bank 1. Here's how:

 

  1. Go to + New.
  2. Select Bank Deposit.
  3. From the Account drop-down menu, choose Bank 1.
  4. Add the necessary details to complete the transactions.
  5. Click Save and close.

 

Then, add the fee as an expense transaction affecting Bank 2. After that, you can exclude the downloaded transactions to avoid duplicates.

 

Additionally, I've added an article that'll help you review your accounts in QuickBooks to make sure they match your bank and credit card statements: Reconcile Workflow.

 

Please keep us posted if you need assistance categorizing your bank transactions in QuickBooks. We're always here to help you out.

Beth104
Level 1

Payment missing when trying to match to a deposit

I appreciate the try but this is not correct either, more importantly missing the point.  I can show many times where the available payments to match to a deposit does not reflect all of the payments available and it has nothing to do with date.  It has everything to do with the amount of the payment and the amount of the deposit and the coding in QBO. 

 

I've resolved my issue by splitting the payment and then reconciling the account making the necessary adjustments in the reconciliation process. 

LieraMarie_A
QuickBooks Team

Payment missing when trying to match to a deposit

Thank you for your feedback, @Beth104.

 

I'm glad that you're able to find a solution. Feel free to visit us if you have further concerns about the reconciliation process. We'd be happy to help.

 

Stay safe always!

ML613
Level 1

Payment missing when trying to match to a deposit

I also have this issue.  I have a bank transcactions that are coming in on the credit card processor.  And yet an invoice and payment has already been processed.  The odd payment is not showing up in the match transaction screen.  This doesn't seem to have anything to do with which account it is being put to (neither undeposited or the actualy bank), it also doesn't have to do with the date range or the amount or it being split entry or not.  Rather it just isn't showing up.  QB desktop cleanly shows all payments in the deposit screen.  But QBO seems to have a glitch.   Please advise.

Carneil_C
QuickBooks Team

Payment missing when trying to match to a deposit

I appreciate you for joining the thread, @ML613.

 

I can imagine the hurdle you've been through when trying to fix this issue. I'll point you in the right direction of support to help you sort this out.

 

Since the issue persists on your end when matching a payment, I'd suggest contacting our QuickBooks Online Support Team. They have the tools to look further into your account in a safe environment and investigate this matter to give you a possible fix.

 

Here's how you can reach them:

 

  1. Click the Help menu.
  2. From the pop-up panel, go to the Search tab.
  3. Click the Contact Us button.
  4. In the text box, type in your concern.
  5. Click Chat with us.

When reaching support, please see our availability hours to ensure your concerns will be sorted appropriately.

 

Feel free to visit again in the Community if you have any other QBO-related concerns. I'm determined to help you succeed. Keep safe always.

Truckrepair1
Level 1

Payment missing when trying to match to a deposit

Helloo company paid me with a checking account , yesterday but its not showing that its payed for , invoice number 260088

Rubielyn_J
QuickBooks Team

Payment missing when trying to match to a deposit

I'm here to help you resolve this matter and ensure the payment is recorded accurately, @Truckrepair1.

 

Let's work together to get to the bottom of this and make sure everything is properly accounted for.

 

It's possible that the payment was not linked to the invoice appropriately. May I know how you record the payment in QuickBooks Online? Any additional information you can provide would be greatly appreciated. 

 

If you're referring to a deposit, we can modify the account linked to Accounts Receivable (A/R). Then, we can connect the payment and the invoice using the 'Receive Payment' feature.

 

Let me show you how: 

 

  1. Select + New and choose Receive payment.
  2. From the Customer dropdown, select the name of the customer.
  3. From the Payment method dropdown, choose the payment method (credit card, debit, PayPal, Venmo, or ACH bank transfer).
  4. From the Deposit to dropdown, click the account you put the payment into.  
  5. In the Outstanding Transactions section, select the checkbox for the invoice you're recording the payment for.
  6. Enter the Reference no. and Memo if needed.
  7. Click Save and close.

 

If you make a bank deposit with several checks in a single deposit, you can also utilize the Undeposited Funds account to record the payments in QuickBooks. This allows you to group multiple payments into one deposit transaction in QuickBooks. 

 

Please don't hesitate to reach out if you have further concerns about recording invoice payments. Your satisfaction is our priority, and we're here to provide the support you need. 

Need to get in touch?

Contact us