Let's go through some troubleshooting to sync all the data you need to QuickBooks Online (QBO) from Spreadsheet Sync, Terrence7.
You can start by refreshing your existing report or template to ensure that when you select all dates, data will sync properly.
To do this, go to Refresh in the toolbar and choose Current Sheet to set new data filters.
Also, I'd like to verify if you receive an error message when posting data to QBO using a transaction template (such as invoices and bills or purchase & sales receipts). Errors can happen if the data doesn’t meet the required criteria. If they've been manually added or uploaded to QuickBooks using a Spreadsheet Sync list template such as Accounts or Invoice Items, criteria are validated.
For detailed guidance on resolving common posting errors—like text and date errors—when using Spreadsheet Sync, please refer to the Posting Data to QuickBooks Online from Spreadsheet Sync and Posting Data to QuickBooks Online sections in this article: Spreadsheet Sync troubleshooting (the article is for the US region but is also applicable to the international version of QBO).
Additionally, if you're looking for a handy reference for the most commonly asked questions about Spreadsheet Sync, I recommend checking out this article: All about Spreadsheet Sync in QuickBooks Online.
Please don't hesitate to drop a comment if you need further help syncing data from Spreadsheet Sync. We're determined to help you succeed.
