Troubleshooting Common QuickBooks Online (QBO) Integration Errors
When syncing data from Recurly to QuickBooks Online (QBO), merchants may encounter errors that prevent invoices, payments, or credits from syncing. This article explains the most common QBO integration errors, their causes, and how to resolve them.
Common Errors & Resolutions
1. Missing Name
- Cause: The Recurly account is missing data in the field mapped to QBO’s Customer Display Name.
- Resolution: Check your QBO integration settings in Recurly to confirm the Display Name format (Company, First & Last Name, or Account Code). Ensure the selected field is populated in the customer record.
2. Tax Errors
- Cause: The tax rate name in Recurly does not exactly match the tax rate in QBO.
- Resolution: Review the tax name on the invoice in Recurly. In QBO, navigate to Taxes → Sales Tax → Setup Sales Tax and ensure the tax rate name matches exactly (case-sensitive).
3. Duplicate Document Numbers
- Cause: Invoice or credit memo numbers conflict with existing documents in QBO.
-
Resolution:
- Credit Invoices: In Recurly’s QBO integration settings, add a unique prefix to Credit Memo Numbers.
- Charge Invoices: In QBO, open the invoice and modify the number to a unique value, then save.
4. Credit Note Allocation
- Cause: A credit note is not automatically allocated to its invoice in QBO.
- Resolution: Manually add the Credit Note in your QBO console, then use Credit Note Options → Allocate Credit to apply it to the correct invoice.
5. Closed Accounting Periods
- Cause: QBO is blocking updates because the accounting period is closed.
- Resolution: Reopen the period in QBO by navigating to Settings → Advanced → Accounting → Close the Books and uncheck the lock. If you cannot reopen, ignore the error in Recurly and adjust manually in QBO.
6. Business Validation Error (Amount mismatch)
- Cause: This often occurs if carry-forward credits were deleted in Recurly or if Credit Invoices are not enabled.
-
Resolution:
- Avoid deleting synced credits in Recurly.
- Enable Credit Invoices in Recurly (Contact Support for this) to ensure proper credit memo syncing with QBO.
Fail Safe
- Always confirm the error directly in the Recurly Admin UI and QBO console before making changes.
- Test fixes in a Recurly Sandbox linked to a QBO trial account before applying in Production.
- If issues persist, contact Recurly Support with error details, example invoices, and timestamps.
Comments
0 comments
Article is closed for comments.