beancount-import icon indicating copy to clipboard operation
beancount-import copied to clipboard

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

Open pallavg opened this issue 2 years ago • 1 comments

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 avatar Dec 12 '23 07:12 pallavg

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.

pallavg avatar Dec 12 '23 08:12 pallavg