3 ms·
> “Every bank formats their statements differently…” In my experience with bank data, on the downstream side, banking data is available in the OFX specificatio
by xtiansimon 9mo ago
> “Every bank formats their statements differently…”
In my experience with bank data, on the downstream side, banking data is available in the OFX specification, which is a consistent transaction data format. Unfortunately, memo’s do get truncated to different char lengths by different banks, even though the specification allows 255 characters. AMEX, amazingly, switches NAME and MEMO properties. It's a dog breakfast of compliance, but there is a standard.
https://en.wikipedia.org/wiki/Open_Financial_Exchange https://en.wikipedia.org/wiki/Open_Financial_Exchange
https://www.financialdataexchange.org/FDX/FDX/About/About-FDX.aspx?a315d1c24e44=5 https://www.financialdataexchange.org/FDX/FDX/About/About-FD...
- direwolf20 9mo agoHow do you get OFX data from your bank?
- xtiansimon 9mo agoMost bank feeds have option for QBO or QFX file export. The export is a text file. Open it with a text editor and the first three lines are: OFXHEADER:100 DATA:OFXSGML VERSION:102