In Progress

Excel Macro VBA reconciliation spreadseet

We are looking for a person who is able to write a simple VBA Excel macro.

We are accountants and would like to use a VBA macro to reconcile Purchase Day Book (all business expenses that have a receipt) to a payments made through the business bank account/s. Identify which expense receipts were paid through business bank account and which ones were paid using different payment methods. But we only interested to find all payments made through the bank account to which a correspondence entry has been recorded in the Purchase Day Book.

What the macro should do:

First objective: the macro must be able to identify the identical data (numerical values) in a column L of the worksheet PDB (see attached file) with a facility to exclude some rows (this sample would be rows 98-101 and 361-364) to a data in a column F on the worksheet BANK 1, also with a facility to exclude some rows (not in this example). Facility to change columns which are required to run macros must be incorporated in the VBA macro as on different spreadsheets column will be different to the example given to you.

Second objective: once the identical data in the required columns in both worksheets has been identified, the identified data in each worksheet the data should be replicated in the custom indicated columns. In the attached file after running macros PDB column K MUST Equal column L in the BANK 1 worksheet.

Since expense allocation to different columns is automated (see sorting column O), rather than replicating data in the L column, macro should just have a facility just to write required column number in the Sort Column O. User should be able to tell macro which number to write in the sort column.

Third objective: identified and allocated data on the two separate worksheets should be within 30 days period (data column A always A on all our spreadsheets) is included in the worksheet to each entry. If time lapse is more than 30 days but data is identical, then the cell with the data should be filled with let say RED colour. Ideally, the macro should have a facility to adjust time gap settings manually.

That pretty much it.

Skills: Excel, Visual Basic

See more: vba reconciliation macro, vba reconciliation, excel vba reconciliation, excel macro reconciliation, macro reconciliation, reconciliation vba, vba account reconciliation, excel reconciliation macro, excel vba bank reconciliation, excel macro bank reconciliation, vba reconcile, excel macro data reconciliation, bank reconciliation excel macro, excel macro reconcile, account reconciliation macro, reconciliation macro vba, macro bank reconciliation, reconciliation macro, reconciliation macros, use excel macro reconcile data, bank reconciliation macro, excel vba reconcile, data reconciliation macros excel, reconcile macro, macro excel reconciliation

About the Employer:
( 5 reviews ) London, United Kingdom

Project ID: #883897

Awarded to:

fedalal2

Hi, I have more 10 years experience in MS Excel and Office automation, so I'm realy GURU in this. I can help you with this project. Best Regards, Alex

$100 USD in 1 day
(32 Reviews)
5.5

21 freelancers are bidding on average $84 for this job

schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$150 USD in 2 days
(85 Reviews)
6.4
MAnkita

Hello,Please refer your PMB.Thank you.

$200 USD in 7 days
(75 Reviews)
6.1
vserv

Pls see your messages. Thanks

$120 USD in 5 days
(62 Reviews)
5.7
mrbrave

Ready to start now...

$120 USD in 3 days
(67 Reviews)
5.3
nagybatonyi

Such jobs are my daily practice, please see PMB for details! Regards!

$50 USD in 1 day
(38 Reviews)
5.3
vbexcel

Over ten years of financial and Excel/VBA experience at your service.

$70 USD in 1 day
(26 Reviews)
5.3
frehmanpk

Respected Sir, My suggestion for your is to develop a MS Access Database which can perform all the required calculations effectively and securely. Please see PM for more details. Kindest regards.

$300 USD in 0 days
(9 Reviews)
3.7
Lotusdeveloper

Hi, Please refer the PMB for more details. Thanks & Regards, LD

$62 USD in 1 day
(17 Reviews)
3.4
hsameer

please check your PM

$35 USD in 1 day
(3 Reviews)
3.2
notenuet

Hi Sir, check PM please. Thanks

$45 USD in 2 days
(2 Reviews)
3.1
balabeena

I have the experience to do it for you

$65 USD in 0 days
(2 Reviews)
1.0
AlanDHJones

Please see PM

$35 USD in 1 day
(1 Review)
1.0
Goldenjaguar

We have more working experience in VBA macro programming and successfully completed many projects through local acquaintances and assure you complete compliance to the project goals.

$30 USD in 1 day
(0 Reviews)
0.0
Alishanuj

Hi Business Partner, I can complete this work in 2 days and gurantee you a quality work within timeline.

$50 USD in 2 days
(0 Reviews)
1.4
sKrypted

Hello sir, I am the man for this job. Please see your PMB. Thanks.

$60 USD in 1 day
(0 Reviews)
0.0
abhishekjha02

Hi I am an excel macro expert. Please read my PM

$40 USD in 2 days
(0 Reviews)
0.0
hamohammed

hi i am expert in EXCEL i am new here and need review.. i can take less than 30 USD

$30 USD in 1 day
(0 Reviews)
0.0
MichaelAParsons

Hello london999, Thank you for your consideration~

$55 USD in 3 days
(0 Reviews)
2.0
legend419

Hi. I can do it. Please contact me. Regards.

$50 USD in 2 days
(0 Reviews)
0.0
satswid

Hello Sir, Here's a simple programmer for your simple query. I am always short in speech and good at work. 4+ yrs experience in VB and 2+ yrs in VBA makes me the best candidate to help you out.

$100 USD in 4 days
(0 Reviews)
0.0