Untitled
Greg
plain_text
a year ago
647 B
12
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 rowsEditor is loading...
Leave a Comment