# Managing bank statement files (CSV, OFX, QIF, etc)

**URL:** https://discuss.tryton.org/t/managing-bank-statement-files-csv-ofx-qif-etc/5456
**Category:** Ideas
**Created:** [August 7, 2022, 10:21pm UTC](https://discuss.tryton.org/t/managing-bank-statement-files-csv-ofx-qif-etc/5456 "2022-08-07T22:21:47Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![pocock](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/p/a88e57/32.png) [@pocock](https://discuss.tryton.org/u/pocock)
#### Post date: [August 7, 2022, 10:21pm UTC](https://discuss.tryton.org/t/managing-bank-statement-files-csv-ofx-qif-etc/5456/1 "2022-08-07T22:21:47Z")

</div>

Banks all provide different permutations of CSV files, OFX, QIF, MT940 and now the MiData files

Some people may want to import these files directly into Tryton and use them to create other records

Some people may want to consolidate all these different files in an external SQL table, outside Tryton, and use it for multiple purposes, for example, to search for expenses that are reimbursable

Has anybody seen any complete or partial solutions to these requirements?

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [August 8, 2022, 6:20am UTC](https://discuss.tryton.org/t/managing-bank-statement-files-csv-ofx-qif-etc/5456/2 "2022-08-08T06:20:08Z")

</div>

> [@pocock](#):
>
> CSV files

It is not a standard so it is not possible to provide a general import.

> [@pocock](#):
>
> OFX

Already exists with [`account_statement_ofx`](https://docs.tryton.org/projects/modules-account-statement-ofx/en/latest/)

> [@pocock](#):
>
> QIF

It should be possible to create a module but I doubt about the usage of this very old format.

> [@pocock](#):
>
> MT940

This is doable thanks to [https://mt940.b2ck.com/](https://mt940.b2ck.com/) even if it also tends to be replaced.

> [@pocock](#):
>
> MiData

I can not find information about this format.

> [@pocock](#):
>
> Some people may want to import these files directly into Tryton and use them to create other records

That’s the goal of the [account statement origin](https://docs.tryton.org/projects/modules-account-statement/en/latest/#origin).

> [@pocock](#):
>
> Some people may want to consolidate all these different files in an external SQL table, outside Tryton, and use it for multiple purposes, for example, to search for expenses that are reimbursable

Well that is not the goal of Tryton.

---

<div class="post-metadata">

### Author: ![pocock](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/p/a88e57/32.png) [@pocock](https://discuss.tryton.org/u/pocock)
#### Post date: [August 8, 2022, 7:30am UTC](https://discuss.tryton.org/t/managing-bank-statement-files-csv-ofx-qif-etc/5456/3 "2022-08-08T07:30:08Z")

</div>

> [@ced](#):
>
> > [@pocock](#):
> >
> > Some people may want to consolidate all these different files in an external SQL table, outside Tryton, and use it for multiple purposes, for example, to search for expenses that are reimbursable
> 
> Well that is not the goal of Tryton.

I agree, nonetheless, if anything like this already exists it might be useful for testing and comparison of data

Another case where this is useful is for people who are loading their company bank statements into Tryton, they don’t want to load their personal bank statements into Tryton but they want to search the personal account statements to look for reimbursable expenses.