[Bug]: QFX Import Broken on new parser

[matthewkdies]

Verified issue does not already exist?

• I have searched and found no existing issue

Is this related to GoCardless, Simplefin or another bank-sync provider?

• I have checked my server logs and could not see any errors there
• I will be attaching my server logs to this issue
• I will be attaching my client-side (browser) logs to this issue
• I understand that this issue will be automatically closed if insufficient information is provided

What happened?

When importing QFX files from my bank (PNC), the import fails with no logs. Previously, I would uncheck the "Use experimental parser" option in the settings to fix this, but this option has disappeared in the current release. I also tried downgrading to 24.1.0, though the migration failed and the app wouldn't start.

If desired, I can include the relevant QFX file (censored) in the comments.

What error did you receive?

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox, Safari

Operating System

Mac OSX

[youngcw]

Please include a sample qfx. We cant do anything useful without it

[matthewkdies]

Please include a sample qfx. We cant do anything useful without it

Had to change the extension to .txt as .QFX isn't supported by GitHub. I've modified the memos, names, and amounts but the rest is as is from PNC.

quickenExport(1).txt

[youngcw]

ping @joel-jeremy

[Oglaf]

I'm also having problems importing OFX

[twk3]

I have a fix for the error you ran into in #2342

But @matthewkdies it appears that the OFX file you are trying to import is for multiple bank accounts. (Though only 1 has transactions). Actuals current transaction importers are meant to be per-account. Does your bank let you download per-account qfx files?

[matthewkdies]

Unfortunately, no. PNC's QFX/OFX export is terrible IMO -- it doesn't let you filter by date selection for import, so I have to do that myself with a script I wrote/am writing. It also exports for all accounts, and PNC's vast majority of users have three: spend, savings, and reserve.

Edit: FWIW, I believe that PNC exports the OFX file based on the selected account and adds the appropriate transactions. So when I am in "reserve" those transactions do appear.

[twk3]

The parse error is fixed in master with #2342