Fill in Excel Spreadsheet Data PDF Bank Statements
$30-250 USD
Ditutup
Dibuat hampir 13 tahun yang lalu
$30-250 USD
Dibayar ketika dikirim
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:
Page 3
Keycard Cold Card
ACCOUNT NUMBER
525 1345 6532 4324
Keycard transactions
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
85822563281156355215882
090910 ASCOT QUAYS APMT HOTEL ASCOT AUS 194.00
85211651384318831385
090910 PAYPAL *CODADDYCOMI 4029357733 USA 5.95
5.49 USD INC FX FEE AUDS 0.15
55242151576385458158454
100910 ACE COMMUNICATIONS BERWICK AUS 20.15
551518658183183138536
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.
Eg:
Date,Description,Dr,Cr,BALANCE
,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.
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