Untitled

 avatar
Greg
plain_text
6 months ago
647 B
2
Indexable
for each acct
    open portia transactions file 
    filter as follows:
        acct (column A)
        -CASH- (column F)

    grab column C, D, G, V
        if D is Buy or Withdrawal, V * -1
        add a ' to G, if G is the cash cusip we can remove
        add to exceptions sheet first available row

    open bank transactions file 
    filter as follows:
        acct fund num (column A)
        Account ends /000 (column F)
        US DOLLAR (column G)
    grab column M, N, O, (V or W) (W is negative), AF, AG


    pair off
        for each Reams, if BK transaction matches at D and sum of E is <= 0.02, delete the rows
Editor is loading...
Leave a Comment