[GH-ISSUE #4983] [Bug]: Amex QIF not importing with blank lines #16362

Closed
opened 2026-04-14 19:28:24 -05:00 by GiteaMirror · 2 comments
Owner

Originally created by @mitchplze on GitHub (May 14, 2025).
Original GitHub issue: https://github.com/actualbudget/actual/issues/4983

Verified issue does not already exist?

  • I have searched and found no existing issue

What happened?

This looks like possible regression of or similar/related to https://github.com/actualbudget/actual/issues/2647 and https://github.com/actualbudget/actual/pull/2653

When importing QIF files from American Express, only one record is shown for input processing, despite there being hundreds of transactions. This occurs on any export from Amex in QIF format, regardless of dates selected for export from the site.

Example contents of activity.qif:

!Type:CCard
D12 May 2025
N20250512
T-50.19
PAMAZON.COM.CA           WWW.AMAZON.CO
M
^

D12 May 2025
N20250512
T-87.39
PAMAZON.COM.CA           WWW.AMAZON.CO
M
^

D11 May 2025
N20250511
T-99.19
PAMZN MKTP CA*REDACTED  WWW.AMAZON.CA
M
^

D11 May 2025
N20250511
T-55.65
PDOORDASHEDOJAPAN        DOWNTOWN TORONT
M
^

Trying to import into Actual results in:

Image

How can we reproduce the issue?

Try to import qif files from American Express - with blank lines maybe?

I can provide full dumps of the files if required, but all tx's in the file look similar to the snippet posted above.

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Firefox

Operating System

Mac OSX

Originally created by @mitchplze on GitHub (May 14, 2025). Original GitHub issue: https://github.com/actualbudget/actual/issues/4983 ### Verified issue does not already exist? - [x] I have searched and found no existing issue ### What happened? This looks like possible regression of or similar/related to https://github.com/actualbudget/actual/issues/2647 and https://github.com/actualbudget/actual/pull/2653 When importing QIF files from American Express, only one record is shown for input processing, despite there being hundreds of transactions. This occurs on any export from Amex in QIF format, regardless of dates selected for export from the site. Example contents of `activity.qif`: ```qif !Type:CCard D12 May 2025 N20250512 T-50.19 PAMAZON.COM.CA WWW.AMAZON.CO M ^ D12 May 2025 N20250512 T-87.39 PAMAZON.COM.CA WWW.AMAZON.CO M ^ D11 May 2025 N20250511 T-99.19 PAMZN MKTP CA*REDACTED WWW.AMAZON.CA M ^ D11 May 2025 N20250511 T-55.65 PDOORDASHEDOJAPAN DOWNTOWN TORONT M ^ ``` Trying to import into Actual results in: <img width="820" alt="Image" src="https://github.com/user-attachments/assets/e97b8a34-c008-4002-9446-a0224c4e7bc2" /> ### How can we reproduce the issue? Try to import `qif` files from American Express - with blank lines maybe? I can provide full dumps of the files if required, but all tx's in the file look similar to the snippet posted above. ### Where are you hosting Actual? Docker ### What browsers are you seeing the problem on? Firefox ### Operating System Mac OSX
GiteaMirror added the bug label 2026-04-14 19:28:24 -05:00
Author
Owner

@alecbakholdin commented on GitHub (May 16, 2025):

You were right, it was the empty lines! Thanks for taking the time to report this!

<!-- gh-comment-id:2885464554 --> @alecbakholdin commented on GitHub (May 16, 2025): You were right, it was the empty lines! Thanks for taking the time to report this!
Author
Owner

@mitchplze commented on GitHub (May 16, 2025):

Wow that was quick. Thank you!

<!-- gh-comment-id:2885766417 --> @mitchplze commented on GitHub (May 16, 2025): Wow that was quick. Thank you!
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#16362