In Progress

Extract specific data from up to 8 PDF files and put in order into their own specific Google Sheets

In addition to placing desired data in its own sheet we will need to copy specific columns of data from several sheets and combine into its own sheets.

Info as to what sheet the data came from and also the "name" of the column will need to be in the TOP CELL for that column so that it will make it easier to identify the data.

For example the columns from (PM) report for CASH IN/CASH OUT will carry the column label of PM DATE, PM EMP, PM VALUE, PM Remarks etc etc,.. This would also apply to (CM) and QuickBook (QB).

The sheets that will be used to merge the data from various sheets will use the DATE as a common process to link the info from each column together. A MASTER DATE will be placed in the far left column starting with the earliest transaction from all the prospective columns. For instance starting with 05-01-2006 on the left MASTER DATE and all the other data sets that have transactions on that DATA will start at the same ROW and continue down rows until the column with the most 05-01-2006 ends,..

This will apply to all transactions within that same date so that I can look at each day in history and see how cash transactions moved from one software input to the other to validate that entries were being made from one software to another equally to make sure that theres not missing or incomplete entries.

Not sure if its possible but would like to be able to have a graphical link between matching CELLS that show that one entry led to another in a approved transaction. If not able then I could use some color coding entered manually to show GREEN or RED to signify found or missing transactions.

In a nut shell this is the majority of what I need to be able to do. Maybe theres a way to automatically sort the various columns of data to align them so that they all have matching dates in the correct order. More explanation on that later.

There is one major file that will take some extra work. Its the bank statement. I need some additional work done on that file and that would be to pull images from the scanned checks and have the ability to search the checks. Some checks now do not show up when I do a search using Adobe ACROBAT. I think its the quality of the scan and maybe it can be indexed properly so that I can use the ADOBE search feature. Like possibly embed a index in the file to make searching 100%.

Skills: Excel, Data Entry, Data Processing, Visual Basic, Excel Macros

See more: extract pictures text pdf files, automatically extract data fom pdf, excel data completing pdf files, extract data mdb pdf, data extraction pdf files, extract data diagrams pdf, extract data secure pdf, extract data multiple csv files, extract data scanned pdf, extract data scanned pdf word table excel spreadsheet, data harvesting pdf files, code extract data scanned pdf documents, need data scraped pdf files, php extract data online pdf, extract data image pdf online, extract data adobe director files, extract data saved html files, extract data from pdf or html file, extract data from pdf, how to extract data from pdf

About the Employer:
( 32 reviews ) Pass Christian, United States

Project ID: #21579394

Awarded to:


Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this easily through a C# automated script.

$122 USD in 2 days
(4 Reviews)

12 freelancers are bidding on average $120 for this job


Hello, After reading your project details I believe I'm suitable for this project. As I'm expert on it with more than 7 years experience. Please feel free to contact me. I am looking forward to hear from you. More

$40 USD in 3 days
(100 Reviews)

Good Day, It is my pleasure to be able to bid on your project. Really very much interested to have this project, if you permit. I am 100% confident that I can execute the project with good quality that will satisfy you More

$140 USD in 7 days
(71 Reviews)

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. An Expert Excel/VBA programmer on and I do not More

$155 USD in 3 days
(30 Reviews)

Dear hiring manager,, Fully understand your requirements & i am ready to start your work now & deliver to you within right time.I am highly experienced .Please sir give me a chance .I will start your work now. Than More

$140 USD in 7 days
(24 Reviews)

Hi there, I have read and understood your project requirement. I will be able to work with [login to view URL] leave a message so that we can discuss more over the chat. Regards M Faisal

$155 USD in 3 days
(4 Reviews)

Very interesting! I have good skills in read data from pdf and write into spreadsheet using python. If you want, i can show my previous works. Thanks.

$200 USD in 3 days
(6 Reviews)

Hi there, I’ve checked the project details and I can do this project perfectly. I have huge experience in working with these projects. If you need sample work just send me a message. Waiting for your quick reply. Best More

$100 USD in 3 days
(1 Review)

Expert in dealing with Excel and work with several accounting offices to enter data that includes the equations and work on word and write vignettes

$140 USD in 7 days
(0 Reviews)

Dear employer I will give you the best result by using my past experience and excellent academic skills I am an audit executive I have 3.6 years of experience in the industry of mnc firm I want to work with you thank y More

$100 USD in 7 days
(0 Reviews)

I am a specialist in Data Entry and Data Mining with Deep Web Research. I am hardworking professional willing to deliver Quality work through expertise and knowledge acquired over a period of 8 years. I can be a valuab More

$35 USD in 5 days
(0 Reviews)

Hi I have done a same kinda project so i would take less time to complete the same. Request you to provide me this project.

$111 USD in 7 days
(0 Reviews)