Before You Start

This guide assumes you have administrator access to QuickBooks Online and a basic understanding of the bill payment cycle.

Overview

15 min
Resolution Time
Intermediate
Difficulty
As needed
Frequency

What You’ll Learn

  • Common causes of duplicate vendor payments
  • How to identify duplicate entries in QuickBooks
  • Steps to safely reverse duplicate payments
  • Tips for preventing future payment errors

1. Understanding the Problem

Duplicate vendor payments can cause significant headaches. Here’s why they happen and their impact:

Common Causes

  • Double entry of bills
  • Paying the same bill twice (e.g., manual payment + online banking)
  • Bank feed matching to wrong transaction
  • Importing data from multiple sources

Impacts of Duplicates

  • Inflated Accounts Payable (AP) balances
  • Incorrect bank reconciliation
  • Potential for overpayment to vendors
  • Misleading financial reports

2. Identifying Duplicate Payments

There are several ways to spot duplicate entries in your QuickBooks.

Method A: Reviewing Transaction History

This method is best for recent or isolated incidents.

Pros:
  • Easy for recent transactions.
  • Quick overview for specific vendors.
  • Directly see payment details.
Cons:
  • Time-consuming for large volume.
  • Misses less obvious duplicates.
  • Requires knowing which vendor to check.

Method B: Using Accounts Payable Reports

For a more comprehensive review, leverage QuickBooks’ powerful reports.

Expert Tip: The “Unpaid Bills Detail” report is your best friend. Look for multiple entries for the same vendor and/or invoice number. Also, cross-reference with your bank activity to ensure each payment corresponds to a unique withdrawal.

3. Step-by-Step: Correcting the Duplicate

This process involves careful review to avoid further errors.

Start by running your “Unpaid Bills Detail” report and sorting by vendor and then invoice number. Look for identical payment amounts or payment numbers on the same date for the same vendor. Once identified, you’ll need to locate the actual transaction.

Here is a sample structure of a payment record you might see in a log before processing:

{
  "payment_id": "PAY-20251025-001",
  "vendor_id": "VEN-BOOKS001",
  "invoice_ref": "INV-10023",
  "amount_paid": 450.75,
  "payment_date": "2025-10-20",
  "payment_method": "Check",
  "status": "cleared"
}

4. Reversing the Duplicate Entry

  1. 1

    Locate the Duplicate Payment

    Go to “Expenses” then “Vendors,” find the vendor, and review their transaction list. Identify the payment that should be removed.

  2. 2

    Void the Duplicate Check/Payment

    Open the duplicate payment transaction. Click “More” at the bottom, then “Void.” Confirm the action. If it’s a bill payment, ensure it doesn’t leave the original bill unpaid if a valid payment exists.

  3. 3

    Match Bank Feed to Correct Transaction

    If the duplicate originated from the bank feed, ensure the correct payment is matched to the bank transaction, and the voided one is excluded from reconciliation.

Common Issue: Reconciled Transactions

If a duplicate payment has already been reconciled, you cannot void it directly. You must first “Undo” the reconciliation for that specific transaction from the reconciliation report, then void it, and finally re-reconcile the period if necessary.

5. Preventing Future Duplicates

Prevention Checklist

  • Implement a clear AP workflow for all staff
  • Regularly review the ‘Unpaid Bills Detail’ report
  • Always match bank feed transactions carefully
  • Train staff on proper payment and data entry procedures
  • Utilize internal notes on bills to mark status (e.g., “Paid via online banking”)

Need Help?

Get Support

Having trouble cleaning up your AP? Our experts can assist with detailed ledger reviews and process optimization.

Contact Us