Fermé

Fill in Excel Spreadsheet Data PDF Bank Statements

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.

Compétences : Saisie de Données

Voir plus : excel spreadsheet bank statements, bank statement excel spreadsheet, excel bank statement spreadsheet, fill pdf excel, fill bank statements, bank statement spreadsheet, pdf bank statement excel, excel spreadsheet bank statement, fill pdf excel data, import pdf bank statement excel, pdf bank statements, fill bank statement, bank statement excel file, bank statements pdf csv, pdf bank statements excel, spreadsheet bank statement, bank transaction spreadsheet, fill pdf bank statement, spreadsheet pdf fill, fill bank statement excel, excel file pdf fill, bank pdfs excel, excel file bank statement, pdf bank statement ocr, copy bank statement excel pdf

Concernant l'employeur :
( 1 commentaire ) Bunbury, Australia

N° du projet : #1063906

50 freelance ont fait une offre moyenne de 86 $ pour ce travail

pandeypriya2003

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

100 $ USD en 3 jours
(501 Commentaires)
7.5
ggopi

Lets start immediately, please send me further details.

80 $ USD en 3 jours
(205 Commentaires)
6.5
Kamalkishover

Pls Check PM

100 $ USD en 3 jours
(189 Commentaires)
6.5
salsuz

It will be my pleasure to work for you

70 $ USD en 5 jours
(12 Commentaires)
4.4
koolsidz

Please see PMB

75 $ USD en 1 jour
(21 Commentaires)
4.3
dobreiiita

Ready to do this. Check PM>

60 $ USD en 2 jours
(8 Commentaires)
3.4
muthumuni

Hello... #####... Can you Kindly see PMB for details ...##### Your satisfaction is my success muthumuni (Gold member)

75 $ USD en 0 jours
(4 Commentaires)
3.1
kumaranunay123

Hi Please check PM.

100 $ USD en 5 jours
(1 Commentaire)
2.6
imranlaghari

I have good experience of this work .. i can do this in a better way

40 $ USD en 13 jours
(0 Commentaires)
0.0
mcbilgin

plz check pm .Thanks.

199 $ USD en 5 jours
(0 Commentaires)
0.0
cathyrinemae

bank account data entry in excel.

85 $ USD en 3 jours
(0 Commentaires)
0.0
fahad634

i am new but work hard. and now time i am searching some work.

50 $ USD en 3 jours
(0 Commentaires)
0.0
sirajalishah

i try my best.

50 $ USD en 5 jours
(0 Commentaires)
0.0
mody4u

i am interested in this project

60 $ USD en 3 jours
(0 Commentaires)
0.0
mschd11972

I will complete the job in three days. with 100% accuracy try me once!!

89 $ USD en 4 jours
(0 Commentaires)
0.0
chaudhry143

hi, the project you have listed is very easy for me, infact u can say its about to complete within no time, i'm very professional in excel and can complete the project within the time given to you. don't look at my hi Plus

85 $ USD en 3 jours
(0 Commentaires)
0.0
shakeelnice

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]

40 $ USD en 6 jours
(0 Commentaires)
0.0
Suman132

Dear Sir, I am interest your job. Please see my resume for more details. I’m looking forward to working with you!

80 $ USD en 5 jours
(0 Commentaires)
0.0
engisarwar

Hello there I have a great experience on this type of project. I am highly willing to perform this project. I am ready to take an interview if you want. I will submit the work on due time. If you want you can take an i Plus

90 $ USD en 4 jours
(0 Commentaires)
0.0
arnobmym

Hello there I have a great experience on this type of project. I am highly willing to perform this project. I am ready to take an interview if you want. I will submit the work on due time. If you want you can take an i Plus

50 $ USD en 5 jours
(0 Commentaires)
0.0