Home› API & Integrations› API & Integrations Technical Support

[Bug] Google Sheet Add-on Balance Sheet Download

honghong Member Posts: 11

Hi, I have encountered a bug while trying to download the balance sheet and setting the balance sheet date.

I have tried setting the "Balance Sheet Date" as 31 Oct or even 31 Nov, but the downloaded data always shows the 30 Oct balance along with the 30 Oct date.

P.S. I am in Singapore Timezone GMT +8. Submitting this post at 12pm my time.

edited October 31, 2019 in API & Integrations Technical Support

Comments

  • SheriSheri Member Posts: 1

    When I use the Wave Connect Integration for Google Sheets, and it also changes the date for me. It goes backwards one day, and it takes forever to change it to the correct dates in Wave. I am in the Korean Standard Time Zone GMT +9.

  • ConnorMConnorM Member Posts: 1,229 ✭✭✭

    Hey @hong and @Sheri! This is actually a known bug that my integration teams are aware of. What you'll want to do is, in Google Sheets, navigate to File > Spreadsheet Settings, and change your Locale to either Canada or the United States. You can then change your Time Zone to something like Toronto or New York, and it should rectify this bug. Let me know if that works out!

Sign In or Register to comment.