Skip to main content
April 8, 2025
Question

I use QBO Advanced and use custom reports & spreadsheet sync. I have one report that never seems to want to update. Any suggestions?

  • April 8, 2025
  • 1 reply
  • 0 views

I have a custom report that displays all time for active projects, but when I try to update in the QBO Advanced spreadsheet sync feature, it states it is completed almost instantly but the new data doesn't populate.

1 reply

April 8, 2025

You can quickly refresh the report you create in Spreadsheet Sync, kevind4, which will update the open spreadsheet based on your custom report. I am happy to guide you through the steps.

 

To do this, follow these instructions:

 

  1. Open the Excel file.
  2. Open and sign in to Spreadsheet Sync.
  3. You can view the details about the report, including when it was last updated. Select Quick refresh in the Spreadsheet Sync tab to get the latest data from QuickBooks.

 

To ensure accurate data synchronization, I also recommend reviewing and adjusting the filters used when refreshing the worksheet.

 

If the issue persists, I suggest contacting our Live Support Team. They have the tools to access your account securely and investigate the problem.

 

You can contact them by clicking the Help button at the top-right corner of your QuickBooks Online account and choosing the Assistant tab to get help from the QB Assistant. From there, enter your question and select Chat with us or Have us call you. Be sure to check their support hours to know when they're available.

 

If you have questions about Spreadsheet Sync in QuickBooks Online Advanced in the future, you can refer to this article for various scenarios on how to address them: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

In addition, we have a team of experts who can offer personal guidance on linking your accounts, automating tasks, and teaching the best bookkeeping practices to increase your efficiency. Check out QuickBooks Live Expert Assisted for more details.

 

If you want to customize your dashboard, please let us know, and we will guide you through the process.

kevind4Author
April 8, 2025

I am aware of how to update, but various reports I attempt to refresh do not update the data.  Have to try several times, close excel, sign out, sign in, restart, etc... and sometimes it works and sometimes I have to try again later on.