leolabs/you-need-a-parser

Amex CSV export

Opened this issue · 2 comments

jan-weezy commented

Amex export from German localized site https://global.americanexpress.com/activity/recent
Amex does not provide any documentation so I wrote the following lines myself:

**Example CSV
activity.csv
**

Datum,Beschreibung,Betrag
07/12/2021,VENDOR TEXT EXAMPLE 123,"-196,85"
06/12/2021,VENDOR TEXT EXAMPLE 123123,"9,95"
06/12/2021,VENDOR TEXT EXAMPLE 123123,"-773,17"

Mapping rules and format
Datum = Date in DD/MM/YYYY
Beschreibung = Description
Betrag = Amount
Negative values are credits (Gutschrift)
Positive values are liablities (Kosten)
Decimal separator is a comma ","

If you have questions, let me know.
Thanks in advance if you choose to support this format. Love the simplicity of your converter 👍

leolabs commented

Thanks for your request! I guess the CSV headings can also be in a different language, right?

jan-weezy commented

I assume so too but as a German user I cannot change language to English. Tried to find an option on the website but didn't find any, so I cannot provide an example in other languages.