LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-25-2021, 08:21 PM   #1
Ynot!
LQ Newbie
 
Registered: Dec 2021
Location: USA
Distribution: Ubuntu
Posts: 2

Rep: Reputation: Disabled
Smile Is there a software that can covert PDF's to QIF/CSV to use with Homebank financial software?


I currently have Homebank financial software installed on my Linux computer running Ubuntu 20.04.3 LTS and I've run into a roadblock importing my bank statements (they are in PDF format). Is there any free Linux software that can convert PDF files to QIF/CSV so that i can import them? I tried looking online but haven't had any luck. Is there a better financial software out there for just doing simple household budgeting?

Thanks in advance,
Tony
 
Old 12-27-2021, 07:55 PM   #2
syg00
LQ Veteran
 
Registered: Aug 2003
Location: Australia
Distribution: Lots ...
Posts: 21,161

Rep: Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125
I can't answer any of your questions, but it's been a couple of days so here goes.
Are you happy in the terminal ?. I would use pdftotext and see what it generates, then hack it to csv (way easier than QIF) as required. Pick your favourite tool - awk, perl, python ... even bash if you're so inclined.
 
1 members found this post helpful.
Old 12-28-2021, 09:17 AM   #3
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 26,805

Rep: Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003Reputation: 8003
Quote:
Originally Posted by Ynot! View Post
I currently have Homebank financial software installed on my Linux computer running Ubuntu 20.04.3 LTS and I've run into a roadblock importing my bank statements (they are in PDF format). Is there any free Linux software that can convert PDF files to QIF/CSV so that i can import them? I tried looking online but haven't had any luck. Is there a better financial software out there for just doing simple household budgeting?
syg00 offers some good advice, but I'll add a caveat...that will work if the PDF's are in text-format, and not images. A better option would be to contact your bank and see if they can provide you with something other than a PDF. You don't mention which bank or how you're getting these PDF's.
 
1 members found this post helpful.
Old 12-28-2021, 10:48 AM   #4
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 10,706
Blog Entries: 4

Rep: Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949Reputation: 3949
PDFs are not an appropriate data source, but I’m quite confident that your bank can provide you with one that is.
 
Old 12-28-2021, 08:48 PM   #5
syg00
LQ Veteran
 
Registered: Aug 2003
Location: Australia
Distribution: Lots ...
Posts: 21,161

Rep: Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125Reputation: 4125
Might be misplaced confidence. I just checked my bank, and exporting data like that is only offered to business accounts. Personal accounts only get the pdf as an option.
 
Old 12-30-2021, 09:45 PM   #6
computersavvy
Senior Member
 
Registered: Aug 2016
Posts: 3,345

Rep: Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484Reputation: 1484
Strange.
I use 3 different banks and all give me the option to download the data as csv or as qfx (quicken web connect). I am though in the US and I know banks are different in different regions.

The software I use for my home banking records is gnu-cash and it can import either one. The only pdf I need to download is the bank statement to use for reconciling the accounts.

Last edited by computersavvy; 12-30-2021 at 09:46 PM.
 
Old 12-31-2021, 07:28 PM   #7
Mike_Walsh
Member
 
Registered: Jul 2017
Location: King's Lynn, UK
Distribution: Nowt but Puppies....
Posts: 660

Rep: Reputation: 362Reputation: 362Reputation: 362Reputation: 362
Mm-hm. I'm sure it does vary from one geographic location to another.

My bank here in the UK have given me the option to download statements, documents, etc, as either PDFs or QIF/CSV for many years. PDFs are usually good enough for me, since I only ever download 'em and stick 'em in a personal dated archive; I don't bother messing about with "home banking" software.

Mind you, from what I understand of it, you guys are responsible for your own taxes & financial records on that side of the "Pond", aren't you? The UK gov't introduced the ability to do your own stuff as an option a few years ago, but that's all it's ever remained as....an option. It's not been made mandatory, and I doubt it ever will be over here.

Completely different cultural 'take' on things, y'see. Here, the onus is 100% on the employer to do the lot....they're the ones that get an "official" kick up the ass if the figures don't match up.

Mike.

Last edited by Mike_Walsh; 12-31-2021 at 07:38 PM.
 
Old 12-31-2021, 10:20 PM   #8
uteck
Senior Member
 
Registered: Oct 2003
Location: Elgin,IL,USA
Distribution: Ubuntu based stuff for the most part
Posts: 1,179

Rep: Reputation: 501Reputation: 501Reputation: 501Reputation: 501Reputation: 501Reputation: 501
This link shows 2 option, one is a GUI tool, the other is the pdf2txt command with examples.
https://www.linuxuprising.com/2019/0...linux-gui.html
 
Old 01-01-2022, 04:13 AM   #9
shruggy
Senior Member
 
Registered: Mar 2020
Posts: 3,688

Rep: Reputation: Disabled
The link doesn't tell it, but Calibre has a command line interface as well.
 
Old 01-08-2022, 11:32 AM   #10
Ynot!
LQ Newbie
 
Registered: Dec 2021
Location: USA
Distribution: Ubuntu
Posts: 2

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
syg00 offers some good advice, but I'll add a caveat...that will work if the PDF's are in text-format, and not images. A better option would be to contact your bank and see if they can provide you with something other than a PDF. You don't mention which bank or how you're getting these PDF's.
My bank is FNCB (First National Community Bank) located in Pennsylvania, USA. I'm downloading the PDF from the banks website, I tried contacting them about this because they used to offer CSV files for customers but now they don't. They couldn't even answer why they changed their format with the statements.
 
  


Reply

Tags
pdf



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
For multiple csv files how do I add the value of one particular entry in any given csv to that csv's name? sean mckinney Programming 8 01-22-2021 09:46 AM
[SOLVED] Convert qif files to csv grumpyskeptic Linux - Software 22 08-13-2020 10:49 AM
LXer: How to use HomeBank for your open source alternative to Quicken LXer Syndicated Linux News 0 02-25-2020 10:42 PM
How to print lines in csv file if 1 csv column field = "text". There are 10 column (;) in csv file nexuslinux Linux - Newbie 9 04-22-2016 11:35 PM
[UBUNTU]How to Covert Multiple Jpegs To one pdf file in UBUNTU/Linux papulia Linux - Newbie 6 12-02-2012 10:44 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 04:18 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration