Transaction Date shown in the Transactions list is off by one day.
E
Eileen
I attached an image which shows a Costco transaction with the date 12/30/2023. When the link to the google spreadsheet was added to Fina (as a manual account), the date of the transaction shown in Fina was behind by one day.
I random picked a couple of transactions throughout the year and compared what I saw in FINA vs what was in the googlesheet containing the transactions. The date in FINA was always behind by one day.
Clay Raterman
Thank you for reporting (Xiao Hu) (Shawn Cao)
It may be because of your systems setting with the time range. We will take a look into this
Shawn Cao
Eileen
I think all DATES read from the Spreadsheet will be treated as ISO DATE (as the template called out), since we don't have ability to know what timezone the time is expected from a Spreadsheet.
The best way to solve this is to specify the TIMEZONE offset in your manual account as shown below.