Stationary Management System

Closed

Description

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: Data Entry, Excel, Visual Basic

See more: Stationary management system, stationary management excel, stationary management, stationary system, vba macro reconcile bank data, management system stationary, stationary management system book, stationary management using, book stationary management system, stationary data management excel, data stationary management, find stationary excel, stationary management objective, stationary management system payment, what is sorting data, what is data sorting, what do accountants do, person management, data entry management system, c&f bank, c and f bank, business for accountants, accountants required, accountants for business, stationary system excel

Project ID: #884503

38 freelancers are bidding on average $97 for this job

gvyshnya

I will be happy to apply my 14+ year experience with Excel programming to completing your project. Please see more details in PM.

$100 USD in 4 days
(11 Reviews)
4.3
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

$100 USD in 3 days
(10 Reviews)
4.0
TCar

Happy to help!

$75 USD in 1 day
(3 Reviews)
2.9
Kubwaj

hi, Please consider my bid for the same. Regards, kubra

$220 USD in 5 days
(4 Reviews)
2.8
TushVaid

Please refer to PM.

$50 USD in 2 days
(4 Reviews)
2.2
ExcelVBA101

I have done this before. See PMB.

$100 USD in 4 days
(1 Review)
1.0
MradulSharma

Hi, I have 7 years of industry experience, good educational qualificaitons (ME Comp Sc) and am very much interested in Excel Macro kind of projects. I have written approx 15 Macros in XL for last 6 yrs which is f More

$50 USD in 5 days
(1 Review)
1.0
rtek84

My partner and I are highly experienced Business Analysts that have worked in MNC(Oil & Gas and IT) for number of years. Our passion is on improving spreadsheets by creating automations using VBA and also building repo More

$30 USD in 4 days
(0 Reviews)
0.0
aryznaiyzphilmla

try to contact me I'm perfect for the job.

$75 USD in 5 days
(0 Reviews)
0.0
KaplunEnterprise

Details provided in the private message

$500 USD in 5 days
(0 Reviews)
0.0
sachinthauoc51

I can type 20 words per mint. I have a friends.I like to do this job with my friends. I think I can do it better. I kindly request give me this job for me

$98 USD in 10 days
(0 Reviews)
0.0
starsoft143

with in20 days. i will ge create it..

$200 USD in 20 days
(0 Reviews)
0.0
Jupadhye

Have done much more complicated bank recon coding and implementation for a bank.

$100 USD in 10 days
(0 Reviews)
0.0
harsh83

Hello I am a highly qualified engineer looking for other avenues of income generation. I am open to negotiate based on the quality of my work which I assure to be good.

$100 USD in 5 days
(0 Reviews)
0.0
dbspec

I can do it. Please see PM

$100 USD in 2 days
(0 Reviews)
0.0
rburggraaf

I can assist you with this project.

$200 USD in 10 days
(0 Reviews)
0.0
kiranjth

I can do it.

$90 USD in 2 days
(0 Reviews)
0.0
manju1108

Hi, I've been doing office tool automation using VBA, Excel, Access, Vb.net, SQL server for last 7 years. As you will notice from my profile that I have already worked for Ernst & Young finance service organiz More

$60 USD in 5 days
(0 Reviews)
0.0
vbadeveloper0502

I hv over 3.5 years of experience as VBA Application Developer and build expertise in building various dynamic financial models in Excel/Access using VBA.

$50 USD in 3 days
(0 Reviews)
0.0
cookieburner

see pmb please thanks

$30 USD in 1 day
(0 Reviews)
0.0