The Book-keepers Forum (BKF)

Post Info TOPIC: Bank Statements to Excel - There must be an easier way!!


Veteran Member

Status: Offline
Posts: 47
Date:
Bank Statements to Excel - There must be an easier way!!


Hi all,

 

So as I sit here inputting the bank statements on my excel spreadsheet I think surely there is a simpler way.. Is there any way of dropping the statement into excel? I get you may have to tweak coloumns etc and organise the figures as you set out spreadsheet, but surely its better than the time consuming effort of just inputing the data manually? yawn

 

I have tried to copy and paste but the pdf won't allow it. disbelief

 

thank you in advance smile



__________________

Shoncee

Account On Us Ltd.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:

where I get bank statements on PDF I use Wondershare PDFElement which turns them into Excel sheets with everything in the right columns (A lot of PDF converters fail on that one!)

Last one I did was a PDF of 900 sheets that it handled in seconds and there wasn't one figure ened up in the wrong column (And we're talking PDF's of photocopies!)

You can download it free.

The perpetual licence is $129. There is a cheaper version but unfortunately you need tohe OCR facility for what you want and that only comes with the professional version.

For what you are doing now, maybe try the free download and see whether that will do your immediate conversion before deciding whether its for you.


HTH,

Shaun.

__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Veteran Member

Status: Offline
Posts: 47
Date:

omg your a life saver!!

 

sounds fabulous im downloading it now yay!! THANK YOU aww



__________________

Shoncee

Account On Us Ltd.



Forum Moderator & Expert

Status: Offline
Posts: 11981
Date:

No probs Shoncee,

really hope that it helps.

Don't know what the latest restrictions are on the free version. with my one they were a relatively low number of page conversions before needing to pay for it.

All the best,

Shaun.



__________________

Shaun

Responses are not meant as a substitute for professional advice. Answers are intended as outline only the advice of a qualified professional with access to all relevant information should be sought before acting on any response given.



Senior Member

Status: Offline
Posts: 151
Date:

Over time it will become really easy to get bank statements via open banking. Best to keep an eye on that.

__________________


Veteran Member

Status: Offline
Posts: 47
Date:

ive downloaded and trying to work it out. i did the pdf converter to excel saved it then when i opened it was the statement but all in one column and a lot of it un readable? what have i done wrong?

 

thanks so much for your help aww



__________________

Shoncee

Account On Us Ltd.



Veteran Member

Status: Offline
Posts: 47
Date:

i look forward to that!! biggrin



__________________

Shoncee

Account On Us Ltd.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

CSV?

Am I missing something?

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 3904
Date:

accountonus wrote:

ive downloaded and trying to work it out. i did the pdf converter to excel saved it then when i opened it was the statement but all in one column and a lot of it un readable? what have i done wrong?


Try the weeny pdf to excel convertor, I had some success with LLoyds bank statements, although I had to tidy the columns up afterwards.

https://www.weenysoft.com/free-pdf-to-excel-converter.html    It's free and open source.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

CSV?

Am I still missing the point?

Although the one I got from rubbish Barclays had no balances - what the heck is that about?

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Veteran Member

Status: Offline
Posts: 47
Date:

csv?  is that a program or you mean the format to open?

wonder share doesnt work on the free trial and im worried to pay for it and still not do the one job i need it to do lol 

thanks x



__________________

Shoncee

Account On Us Ltd.



Senior Member

Status: Offline
Posts: 259
Date:

Shoncee,

Most banks facilitate statement downloads in csv file format (as well as other formats). Look carefully at your transaction screen options. I think Joanne is asking "does your bank not allow CSV format statement downloads?". If it does, she's suggesting that you use that instead. I concur

FWIW. I use Able2Extract if I need to convert PDFs to Excel. Very happy with it.

Regards,

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Veteran Member

Status: Offline
Posts: 47
Date:

ok great will try that.

my client has sent the all via pdf but will ensure in future i request csv format.

__________________

Shoncee

Account On Us Ltd.



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Cheshire wrote:

CSV?

Am I still missing the point?


 No, but I was smile  I thought you meant convert the PDF to CSV instead of excel, which you can't do.

Yes, totally agree that csv is the best format to download in, if that's practical.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Senior Member

Status: Offline
Posts: 259
Date:

Leger wrote:
 I thought you meant convert the PDF to CSV instead of excel, which you can't do.

Hi John,

Sorry to contradict, but all the PDF converters I've ever seen do allow conversion to CSV. Able2Extract, for example, allows Excel, CSV, Word, Powerpoint, Publisher, HTML, AutoCAD, Text, Images (BMP, JPG, PNG, GIF, TIFF) and Searchable PDF (for scanned PDFs).

Regards,

 



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Veteran Member

Status: Offline
Posts: 47
Date:

Went with able2extract and the lovely salesmen did the one off licence with £40 discount!! Preferred it most on free trial. Thanks for recommendations Onion xx

__________________

Shoncee

Account On Us Ltd.



Expert

Status: Offline
Posts: 1811
Date:

"my client has sent the all via pdf but will ensure in future i request csv format"

