# .csv importing bank statements **URL:** \ **Category:** Uncategorized\ **Created:** [October 2, 2016, 1:49pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258 "2016-10-02T13:49:17Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![m1sty222](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/m1sty222/32/13570_2.png) [@m1sty222](https://forum.manager.io/u/m1sty222)\ **Post date:** [October 2, 2016, 1:49pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258/1 "2016-10-02T13:49:17Z")
my present bank statements .csv files are not allowing me to change date format to the dd/mm/yyyy required by manager, and i do not have a choice to save my statement as another recognised option. anyone help how to import this file please. ---
**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:** [October 2, 2016, 4:35pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258/2 "2016-10-02T16:35:59Z")
Do this in a spreadsheet. Check you spreadsheet help on how. ---
**Author:** ![m1sty222](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/m1sty222/32/13570_2.png) [@m1sty222](https://forum.manager.io/u/m1sty222)\ **Post date:** [October 2, 2016, 4:58pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258/3 "2016-10-02T16:58:36Z")
I did, i am using Excel but it will not allow me to save .csv with the option dd/mm/yyyy. anyhow i used the free .csv converter earlier recommended on here, perfect except the fact all transactions come thru posted to the SUSPENSE account. ---
**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:** [October 2, 2016, 5:33pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258/4 "2016-10-02T17:33:58Z")
> [@m1sty222](#): > > all transactions come thru posted to the SUSPENSE account. That’s the entire point of the importing process. How could your bank statement, which is all that’s represented by the .csv file, know which accounts an item of income or expense should be allocated to? **You** have to make that determination. Bank rules can help for easily recognizable, especially repeated, transactions. Importing the .csv file only brings in numbers. It makes no decisions. ---
**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, 2:50pm UTC](https://forum.manager.io/t/csv-importing-bank-statements/7258/5 "2023-01-18T14:50:46Z")