Refreshing data using Spreadsheet Sync

Losing your format is never easy, especially after putting in the effort to tailor it to your needs; however, when you refresh data in Spreadsheet Sync, the system reverts to its original formatting, which overrides any custom settings you've applied. Let's explore how you can navigate this limitation and how your valuable feedback might help improve the system.

To begin with, please know that the spreadsheet will revert to its default format upon refreshing, as it pulls the latest data from QuickBooks. This ensures consistency and accuracy, preventing potential data parsing errors from custom formatting.

While the existing system behavior might not align with your preference for retaining custom formats, I recommend working with the default settings post-refresh to manage your data within the current framework.

In the meantime, you can submit feedback to our product engineers. Your insights into how retaining formatting could significantly enhance user experience are incredibly valuable:

1. Click the Gear icon in QuickBooks Online.
2. Select Feedback.
3. Enter your feedback regarding the Average Days to Pay feature.
4. Hit Next to submit.

If you'd like to monitor the status of your feedback, you can visit our Customer Feedback for QuickBooks Online.

Additionally, you can check out these articles to learn more about Spreadsheet Sync:

• Get started with Spreadsheet Sync for QuickBooks Online Advanced or Accountant
• Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant

You can also refer to these articles to learn how to manage your reports:

• Customize reports in QuickBooks Online
• Save a customized report in Quickbooks Online

I appreciate your efforts in navigating the Spreadsheet Sync features. If you have further questions or additional suggestions for improvement, please don’t hesitate to reach out. The Community team is here to help ensure your system runs smoothly and efficiently.