If the client is sending it to you, I'd be inclined to ask them to send it in both formats. Both can be edited with the right software, but fewer people are equipped to do so to PDFs - whereas CSV can be edited even in a basic text editor like Notepad. The PDF then becomes something to double check against.

Okay, yes, I have trust issues.

 



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Senior Member

Status: Offline
Posts: 259
Date:

VinceH wrote:

Okay, yes, I have trust issues.

 


 I'll say! You must have been an auditor in a past life. biggrin



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Senior Member

Status: Offline
Posts: 259
Date:

accountonus wrote:

Went with able2extract and the lovely salesmen did the one off licence with £40 discount!! Preferred it most on free trial. Thanks for recommendations Onion xx


 Rats! I paid full price via the web site. Too used to doing these things in the small hours of the morning when there's no-one to talk to! Still, worth every penny I paid. 



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Expert

Status: Offline
Posts: 1811
Date:

"I'll say! You must have been an auditor in a past life."

There was indeed some auditing (though only as a junior) when I started out working for a firm of chartered accountants.

But you can combine that with all the years since of dealing with clients who try to push their luck a bit - some notably more than others. smile



__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)



Master Book-keeper

Status: Offline
Posts: 3904
Date:

Onion4Sage wrote:
Leger wrote:
 I thought you meant convert the PDF to CSV instead of excel, which you can't do.

Hi John,

Sorry to contradict, but all the PDF converters I've ever seen do allow conversion to CSV.


 Oh, my apologies.  I use two, the weeney one I mentioned above, which only converts to excel, and another one I use at work, which I've found excellent for converting invoice lists, but not bank statements.  (I won't mention the name as when I got it it was freeware but I installed it later on my home computer and it had spyware on it, so was instantly removed) Having just looked at it it can indeed convert to csv, which I never realised.



__________________

John 

 

 

 Any advice given is for general guidance and professional advice should be sought applicable to your circumstances.



Master Book-keeper

Status: Offline
Posts: 8646
Date:

Onion4Sage wrote:

Shoncee,

 I think Joanne is asking "does your bank not allow CSV format statement downloads?". If it does, she's suggesting that you use that instead. I concur



Haha, yes Ian , thank you for translating for me.

Problem banks that drive me mad - Barclays as mentioned. Lloyds - only download 150 trans at a time, how the hell do you know where the cut off is without faffing about.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Master Book-keeper

Status: Offline
Posts: 8646
Date:

accountonus wrote:

ok great will try that.

my client has sent the all via pdf but will ensure in future i request csv format.


Always get the PDF for the year end as well for audit purposes.   

------------------------------------

Trust clients?????  Never fully.



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Veteran Member

Status: Offline
Posts: 47
Date:

Ok thank you everyone

__________________

Shoncee

Account On Us Ltd.



Guru

Status: Offline
Posts: 715
Date:

Santander only supply pdf statements now , no other options. Its good to know they can be converted to csv. I must take a look at my pdf software to see if I can use it convert pdf!



-- Edited by YLB-HO on Saturday 6th of July 2019 02:01:44 PM

__________________


Frauke
BKN Book-keeper of the year 2011



Senior Member

Status: Offline
Posts: 259
Date:

Hi Frauke,

I've just looked at my Santander account. The transactions screens allow downloads in XLS, QIF, PDF and TXT format.

Regards,

__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Guru

Status: Offline
Posts: 715
Date:

Really? None if my clients have been able to do so (unless its a recent change), but then they all seem to be mac users. Perhaps thats the issue!  

Thanks, I need to let them know that they should be able to get me xls format statements.



__________________


Frauke
BKN Book-keeper of the year 2011



Senior Member

Status: Offline
Posts: 151
Date:

It may be worth your clients seeing what they can get with Chrome rather than Safari. Safari tends to be a bit behind the times from a javascript perspective.

__________________


Senior Member

Status: Offline
Posts: 259
Date:

YLB-HO wrote:

Really? None if my clients have been able to do so (unless its a recent change), but then they all seem to be mac users. Perhaps thats the issue!  

Thanks, I need to let them know that they should be able to get me xls format statements.


Hi Frauke,

Maybe they're only looking in the e-Documents area where there are only PDF statements available. Exactly the same information is available in the transaction listing area in the multiple formats mentioned. Clients can be very literal at times I find. If you ask for statements they will give you statements - and nothing else!

Regards, 



__________________

Ian

Ian Brown FCA
Onion Reporting Software Ltd

www.onionrs.co.uk

Sage accounts in Excel. No set-up necessary. Free 30 day trial.



Guru

Status: Offline
Posts: 715
Date:

Thanks Ian. I don't use Santander Myself.   I have collection of card readers for other banks, and lost the will to live with the paperwork to have access to client banks accounts myself, so no longer ask for it.  

It is hard enough asking for transaction/statements report etc in either csv or xls......   and they dont have a clue, what either means..... and when they do they miss a day/week/month out.....



__________________


Frauke
BKN Book-keeper of the year 2011



Newbie

Status: Offline
Posts: 1
Date:

You can use a bank statement converter to automatically import any bank statement to Excel or your accounting software.

 

 



__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About