# Import account statement in CSV format
**URL:** https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394
**Category:** Ideas
**Tags:** accounting
**Created:** [October 25, 2020, 10:12am UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394 "2020-10-25T10:12:19Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@jcm](https://discuss.tryton.org/u/jcm)
#### Post date: [October 25, 2020, 10:12am UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/1 "2020-10-25T10:12:19Z")
In France, many banks (all those of the BPCE group at least) don’t propose bank statement export in formats other than csv. Currently I use a complex process to convert this csv to OFX, then I manually add some missing field, to be able to import statement as a OFX file.
I propose to write a module account\_statement\_csv that would use directly the csv from the online bank account interface to import statements.
Is it a bad idea or do you think to a better way?
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [October 25, 2020, 10:30am UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/2 "2020-10-25T10:30:47Z")
CSV format is not a standard for statement. You can not have a unique parser for such generic format.
I think the first step is to collect the maximum of format example. Then maybe we could find some common format and so kind of standardize them.
Otherwise normally every EU banks should provide SEPA, so working on [CAMT053 SEPA Statement module (#4658) · Issues · Tryton / Tryton · GitLab](https://bugs.tryton.org/issue4658) could be better.
---
### Author:  [@jcm](https://discuss.tryton.org/u/jcm)
#### Post date: [January 8, 2021, 1:49pm UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/3 "2021-01-08T13:49:43Z")
We have solved our CSV to OFX problem with this simple utility that we place under GPL license:
> **[BPCEcsv-to-ofx](https://symetriedev.gitlab.io/bpcecsv-to-ofx/)**
It’s a small js-in-html-page convertor from the particular CSV output to OFX ready to be imported into Tryton.
---
### Author:  [@Simon](https://discuss.tryton.org/u/Simon)
#### Post date: [June 17, 2021, 4:04pm UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/4 "2021-06-17T16:04:44Z")
Actually the lack of standardisation is not a problem if we create a custom mapping to handle the format.
Gnucash provide this kind of functionalities. You set few formatting parameters (separator, encoding,…) and then you can bind each field (date, account, name ,…) with a column number.
---
### Author:  [@jhaand](https://discuss.tryton.org/u/jhaand)
#### Post date: [August 24, 2024, 8:50pm UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/5 "2024-08-24T20:50:04Z")
I think it would work best to tell what CSV format would map well towards the statements Tryton would like to see. Then people can convert their CSV files to those columns and format.
That makes it a lot easier than converting CSV to MT940 or the other XML based formats.
---
### Author:  [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [July 23, 2026, 9:32am UTC](https://discuss.tryton.org/t/import-account-statement-in-csv-format/3394/6 "2026-07-23T09:32:46Z")
I created [Add CSV as import format for account statement (!3510) · Merge requests · Tryton / Tryton · GitLab](https://foss.heptapod.net/tryton/tryton/-/merge_requests/3510)