Bug 503038 - Import QIF
Summary: Import QIF
Status: REPORTED
Alias: None
Product: kmymoney
Classification: Applications
Component: bugtracker (other bugs)
Version First Reported In: unspecified
Platform: Microsoft Windows Microsoft Windows
: NOR normal
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-20 03:06 UTC by bnbunch
Modified: 2025-05-08 12:35 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
Improper import QIF (6.53 KB, image/png)
2025-04-20 03:06 UTC, bnbunch
Details

Note You need to log in before you can comment on or make changes to this bug.
Description bnbunch 2025-04-20 03:06:50 UTC
Created attachment 180423 [details]
Improper import QIF

I keep having same problem with importing on same payee. QIF is as follows:
!Account
NBank 9999^
!Type:Bank
D04/10/2025
T2084.70
C*
PSSA
MIncome
LSSA
^
When imported I get a transaction with No Payee, category is " Opening Balance " ,with blank in front of "Open"

It prompts me for scheduled tranasctions, which I do have for "SSA", but it doesnt match it even though "SSA" is already listed
as a payee
Comment 1 bnbunch 2025-04-20 03:17:29 UTC
My Clock shows 10:06 Central time, Yrt bug reports show 3:06 UT. Why is this
Comment 2 Thomas Baumgart 2025-04-20 12:28:54 UTC
Regarding time: because CDT is five hours behind UTC.

Regarding QIF: can you post your QIF profile here, please?
Comment 3 bnbunch 2025-04-21 23:56:50 UTC
(In reply to Thomas Baumgart from comment #2)
> Regarding time: because CDT is five hours behind UTC.
> 
> Regarding QIF: can you post your QIF profile here, please?

Don't know if you mean the qif file instead of profile. I don't know how to get to qif profile to post as there are several sections.
I discovered the problem as Kmymoney doesn't like using "SSA" as the payee and threfore it skips that and creates an "Opening Balance" entry
If I change the payee from "SSA" to "Social Security" it imports correctly with "Social Security" as payee and imports category as well correctly. I have a category "SSA". Could this cause the conflict?
I will just have to change "SSA" to "Social Security"  in qif before importing.
I use an app called ImportQif to convert qfx to qif.
Have tried directly importing qfx file but it doesn't match transactions the way I want.
Hope this is helpful
Thanks
Comment 4 bnbunch 2025-04-22 00:08:38 UTC
Went back and also if I change SSA and put a space in front of SSA it works perfectly
Just wanted to let you know that too
Comment 5 Bug Janitor Service 2025-05-07 03:47:03 UTC
๐Ÿ›๐Ÿงน โš ๏ธ This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information, then set the bug status to REPORTED. If there is no change for at least 30 days, it will be automatically closed as RESOLVED WORKSFORME.

For more information about our bug triaging procedures, please read https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging.

Thank you for helping us make KDE software even better for everyone!