QuickBooks Desktop sync error: There is a missing element: "TxnID"

Why the sync error occurs

This error occurs when the bill or invoice for the payment listed in the sync error can't be found in QuickBooks. This can happen if the bill or invoice didn't sync from Bill.com or if the bill or invoice was deleted in QuickBooks.

How to fix the sync error

Check the Sync Status page in Bill.com to see what is causing the error:

If the error is for a payment for your vendor:

  1. Delete the bill in QuickBooks
  2. After deleting the bill (or if you can't find the bill), contact Customer Support to request to have the bill re-synced to QuickBooks
  3. After the bill syncs, the payment will sync and the error will resolve

If the error is for a payment received from a customer:

Find the invoice for the payment received in QuickBooks and clone it - If you can't find the invoice, create a new invoice and reapply the payment

  1. In Bill.com, find the corresponding invoice
  2. Select More actions
  3. Select Clone Invoice
  4. Update the invoice
  5. Deselect all checkboxes under Send Via
  6. Select Save
  7. Select Settings
  8. Select Status under Sync
  9. Select the payment received
  10. Select the edit icon
  11. Apply the payment to the newly created invoice
  12. Delete the original invoice
  13. Sync again

Once the newly created invoice syncs, the applied payment will sync and the error will resolve.