dinesh.sarsar
New member
- Joined
- Sep 8, 2014
- Messages
- 21
- Reaction score
- 0
- Points
- 0
- Location
- India, Maharashtra Pune
- Excel Version(s)
- MS OFFICE Windows 10
Hi,
We have to reconcile a monthly stock rec file.
The matching criteria is as follows
1) The match has to be E v/s as given in column B.
2) The match has to be a positive units v/s negative units as given in column C.
3) The match has to be as per the Trans Type i.e
a) Transfers In v/s Transfer In - Inspecie
b) Sell v/s Repurchases
We have to reconcile a monthly stock rec file.
The matching criteria is as follows
1) The match has to be E v/s as given in column B.
2) The match has to be a positive units v/s negative units as given in column C.
3) The match has to be as per the Trans Type i.e
a) Transfers In v/s Transfer In - Inspecie
b) Sell v/s Repurchases
c) Buy v/s Sales 4) The only exceptional match is I v/s I as given in column B i.e Transfer In - Inspecie - Cancelled v/s Transfers In as it is a cancelled deal. 5) The matched items are to be given a match number as given in column F, the number has to be same for the match. Also Fractional difference for the match has to be excluded. I hope i have put the question in the most best way that i could have. |