DESKTOP EDITION CLOUD EDITION SERVER EDITION GUIDES FORUM

Import of bank statements in MT940 Format


#1

Hello there,
I want to import my bank statements from a Dutch Bank called Knab into manager.
I can download it as a MT940 Format .txt
Does Anyone know if I can convert this MT940 Format .txt file to -> .qif, .ofx, .qfx or .sta formats?

Thanks


#2

You don’t need to convert. Manager will import the 940 format: https://www.manager.io/guides/9240.


#3

Hi Tut,
I have the same problem as Roze Bunker. The KNAB bank supports an MT940 format output, but the output itself has a .txt extension.
I have tried to convert this by changing the extension form .txt to .940, but this did not get accepted by Manager (incorrect file format or similar message).
It would be great if you guys have any guidance how to move this forward.

Thanks!
Theo


#4

Just changing the extension from .txt to .940 wont work just like changing it from .txt to .pdf wont work.
You will need to open the .txt file with a programme and then do a “save as” and select .940 as the format.
As to which programmes have a .940 format - I don’t know.


#5

The bank seems not to have implemented its output correctly. Not only must the filename extension be correct, but each format has specific definitions for order, labelling, and content. Just as with other types of applications, to give an example, you can force a *.xlsx file to look like a *.txt file and open with a text editor, but when you do, the functionality of the spreadsheet is gone.


#6

I contacted Knab servicedesk and they told me to open the .txt file with notepad, then save as *all documents whilst adding .940 after the existing file name. This will result in an importable .940-file (I just checked). Hope this helps my fellow Dutch Knab-customers using Manager!


#7

Thanks guys! It works the way Mirjam explained.
I read the guideline about Use bank rules to categorize imported transactions
But I stil have a next question you guys may know the answer.
If I created a Bank Rule which would automatically linked to 1 of my suppliers (dutch: Crediteuren)

->
It doesn’t change the actuall transfer automatically->

Is this normal and do I still have to do that manually?

I hoped this would happen automatically:


#8

It would appear that you haven’t got the “then allocate to” fields set up correctly - it should look like this:
0000000 Bug 1


#9

That’s strange. I can’t do it like that. This whats happen if I click on the tab

Do you know whats going on?


#10

Just a change from a two-step selection to a one-step selection. The functionality has not changed. I think @Brucanna captured an image from an older software version than you have. With the two-step approach, there was a possibility the transactions would end up in Suspense, because no subaccount was selected. The one-step approach ensures that can’t happen.

As for your problem, your screen shots are not clearly explained. Exactly what happened in what sequence? Are you saying that a transaction in a new imported bank statement that fits the criteria of the bank rule is not going to the right subaccount? Some of what you have posted shows that things are happening correctly. But one shot shows nothing is happening at all. More detail will help.


#11

Hi Tut,

When I import my Bank Statement

And make for example this Bank rule:


Update Bulk

Then Check my Bank Transactions


The Transaction still ends up in Suspense


#12

When you Bulk Update, did you first tick either the top box or the box next to it 0000000 Bug 4