Thank you for sharing detailed information regarding your issue, @toomanyrobots. Let's collaborate to discover the reasons your date formula format isn't functioning and manage your data properly.
When submitting data to QuickBooks Online via Spreadsheet Sync, it's important to ensure that the date format matches the settings of the template.
To confirm that you are utilizing the correct format, please ensure you are working with a Spreadsheet Sync posting template. You can find them under Manage Records > Records to create or edit.
If everything appears to be in order but the issue persists, I suggest contacting our Customer Support Team. They are well-equipped to offer personalized and effective assistance, and I am sure they can help you resolve this issue promptly. I would gladly assist you in reaching out to them for the support you require.
- Sign in to your QuickBooks Online company and select Help (?).
- Choose either tab to get started:
- Assistant: Quickly get customized answers. Choose a suggestion or type your query. If you need more help, Talk to a human.
- Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
- Start a chat with a support expert.
- Get a call back from the next available expert.
- Ask the community to get help from businesses like yours.
Additionally, take a look at this article as a reference to help you troubleshoot common errors encountered with Spreadsheet Sync in QBO: Spreadsheet Sync troubleshooting.
Explore this article for further information about the feature, including instructions on creating and editing reports: Create and edit reports in Spreadsheet Sync in QuickBooks Online Advanced or Accountant.
Let me know if you have other questions about using Spreadsheet Sync. Just leave a comment below. I’ll be happy to assist you.
