QuickBooks for Windows 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 cannot be found in QuickBooks. This can happen if the bill or invoice did not 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:
- Delete the bill in QuickBooks
- After deleting the bill (or if you cannot find the bill), contact Customer Support to request to have the bill re-synced to QuickBooks
- 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 cannot find the invoice, create a new invoice and reapply the payment
- In Bill.com, find the corresponding invoice
- Click More actions
- Click Clone Invoice
- Update the invoice
- Uncheck all boxes under Send Via
- Click Save
- From the Sync Status page, click on the Payment Received
- Click the edit icon
- Apply the payment to the newly created invoice
- Delete the original invoice
- Sync again Once the newly created invoice syncs, the applied payment will sync and the error will resolve.