# Impossible to import a bank statement file .Ofx

**URL:** <https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301>\
**Category:** Uncategorized\
**Created:** [December 22, 2017, 10:20pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301 "2017-12-22T22:20:36Z")\
**Posts on this page:** 18\
**Page:** 1

<div class="post-metadata">

**Author:** ![chtipec](https://avatars.discourse-cdn.com/v4/letter/c/58f4c7/32.png) [@chtipec](https://forum.manager.io/u/chtipec)\
**Post date:** [December 22, 2017, 10:20pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/1 "2017-12-22T22:20:36Z")

</div>

Since a recent update, i cannot import an .ofx file from my bank as i have a message HTTP 500 internal error…  
I have tried with an older file (that have been already imported) but have the same problem…  
I have made no change (only updated manager) since last successfull import…

 ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/e/ecf4ecc76dccca2ce3aea9b0bd59dacf27796bfb.png)

I have tried to come back to an older version (17.11.22) that was working to import .ofx file, but it is not possible to install as the database was already updated with last version…

---

<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:** [December 22, 2017, 11:29pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/2 "2017-12-22T23:29:19Z")

</div>

I don’t know if this is related, but another user had an issue with .ofx imports not matching number formats. A recent change to the program (v17.12.12) addressed this. Are the number formats in your export the same as your number format preference in Manager? As I understand things, the program now assumes that they are. If they are not, perhaps that causes problems.

---

<div class="post-metadata">

**Author:** ![chtipec](https://avatars.discourse-cdn.com/v4/letter/c/58f4c7/32.png) [@chtipec](https://forum.manager.io/u/chtipec)\
**Post date:** [December 22, 2017, 11:50pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/3 "2017-12-22T23:50:26Z")

</div>

You right , i have change the number format in program preference and could import the .ofx file.  
Thank you for your help

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 1, 2018, 12:39am UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/4 "2018-01-01T00:39:58Z")

</div>

I have the same error with the cloud version :  
Internal Error

17.12.62 (Cloud)

/import-bank-statement-form?FileID=7ff99795-f127-4254-8ace-1e2048308a54

System.FormatException: Input string was not in a correct format.  
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)  
at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt)  
at ManagerServer.HttpHandlers.Businesses.Business.BankTransactions.ImportBankStatementForm.ParseBankStatementLines(String fileName, Byte buffer)  
at ManagerServer.HttpHandlers.Businesses.Business.BankTransactions.ImportBankStatementForm.Post()  
at HttpFramework.HttpApplication.ProcessRequest(HttpRequest request, HttpResponse response)  
at ManagerServer.HttpApplication.ProcessRequest(HttpRequest request, HttpResponse response)

---

<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:** [January 1, 2018, 12:54am UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/5 "2018-01-01T00:54:29Z")

</div>

Does the number format exported by your bank match your preferences?

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 1, 2018, 6:35pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/6 "2018-01-01T18:35:18Z")

</div>

The date and amounts look like this:  
date: “20171208”  
amount : “-2000.00”  
My preferences are:  
French  
123 456 789,00  
2017-12-31

---

<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:** [January 1, 2018, 7:36pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/7 "2018-01-01T19:36:44Z")

</div>

I am not sure how Manager interprets different date formats, or whether .ofx format allows different date formats. But as of a recent fix, Manager assumes the .ofx numbers are in the same format as your preference. So you will need to either (a) temporarily choose a matching number format or (b) edit the statement file wit a text editor to substitute a period for the comma as your date separator. I confess I do not know how Manager treats the absence of spaces as thousands separators. Probably it ignores them.

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 1, 2018, 8:07pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/8 "2018-01-01T20:07:50Z")

</div>

None of the choices we have in preferences matches the one generated by the bank.  
the best would be to have an option with comma or dot without any thousands separators.

---

<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:** [January 1, 2018, 8:53pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/9 "2018-01-01T20:53:59Z")

</div>

Did you try importing with the format highlighted in this illustration?

![13 PM](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/4/4580e5eac7d07cb5f53bc875cb1d81e5da46a6c9.png)

Another option is to try importing the .ofx file into a spreadsheet, then define the column with amounts as a number format. You can select a number format available in Manager or define a custom format. Finally, convert back to a text file format and paste the result into your .ofx file.

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 4, 2018, 3:00pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/10 "2018-01-04T15:00:02Z")

</div>

This number format (spaces and dot) is not available on the cloud version… but there’s 2 formats exactly alike (spaces and comma).

---

<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:** [January 4, 2018, 3:13pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/11 "2018-01-04T15:13:50Z")

</div>

They are not exactly alike. One includes only a single thousands-separating space, the other includes more.

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 4, 2018, 7:44pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/12 "2018-01-04T19:44:12Z")

</div>

The point is that Is can’t select the highlighted number format, since it’s not shown.

 ![2018-01-04-144526_3840x2160_scrot](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/2X/7/7075b799771517a4c7567c54279166b8d3235957.png)

---

<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:** [January 4, 2018, 10:05pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/13 "2018-01-04T22:05:28Z")

</div>

This is very strange. Cloud and desktop editions are supposed to be identical in this respect. @lubos, can you explain this?

---

<div class="post-metadata">

**Author:** ![lubos](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/lubos/32/62798_2.png) [@lubos](https://forum.manager.io/u/lubos)\
**Post date:** [January 7, 2018, 10:29pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/14 "2018-01-07T22:29:32Z")

</div>

Currently, the software pulls number formats from the underlying operating system.

As for importing OFX, try to select number format which has “dot” as decimal separator. This should fix OFX importing issue.

---

<div class="post-metadata">

**Author:** ![francoisbedard](https://avatars.discourse-cdn.com/v4/letter/f/5fc32e/32.png) [@francoisbedard](https://forum.manager.io/u/francoisbedard)\
**Post date:** [January 9, 2018, 6:09pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/15 "2018-01-09T18:09:38Z")

</div>

It worked, but I don’t want to work in a foreign number format nor want to change umber format each time I need to import a bank statement. This is a feature that was working before.

---

<div class="post-metadata">

**Author:** ![lcprop](https://avatars.discourse-cdn.com/v4/letter/l/3da27b/32.png) [@lcprop](https://forum.manager.io/u/lcprop)\
**Post date:** [June 9, 2018, 8:01am UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/16 "2018-06-09T08:01:01Z")

</div>

Sorry . how do i select number format which has “dot” as decimal . i dont understand

---

<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, 2018, 8:01am UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/17 "2018-06-09T08:01:57Z")

</div>

See the Guide: [Manager Cloud](https://guides.manager.io/9155).

---

<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:10pm UTC](https://forum.manager.io/t/impossible-to-import-a-bank-statement-file-ofx/13301/18 "2023-01-18T15:10:46Z")

</div>

Closed on January 18, 2023, 3:10pm UTC


