Comparing 2 data sets to find missing transactions

Closed Posted Sep 22, 2015 Paid on delivery
Closed

This project involves comparing set A data to set B data. We then need to determine what are the differences between the 2 sets of data. Only certain differences are important to us.

The data basically consists of a date, a payee, and an amount.

It's a plus for you to have some basic knowledge of Excel. You see, one of the methods at our disposal is that you highlight set A data, then sort it by date with set B of data. You can then compare the colored rows versus the non-colored rows. As you can see, it's good if you understand how to properly sort the data as formatting can mess up data sorting.

It's also a plus for you to apply logic to the project. For example, you can create a running total of each data set to help you find where differences may lie.

In some instances, brute force "line the transactions up side by side" can prove useful. So, some solid data entry skills. Although you are not so much data entering as you are dragging and dropping.

I am a reasonable guy to work for. I am pretty patient and understanding. What I need from you is solid, accurate, output.

For people that do a good job on this, I will try to reward them with similar projects. I am not the kind of person that is looking to constantly hire new people. I'd prefer to keep people that have done good work for me in the past, and bring them into new work.

Data Entry Data Processing Excel

Project ID: #8531859

About the project

37 proposals Remote project Active Nov 5, 2015

37 freelancers are bidding on average $5/hour for this job

OniNeko

I am a professional Data Analyst with over a decade of experience. I understand my bid is a bit higher than your project budget, however keep in mind I will be able to complete this work very quickly, as I have a lot o More

$10 USD / hour
(33 Reviews)
4.4
jpablocar

As a civil engineer, I am proficient in the use of excel with macros and VBA. Please have a look to my profile to see my portfolio. For this particular project, I am thinking in a VBA code approach which will compare More

$8 USD / hour
(3 Reviews)
1.7
basitabbasi

Hello I am professional Data Entry & Data Processing Freelancer having solid skills working on Excel. I can implement various strategies in Excel depending on your requirement. I can efficiently work around on Filte More

$6 USD / hour
(1 Review)
1.8
achilies

Good Day Sir, I am a IT Professional with 6 years of experience in VBA/Macros and Excel roles working with Accenture Services Pvt Ltd(Proof of employment available). I will be able to assist you with the Excel re More

$8 USD / hour
(3 Reviews)
1.4
prasadbg86

I Have good experience in working with excel sheets , so i think i can complete your project as per requirements and on time

$4 USD / hour
(0 Reviews)
0.0
jiszd

It will be nice to work on this project, I really enjoy identifying mistakes on spreadsheets. I am going to do my best.

$2 USD / hour
(0 Reviews)
0.0
mainamuchoki

Hello, I have read and understood the instructions clearly. Additionally, I possess the required academic qualifications and experience required to complete this order on time and in high quality. Please lets m More

$6 USD / hour
(0 Reviews)
0.0
manas2206

I have a total experience of 3 years in pure analytics domain. I have proficient in statistical tools like SAS, Excel (VBA), SQL etc and expert in statistical techniques like Segmentation, Clustering, Linear and Logist More

$3 USD / hour
(0 Reviews)
0.0
manjulrajput31

A proposal has not yet been provided

$2 USD / hour
(0 Reviews)
0.0
sunnykika777

I have done this several times befora and am verry familiar with data entry and comperring the data. Even without your tips I would have use them. I think I am the right one for the job, plus I have a lot of time, so More

$6 USD / hour
(0 Reviews)
0.0
roshniagrawal001

Greetings I have successfully completed a certified course in ms excel along with management course. I posses a good typing speed and can type around 39 words per minute,if required can even submit the screenshot of m More

$2 USD / hour
(0 Reviews)
0.0
olyahorobets

Good afternoon! Ready and willing to take your project. I have the basic Excel knowledge, and I am also a philologist - oftenly I edit texts and search mistakes. Promise accurate and punctual work! Thanks in advance.

$7 USD / hour
(0 Reviews)
0.0
papu8018

sir, i am the best for this project bcs am doing this type work in my company..so i am so confidence i can do this work.

$3 USD / hour
(0 Reviews)
0.0
Leonchik

Good day sir! I will gladly do this for you. Will do this us convenient us it can be. Hope you will rate me afterwards.

$5 USD / hour
(1 Review)
0.0
ChrisnaStroebel

A proposal has not yet been provided

$6 USD / hour
(0 Reviews)
0.0
fgomezoso

La propuesta todavía no ha sido proveída

$6 USD / hour
(0 Reviews)
0.0
kameswarib86

A proposal has not yet been provided

$6 USD / hour
(0 Reviews)
0.0
mateopul

Administrador de Empresas actualmente realizando una Maestría en Alta Dirección de Empresas, proactivo, con clara misión en los resultados y objetivos de la organización, con gran capacidad para organizar, dirigir, in More

$5 USD / hour
(0 Reviews)
0.0
marcosmacedo

Hello, I have experience working with data and can acomplish the task needed in your project. I would like to know what is the source of the data you need to compare (Database, Excel, etc) and what differences you n More

$16 USD / hour
(0 Reviews)
0.0
workwomen

The Women Project is a dedicated Virtual Office Services Provider to many companies around the world, our services and standards are of remarkable quality and we’re sure we can meet your Virtual needs. We offer a lis More

$5 USD / hour
(0 Reviews)
0.0