F2O ADS/ADR fees and FOREIGN TAX PAID

[Cal Learner]

Tom (Texas) said 

Here’s a couple of transactions that are not being imported from the CVS.  Historically in my MSMoney file they were just recorded in “Cash Transactions” as:Taxes>Foreign TaxesFeesThey were not tied to an investment asset.

 My inclination is to generate an <INVEXPENSE> for the ADR/ADS fee. They do provide a symbol. Ideally that would let Money analyze the net yield better. I have not checked to see if Money makes use of the info.

The Foreign tax withheld thing is probably best to turn into a cash-account thing as it was with the Fidelity downloads. I am less sure of that. 

I do have some of those to study.

I did this as a separate thread because it was hard to track the different trains of thought.

I will put F2O in the subject to alert those who want to follow or ignore.

[Tom Meyer]

I can probably work with whatever you do.  Here's a snip from an older pockectsense ofx:

                    <INVBANKTRAN>
                        <STMTTRN>
                            <TRNTYPE>OTHER
                            <DTPOSTED>20251027120000
                            <TRNAMT>-00000000000000.3100
                            <FITID>xxxxxxxxxxxxxxxxxxxxxx
                            <NAME>FOREIGN TAX PAID
                            <MEMO>FOREIGN TAX PAID
                            <CURRENCY>
                                <CURRATE>1.00
                                <CURSYM>USD
                            </CURRENCY>
                        </STMTTRN>
                        <SUBACCTFUND>CASH
                    </INVBANKTRAN>
                    <INVBANKTRAN>
                        <STMTTRN>
                            <TRNTYPE>OTHER
                            <DTPOSTED>20251029120000
                            <TRNAMT>-00000000000000.7200
                            <FITID>xxxxxxxxxxxxxxxxxxxxxx
                            <NAME>LATE SETTLEMENT FEE
                            <MEMO>LATE SETTLEMENT FEE
                            <CURRENCY>
                                <CURRATE>1.00
                                <CURSYM>USD
                            </CURRENCY>
                        </STMTTRN>
                        <SUBACCTFUND>CASH
                    </INVBANKTRAN>

--
You received this message because you are subscribed to the Google Groups "Microsoft Money" group.
To unsubscribe from this group and stop receiving emails from it, send an email to microsoft-mon...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/5b3704b4-02b0-4349-917a-077b3c034ac5n%40googlegroups.com.

[Cal Learner]

How about

ADJ FOREIGN TAX PAID TAX RCLM PD:02/18/25 as of Feb-18-2025 NOKIA OYJ ADR EACH REPR 1 ORD NPV (NOK) (Cash)

What OFX was generated for that?

I have switched my plan... first do it as Fidelity did, and then add the investment expense for ADR/ADS fee later.

[Tom Meyer]

Sorry, don't work on "ADJ Foreign Tax"

I was unable to locate the ofx for "ADJ FOREIGN TAX PAID TAX RCLM"  I must have entered it manually when my Cash Transactions didn't balance with Fidelity.  It was dated 1/21/2026 and I didn't get a download that date.   You know why...   That transation was not tagged "E".  It is in my Fidelity Activity & Orders.  

Thanks,

Tom (Texas)

[Cal Learner]

Please try the F2O.py f2o_beta1D.zip.

I may have screwed things up, but it looks OK to me.

Work with copies.... and make sure that IGNORE_BEFORE_YYYYMMDD is old enough to catch the entries.

I tested with IGNORE_BEFORE_YYYYMMDD="20250116"  -- over a year ago. I had a more recent number, and was wondering why I was not finding matches.

[Tom Meyer]

I can't run Beta11D.  I have 2 Muni's that were just ignored with Ver 10, but now causing an error.

Fidelity csv 2 Ofx converter
('ptext: ', 'xxxx6814,Fidelity Joint 6814,,224381VG5,CRANDALL TEX INDPT SCH DIST UNLTD TAX 04.00000% 08/15/2052 BLDG BDS SER. 2022 A,20000,91.476,+0.223,18295.20,0.00,0.00%,-1183.39,-6.08%,3.48%,19478.59,--,Cash,\n')
('pln_ctr: ', 3)
('split_ptext: ', ['X36426814', 'Fidelity Joint 6814', '', '224381VG5', 'CRANDALL TEX INDPT SCH DIST UNLTD TAX 04.00000% 08/15/2052 BLDG BDS SER. 2022 A', '20000', '91.476', '+0.223', '18295.20', '0.00', '0.00%', '-1183.39', '-6.08%', '3.48%', '19478.59', '--', 'Cash', '\n'])
('symbol: ', '')
now to invoke the debugger error 42
> c:\users\tomhm\documents\f2o\f2o.py(1104)<module>()
-> this_account_string=split_ptext[P_AccountNumber] #into the positions csv
(Pdb)

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>%<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Here's a snip from an older pocketsense ofx file:

            <DEBTINFO>
                <SECINFO>
                    <SECID>
                        <UNIQUEID>224381VG5
                        <UNIQUEIDTYPE>CUSIP
                    </SECID>
                    <SECNAME>224381VG5 CRANDALL TEX INDPT SCH DIST UNLTD TAX 04.00000% 08/15/2052 BLDG BDS SER. 2022 A
                    <TICKER>224381VG5
                    <UNITPRICE>92.3030000
                    <DTASOF>20260117033010.000[-5:EST]
                    <CURRENCY>
                        <CURRATE>1.000
                        <CURSYM>USD
                    </CURRENCY>
                </SECINFO>
                <PARVALUE>1000.00
                <DEBTTYPE>COUPON
                <DEBTCLASS>MUNICIPAL
                <COUPONRT>0004.00000
                <DTCOUPON>20260117033010.000[-5:EST]
                <COUPONFREQ>OTHER
                <DTCALL>20260117033010.000[-5:EST]
                <DTMAT>20520815120000
            </DEBTINFO>

[Cal Learner]

I did email some debugging info.

[Cal Learner]

f2o_beta11E.zip put up. Fixes missed foreign tax paid bug.

[Cal Learner]

Got the sign wrong. f2o_beta11G.zip has that fixed.

[Tom Meyer]

Looks really good.  My mny Cash Transactions balance to the number I see in Fidelity.   The "Other Expense" action is asking for a Category when I open the transaction since it is blank.  I'm not sure if a default will be set by Money.  I don't know where to modify Money actions.

I can live with the blank if you don't see an easy update.

Good Job!

T

To view this discussion visit https://groups.google.com/d/msgid/microsoft-money/ac162ff0-a26c-4dca-bc32-4231efb67b37n%40googlegroups.com.

[Cal Learner]

I think <INVTRAN> will be like a dividend, but will take money rather than supply money. So no category per se.

For Foreign Tax, there is a NAME  "Foreign Tax". So you will manually set category the first time, and I am hoping Money remembers that category the next time it comes up.