Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Importer doesn't seem to recognize some transactions from QFX from Merrill Edge #217

Open
pallavg opened this issue Dec 12, 2023 · 1 comment

Comments

@pallavg
Copy link

pallavg commented Dec 12, 2023

I have been using beancount-import to process QFX files from Bank of America, Wells Fargo, Chase/Citi/BofA credit cards. In all cases, it has worked extremely well. Now I am trying to import portfolio holdings and am running into some transactions not being recognized.

The QFX is generated from Merrill Edge. I generate transaction history between Jan 1-20, 2023 which contains a single transactions only (redemption of a T-Bill) for testing. However, beancount-import doesn't seem to recognize the transaction during import.

I'm attaching a sample QFX generated file from Merrill to help reproduce the issue (I removed some unnecessary sections which contains entire portfolio holdings as of date + user/acct info). I am not sure if there is a potential gap in beancount-import's ability to recognize certain qfx statement constructs. Please advise.

In the meantime, I can try to use a CSV dump and proceed.

example.txt

@pallavg
Copy link
Author

pallavg commented Dec 12, 2023

I did some debugging and it seems like the version released installed by pip is 1.3.5 which was released on Feb 21, 2022. Going through the ofx.py code I see this:

 for tran in invtranlist.find_all(
                    re.compile(
                        '^(buymf|sellmf|reinvest|buystock|sellstock|buyopt|sellopt|transfer|income|invbanktran|stmttrn)$'
                    )):

There is no support for selldebt. But if I look at the master branch it seems like that has been added with PR for #187. Is there any plan to make a release to bump up the version? Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant