Skip to main content

How can I resolve syncing issues between BuildOps and QuickBooks?

This article outlines various troubleshooting steps to resolve common syncing issues related to invoices, payments, and property records.

Written by Angelene Rosario

Syncing issues between BuildOps and QuickBooks can occur due to data mismatches, duplicate records, deleted entries, account mapping differences, character limits, or manual edits. This article walks through the most common syncing errors and how to resolve each one.

Additional causes of syncing issues include closed accounting periods and mismatched reference IDs, which can also lead to failures during the syncing process.

How syncing works: Post vs. Export

Syncing in BuildOps is a two-step process. A record that shows as Posted has not yet synced to QuickBooks — you must also trigger the export step.

  1. Post — saves the record and marks it ready for export. This does not send data to QuickBooks.

  2. Export/Sync — sends the posted record to QuickBooks. Always click the export action after posting to trigger the sync.

If a record shows as Posted but has not appeared in QuickBooks, check whether the export step was completed.

Fields or actions greyed out? If a record is in Approved or Posted status, some fields and the Edit button may be locked. Unapprove or unpost the record first (if your permissions allow), or contact BuildOps Support to request a status reset before re-triggering the sync.


1. Invoice Syncing Issues

Invoice sync failures typically happen when an invoice is deleted or moved in QuickBooks after it was already synced from BuildOps.

If the invoice was deleted in QuickBooks:

  1. Contact the BuildOps Support Team to request a Reference ID (RefID) reset for the affected invoice.

  2. Once the RefID is reset, retry the sync.

If the invoice was moved in QuickBooks:

  1. Open QuickBooks and locate the invoice.

  2. Verify that the invoice is assigned to the same job/project, property, and customer as it appears in BuildOps.

  3. If it was moved to a different entity, move it back to the original job/project, property, and customer.

  4. Retry the sync from BuildOps.


2. Property Syncing Issues

If a property record fails to export to QuickBooks, the issue is often caused by a duplicate property name in BuildOps or a stalled record export.

  1. Navigate to the affected property record in BuildOps.

  2. Check for any other property records with the exact same name. Duplicate names will prevent a successful sync — rename or remove the duplicate if one exists.

  3. Open the property record and select Edit, make no changes, then click Save. This retriggers the record export to QuickBooks.

  4. If the sync still fails after completing the steps above, contact BuildOps Support for further assistance.


3. Pre-Existing Payments in QuickBooks

When a payment already exists in QuickBooks, syncing the same record from BuildOps will fail to prevent duplicate entries.

To resolve this:

  1. Locate the payment record in BuildOps that is failing to sync.

  2. Use the Bypass option on the payment. The payment status will update to Bypassed.

  3. The record will no longer attempt to sync, preventing duplicate entries in QuickBooks.

Note: The Bypass option is intended for records that already exist in QuickBooks and do not need to be re-created. Use it only when you have confirmed the payment exists on the QuickBooks side.


4. Vendor Document Number Errors

QuickBooks Online requires a unique Vendor Document Number for each receipt per vendor. If a receipt shares a document number with an existing entry for the same vendor, the sync will fail.

To resolve this:

  1. Open the affected receipt in BuildOps.

  2. Locate the Vendor Document Number field.

  3. Update the number to a unique value that has not been used for that vendor in QuickBooks.

  4. Save the changes and retry the sync.

Tip: Use a consistent naming convention (e.g., adding a date suffix) to avoid duplicate document numbers going forward.


5. Expense GL Account Mismatches

If the Expense GL accounts assigned to items in BuildOps do not match the corresponding accounts in QuickBooks, invoice syncing will fail.

To resolve this:

  1. In QuickBooks, review the Expense GL account settings for the affected items.

  2. In BuildOps, update the corresponding items to match the Expense GL accounts found in QuickBooks.

  3. If you need to make changes in QuickBooks, switch to single-user mode first to avoid conflicts with other users.

  4. Once the account mappings are aligned, retry the sync.

Note: GL account mismatches are one of the more common causes of ongoing sync failures. If you experience repeated invoice sync errors, check GL mapping first before escalating.


6. Deleted Receipts That Won't Re-Sync

When a receipt that was previously synced to QuickBooks is deleted in BuildOps and then re-created, the backend accounting Reference ID (RefID) from the original sync is often retained. This prevents the new receipt from syncing until the RefID is cleared.

To resolve this:

  1. Identify the receipt that is failing to re-sync.

  2. Contact the BuildOps Support Team and request a RefID reset for the affected receipt.

  3. Once the RefID has been reset, retry the sync.

Additional Steps for Correcting and Re-Exporting Receipts

  1. Set the receipt status to "Pending" and "Not Synced" if it is blocking further actions.

  2. Delete the incorrect receipt from BuildOps.

  3. Create a new receipt with the correct details.

  4. Re-export the corrected receipt to your accounting system. If the receipt was already exported, delete the existing version in your accounting system before re-exporting.


7. Payment Syncing Issues

  • Invoice Already Marked as Paid in QuickBooks: Payments may fail to sync if the invoice is already marked as paid in QuickBooks. To resolve this, either bypass the payment in BuildOps or delete the payment in QuickBooks and re-sync it.

  • Mismatched Customer Records: Payments may not sync if the customer names differ between BuildOps and QuickBooks. Ensure that the invoice and payment are associated with the same customer in both systems.

  • Unposted Payments: Payments saved but not posted in BuildOps will not sync. Always use the 'Save & Post Payment' option to trigger the sync.


8. Character Limit Violations

QuickBooks Online has character limits for fields like payment numbers, customer names, or property names. If these fields exceed the limits, the sync will fail. Shorten these fields to comply with QuickBooks' requirements. For example, product codes must not exceed 30 characters. Ensure all fields meet these specific limits before retrying the sync.


9. Inactive Classes or Items in QuickBooks

Errors may arise if a class or item associated with a transaction is inactive in QuickBooks. Reactivate the class or item to resolve the issue.


10. Web Connector Not Running

  1. Confirm QuickBooks is open and the correct company file is active on the designated sync computer

  2. Open the Web Connector and check for authentication errors or stale credentials — sign out and back in if prompted

  3. Click Update Selected in the Web Connector to manually trigger a sync attempt

  4. If QuickBooks is open in multi-user mode, switch to single-user mode, run the sync, then switch back

  5. Restart both QuickBooks and the Web Connector if the issue persists

  6. If the Web Connector still fails to connect after restarting, contact BuildOps Support to review the connection configuration


11. Closed Accounting Period in QuickBooks

If the date on an invoice or PO falls within a period that has been closed in QuickBooks, the sync will be rejected. This is one of the most common causes of repeated invoice sync failures.

To resolve this:

  1. In QuickBooks Desktop, go to Edit > Preferences > Accounting > Company Preferences and check the Closing Date. In QuickBooks Online, go to Settings > Advanced > Accounting.

  2. If your invoice or PO date falls on or before the closing date, the sync will be blocked.

  3. Update the date on the affected record in BuildOps to fall within an open period, then retry the sync.

  4. Alternatively, contact your QuickBooks admin to temporarily open the period for the affected date range.

If you experience repeated invoice sync failures and GL account mapping appears correct, check the closing date in QuickBooks — a closed period is often the underlying cause.

Did this answer your question?