If your QuickBooks Desktop sync with STRATAFOLIO stops working, you can quickly reconnect and restore your data flow by following a simple process. This guide walks you through how syncing works, why it may break, and exactly how to fix it step by step. By the end, you will understand how to safely run a sync, verify success, and troubleshoot issues with confidence.
Overview
STRATAFOLIO connects to QuickBooks Desktop through a controlled sync process. QuickBooks remains your source of truth, and STRATAFOLIO reads your financial data from it.
Unlike cloud software, QuickBooks Desktop does not sync automatically in the background. You must manually run the sync using the QuickBooks Web Connector. When the sync breaks, it usually means the connection needs to be refreshed, or the process was interrupted.
If you collect rent through ACH, sync your QuickBooks Desktop file every day. Tenants can only pay invoices that have reached STRATAFOLIO. If you create an invoice in QuickBooks after your last sync, your tenant will not see it and cannot pay it until you sync again.
This guide helps you safely reconnect and complete a successful sync without risking your accounting data.
Things That Will Break Your QuickBooks Desktop Sync
Once your QuickBooks Desktop file is linked to STRATAFOLIO, a few actions can permanently break the connection. Avoiding these will help you prevent sync failures before they happen.
Download the QBD Sync Breaking Points Reference Sheet for more guidance.
How to Reconnect and Run a Successful Sync
Follow these steps exactly to reconnect and run a successful sync.
Step 1: Log into Your Host Server
If your QuickBooks Desktop is hosted on a server, log into that environment first. This ensures you are working in the correct system.
Step 2: Close All Other Company Files
Make sure all QuickBooks company files are closed and no one else is logged into any company. This prevents sync conflicts and failures.
Step 3: Open the Correct Company File
Open the QuickBooks company file you want to sync. Always use single-user mode for best results.
Step 4: Open the Web Connector
Go to File and select Update Web Services to open the Web Connector.
Step 5: Select the Correct STRATAFOLIO Integration
Find the STRATAFOLIO integration that matches the company file you currently have open. Check the box next to that integration. Choose Select All if you are syncing in bulk.
NOTE: Only use Select All when every integration in the list is working. If any integration shows Updating in STRATAFOLIO, fix each stuck integration one at a time first. See How to Fix an Integration Stuck on Updating below.
Step 6: Click Update Selected
Click the Update Selected button to begin the sync process.
Step 7: Wait for Completion
The sync will begin immediately. Do not click anything else while it runs. Large files may take several minutes to complete.
Step 8: Confirm Success
Look at the Status column. If the sync worked, you will see “Last result: Success!”
Step 9: Close the Company File
Once complete, you can safely close the QuickBooks company file. For every company with an issue, restart the process beginning from step 3.
What Happens During the Sync
When you run a sync, STRATAFOLIO pulls financial data from QuickBooks. This includes transactions, balances, and account data.
You may notice:
– Progress bars are moving slowly
– Longer wait times for large files
– No visible changes in QuickBooks
This is normal. Always allow the sync to complete.
How to Tell If the Sync Worked
You can confirm success in two places:
Web Connector
Look for “Last result: Success!” in the status column.
STRATAFOLIO
Go to Hierarchy on the left-side navigation menu, then Organizations. Click the i icon to open the Organization’s detailed view, then open the Integrations tab.
If Web Connector shows success and the Integrations tab shows Connected and Success, your data is up to date. If the Integration Status shows Disconnected or Error, the connection needs attention even if the last sync succeeded.
Why this matters: A single failed sync can stop certain records, like invoice balances, from updating. Later syncs can still show success. Checking the Integrations tab after every sync catches this early.
Understanding Sync Statuses in the Integrations Tab
Outdated: Your file has not synced in a while. Run a sync to bring your data up to date.
Updating: A sync was started and STRATAFOLIO is waiting for it to finish. A sync for an established integration should finish in a few minutes. If Updating stays on screen for more than 10 minutes, the sync is stuck. New integrations are the one exception. The first sync takes longer, so Updating may show for a while.
Why a sync gets stuck. There are two common causes.
- A pop-up opened in QuickBooks Desktop during the sync and was not closed. The sync cannot finish until you deal with the pop-up.
- The sync was interrupted before both progress bars reached 100 percent. This includes stopping the sync, closing Web Connector, or opening QuickBooks or another company file while the sync was running.
When All Web Connector Connections Are Disconnected
If every authorized Web Connector connection for an integration is disconnected, STRATAFOLIO flags the Setup tab with a warning. When you open the integration, it opens directly to the Setup tab until a connection is restored. Select Authorize New Computer on the Setup tab, reconnect Web Connector, then run a sync and confirm that the Integration Status shows Connected.
How to Fix an Integration Stuck on Updating
Web Connector signs in to one company file at a time as a single user. While one file is stuck, Web Connector cannot sign in to the next file. That is why Select All will keep failing until you fix each stuck file on its own.
- Close QuickBooks pop-ups and make sure no one else is using any company file.
- Open the company file for the stuck integration in single-user mode.
- Open Web Connector.
- Check the box next to that one integration only.
- Click Update Selected and wait until both progress bars reach 100 percent.
- Close that company file, then repeat these steps for each integration that shows Updating.
- Check the Integrations tab. Last Successful Sync should show today’s date and time for each integration you fixed.
You do not need to run Select All after this. The next time you sync, Select All will work again.
TIP: Click Update Selected only once. Clicking it again does not speed up the sync. It forces the sync to stop and start over, which makes it take longer.
What to do if QuickBooks Desktop Won’t Sync
If the steps outlined in this article still do not work, click View Log in the Web Connector application, then save the file to your computer. Submit a ticket and attach the file. The team will respond within 24 hours.
Check Your QuickBooks Desktop Version
Before you reconnect, check your QuickBooks version in STRATAFOLIO. If the version appears in red, your QuickBooks Desktop is older than the versions Intuit supports, and upgrading may fix the sync. If you see a warning triangle, your authorized computers use different QuickBooks Desktop versions. Hover over the triangle to see which computers are affected, then upgrade them to the same version or delete any outdated authorized computer from the Setup tab. To learn where to find your version, see How to Check Your QuickBooks Version in STRATAFOLIO in the article How to Add a New QuickBooks Desktop Integration to STRATAFOLIO.
The Sync Shows Success, but the Accounting Customer List Is Empty
Sometimes the sync says Success, but the Accounting Customer dropdown is empty when you edit a lease. This usually means the lease is entered in one Entity, but your QuickBooks Desktop integration is connected to a different Entity. Customers and Income Items only show for leases in the same Entity as the integration. This can happen when your account has two Entities with the same legal name but different names.
How to Check
Go to Hierarchy, then Organizations, and select the i icon next to your Organization. Open the Integrations tab, select your QuickBooks Desktop integration, and look at the Entity name at the top of the page. Open the Customers tab to confirm your customer is listed.
Next, go to Operations, then Leases. Open the lease, select Edit Lease, and look at the Entity name at the top of the page.
If the two Entity names are different, you have found the cause.
How to Fix It
You have two options.
Option 1: Move the lease to the Entity that has the integration.
Remove the lease from its current Entity and add it to the Entity with the QuickBooks integration. Then edit the lease and choose your Accounting Customer. Contact Support before you remove a lease so your lease notes, files, and history are kept safe.
Option 2: Create a new integration for the Entity the lease is in.
Set it up using How To Add a New QuickBooks Desktop Integration to STRATAFOLIO, then request that the account be purged and wait for the process to be completed. A new integration needs a full remapping of your chart of accounts, leases, loans, and income items.
If you are not sure which option is right for you, submit a ticket before making changes. Include your Organization name, both Entity names, and the lease name.
Troubleshooting: My invoice balance in STRATAFOLIO does not match QuickBooks
The fix is to run a sync, confirm success in both Web Connector and the Integrations tab, and submit a ticket if the balance is still wrong. The support team can trigger a full resync.