Menu

#932 The way MME handle transfers in QIF file is... surprising!

1.3.0
closed-out-of-date
Nikolay
None
5
2017-03-05
2016-09-18
Julien
No

Hello,
I just discovered your app, and i like it ! It seems to fit all my needs.
I was before using another app, called Ace Money, which does not offer a mobile app.

Anyway, i tried to export from the previous app, and import to Money Manager Ex in QIF format. It has been very painful to be honest.

Problems encountered with transfers.

Here is how look a transfer in QIF format from my previous app:

D18/09/2016
T5.00
C
L[AccountB]
^

This is a transfer from AccountA to AccountB of 5€.

Here is the problems:
This interpretation of this transfer by MME depends on other transactions in the file!

Three scenarios:

  • IF the file contains only transfer with negativ values, the transfer appears in "withdrawl" on both side, which is wrong.
  • IF the file contains transfer with positiv AND negativ values, values appears in withdrawl instead of in deposit column on one side, and the other way around on the other side
  • IF the file contains only transfer with positiv values, they are not inserted, and don't throw exceptions.

So, to make this thing work, (and to avoid having duplicate transfer because i import one QIF per account), i had to:

  • Remove all positiv transfer from each file to avoid duplicate
  • Change the sign of negativ transfer to positiv transfer to have values in the right columns
  • Add a temporary negativ transfer otherwise it does not import transfers

See, it was painfull :)

Please find attached very small file for each scenarios.
If more information needed plz ask.

3 Attachments

Discussion

  • Anonymous

    Anonymous - 2016-09-20

    This is the same problem in bug 774, but maybe better described here in more detail.
    https://sourceforge.net/p/moneymanagerex/bugs/774/

    Says it's fixed, but still exists in v1.3.0-beta.4

     
  • Anonymous

    Anonymous - 2016-11-22

    Tested with v1.3.0-RC1:
    IF the file contains only transfer with negativ values, the transfer appears in "withdrawl" on both side, which is wrong: bug still exists
    IF the file contains only transfer with positiv values, they are not inserted, and don't throw exceptions: bug still exists
    IF the file contains transfer with positiv AND negativ values: seems to work as expected
    edit
    Tested with v1.3.1 on January 2017, 9th
    Same behavior as above, nothing changed.

     

    Last edit: Anonymous 2017-01-09
  • Nikolay

    Nikolay - 2017-01-24

    I've provided some fixes in 1.3.1

     
  • Nikolay

    Nikolay - 2017-03-05
    • status: open --> closed-out-of-date
    • assigned_to: Nikolay
     

Log in to post a comment.

MongoDB Logo MongoDB