I’m attempting to import a CSV file from my Mercury accounts, but the Import CSV reports that there are no transactions found despite having 30 (or so) transactions. I’ve used the same import template on my other accounts USAA, Valliant FSB, Chase, Capital One without issue. Any clues as to where I can look? When I look at the CSV in a plain text editor, I see everything is indeed comma separated. I also can import into Excel, Numbers, and Google Sheets and they all display the data correctly. I’ve re-downloaded my raw transactions as we as doing a manual copy/paste into a fresh set of files… nothing seems to work. I’m wondering if Mercury could be inserting non-visible special characters which interfere with the CSV import tool?
Any advice?
Thanks,
PS: Please fix the Mercury sync!