Unable to download credit card transaction

MJH

I have two transactions for the same vendor, amount, date. The first is for a purchase, and the second is to return the purchase. These occurred on the same date. Quicken imported the debit transaction but doesn't import the 'credit' transaction.

<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20250503120000</DTPOSTED>
<TRNAMT>-65.01</TRNAMT>
<FITID>20250503HOMEGOODS364ROSEVILLEXX6501</FITID>
<NAME>HOMEGOODS 364 ROSEVILLE XX</NAME>
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20250503120000</DTPOSTED>
<TRNAMT>65.01</TRNAMT>
<FITID>20250503HOMEGOODS364ROSEVILLEXX6501</FITID>
<NAME>HOMEGOODS 364 ROSEVILLE XX</NAME>
</STMTTRN>

UKR

The problem is the "<FITID>" number is the same for both transactions, causing Quicken to throw out the 2nd transaction as a "duplicate transaction"

Whoever programmed the <FITID> should have ensured that this "Financial Institution Transaction ID number" is a unique number for every transaction.

To get around the duplicate number just edit the FITID and append a non-blank number or letter to the end of the text

CaliQkn

@MJH what happens if you remove the negative sign for the credit?

MJH

Removing minus sign makes no difference. Credit transaction is still not downloaded into Quicken.

I also tried changing the transaction date so the Credit transaction was a day later. That simply added a duplicate Debit charge transaction in Quicken on the later day.

PS: Another long time issue is that the <BALAMT>amount is always missing a minus sign. Quicken credit card account indicates I have a credit instead of a balance due.

UKR

The problem is the "<FITID>" number is the same for both transactions, causing Quicken to throw out the 2nd transaction as a "duplicate transaction"

Whoever programmed the <FITID> should have ensured that this "Financial Institution Transaction ID number" is a unique number for every transaction.

To get around the duplicate number just edit the FITID and append a non-blank number or letter to the end of the text

MJH

Thanks UKR. Problem solved.