I have joined the community specifically to get this sorted out. The CSV export file has gone downhill since June. My financial management package no longer recognises it and refuses to import it. So July and August transactions don’t appear in my figures at all.
First point: This is a STATEMENT. As a minimum it needs a date, description, debits and credits column or it won’t import. The other columns are just fluff to me. I get them in the app but I don’t need them in my financial statement as it does it’s own analysis. I appreciate that everyone would like something different from this but I just want the four columns that make up a standard legacy bank statement.
Second point: This is supposed to be a CSV file! That stands for Comma Separated Variables. Software that imports CSV looks for the C for Commas in the file. I viewed the CSV in Notepad and it contains no commas! So you can’t call it a CSV. And it’s never going to work. In June it had commas and it worked. Which developer flipped his lid and broke the mould??
Banking transactions are seamlessly imported if you use OFX. There’s no room for personality in the spec. We need that for getting our banking transactions. Then it won’t matter what fluff you put in the CSV.