Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

OFX transaction with negative amount imported as positive

Comments, critical feedback, praise, or suggestions for new features.

Postby Nisse » Fri Aug 04, 2023 1:48 am

Hi,
I imported the following two transactions from an Interactive Brokers OFX file. The first debit transaction has the amount -32.51 and the second credit the amount 421.84 but both transactions was imported with a positive amount. I had to manually add the minus sign on the debit transaction.

<INVBANKTRAN>
<STMTTRN>
<TRNTYPE>INT</TRNTYPE>
<DTPOSTED>20230803202000.000[-4:EDT]</DTPOSTED>
<TRNAMT>-32.51</TRNAMT>
<FITID>20230803xxxxxxx</FITID>
<MEMO>USD DEBIT INT FOR JUL-2023</MEMO>
<CURRENCY>
<CURRATE>1.0</CURRATE>
<CURSYM>USD</CURSYM>
</CURRENCY>
</STMTTRN>
<SUBACCTFUND>CASH</SUBACCTFUND>
</INVBANKTRAN>
<INVBANKTRAN>
<STMTTRN>
<TRNTYPE>INT</TRNTYPE>
<DTPOSTED>20230803202000.000[-4:EDT]</DTPOSTED>
<TRNAMT>421.84</TRNAMT>
<FITID>20230803xxxxxxx</FITID>
<MEMO>USD CREDIT INT FOR JUL-2023</MEMO>
<CURRENCY>
<CURRATE>1.0</CURRATE>
<CURSYM>USD</CURSYM>
</CURRENCY>
</STMTTRN>
<SUBACCTFUND>CASH</SUBACCTFUND>
</INVBANKTRAN>
Nisse
 
Posts: 14
Joined: Tue Oct 07, 2014 6:25 am

Postby Mark » Fri Aug 04, 2023 2:05 pm

Hi Nisse,

I see this too. Thanks for pointing it out, and we'll get it fixed. FM was assuming that all interest in investment banking transactions were positive.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11313
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Feedback

Who is online

Users browsing this forum: No registered users and 45 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.