News for hackers. Stuff that matters.
Re:Show HN: Connect your bank account to Google Sheets by neilv on Thursday July 08, 2021 @07:43PM (#27778944)
If you want to import banking data for tracking your personal finances or small business, there's also GnuCash, which you can run locally. https://gnucash.org/

I haven't used its online data-fetching features, but instead save manually save OFX and QFX files periodically from banking Web sites, and later import them into GnuCash (which includes transaction matchup features). I also use the statement reconciliation features.

I save all the OFX, QFX, and PDF files separately, in case I ever want to do something different with the data. (One of my financial services won't let you download transaction data older than 90 days, and most of my services won't let you download data or statements more than 1-2 years old.)

Re:Show HN: Connect your bank account to Google Sheets by sumedh on Thursday July 08, 2021 @09:27PM (#27779592)
Is there something similar to gnucash but with better UX?
Re:Show HN: Connect your bank account to Google Sheets by neilv on Thursday July 08, 2021 @10:20PM (#27779873)
If you're up to investing time in GnuCash, and tuning it to your needs, there's some nice UI/HCI details, though some is still rough.

But the GnuCash out-of-box UX definitely isn't contemporary tech industry polish nor style. (Though that heritage also means that GnuCash isn't selling out the user a dozen different ways like we tend to do in tech industry right now.)

(Examples of tuning GnuCash: I replaced the default account hierarchy with one I evolved, switched to displaying only leaf account names instead of the colon path ones, and color-coded the accounts to distinguish liquid/non-liquid/liabilities/receivables.)

Re:Show HN: Connect your bank account to Google Sheets by blooalien on Friday July 09, 2021 @02:52PM (#27787145)
Maybe https://skrooge.org/ perhaps?

There's also a big list of alternatives to GnuCash at https://alternativeto.net/software/gnucash/ which you can filter down by various tags (open source or not, operating system, etc).

Re:Show HN: Connect your bank account to Google Sheets by devinsit on Thursday July 08, 2021 @10:29PM (#27779949)
I built uFincs (https://ufincs.com) basically because I got fed up with GnuCash's UX. It only supports importing CSVs right now, but I'm open to adding other formats. It's also a web app rather than a desktop app, but you're free try it out/use it without an account (https://ufincs.com/noaccount) and all of your data will just be kept in your browser.
Re:Show HN: Connect your bank account to Google Sheets by barbarbar on Friday July 09, 2021 @01:21AM (#27780686)
I remember this from previous submission here. It looks amazing.
Re:Show HN: Connect your bank account to Google Sheets by sumedh on Friday July 09, 2021 @02:01AM (#27780849)
It looks good but I dont want to pay 120 per year, maybe 50-60.

There is also another risk that you have access to my name and my financial status :)

Re:Show HN: Connect your bank account to Google Sheets by jazzyjackson on Thursday July 08, 2021 @10:55PM (#27780058)
Re:Show HN: Connect your bank account to Google Sheets by sumedh on Friday July 09, 2021 @01:58AM (#27780834)
Thanks, it looks interesting, I will try it out
Re:Show HN: Connect your bank account to Google Sheets by throwawayswede on Friday July 09, 2021 @02:26AM (#27780978)
GnuCash's UX is great.
Re:Show HN: Connect your bank account to Google Sheets by mindslight on Thursday July 08, 2021 @09:36PM (#27779637)
Is there any existing Free software project that aims to grab OFX files via banks' web interfaces? Obviously for banks that don't allow Direct Connect.
Re:Show HN: Connect your bank account to Google Sheets by fatcow on Friday July 09, 2021 @04:06AM (#27781472)
Thanks for mentioning GnuCash - it has a mature scheme backend.