search

mtotschnig / MyExpenses

GPL licenced Android Expense Tracking App
http://www.myexpenses.mobi/
GNU General Public License v3.0
848 stars 222 forks source link

Import to GnuCash errors with QIF, CSV #1522

Closed link-leo closed 5 months ago

link-leo commented 5 months ago

I am having trouble with importing QIF files to GnuCash. I repeatedly get the following error:

Missing QIF investment action for transaction dated MM/DD/YYYY.

I have attempted to make numerous manual corrections to the .qif file per the guidelines to no avail.

I also note that the CSV export (using default options, anyway) is incompatible with a GnuCash import without several intervention steps in GnuCash.

mtotschnig commented 5 months ago

GnuCash seems to have a problem with QIF import: https://www.mail-archive.com/gnucash-user@gnucash.org/msg40172.html With respect to MyExpenses CSV export, could you document what format would work best with GnuCash's CSV import?

link-leo commented 5 months ago

GnuCash seems to have a problem with QIF import: https://www.mail-archive.com/gnucash-user@gnucash.org/msg40172.html

Understood. 👍

With respect to MyExpenses CSV export, could you document what format would work best with GnuCash's CSV import?

I might not have time this week, but I'll try to document a mapping and get it to you.

link-leo commented 5 months ago

@mtotschnig I did a small mapping here if you're interested, along with some general notes.

mtotschnig commented 1 week ago

@link-leo Thanks for sharing!