OFX conversion always assigns OTHER to TRNTYPE #98146 Active Opened 9 Mar 2024 When converting to OFX, TRNTYPE always has OTHER. Is there a way to make it CREDIT or DEBIT? I tried mapping TYPE to CREDIT but that does not change TRNTYPE being OTHER. C # CSV*** Sat, 9 Mar 2024 - 07:03 Hi Randy, in theory yes, see list from this site https://financialdataexchange.org CREDIT = Generic credit DEBIT = Generic debit INT = Interest earned or paid DIV = Dividend FEE = FI fee SRVCHG = Service charge DEP = Deposit ATM = ATM debit or credit POS = Point of sale debit or credit XFER = Transfer CHECK = Check PAYMENT = Electronic payment CASH = Cash withdrawal DIRECTDEP = Direct deposit DIRECTDEBIT = Merchant initiated debit REPEATPMT = Repeating payment/standing order HOLD = Only valid in <STMTTRNP>; indicates the amount is under a hold OTHER = Other Can you do me a favour and test this on your side: Manually edit the OFX in notepad or similar text editor Change the TRNTYPE to DEBIT and CREDIT for negative and posive amounts respectivelly Import into your financial software Share the outcome, did it work? what changed? What is the financial you use? Log in or register to post comments R # Ran*** Sun, 12 May 2024 - 19:19 In reply to Hi Randy, in theory yes, see by CSV Converter I do manually edit the file each month and replace OTHER with CREDIT and it imports into MS-Money just fine. Log in or register to post comments C # CSV*** Mon, 13 May 2024 - 10:02 Thanks for confirming, I will mark this issue as high priority. Log in or register to post comments Log in or register to post comments
C # CSV*** Sat, 9 Mar 2024 - 07:03 Hi Randy, in theory yes, see list from this site https://financialdataexchange.org CREDIT = Generic credit DEBIT = Generic debit INT = Interest earned or paid DIV = Dividend FEE = FI fee SRVCHG = Service charge DEP = Deposit ATM = ATM debit or credit POS = Point of sale debit or credit XFER = Transfer CHECK = Check PAYMENT = Electronic payment CASH = Cash withdrawal DIRECTDEP = Direct deposit DIRECTDEBIT = Merchant initiated debit REPEATPMT = Repeating payment/standing order HOLD = Only valid in <STMTTRNP>; indicates the amount is under a hold OTHER = Other Can you do me a favour and test this on your side: Manually edit the OFX in notepad or similar text editor Change the TRNTYPE to DEBIT and CREDIT for negative and posive amounts respectivelly Import into your financial software Share the outcome, did it work? what changed? What is the financial you use? Log in or register to post comments
R # Ran*** Sun, 12 May 2024 - 19:19 In reply to Hi Randy, in theory yes, see by CSV Converter I do manually edit the file each month and replace OTHER with CREDIT and it imports into MS-Money just fine. Log in or register to post comments
C # CSV*** Mon, 13 May 2024 - 10:02 Thanks for confirming, I will mark this issue as high priority. Log in or register to post comments
Hi Randy, in theory yes, see list from this site https://financialdataexchange.org
CREDIT = Generic credit
DEBIT = Generic debit
INT = Interest earned or paid
DIV = Dividend
FEE = FI fee
SRVCHG = Service charge
DEP = Deposit
ATM = ATM debit or credit
POS = Point of sale debit or credit
XFER = Transfer
CHECK = Check
PAYMENT = Electronic payment
CASH = Cash withdrawal
DIRECTDEP = Direct deposit
DIRECTDEBIT = Merchant initiated debit
REPEATPMT = Repeating payment/standing order
HOLD = Only valid in <STMTTRNP>; indicates the amount is under a hold
OTHER = Other
Can you do me a favour and test this on your side:
In reply to Hi Randy, in theory yes, see by CSV Converter
I do manually edit the file each month and replace OTHER with CREDIT and it imports into MS-Money just fine.
Thanks for confirming, I will mark this issue as high priority.