I have bank statements that are in non ocr'd pdf form that I would like to have converted to an excel spreadsheet.
With a good ocr program they do ocr quite well (I have tried paperport 12), and I expect that someone could then either write a parsing program to pull just the relevant data or manually copy and paste the data sections into a text file then import it into excel.
There are about 300 pages of statements, however, a lot of these are not required to be converted as they are statement heading information etc and not the actual data. I expect the data pages are probably about half of that.
I do not want someone who is going to retype all of the information as pure data entry. I want someone who can automate the process as much as possible to both save time and ensure accuracy.
The statement pages that contain data look like:
Keycard Cold Card
525 1345 6532 4324
IRAN TRANSACTION DESCRIPTION DEBITS CREDITS(-)
DATE AND REFERENCE NUMBER
070910 PAYPAL *AFRD WEB 4158157152 AUS 87.17
74.00 USE INC FX FEE AUDS 1.3
090910 ASCOT QUAYS APMT HOTEL ASCOT AUS 194.00
090910 PAYPAL *CODADDYCOMI 4029357733 USA 5.95
5.49 USD INC FX FEE AUDS 0.15
100910 ACE COMMUNICATIONS BERWICK AUS 20.15
As such that above section would need to be converted as follows (eg CSV for Excel):
070910,PAYPAL *AFRD WEB 4158157152 AUS 74.00 USE INC FX FEE AUDS 1.3 85822563281156355215882,87.17
090910,ASCOT QUAYS APMT HOTEL ASCOT AUS 85211651384318831385,194.00
090910,PAYPAL *CODADDYCOMI 4029357733 USA 5.49 USD INC FX FEE AUDS 0.15 55242151576385458158454,5.95
100910,ACE COMMUNICATIONS BERWICK AUS 551518658183183138536,20.15
Each Statement has an opening and a closing balance. Once the data has been put into excel I would then like the successful bidder to have a running total column (BALANCE) and confirm that the balances on each statement match the running total calculation from the transactions. Note even though a csv form is displayed below, it is only so it shows correctly here, this would be done after import to excel rather than before.
,Opening Balance 010410,,,1000
090410,BLAH BLAH BLAH,50,,1050
100410,BLAH BLAH BLAH,60,,1110
110410,BLAH BLAH BLAH,,5,1105
,Opening Balance 010510,,,1105
I would like the job completed within 5 days of acceptance at the absolute latest.
All of the pdfs can be provided via email as soon as bid has been accepted.
I am in Australia (GMT+8) for communications as required, ideally during the business day.
50 freelancer đang chào giá trung bình $86 cho công việc này
Hello, GAF 10th rank provider here at your service. We have a team of Data entry experts which completed more then 1000 projects and provided excellent result. Please check inbox for detail. Thanks Preeti
A self driven and versatile individual who is keen to deliver best of the best in any initiative I am currently working as an accountant Govt. Deptt. Regards, [url removed, login to view]