Cancelled

Macro_Reconciliation

below are the pointers which needs to considered.

 Matching Tab – BA (debit / credit) document matching with any other document (except BA) for same amount should be highlighted as green and moved to Matching tab

• Condition 1 – BA document should be kept as base

• Condition 2 – While applying ABS, macro should identify one duplicate entry

• Condition 3 – Document type (Clase) should not be same

 Cash Pooling tab – BA (debit / credit) document matching with two other documents (except BA) for same amount should be highlighted as Amber and moved to Cash pooling tab

• Condition 1 – BA document should be kept as base

• Condition 2 – While applying ABS, macro should identify two or more duplicate entries

• Condition 3 – Document type (Clase) should not be same

• Condition 4 - check if the two duplicate entries found are BP document. If there is no BP document, the matching should not be considered as cash pooling.

 Matching with bank fees - BA (debit / credit) document matching with any other document (except BA) for same amount with a difference of upto 120.20 should be highlighted as Blue and moved to Matching with bank fees tab

• Condition 1 – BA document should be kept as base

• Condition 2 – Difference in debit and credit should not be more than 120.20

• Condition 3 – Document type (Clase) should not be same

Further, I will work on creating Pivot table and matching once these are captured.

Skills: Excel, Excel Macros, Excel VBA, Visual Basic

See more: excel macro reconciliation bank, macro reconciliation use, cash delivery check magento pincode, cash register check, macro reconciliation, pivot table macro excel 2010, excel 2010 macro pivot table, pivot table macro 2010, excel macro create pivot table, can use macro create pivot table, account reconciliation macro, 2010 excel pivot table macro, macro refresh powerpivot data pivot table, excel reconciliation macro, reconciliation macro vba, vba reconciliation macro, excel macro reconciliation, pivot table macro dates, macro script bot difference, difference paying cash finance

About the Employer:
( 0 reviews ) Navi Mumbai, India

Project ID: #15544210

2 freelancers are bidding on average ₹1475 for this job

abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# More

₹1650 INR in 3 days
(46 Reviews)
5.4
egrigorya

rgh Relevant Skills and Experience excel Proposed Milestones ₹1300 INR - de

₹1300 INR in 1 day
(0 Reviews)
0.0