Importing Bank's QIF Files
I have a question/issue....
When I download my BoA credit card account into the QIF 4 digit file, and then load it into MD by opening the QIF file, MD does not seem to account for previously QIF imported transactions. Below is a screen shot showing the duplicate transactions. How do get MD not duplicate QIF file transactions?
Thx,
PS
Inline image 1
-
image.png 91 KB
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
1 Posted by -Kevin N. on 09 Oct, 2016 02:13 PM
Hi Peter,
The QIF format is a rather crude format for use with financial data. The preferred format is OFX or QFX.
OFX and QFX file formats follow guidelines that incorporate a unique identifier for each txn that Moneydance uses to help prevent duplicate txns.
QIF files do not. Hence, your txns can be duplicated.
Look to see if B of A offers OFX or QFX file formats or look to see if you can limit the date range of the downloaded QIF so as not to overlap existing txns in your register.
Aside from that, there is little that can be done in this regard when using QIF files.
If B of A offers CSV files, you may want to look into trying the free, third-party CSV Importer which looks to skip duplicate txns. If you're interested, I'll post the link to the CSV Importer.
-Kevin N.
2 Posted by Peter Seidle on 16 Oct, 2016 01:46 AM
Kevin - The budgeting and categories don't seem as well developed as I had
hoped. Everything needs to have a category, which is often not the case
for me. When I made a category called "uncategorized", it still seems to
result in inaccurate budget/spending summaries. After trying the software
for several weeks, is it too late to request a refund?
Thanks,
Peter Seidle
561.596.2766
3 Posted by -Kevin N. on 16 Oct, 2016 01:52 AM
Hi Peter,
I'm a Moneydance user. I'm not a member of the Moneydance support staff.
If I may make a suggestion, start a new thread requesting a refund so that it garners the proper attention.
-Kevin N.
4 Posted by Peter Seidle on 18 Oct, 2016 03:10 AM
Kevin - Thanks for the response and help. My apologies - I thought you
were with Moneydance.
Thanks for the your help though.
PS
System closed this discussion on 17 Jan, 2017 03:10 AM.