I'm trying to import bank transaction (type TRNS) into QB Desktop from an IIF file, but the NAME field is always ignored (it's not put into the Payee field like it should be). The type is DEPOSIT.
I have tried first importing those names as OTHERNAME records, or as CUST records, earlier in the same IIF file, but it doesn't help. (They do get imported from those records!) Even if the values I'm using for the NAME field are already stored in QB as Customers, and I import the field, the NAME is ignored and nothing is put into the Payee field.
Here's the file I'm importing (the version that tries to create the customers first):
!CUST NAME
CUST 1234567[removed][removed][removed]890
CUST Bob's Burger
!ACCNT NAME ACCNTTYPE
ACCNT TD BANK
ACCNT Advantage Income INC
ACCNT Service Charges EXP
ACCNT General Donations INC
ACCNT Library Donations INC
!TRNS TRNSID TRNSTYPE DATE ACCNT CLASS NAME AMOUNT MEMO
!SPL TRNSTYPE DATE ACCNT CLASS AMOUNT NAME
!ENDTRNS
TRNS 20240913-74-2 DEPOSIT 04/02/2024 TD 1234567[removed][removed][removed]890 99.00 eTransfer
SPL DEPOSIT 04/02/2024 Advantage Income -40.00 1234567[removed][removed][removed]890
SPL DEPOSIT 04/02/2024 General Donations General -60.00 1234567[removed][removed][removed]890
SPL DEPOSIT 04/02/2024 Service Charges 1.00 1234567[removed][removed][removed]890
ENDTRNS
TRNS 20240913-74-7 DEPOSIT 04/27/2024 TD Bob's Burger 14.50 eTransfer
SPL DEPOSIT 04/27/2024 General Donations General -10.00 Bob's Burger
SPL DEPOSIT 04/27/2024 Library Donations General -5.00 Bob's Burger
SPL DEPOSIT 04/27/2024 Service Charges 0.50 Bob's Burger
ENDTRNS
TRNS 20240913-74-12 DEPOSIT 08/28/2024 TD Bob's Burger 0.50 eTransfer
SPL DEPOSIT 08/28/2024 General Donations General -1.00 Bob's Burger
SPL DEPOSIT 08/28/2024 Service Charges 0.50 Bob's Burger
ENDTRNS
Does anyone have any ideas how to get this to work? Thank you.
