Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
A
asiaplk26
June 16, 2020
Solved

Double payments

  • June 16, 2020
  • 3 replies
  • 0 views

When we try to do new bank deposit the description says : There are no transactions matching the criteria.

On customer's transaction list we have the same payment twice: one payment is closed and the second shows as unaplied. It keeps happening to few customers, not all of them. How to resolve it?

We use online banking and a third party service (Jobber) for invoicing and recording payments.

 

 

Best answer by LieraMarie_A

I'll help you clear out the duplicate payments, @asiaplk26.

When you entered these transactions accidentally, you'll want to void or delete them in QuickBooks. I'll guide you how.

  1. Go to Sales or Expense.
  2. Find and open the transaction.
  3. Add a note to the Memo or Message section if you want to include the void or delete date.
  4. Select More in the footer and choose Void or Delete.

 

Duplicates also occur when you add downloaded transactions that you already manually entered into the program. To avoid this from happening, you'll need to find a match for these transactions. Let me guide you on how.

 

  1. Go to Banking.
  2. Select your bank account.
  3. In the For Review tab, click one transaction.
  4. Select Find match.
  5. In the Match transactions page, choose the transaction that matches and click Save.

If these duplicates are already accepted from your bank feeds, you have an option to exclude them in the Online Banking menu.

Here's how:

  1. Go to Banking.
  2. In the Reviewed tab, find the duplicate deposits.
  3. Click Undo in the Action Column.
  4. In the For Review tab, select the duplicate transactions. 
  5. In the Excluded tab, check the boxes for these duplicates.
  6. Click on Batch actions and select Delete.

 

For more details about managing your bank feeds, check out this link: Assign, categorize, edit, and add your downloaded banking transactions.

 

Let me also add an article for more information about reconciling an account: How to Reconcile an Account in QuickBooks Online?

 

If there's anything else that I can help you with, please let me know in the comment section down below.

3 replies

LieraMarie_A
LieraMarie_AAnswer
Level 8
June 16, 2020

I'll help you clear out the duplicate payments, @asiaplk26.

When you entered these transactions accidentally, you'll want to void or delete them in QuickBooks. I'll guide you how.

  1. Go to Sales or Expense.
  2. Find and open the transaction.
  3. Add a note to the Memo or Message section if you want to include the void or delete date.
  4. Select More in the footer and choose Void or Delete.

 

Duplicates also occur when you add downloaded transactions that you already manually entered into the program. To avoid this from happening, you'll need to find a match for these transactions. Let me guide you on how.

 

  1. Go to Banking.
  2. Select your bank account.
  3. In the For Review tab, click one transaction.
  4. Select Find match.
  5. In the Match transactions page, choose the transaction that matches and click Save.

If these duplicates are already accepted from your bank feeds, you have an option to exclude them in the Online Banking menu.

Here's how:

  1. Go to Banking.
  2. In the Reviewed tab, find the duplicate deposits.
  3. Click Undo in the Action Column.
  4. In the For Review tab, select the duplicate transactions. 
  5. In the Excluded tab, check the boxes for these duplicates.
  6. Click on Batch actions and select Delete.

 

For more details about managing your bank feeds, check out this link: Assign, categorize, edit, and add your downloaded banking transactions.

 

Let me also add an article for more information about reconciling an account: How to Reconcile an Account in QuickBooks Online?

 

If there's anything else that I can help you with, please let me know in the comment section down below.

    A
    asiaplk26Author
    June 17, 2020

    Thank you!

    H
    Holly60
    June 30, 2020

    How do you stop that from happening?  Even looking at the Pending payments makes it double post the payments.

    H
    Holly60
    June 30, 2020

    When applying the payment to the invoices from the home page this payment showed up under QuickBooks Customer, I searched for the customer who's payment it was but she did not have any open invoices.  I cancelled the application but it posted to the QB customer anyway.  that payment came in online, we do not manually post any cards unless they call to pay.  I am the only person at this computer for the past 3 months.  

    Issue of the double payments plagued us last year also - i was guided to delete the payment after deleting it from the deposit - since all that went thru to the banking part as a deposit, it now shows a deficit of $30,000 difference.  my accountant is waiting to do my taxes.  so...after deleting the deposit and the payment do you have to go into the banking section and adjust that there?

    LieraMarie_A
    LieraMarie_A
    Level 8
    June 30, 2020

    Hi there, @Holly60.

     

    I can see from your screenshots that you've excluded both the payment and its duplicate. You'll need to omit the copies only. This way, you can categorize the original transaction.

     

    Since we're unable to recover deleted transactions, you have the option to import .qbo files manually. However, you'll need to deactivate bank feeds first. You can refer to this article for more details: Download Bank Feed transactions in QuickBooks Desktop.

     

    Once imported, you can categorize or match them in the Bank Feeds Center.

     

    Also, let me add this article about reconciling an account to make sure it matches your real-life bank statements: Reconcile an account in QuickBooks Desktop.

     

    Please let me know if you have additional questions or concerns. I'll be here every step of the way. Keep safe.

    H
    Holly60
    June 30, 2020

    Also, if not caught quickly will your guide take the deposit from the records so not to show a loss of that amount of money?

    M
    Mark_RModerator
    Moderator
    June 30, 2020

    Thanks for joining the thread, @Holly60.

     

    Let me clarify things about the duplicate payments and help you from there.

     

    As mentioned by my colleague above, duplicate payments will happen if you add bank transactions that you already recorded in your QuickBooks account. For example, if you have deposits from your bank transaction, then you record the same transaction in QuickBooks, this will create duplicate deposits if you add the bank transactions instead of matching them.

     

    Moving forward, you'll have to match the transactions to avoid duplicates. You can follow the detailed steps provided by my colleague on how to match transactions. 

     

    On the other hand, voiding or deleting the duplicate deposit won't show a loss of the amount. 

     

    You can also read this article to learn when to add or match bank transactions: Categorize and match online bank transactions in QuickBooks Online.

     

    Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day and keep safe.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement