from Hacker News

Show HN: An expense manager built using Google Sheets

by mitul_45 on 5/6/17, 10:53 AM with 28 comments

  • by deferredposts on 5/6/17, 8:12 PM

    > why? Privacy. It's your personal data. It should belong to you.

    Well, it uses Google sheets to store the data. So I don't agree with this 'benefit'.

  • by sanderjd on 5/6/17, 5:00 PM

    Nice work! I've been mulling something like this for awhile. I use YNAB (classic) to track our budget, but I haven't made the switch to their new subscription-based version because it just doesn't fit my workflow as well. The experience made me think more deeply about what I actually need in a tool like this, and I came to a similar conclusion that you seem to have: I need a convenient way to enter my expenses and balances, and a way to analyze them. A spreadsheet is perfect for the latter purpose, but isn't very good at all for the former.

    Having said that, the thing I care about the most in YNAB is importing expenses from my bank accounts. My thought on replacing this was to be able to add download URLs to my spreadsheet and kick off a script which would prompt for manual username and password entry (so that the credentials aren't saved) before downloading and parsing the exports. I haven't gotten around to creating this yet - if you added it to your project, I would seriously consider using it!

  • by faysal_ahmad on 5/7/17, 1:14 PM

    I created a clone of the new YNAB as a standalone desktop application. It is available at https://github.com/envelopes-app/envelopes-desktop with installers for mac/windows.
  • by t24562445 on 5/8/17, 7:16 PM

    I'm aware this isn't a place intended for troubleshooting questions, but when one adds a read-only Google Sheet to their drive, doesn't it just make a shortcut? I clicked on the Drive icon as shown in the tutorial but the document is still read-only, and the app says that it isn't in my Drive. I tried making a copy with the same name, but no dice either. What am I missing?
  • by obsurveyor on 5/6/17, 8:49 PM

    Is there a demo I can try without connecting it to my Google account? Also, why does it say the app is "Tracking Numbers" when clicking Login? Makes it seem fishy.
  • by vsidn on 5/10/17, 7:01 AM

    Nice one. I have been using a similar method with Google Forms that carries the data over to a google spreadsheet, for a while now.
  • by davidjhall on 5/7/17, 4:51 AM

    I get "Cannot find the sheet" from Windows/Chrome. Details takes me back to the Github page. Was something removed?
  • by la_fayette on 5/8/17, 5:22 AM

    It is an interesting idea to store data on a private (also shareable) excel sheet instead of a database.
  • by huula on 5/6/17, 6:18 PM

    Nice work! I've been trying to pick up some App Script stuff too. Where did you learn it?
  • by elmalto on 5/6/17, 8:17 PM

    Cannot get the example to work on iPhone 7+ with 10.3.2 beta3(I think)
  • by zomg on 5/7/17, 12:49 AM

    although not free, ynab (you need a budget) is probably a much better way to track expenses and budgeting.
  • by justcreatedthis on 5/6/17, 5:41 PM

    Does not work on Firefox (53)