Importing QIF
Posted: Mon Aug 17, 2015 11:19 pm
I've been using an Android application called anMoney for some time and I'm trying to migrate to Money Manager EX. I love the idea that it's Open Source and I'm hoping that it fits my needs. In installed 1.2.2 on a 64bit Windows 8.1 machine this morning.
I've exported my entire account from my previous application as QIF but when I imported it into MMEX, all of the balances were wrong. I figured that it was just an issue with having all accounts in one QIF so I exported each account separately as it's own QIF. Once I had imported them I got the same result. The balances were off by tens of thousands. I imported everything again using CSV and my balances were correct but transfers, of course, were now just debits and credits and not actual transfers.
In tinkering I've found that when I import a QIF file all transfer transactions turn up as outbound transfers in every case regardless of positive or negative values.
My QIF files seem to have the correct markup but they don't import correctly.
The transaction above imported just fine, but a transaction that involves a transfer from another account, as opposed to a transfer to an account, also turns up as a withdrawal.
It seems like I must be missing something but I can't seem to figure out just what it is. If anyone has any advice I'll gladly take it.
I've exported my entire account from my previous application as QIF but when I imported it into MMEX, all of the balances were wrong. I figured that it was just an issue with having all accounts in one QIF so I exported each account separately as it's own QIF. Once I had imported them I got the same result. The balances were off by tens of thousands. I imported everything again using CSV and my balances were correct but transfers, of course, were now just debits and credits and not actual transfers.
In tinkering I've found that when I import a QIF file all transfer transactions turn up as outbound transfers in every case regardless of positive or negative values.
My QIF files seem to have the correct markup but they don't import correctly.
Code: Select all
!Account
NChequing
TBank
^
!Type:Bank
D07/31/2007
T573.25
CX
POpening Balance
L[Chequing]
^
D07/31/2007
CX
T-398.91
PTRANSFER
L[TD Powerline]
The transaction above imported just fine, but a transaction that involves a transfer from another account, as opposed to a transfer to an account, also turns up as a withdrawal.
Code: Select all
^
D07/20/2008
CX
T1500
PTRANSFER
L[TD Powerline]
NDEP
It seems like I must be missing something but I can't seem to figure out just what it is. If anyone has any advice I'll gladly take it.