# Importing Bank Statement - Which Format to Choose

**URL:** <https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397>\
**Category:** Uncategorized\
**Created:** [June 9, 2019, 8:11pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397 "2019-06-09T20:11:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nieve](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@Nieve](https://forum.manager.io/u/Nieve)\
**Post date:** [June 9, 2019, 8:11pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/1 "2019-06-09T20:11:03Z")

</div>

Hello! I am using the Desktop version of Manager on a Windows computer, and I deal with 2 banks.  
I have multiple formats that I can choose to download my transactions.

My question is, what is the BEST / EASIEST format to use? @Brucanna

BMO:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/c/9c9e633946df451d20b0272e82a3ed81e96d82c5.png)

TD:  
 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/a/6a7fab40799c0c4713675c1470c207f496d6cbc3.png)

---

<div class="post-metadata">

**Author:** ![novica](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/novica/32/7414_2.png) [@novica](https://forum.manager.io/u/novica)\
**Post date:** [June 9, 2019, 8:32pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/2 "2019-06-09T20:32:46Z")

</div>

See this guide for supported formats:  
[https://www.manager.io/guides/9240](https://www.manager.io/guides/9240)

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [June 9, 2019, 8:37pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/3 "2019-06-09T20:37:17Z")

</div>

I think you need to experiment with the different formats available to see which works best in your situation - the information in the files and the format of your accounts (chart of accounts, list of customers & suppliers, etc) will differ from others

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [June 9, 2019, 9:14pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/4 "2019-06-09T21:14:55Z")

</div>

Historically, the forum sees many complaints from people using CSV-formatted statements. I can’t recall more than 1 or 2 issues with any of the other formats over the past 5 years, and those typically turned out to be user errors, not actual import problems.

The issue is that most of these format standards are proprietary, and therefore not enforced at all, or have very loose definitions of what an institution can put into various fields.

---

<div class="post-metadata">

**Author:** ![Brucanna](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/brucanna/32/1960_2.png) [@Brucanna](https://forum.manager.io/u/Brucanna)\
**Post date:** [June 9, 2019, 9:59pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/5 "2019-06-09T21:59:27Z")

</div>

> [@Nieve](#):
>
> My question is, what is the BEST / EASIEST format to use?

I have only ever used .qif files and never had a problem.  
Unsure if .qif relates to Quicken or QuickBooks or both.

---

<div class="post-metadata">

**Author:** ![Nieve](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@Nieve](https://forum.manager.io/u/Nieve)\
**Post date:** [June 10, 2019, 12:39am UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/6 "2019-06-10T00:39:36Z")

</div>

Thanks everyone for information. I guess i will just have to try it out and determine what works best for my banks. @Brucanna I will figure out and try the QIF first. Thanks

---

<div class="post-metadata">

**Author:** ![HeritageArts](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/heritagearts/32/17628_2.png) [@HeritageArts](https://forum.manager.io/u/HeritageArts)\
**Post date:** [June 12, 2019, 10:04pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/7 "2019-06-12T22:04:43Z")

</div>

Quickbooks QBO format has been golden for me.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 3:00pm UTC](https://forum.manager.io/t/importing-bank-statement-which-format-to-choose/22397/8 "2023-01-18T15:00:54Z")

</div>


