[Bug]: QFX amounts are lumped together in Amount column despite having distinct positive and negative values

[bverkron]

Verified issue does not already exist?

• I have searched and found no existing issue

What happened?

When attempting to import a QFX file from my credit card company Actual Budget lumps all the values, regardless if they're positive or negative, into an "Amount" column. If I complete the import like this all the credit card charges go into the deposit column instead of the payment column and are treated as payments on the credit card instead of charges.

I am not intimately familiar with the QFX file format but I can see in the file that the transactions have positive values for payments and negative values for charges and are marked as Debit or Credit so not sure why this isn't picked up by AB and put into the Amount columns.

Have tried Safari and Brave, same behaviour.

How can we reproduce the issue?

Try to import this file...
credit_card_sample.qfx.zip

Example snippet...

...

</CCACCTFROM>
<BANKTRANLIST>
<DTSTART>20250101
<DTEND>20250101
<STMTTRN>
<TRNTYPE>DEBIT <--- Shows Debit
<DTPOSTED>20250101120000
<TRNAMT>-5.55  <--- Shows negative amount
<FITID>123456789098765
<NAME>Patreon* Membership

</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT <--- Shows Credit
<DTPOSTED>20241225120000
<TRNAMT>200 <--- Shows positive amount
<FITID>453826288711501122222225990000221500
<NAME>THANK YOU

...

Should see results like this...

Where are you hosting Actual?

Docker

What browsers are you seeing the problem on?

Chrome, Safari

Operating System

Mac OSX

[jx34tech]

I just want to add that I have seen this bug the same way (pulled via docker) for myself, Every file format shown in this way except for QIF, that appeared to import the data correctly