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.

Exception for QuickBooks Desktop — invoices exported by a payment: If an invoice was posted but never exported, and a user later records a payment against it while sync is enabled, the connector exports that invoice as part of syncing the payment, because QuickBooks Desktop needs the invoice to exist before it can apply the payment. The invoice then shows as Exported/Synced even though no one ran the export step manually.

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. Blank Vendor Document Number — Bills Won't Reconcile

The Vendor Document Number on a BuildOps receipt becomes the bill's reference number in QuickBooks (Bill no. / Ref no.). If the field is left blank, the bill still syncs, but QuickBooks shows the BuildOps receipt number instead — in the format <PO#>-<receipt#> (for example, 1137-1). Because the supplier's invoice number never reaches QuickBooks, vendor statements can't be matched by invoice number and the bills can look like they are missing.

Before exporting: Type the supplier's invoice number exactly as it appears into the Vendor Document Number field, then post and export. The number must still be unique for that vendor (see section 4).

For a bill that already synced without a Vendor Document Number: Exported receipts cannot be edited in BuildOps, so correct the reference number in QuickBooks instead.

  • To add the missing invoice number, open the bill in QuickBooks and type the supplier invoice number into the Bill no. field.

  • If the bill amount itself is wrong, use Void Receipt in BuildOps, re-receive with the correct lines and the Vendor Document Number, then post and export the new receipt.

Finding a synced bill in QuickBooks: Pay Bills lists only open bills sorted by due date, so search the vendor's transactions for the BuildOps receipt number (for example, 1137-1) to locate it.


6. Expense GL Account Mismatches

If the Income or 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.


7. 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.

If you encounter a timeout error during receipt syncing, repost the receipt. This often resolves the issue, allowing the receipt to export successfully.


8. 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.


9. 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.


10. 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.


11. 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


12. "Application permission" Prompt in QuickBooks Desktop

QuickBooks Desktop may show an Application permission prompt that identifies BuildOps as an application "without a certificate." This prompt comes from BuildOps QuickBooks Web Connector, not BuildOps. BuildOps does not use a certificate that can expire, so QuickBooks always labels the app "without a certificate" — nothing on the BuildOps side has expired. The prompt usually returns after QuickBooks is updated or its saved app permissions are reset, and approving it again lets syncing resume.

To approve the prompt:

  1. Select Yes, whenever my QuickBooks company file is open.

  2. Sign in as the full-access QuickBooks user that the BuildOps connector normally runs as.

  3. Leave the box for allowing access to personal data unchecked.

  4. Type yes and click Continue.

  5. Open the Web Connector and click Update Selected to start syncing again.


13. 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?