[Bug]: QFX Import Broken on new parser #912

Closed
opened 2026-02-28 19:24:47 -06:00 by GiteaMirror · 7 comments
Owner

Originally created by @matthewkdies on GitHub (Feb 4, 2024).

Verified issue does not already exist?

  • I have searched and found no existing issue
  • 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?

image

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox, Safari

Operating System

Mac OSX

Originally created by @matthewkdies on GitHub (Feb 4, 2024). ### Verified issue does not already exist? - [X] 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? <img width="814" alt="image" src="https://github.com/actualbudget/actual/assets/74341536/1ca136cf-27e6-44e8-8c83-dedbe0661fd0"> ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox, Safari ### Operating System Mac OSX
GiteaMirror added the bug label 2026-02-28 19:24:47 -06:00
Author
Owner

@youngcw commented on GitHub (Feb 4, 2024):

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

@youngcw commented on GitHub (Feb 4, 2024): Please include a sample qfx. We cant do anything useful without it
Author
Owner

@matthewkdies commented on GitHub (Feb 4, 2024):

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

@matthewkdies commented on GitHub (Feb 4, 2024): > 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](https://github.com/actualbudget/actual/files/14158748/quickenExport.1.txt)
Author
Owner

@youngcw commented on GitHub (Feb 5, 2024):

ping @joel-jeremy

@youngcw commented on GitHub (Feb 5, 2024): ping @joel-jeremy
Author
Owner

@Oglaf commented on GitHub (Feb 6, 2024):

I'm also having problems importing OFX

@Oglaf commented on GitHub (Feb 6, 2024): I'm also having problems importing OFX
Author
Owner

@twk3 commented on GitHub (Feb 8, 2024):

I have a fix for the error you ran into in https://github.com/actualbudget/actual/pull/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?

@twk3 commented on GitHub (Feb 8, 2024): I have a fix for the error you ran into in https://github.com/actualbudget/actual/pull/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?
Author
Owner

@matthewkdies commented on GitHub (Feb 8, 2024):

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.

@matthewkdies commented on GitHub (Feb 8, 2024): 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.
Author
Owner

@twk3 commented on GitHub (Feb 8, 2024):

The parse error is fixed in master with https://github.com/actualbudget/actual/pull/2342

@twk3 commented on GitHub (Feb 8, 2024): The parse error is fixed in master with https://github.com/actualbudget/actual/pull/2342
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#912