Quickbooks Online Sync Error: Cannot import payment - it would result in overpayment

Why the sync error occurs:

This sync error occurs in QuickBooks Online when a payment you are trying to sync from Bill.com results in an overpayment. The sync error occurs because of an AP Bill that was either partially or fully paid in the accounting system and in Bill.com. This is likely because an AP Bill was paid or given a credit in your accounting system, while also being paid or marked as paid in Bill.com.


How to fix the sync error:

  1. In QuickBooks Online, locate the bill or invoice that's causing the overpayment error and delete any credits or partial payments applied to it.
    • Your Bill.com account may be attempting to sync multiple AP Bill Payments for your open AP Bills. The first step in solving this conflict is to determine which AP Bill in your AP Payment is being overpaid because of this sync.
    • There's no way to remove a single AP Bill Payment from an AP Payment (SentPay) in Bill.com. This means the simplest way to resolve this sync error is to locate the AP Payment or AP Credit in QuickBooks Online that's causing the overpayment, and delete it in QuickBooks Online. That way the sync conflict is resolved and you don't have to manually enter the other AP Bill Payments that are included in your AP Payment created in Bill Manger.
  2. Once the bill or invoice in QuickBooks Online has a zero balance, try syncing the payment from Bill.com again.
    • QuickBooks Online allows you to mark a SentPay to re-sync via “Check Sync Status” on the Payment page in Bill.com This will allow the payment to successfully sync without causing an overpayment in QuickBooks Online.